I 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 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 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 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'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 RepliesI 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.
on 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.
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].....
My intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
View 2 RepliesI am writing below code for validating compulsary field account no. in form.User's requirement is set focus back on field when error comes :
If txtAccountNo = "" Then
MessageBox.Show("Account no filed can't be left empty")
txtAccountNo.SetFocus
Exit Sub
End If
It's working properly. But suppose user don't want to fill form and exiting from application.Message box keep on appearing till user enters account no.
I have a function that search for a keyword and then return DataTable. I want to check if there rows inside because sometimes there's no query found.
'which one shoud I use ?
If dtDataTable Is Nothing Then
'some code
[Code]....
How can I check if a datatable has never been set ? or Null or Nothing ? I don't mean empty Datatable ... For example,
[Code]...
how to check if current row is new row in datatable?i'm trying to have some fields non-updataeble but can be inserted when it is a new record.
View 2 RepliesI use ADO.Net to call a stored procedure that retrieves data from our database.I put that data into a data table using this code below:' set Ready ResultIDs in databaseDim dt As New DataTabledt.Load(cmd.ExecuteReader)
View 3 Repliesi have a code where I dynamically generate the columns name and bind it it datatable. now I am iterating thru loop for each column and fill the datatable. My Problem is when I fill for first column row is already added to the position(e.g 0,1). if row at some position already exist in datatable I should not write
dr = dt.NewRow()
dt.Rows.Add(dr)
i getchanges from dataSet
when i am iterating through the rows I would like to check rowstate to see if row was added or modified. It says I cant check through an instance and the expression will be ignored..
Dim changes As New DataSet
changes = dsRates.GetChanges()
Dim count As Integer = 1
[Code].....
i defined a list of DataTables
Dim PreSubTables As New List(Of DataTable)()
Then I parse some source files and depending on the data, possibly none of the tables in the list PreSubTables2 might be populated, so it's just an empty list. Later on when i refer to the first table in the list , I get "index out of range error"
If (PreSubTables(0).Rows.Count > 0) Then ...
' just dealing with the first table: PreSubtables(0)
For ii = 0 To (PreSubTables(0).Rows.Count - 1)
[Code]....
I'm just trying to come up with a line that checks whether the(at least the first)Table in the list is populated, before I can print it out or do other things.
I have this code:Dim Result As New DataTable DataAdapter.Fill(Result)
'bind data to visible surname/name grid If Result.Rows.Count = 0 Then NoInputBottom.Text = "No Results. Please widen your search criteria and try again" NoInputTop.Text = "No Results. widen your search criteria and try again" Else
GV.DataSource = Result
GV.DataBind()
End If
I have also tried moving the check to the gridview like so:
If GV.Columns.Count = 0 Then
NoInputBottom.Text = "No Options Selected: Please select your search criteria and try again"
NoInputTop.Text = "No Options Selected: Please select your search criteria and try again"
End If
When I run the code. the noinput labels do not have value, the null check seems to be failing? Please can you tell me how to display a message if the search returned no reults.
I have a webpage with a form that is used to edit some object. This object contains a Collection of other objects defined like this: Public Overridable Property Employees As List(Of Employee)
On a form I can delete an employee, add a new one or modify existing one. When I click save new values are sent to the server. On a server I check if the user exists. If exists then I modify its values, if it does not exist then I add it. All employees that exist on the server and were not sent are marked as deleted (State changed to EntityState.Deleted). I try to use the following code (dbCollection = database entities, newCollection = collection sent from the form):
[Code]...
This code does not work, because changing to EntityState.Deleted removes the object from collection, and for each loop breaks, since the collection is modified...I know that I can overcome this problem by using a for loop or adding objects to delete to some other list first, but I hope maybe there is a pattern that would make my code nicer.
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
I have a datatable and I apply a filter to the defaultview.rowfilter property of that datatable. If I then loop through the rows collection of the datatable, will I only be able to see those rows that the filter applies to, or will it loop through all the rows?
View 6 RepliesI am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
I came across a problem with using a BindingSource as my DataGridViews.DataSource. Whenever I applied a filter to a column in the BindingSource and the user makes changes that don't match the column filter the DataGridViewRows would automatically disappear. A similar thing would happen when applying a Sort to a column. If the user made any changes the DridGirdViewRows would automatically sort causing rows to be moved around. This was not ideal for my application and there isn't anyway to stop this from happening with the BindingSource.
To correct this issue I have to use subsets of data. I use a DataView to apply the filter and sort to the main DataTable, which creates the subset DataTable.The problem is when I use the DataView.ToTable method I loose the Primary Key and RowError information. So I have to reapply this information everytime the user filters or sorts the DataGridView.Is there a better way to get a subset DataTable?[code]...