But I've got a problem now, and I haven't been able to find any answer. Here is the code I'm executing:
Imports MySql.Data.MySqlClient
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
[code].....
I have a form which has bound textboxes from 2 tableadapters allowing me to use:
me.datatableTableAdapter.fill(dataset.datatable)
so I assumed that I could use:
Try
[code].....
I have a little big problem in one application.
I have a datagridview with data from a datatable, this datatable have these fields (id,num1,num2, date,user,ref,qt,cost,center), some of them are hided in the dgv (id,num1,num2,date,user). The user can edit,delete and add new rows to the dgv.
I have a save button that performs this actions:
First check if there are new rows, and if yes it fill the hidden fields. Then validate the inserted values by the user with a couple of ifs. In the end, i call the bindingsource EndEdit, and call the adapter Update command against the datatable...
This sometimes works others not really, i don't understand why.
The error it's: "Concurrency violation: the DeleteCommand affected 0 of the expected 1 records"
I think sometimes when Updating it occurs to.
If strCustomerOrder = "A1#" Then
decSubtotal = ANTACID_ONE
mintQuantity += 1
ShoppingCartForm.lstShoppingCart.Items.Add(("A1" & vbTab & vbTab & "Alka-Seltzer Antacid" _
[Code] .....
I want my listbox to not display duplicate items. I just want it to update the quantity(Qty).
I have a wingrid that is bound to a datatable. I create a new asynchronous thread and from that thread make a remote server call passing the datatable. When the server call is completed the wingrid automatically refreshes to show any changes. However, since this is not being done on the main UI thread of the program, we will often get an error where the control goes whilte and a big red X appears in it.
Is there a flag to set the wingrid to not automatically upate when the datasource changes? I would like to turn it off before the remote server call and turn it on again after I am back on the main thread.
I wonder if it's possible to prevent Visual Studio (2010) from automatically updating code when I change control names? [code]...
View 8 RepliesI have a dataset which I load three tables into from the database. Each of these three tables are related by the AccountNo. On two of the tables I specify this field as a foreign key constraint with the appropriate cascading flags. However when I scroll through the list of companies with my combo box. Only the one table is having its values change on the form whereas the other tables remain static/unchanged.[code]...
View 5 RepliesI am using sql server 2005 with vb.net 2008. I really troubled to resolve a problem that how to updating datatable. My code just update the first record the datatable but when i want to update any other record of datatable it still remain unchanged. I am using Master/Detail tables and my coding structure is as under Note I am just facing problem to updating the child table only and I am using Typed DataSet and in child table ItemID is a Primary Key
Dim i As Integer
StoreDBDataSet.Tables("RequisitionDetail").Rows(i).Item("ItemID")=txtCode.EditValue
StoreDBDataSet.Tables("RequisitionDetail").Rows(i).Item("ItemName") = txtDescription.EditValue
[code]....
I am wanting to update a datatable which is been created dynamically. Each row has a unique Id column. How can I retreive the row and update a column in it using the Id column
[Code]....
created a small application that I'm able to add items from an access DB to a ataGridView.Now, My questions is: suppose that I have a list of item in this DGV,containing name and Quantity. Now I would like the database to be updated with new values on Quantity column, something lke this: (Current values - Quantity on DGV).
View 1 RepliesI have a datagridview that has a checkbox. That checkbox will designate if a day is a "Holiday" or not. When then user clicks on my save event, I want my sub to check to see if that box is checked and appending the data to a table in my database.
View 15 RepliesI have a datagridview that has a checkbox. That checkbox will designate if a day is a "Holiday" or not. When then user clicks on my save event, I want my sub to check to see if that box is checked and appending the data to a table in my database.
View 1 RepliesI've been browsing these forums for a day looking for the answer to this, so far nthing has fitted.I've got an access 2000-2003 database containing a whole pile of data for a VB coded application to use. One of the tables in the database needs to be able to be updated with data from the application.The new data is stored in the app as a datatable. I need to replace the original table in the Access file with the datatable in the App.
I'm changing as many as 60 values at a time, so defining these as parameters in an OleDbCommand would be impractical and frankly ridiculous.
I have a vb.net project where I have data loaded into a datatable in a dataset and have to do approximately 20 updates that are sql like. On this project, I don't have access to sql nor does the end user want to use any type of sql, sql express etc.
My question is, is there a generic way of doing this so I can reuse it. Was wondering if a dataview could be analgous to the "WHERE CLAUSE" and some type of delegate function could be the update function.
[Code]....
I have a vb.net project where I have data loaded into a datatable in a dataset and have to do approximately 20 updates that are sql like. On this project, I don't have access to sql nor does the end user want to use any type of sql, sql express etc
View 2 Replieson a windows form i have a combobox called currency, it is populated by a table-adapter called exchan-gerate which is turn populated by a dataset called mydataset. on form load, i issue update commands to the back-end database that holds the table which populates the dataset - they work. if i look at the update to the combobox, they are not reflected until i exit and restart the app - then they're fine. further down the form load i've tried:
Me.exchangerate.Update(Me.DataSet.Currency)
Me.CurrencyComboBox.Refresh()
am i missing something silly to have the values in the combobox change and refresh at the time of the update to the database? as i said, an exit and restart of the app displays the accurate data.
I am using Microsoft Visual Basic 2010 Express. I have a WPF-based project. I have a successful connection to a database in Database Explorer, and a working existing Data Source in Data Sources.
I created a datatable from the datasource using this code:
Dim roster_table As New DataTable("AGENT_ROSTER")
I can manipulate this datatable just fine, but I cannot figure out how to save its data to my database (agentroster.sdf) since the connection is on a global level, and isn't declared in this particular window.
How do I update this database from the datatable on this window?By the way, I tried creating a connection on this window's code, using the exact same connection string as the successful globally-connected database, yet it said that it couldn't connect.
I've finally got around to starting windows phone dev. I'm not very good at it yet, but anyway, I hope you guys understand what I want to do here.From what I've learnt from other programmers, an ObservableCollection can be updated in live time whilst it is databound to an object, such as a listbox. All changes to the ObservableCollection will cause the UI of the object it's databound to update it's items.
So what I'm trying to do, is download a file from my server, parse it with json, then update the ObservableCollection with the new data. However, the webclient doesn't seem to be downloading the new data until the app is re opened!
[Code]...
How can I disable letters from being typed into listbox?I know I can use maskedlistbox and easily select what can be put into it, but then if I use that can I set a limit to 2 units only?
View 2 RepliesI need to extend a combobox to disable some listitems (i.e splits - "----------"). I reckon some APIs will be involved, and it could get complicated. That'll not put me off though. If anyone with usefull info on the subject could post it,
View 11 RepliesI have a Listbox which is to display a list of product names which it reads from a database table, bound using the inbuild datasource/databinding stuff..however when the product names are updated/more are added in the table etc no change is reflected in the Listbox! only the initial names from when it was first bound appear, how to fix this?
View 1 RepliesDisable dynamic searching when typing in a listbox?
View 1 RepliesHow do I disable buttons while there are less than 2 items in a listbox? I can't figure out how to do it. I'm a newbie in Visual Basic(programming at all)
View 7 RepliesI have a listbox which content is based on a treeview. When the user doubleclicks an item in the listbox the treeview will be updated and aftervards all the items in the listbox will be removed and the text of each TreeNode in the TreeView will be addedto the ListBox
View 2 RepliesI am writing a program that has a listbox which is bound to a dataset. When I click a button (e.g. delete) the item is deleted from the database ok using an SQL query but is still shown in the listbox. How do I get the listbox to refresh/update its display?
View 8 RepliesHow would I enable/disable a button if listbox become populated?
View 1 RepliesAs far as I know, there is no way to grey out/disable specific items in the ListBox control? I want to make a list of surveys that need to be answered, but grey out/disable those that the user has already answered.Or is there some way to do it with ListBox?
View 1 RepliesI can't seem to figure out how to use databindings to enable/disable a button when a listbox contains 0/1+ items?
Button1.DataBindings.Add("Enabled", ListBox1, "Items.Count")
Button1.DataBindings.Add("Enabled", ListBox1.Items, "Count")
Result = ArgumentException: Cannot bind to the property or column Count on the DataSource. Parameter name: dataMember
Button1.DataBindings.Add("Enabled", TextBox1, "Text.Length") ' This works?
I'm having trouble removing both the number of adult golfers and children golfers in a group. I want to remove the item as well as update the order subtotal.
The Minigolf form code
Dim intTotalGolfers As Integer = 0
If IsNumeric(txtNumberOfAdults.Text) Then
If CInt(txtNumberOfAdults.Text) >= 0 Then
[Code]....
I have a windows form with a tool strip menu, a header and a datagrid view.
When I add auto scroll to the windows form the scroll bar scrolls through the whole windows form, I want it so that it only scrolls through the datagrid and the header and tool strip stay fixed and don't move.