How to save changes from “textbox” to database?

The current entry from "dataGridView1" is displayed in "textBox1".

The user in "textBox1" makes changes.

How to save changes from "textBox" to the database and display in "dataGridView1"?

I enclose the code of my decision.

If the form has several "textBox", "checkBox1", then make an event for each element, somehow troublesome ...

Are there any other more efficient ways to do this?

picture - http://www.imageup.ru/img249/3222168/2018-11-23_15-05-54.png.html

public partial class Frm1UC : UserControl
{
DataTable dt;
OleDbConnection connection;
OleDbDataAdapter adapter;
OleDbCommandBuilder commandBuilder;
static string catBD = @"c:\vs\csharp\db_GridVAccess.accdb";
string connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", catBD);
string sql = "SELECT * FROM TreeFolder_tbl";
// *** ???????????
public Frm1UC()
{
InitializeComponent();
}
// *** ???????. ???????? ?????
private void Frm1UC_Load(object sender, EventArgs e)
{
using (OleDbConnection cn = new OleDbConnection())
{
connection = new OleDbConnection(connectionString);
connection.Open();
adapter = new OleDbDataAdapter(sql, connection);
commandBuilder = new OleDbCommandBuilder(adapter);
dt = new DataTable();
adapter.Fill(dt);
dataGridView1.DataSource = dt;
}
}
// ????? ??????
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
textBox1.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
}
// ???????. ????????? ??????
private void textBox1_TextChanged(object sender, EventArgs e)
{
dataGridView1.CurrentRow.Cells[1].Value = textBox1.Text;
}
// ?????????
public void Save()
{
adapter.Update(dt);
}
private void button1_Click(object sender, EventArgs e)
{
Save();
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://www.c-sharpcorner.com/UploadFile/1e050f/edit-and-update-record-in-gridview-in-Asp-Net/
0
Asma Khalid7y ago
Look into this -> https://bit.ly/2tJqs9c

Mark the answer yes it helps
Visit www.asmak9.com for more...
+1
Sanwar Ranwa7y ago
Hello Ivan

i think you want to Update or edit in your datagrid

https://www.aspsnippets.com/Articles/Simple-Insert-Select-Edit-Update-and-Delete-in-ASPNet-GridView-control.aspx

https://www.c-sharpcorner.com/UploadFile/1e050f/edit-and-update-record-in-gridview-in-Asp-Net/

https://www.c-sharpcorner.com/UploadFile/9f0ae2/gridview-edit-delete-and-update-in-Asp-Net/
+1