如何动态地将datagridview数据插入数据库 [英] how to insert dynamically datagridview data to database

问题描述

嗨...我正在像这样的代码在datable中动态显示数据...我不知道如何将修改后的数据从datagridview插入数据库.....

hi...i am displaying dynamically data in datable like this code...i dont know how to insert the modified data from datagridview to database.....

int sitting = Convert.ToInt32(D3.Text);
 DataTable dt = new DataTable();
 DataRow dr;
 dt.Column1.Add("Treatment Name");
 dt.Columns.Add("Detail");
dt.Columns.Add("amount");
for (int i = 0; i < sitting; i++)
{
 dr = dt.NewRow();

 dr["Treatment Name"] = D1.Text;
    dr["Detail"] = D2.Text;
   dr["amount"] = "";
   dt.Rows.Add(dr);
   }
  dataGridView1.DataSource = dt;

推荐答案

查看此

See this
DataBase Updation With DataGridView in simple steps[^]

实际上我不需要更新数据...如何使用datatable在datagridview中动态显示数据插入数据库....

actually i dont need to update data...how dynamical displaying data in datagridview insert into database using datatable....

这篇关于如何动态地将datagridview数据插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！