You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$10
For Premium members:
In this article you will learn to get any DataGridView cell's value into a TextBox and saving the changes into the database.
Introduction In this article, I am showing selected values of a DataGridView into TextBox and saving changes into Database. Open Visual Studio 2010 and create a Windows Forms Application. Add some UI controls and arrange them as in the following figure. Here I am showing a record in a DataGridView from the database. The database table name is "student_detail" which has some records. Write the following code.
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace SqlParameterClass { public partial class Form1 : Form { public Form1() { InitializeComponent(); } SqlDataAdapter dadptr; DataSet dset; string connstring = "database=student;server=.;user=sa;password=wintellect"; private void Form1_Load(object sender, EventArgs e) { dadptr = new SqlDataAdapter("select * from student_detail", connstring);// Specifying SQL statement and Database connection dset = new DataSet();// creating instance of DataSet dadptr.Fill(dset); // Filling DataSet dataGridView1.DataSource = dset.Tables[0]; // Binding DataGridView with DataSet } int i, j; private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { i = dataGridView1.CurrentCell.RowIndex; j = dataGridView1.CurrentCell.ColumnIndex; txtcellvalue.Text = dataGridView1.Rows[i].Cells[j].Value.ToString(); // Getting cell value into TextBox } private void btnupdate_Click(object sender, EventArgs e) { SqlCommandBuilder scmb = new SqlCommandBuilder(dadptr); try { dadptr.Update(dset); MessageBox.Show("Saved"); // // Showing Success Message } catch (Exception) { MessageBox.Show("Not Saved"); // Showing Failure Message } } private void btnchange_Click(object sender, EventArgs e) { dset.Tables[0].Rows[i][j] = txtcellvalue.Text; // Set the value of DataSet with the value of TextBox } } }
As you have seen, there are two buttons in this application - "Change" and "Update". The "change" button updates the cell value of DataSet with the TextBox value and the "Update" button saves the updated value in the Database. Run the application. Output Now click at any cell of DataGridView. Its value will be shown in TextBox.
Update the value of the TextBox and click the "Change" button. It will replace the value of DataGridView cell vlaue by TextBox. Click the "" button to save changes into Database. It will show success or failure message according to operation.
Pro WPF: Windows Presentation Foundation in .NET 3.0