I'm trying to read a datagridview and post the changes back to the SQL database. Does anyone have some straightforward code that will work. I'm a newbie in VB. Posted 2-Jun am Roger Rainey. Add a Solution. Top Rated Most Recent. Accept Solution Reject Solution. Hi Roger, When people ask for "Straightforward code" it's kind of impossible to respond.
Nor will they create it for you if you are not willing to put some effort into it yourself. The best way to start a project like this is to read some articles about what you are doing. You can search codeproject for articles, like this. Then as you implement code you've found in the article, if you run into problems post your code and error messages and a description of what your program is doing and what you want it to do.
Then we can help you. Hope this gives you a good place to start. Posted 2-Jun am Kschuler. I have a access connection with textbox as data feeder to database change it to SQL if u want. The code is: VB. Copy Code. Posted Mar pm vijitizer. Sandeep Mewara Mar am. Always wrap your code in PRE tags. It makes the question readable as it formats it. Member Feb am. I have made a project in visual basic and sql server, i want to update the record in party master in another form , where when i click on the update button the another update form will open and there in the dtagrid all the records of data table will present, on that form there is three button , update, delete, cancel, i just want that when i click on the update button after editing the data row the data save to the datagrid and same to data table in sql server.
Imports System. In my windows application I select some data into Datagridview. I am using sqlcilent connection. I want to edit this gridview data and save to the DB. How can I perform this? Using a connection and command object, open the connection, assign the Connection property of the command object to the newly created connection object, open the connection then use ExecuteReader method of the command object to populate the DataTable with data returned from the query.
To add a new row there are two options, first show a child form with controls to accept input. On the child form setup a button where the property DialogResult is Okay and one button with DialogResult equals Cancel.
If the user presses the Ok button capture this from the Child form's ShowDialog turning value with is of type DialogResult. If Okay get the values from the child form i. Check the result of ExecuteNonQuery , if the value is 1 then execute another query using Identity to get the newly created row's primary key thinking you have an auto-increment key. Now cast the BindingSource. DataSource to a DataTable using Ctype. Add the new row via CType BindingSource1. Once the row has been added to the BindingSource the result is, the row has been added to the database and the row will display in the DataGridView.
Now to edit, via BindingSource. Current we can cast the current property to a DataRowView i. Rows 0. Cells 1. Cells 2. Cells 3. Cells 0. Open cmd. ExecuteNonQuery con. Improve this question. Joel Coehoorn k gold badges silver badges bronze badges. Muazzam Muazzam 1 1 1 gold badge 1 1 silver badge 2 2 bronze badges. This is not about c. It is vb. Don't add irrelevant tags. Look for bulk updates on Google. You will find some useful help. Add a comment. Active Oldest Votes.
You've hard coded the row - dgvEmpDetail. I imagine you are calling this in a loop. Rows i. Improve this answer. Sam Makin Sam Makin 1, 8 8 silver badges 23 23 bronze badges. IsPostBack Then ' Create a new table. Add tableRow Next 'Persist the table in the Session object. Rows e.
RowIndex dt. Rows row. Controls 0 , TextBox.
0コメント