如何在SQL Server的数据表中动态添加行
问题描述:
如何动态添加行数据?
我用这段代码创建了一些列:
I created some columns with this code:
DataTable obj_dt_grdvw = new DataTable();
obj_dt_grdvw.Columns.Add("_Pur_Product_Id", typeof(string));
obj_dt_grdvw.Columns.Add("Product_pur_Name", typeof(string));
现在我尝试添加一行数据,但显示错误没有行0
Now I tried to add a row of data but showing error "there is no row at 0"
obj_dt_grdvw.Rows[0]["_Pur_Product_Id"] ="12";
obj_dt_grdvw.Rows[0]["Product_pur_Name"] ="milk";
我的错误是什么?
答
当您创建新的datatable时,它是空的 - 即没有行。这就是为什么在索引 0
找不到行。您应该手动创建和添加行。
When you create new datatable, it is empty - i.e. there is no rows. That's why you can't find row at index 0
. You should create and add rows manually.
使用 DataTable.NewRow 方法来创建与您的datatable相同的列(即相同的模式)的新行:
Use DataTable.NewRow method to create new row with same columns (i.e. same schema) as your datatable:
DataRow row = obj_dt_grdvw.NewRow(); // create new row
row["_Pur_Product_Id"] ="12"; // set field values
row["Product_pur_Name"] ="milk";
obj_dt_grdvw.Rows.Add(row); // add this new row to table rows