資料庫datatable

『壹』 C# datatable 讀取資料庫

DataTable dtb = null;
string sql = "select class from table1 where name = '張三' ";
dtb = db.GetDataTable(db.form,sql);

string dtbStr=dtb.Rows[行下標][列下標].toString(); //兩種寫法，獲得datatable中的某行某列專的值
string dtbStr1=dtb.Rows[行下標]["列名屬"].toString();

『貳』 如何將DataTable更新到資料庫中

SqlDataAdapter adapter = new SqlDataAdapter(strSql, strConn);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet ds = new DataSet();
adapter.Fill(ds, "Titles");

//插入記錄
DataTable table = ds.Tables["Titles"];
DataRow row = table.NewRow();
row["Title_id"] = "JP1001";
row["title"] = "programming Microsoft .NET";
row["price"] = 59.99m;
row["ytd_sales"] = 100000;
row["type"] = "business";
row["pubdate"] = new DateTime(2002, 5, 1);
table.Rows.Add(row);
//更新資料庫
adapter.Update(table);