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.
