I have added a new column to my bound datagrid table using sql server management. Added a new textbox to my form and using databinding, bound the textbox to the new column. Running my app I can enter text in the new textbox and if I save or move from the current row the text shows in the grid. But...after refreshing the grid or restarting the application, the text is no longer there.
[Code]...
I have a DataGridView on a form in VB 2005 Express, of the 10 columns i need on this DGV 6 of them will be pulled from an MSSQL DB and 4 of them i need to manually enter. One thing i have going for me (i think) is that the 4 manual columns have the same data in each row.I have been filling this DGV using a datatable, but i am not figuring out how to add manual columns and databound ones in the same DGV. My column layout would look like this:[code]some one please explain to me how i would do something like this. if you can include the datatable definitions also it would be a big help, in order for me to verify that i am at least doing that the right way.
View 1 RepliesI have a pre-existing database which I am coding to, so I can't change the data stored in the SQL-Server 2005 database. My application uses the DataGridView to maintain the data. There is a yes/no field that I would like to bind a checkbox to. The field is a character field in the database, and holds either Y or N. So, here's the question. I know how to set the column to be a checkbox, I think, but I don't know how to map it so that it reads/stores a "Y" value as checked and a "N" value as unchecked.
View 1 RepliesI've bound a lot of controls on a form to a Entity. Some of them update fine, the others are just jumping back to their original value as soon as it loses focus.The old data are loaded in all controls perfectly.
Dim Q = From e In EnData.Calls Where e.CallID = ID
TempRow = Q.FirstOrDefault()
ticTemp1.DataBindings.Add("Value", TempRow, "CallDate")
ticTemp2.DataBindings.Add("Value", TempRow, "CustomerID")
How can this be fixed?
I have a simple windows form application (I'm working in Visual Basic Express 2008).
There are some forms that have simple text boxes. When somebody wants to edit something in this boxes he pushes edit button and then they are enabled. I insert some text and when I save this text is saved for good.
When I reopen the application this text is there like I want it to be. Just for information, this text is always the same in one text box, until I change it (me or some other user) - so I think there is no need for databases. For my needs this is ok because I don't need to change this data often. This is code in Form load event (for calling back the data)
[Code]...
I have a databound combobox that displays a list of items, and I have a windows form that opens after clicking a button that allows me to make changes to the table that the combobox gets it's values from. When I make the changes and save them (successfully) and return to the parent window, the changes aren't reflected in the combobox. If I exit the app and launch it again the changes are reflected perfectly. I've tried me.combobox.refresh() on the forms GotFocus event, but no luck.
View 3 RepliesThe problem is this: I have two forms. One form and the other form do mathematical calculations. I want to save the values that the user inputs, so when the user quits the program and then starts it up again the values are still there. But when I open up the program, start typing in values, then calculate them, hit quit. Try to open up the program again, its giving me a message that the input file is invalid. When I click ok, the program doesn't crash, continues. But the values are not there at all. The other form I put exactly the same code, just changed the variables and it doesn't want to save the values at all! I wrote this code for saving and loading the values:
[Code]...
am trying to calculate the values in rows in column 6 based on values of column 5. Bellow is the the code I am using I get a run time error about the string not formatted properly
[Code]...
I'm trying to make a method that can get unique values from a specified column of a DataTable. The problem is that the column may be string, integer, etc. I'm not sure what type of variable the (Of T) is.
Private Sub GetColumnUnique(ByVal dbTable As DataTable, ByVal ColumnNumber As Integer, ByVal ColumnType As ???)
Dim results As List(ColumnType) = (From item In dbTable.AsEnumerable Select item.Field(ColumnType)(ColumnNumber)).Distinct.ToList
End Sub
Is there any way to set a column to accept only unique values?(Via Table Definition)
View 2 RepliesI have a 3 column listview. Column 1 and 2 has few integer. How can I subtract Column 1 and column and show the result in column 3. Below is a sample data for columns.
View 5 RepliesI'm trying to loop through a column of checkboxes to see how many checked values there are in that column. The user has to have 2; no more, no less than 2, otherwise an error should show up.
Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
Dim count As Integer = 0
Dim x As Integer = 0
For x = 1 To DataGridView1.RowCount - 1
[Code] ....
The error message still occurs when I have only 2 chosen in that column. I even tried this
If CBool(DataGridView1.Rows(x).Cells(7).Value = Checkstate.checked) Then
i have retrived this datatable from datasource and i want to add a more colum 'category'basedon the each value of each Role, like if role column has the value '90 daya client' then in the same row it should have a value 'DC' in the category column.n make a temporatry dt1 table but to add related values.
S.No First Name Last Name Role Date
1 Us er1Name User1Name 90 Day Client 11/01/2011
2 User1NameAtt1 User1NameAtt1 90 Day Client 11/01/2011
[code].....
I want to add all the values of a certain column. I already get the value of an exact cell value but when i add the loop code for it to continue,it doesn't performs well.
[code...]
I,m using vb6 po with datagrid component.
how can I save the value of my first column of my listview to sql? I'm using OLEDB by the way.
View 1 RepliesI have a question regarding Databound listbox (Item selection)I have not used the listbox much so I am very uncurrent in it's use:What I am wanting to to is connect to a database, select from the database (lastname) then display the list of names in the listbox, also have a datagrid on the same form, so that when I click on a name on the listbox the datagrid moves to that same record.
View 5 RepliesI want to refresh a form that has a listbox which is databound to a source. Me.Refresh() doesn't do the job. I tried reloading the orginal sub thats also doesn't work.
View 14 RepliesI have an application working great that has a data-bound combo box.My question is When the user types in box the results are not shown unles I manually click the drop down arrow.
View 2 RepliesI have an MDI application that shows MDI forms with a single DataGridView on each form. The grid is bound to a List(Of Item), where Item is some class. Now I need to be able to drag (possibly multiple) items from one grid (in one form) to another grid (in another form).
Unfortunately, I know nothing about DataGridViews and even less about drag and drop, so this is turning into a real pain for me...I have been looking at examples for ages, but none of them work for me. Most of them don't deal with databound items, others don't seem to work at all, and yet others can only deal with a single row at a time (pretty useless for me).
This must be something that people need a lot, so I can't understand why the examples are so 'bad'.
I have a combo box that's filled from a query in the database. If I add a field to the database, the new field won't show up in the form until I close it and reopen it.
So, how do I refresh the contents of that combo box?
I bound the data onto the combo box like this:
[Code]...
Having a little issue with my boolean statement. It is not changing the value to true after you click it. Its a basic function just not working correctly and Im pretty stumped on why. I mean its a simple yes or no concept. The button is on or off is the basic concept.
Private Sub btn_Backhoe_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_Backhoe.Click
Dim InUse As Boolean
'Switch On/Off[code].......
Have read most of the null value posts here, and I have managed to get things working as far as a "next record" button for my database application form (there's some awesome advice on this forum!). I have just one question, though. How do you manage saving of blank text box values from a form? I am using JET, but when I try to save an updated file that has a null value, it is not letting me. I got around it by forcing the text boxes with null values to contain " ", but obviously this is not the bext solution!
View 1 RepliesIm creating an application that allows me to enter a product with a cost. I want all the costs to be saved in an array and then calculate the total cost and display it in a label. I looked for hours in my textbook and cant seem to get this part.
[Code]...
trying to understand DataGridView. I can sum columns with no problems and place the result in a textbox. My problem is multipling two column rows and saving it. I receive the following error when I go to save it. "Column mapping from source column failed because the data column is a computed column. So can I compute two column row to a third and save it, if so how. My code is below:
I save.[code....]
Sometimes I select a value in my Combobox by hand, and sometimes the value to show is chosen elsewhere in my program logic. I want to carry out a certain action only when I have chosen a value by hand, and not when the value is changed by the program. For this reason I use the DropDownClosed event (and not, for example, SelectedValueChanged or SelectedIndexChanged). This works fine, but if I set AutoCompleteMode of my Combobox to Suggest, selecting a value from the suggested list doesn't fire the DropDownClosed event (perhaps logical, as the actual drop down list doesn't actually open).
View 2 RepliesI have a form in an application that I'm building and in it I have a datagridview that when a user clicks a checkbox on a line in the datagridview and "submits" the data, then the form will insert all of the data on that line (along with the code "Holiday") into a database. Currently if I click in the checkbox on any line other than the first line and put a line break on the "Try" statement, and then fire the submit_onclick event, I'm never reaching that break point but if I click on the checkbox on the first line and submit that data, that works and it behaves at I stated above. Here is the code as it stands currently:
Code:
Private Sub holidaysaveButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles holidaysaveButton.Click
For Each dr As DataGridViewRow In DataGridView1.Rows
[Code....
My windows form as a bunch of textboxes on it that basically let the user put in different positions/forces that a test cycle then uses. I am trying to let the user save their profile settings/open the settings so they don't have to input the same values every time they want to run the same test. Here is my code so far. basically, when i save my csv file, and open it, all 6 textbox values are plopped in the first textbox instead of being distributed to their original boxes. I just read about a "split" function
code
Private Sub SaveProfileToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveProfileToolStripMenuItem.Click
SaveProfileDialog.ShowDialog()
Dim sw As StreamWriter
[Code]....
I have A combo box with 5 values in: How would i save all 5 of those values to my file?sw.WriteLine(CustomerIDTextBox.Text + ":" + CustomerFirstNameTextBox.Text + ":" + what????? Once these values are saved how would i go about retreiving them from the file and displaying them back into the Combo box?
View 3 RepliesWe have a listbox in our MVC View and the user has the ability to highlight multiple values. I'd like to be able to save those selected values(if possible?) as a comma delimited cell value in our '08 SQL Database.
The image below shows what I am attempting to explain. Note the selection in the LISTBOX
This is where we save the passed in values from the Positionnumber DDL (Listbox w/ mulitple highlights).
> <HttpPost()>
> Function Edit(wsmonitor As WSMonitor, ByVal vbpositionnumberDDL As Integer, ByVal PassedCounty As Integer, ByVal
> MonitorTypeDDL As String) As ActionResult
[Code]....
I have 50 checkboxes for 50 american states. The user can choose all 50 or only 1( so basically any number he wants). Based on his choice, I want to insert or update the table in sql server 2008. e.g- Color = blue and chk1=check, chk2= check and chk3 = check (chk = checkbox).
Now the user wants to ad 10 more states to this or remove these 3 and add 5 more. so u basically get the idea. the table in database looks like this -ID Color State_id
There is a table called states, so stateid shall come from there. so how do i do a loop insert or update in vb.net?