Asp.net detailed description of the DataTable operation (add search for deletion and modification)

The primary key of the data table uses id column auto-increment. For example, the table structure: users table

Id

Name

Sex

Add

Tel

All data in the users table is retrieved to a able dataset through the dataset and sqldataadapter. Query: datatable dt = database tutorial query set; datarow [] dr = dt. select ("id =" + txt_id.value); txt_name.value = dr [0] ["name"]. tostring (); txt_add.value = dr [0] ["add"]. tostring (); add: datatable = database query set; datatable. rows. add (new object [] {name, sex, add, tel}); Data list binding (datatable); Delete: datatable dtable = database query set; dtable. rows. remove (dtable. select ("id = 2") [0]); Data list binding (datatable); changed: datatable dtable = database query set; datarow drow = dtable . Select ("id = 3") [0]; drow. beginedit (); drow ["name"] = txt_name.value.trim (); drow ["add"] = txt_add.value.trim (); drow. endedit (); Data list binding (dtable); Note: select (...) appears multiple times in this article (..........) [0]; why is this code followed by [0]? Because the select query returns a datarow [] set, we only need the first element in the set. The following table is 0.