I'm trying to create a message box that shows a column for Years, represented by 0-10, and an amount, as a $ wise decimal in another column.I was wondering how to create a multi column message box with column headings o.o.
View 28 RepliesAs the title says, when I attempt to update a row in a table in a database, I recieve an InvalidCastException. I am unsure why, since the variables I am using should be, and indeed, when I check them at runtime, are filled with the correct data.
I am trying to update using the method wherein the row that is being updated is identified with all the variables already stored. Interestingly, Intellisense is telling me that EntryID, the primary key, is only necessary in it's original form, and that the variables that I am attempting to update have question marks after their type.
I am trying to placed several check boxes (15) in a group box or on a form. I receive the following error message in Visual Studio:
Cannot set column, "The value violates the MaxLength limit of this column".
I am trying to implement a DataViewGrid in VB.NET that will be simply for identifying and selecting GIS features that are already within a database. Simple enough with DataGrids and DataSets, although there is one slight twist.First, I need to be able to populate the grid based on one record of the column [Name] that is chosen from a ComboBox(I have been able to populate the ComboBox, but not the grid).Second, I need to restructure the DataGridView so that each current column name is in a column called "Field" and the row for that one record chosen is in another column called "Value".As you can see here, each "Field" is a column name and each "Value" is one record for each of those columns. So, if I could somehow parse through all of the column names into a "Field" column, and also populate a "Value" column with one record for each [Name], I would be on the road to happiness.
View 1 RepliesI'm working with Microsoft Word and trying to generate a table with headings that may span one to three columns. I'm having trouble figuring out how to do this. The table should look something like the following:Counters
Times (hrs)
Flows (gals)
Day
Regens
Well Starts
[Code]...
To get it to look this way, I'm not exactly sure what to do from VB.
I have a datatable which has a number of rows containing dataThen I need to add some empty datacolumns which I do like this:
Code:
Dim OT_Hours As New DataColumn("OT_Hours")
OT_Hours.DataType = System.Type.GetType("System.Double")
[code].....
Just wondering how i can get all of a documents headings (from a specified word file) and put them in a list(Of String)
View 1 RepliesI have a Dataset with a Bunch of Columns used in a Report (DevExpress XtraReports) (DataSet being the DataSource). The Dataset has many columns, and i need to read a column (based on the row type), and decide which column value to read for the row, and apply formatting based on the row type.
[Code]...
Is there a suggested way to handle this in the Report or at DataSet Level (excepting the formatting part)?
how I can get the value of the ninth column. Columns are separated by spaces.
The value im getting will be added to a int so say int = 2 then the column is 32 then the int will be 34
I have a DataGridView on my windows form. I am adding columns to the datagridview at runtime. In doing so, I create the columns by this code:
[Code].....
At least one of the DataGridView control's columns has no cell template.
I have looked and looked and I appear to be doing everything correct
I have a working dropdown box that gives the answers yes & no.When "yes" is selected I need to create a message box that displays a simple message and allows the user to click ok, to get back to the survey.I have been working with it, and tried several things but no luck. What would the code look like, and where exactly would I place it to fire at the right time.I am working in VB, with an aspx & aspx.vb page.
View 3 RepliesI need to display a column called Full Name in the my datagridview, but the datasource (datatable) does not have a FullName column. It only has FirstName and LastName columns. I'm setting up my DataGridView like this:
[Code]...
I need to create a checkedlistbox that has multiple columns and each column has a header. Is this possible? I can't really find much on Google. Here's the headers I need:
Checkbox Title Existing path Destination path
I have created these columns to the checkedlistbox I have in my form, but when it is run the headers don't show up. Also the items I'm adding don't seem to abiding to the column widths I put in. Also with the code I'm providing below the items don't display as multiple rows, meaning each item doesn't get displayed on a new row, but in a new column.
vb
For i = 0 To iMovies
Movie = New MovieItem()
Movie.tmdbid = CInt(StrBetween(moviestag, "<tmdbid>", "</tmdbid>"))
[Code].....
I used sqlbulkcopy to upload huge data from local to remote. It works great.The only problem is that there is a table tClaim in which there are 50 columns. One clumn "IsUpload" do not need to upload. How to upload all columns except for this column? If I use columnmappings, do I have to code add column one by one?
View 1 RepliesI am working with two different connections because the information I need is stored in two different locations. One being Oracle, the other being Access. I pull all the information I need from Access with the exception of one field which I pull from Oracle. When I add this field to my datatable, it adds it to the end. I am wanting the column that I add to be between column 1 and 2 of my current datatable. Anyone know the best way to do this? From what I could find, there wasn't a way to re-arrange columns. Here is my code.
Dim da As New OleDbDataAdapter(" SELECT tblSummary.WorkOrderNumber, tblLabor.Crew, tblLabor.NumberOfMechanics, tblLabor.NumberOfHoursPerMechanic, tblTasks.TaskNumber, tblTasks.TaskDescription FROM (tblLabor tblLabor INNER JOIN tblTasks tblTasks ON
[code].....
How do you change the colour of the headings and the record selector. That is forecolor and backcolor?
I want to change it to navy so it blends in with form.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
For c = 0 To grd.Columns.Count - 1
grd.Columns(c).Resizable = DataGridViewTriState.True
Next c
That allows all the columns in my DataGridView to be resizable EXCEPT the last column. Why?I DO get the little resizable-mouse-pointer... but you can only make the column SMALLER, never WIDER.(Same problem if I try to set all the columns to Resizable, using the VB.net IDE)Shouldn't I be able to resize ANY column I want, bigger or smaller?
I'm trying to split a date column into multiple columns by year. If I could achieve a roll-up subtotal at the end that would be awesome.
I'm thinking the best way to do it, is using a .NET datalist control, but I'm open to suggestions.
Example data:
DATE | SALES
1/1/2009 | 1234.56
2/1/2009 | 4567.89
[Code]....
I'd like to autosize listview columns to fit the column names. From what I saw this should do it but it doesn't work for me. Can someone see what I'm doing wrong or know of a way to do it? The listview is designed to dynamically build the coulmns based on the number of coumns in a recordset.
[Code]...
I want to create two columns of checkboxes but only the first column is being displayed.
[Code]...
I have been trying to pull rows from my access database into a list box, so the rows do appear on the list box, however the columns are not spaced out, and when I put & Space(10) & inside the ListBox1.Items.Add() the values are all scattered around. How do I fix this?
And how do I add column headers for them?
TransactionTableApt.FilltList(LoyaltyDataSet.Transaction, busid1)
Dim x As Integer = 0
[CODE]................................
Below code is supposed to update a table in oracle with rows imported. But it seems to update all columns in the table with only the first column which is imported from the CSV file. I figure its the "ReadFields" property which needs to manipulated/changed.
[Code]...
i am cannot for the life of me figure out how to create a running total that will be displayed in a textbox and message box. here is what i need to mimick - [URL] this is my code:
[Code]...
I have a user control with an embeded DataGridView. I exposed the Columns property so that the columns collection could be edited in the visual designer:
View 2 RepliesI'm trying to display all services on a computer into column 1 under Processes and column 2 as services. I can't figure out how to do this with the WMI statements.
Here is my code......
Private Sub OKButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OKButton.Click
[CODE]..................................
I am trying to link two columns with dates and time to a new column, but the original columns are not in DateTime format. Here is sample of the data:
C_DATE C_TIME
231110
211152
[Code].....
im using listview not sql or other cr..p (Plain)I would like to get a guide to help me with all features of listview im new in dat area?But the most important thing is i want to know how can i load a file into a listview which has columns and each column has its information
Example - < Columns
Website Name
Website Location
Website Description
[code]....
so how can export it and load it ?and how can one add records and remove if using tht type of manner?
I'm getting this error 'column' argument cannot be null. Parameter name: column at the bold character instruction. Also I would like to know how to relate two tables with two key columns in each table
Dim connection As New OleDb.OleDbConnection(strTextoConn)
Dim EnPartesdataSet As DataSet = New DataSet("Enpartes")
Dim strsql As String
[Code].....
I am making a simple application that will be able to store competition data into a text file that I have given a custom extension to on saving. Here is an example of the format that i have saved the data in.
[Comp_Name]Test Competition[Comp_Name]
[Location]Silverwood Lurgan[Location]
[Type]Teams[Type][code].....
When i open the file, i want to redisplay the data in separate text boxes. Later on in the project i want to be able to search within the file for headings for example;
if "[Heat1]" is present then get all text between [Heat1] and [Heat1]
i am currently able to use the streamreader and open file dialog to retrieve the entire string of text fromthe however i am not sure how to go about getting the text between the headings I have used.