DataSet DataTable操作

SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) //行的读取 { Response.Write(sdr[0]); //列的读取，第一列 Response.Write(sdr[1]); //列的读取，第二列 Response.Write("<br>"); }

 

SqlDataAdapter sda=new SqlDataAdapter(); SqlCommand selectcmd=new SqlCommand("select * from test",con); sda.InsertCommand = new SqlCommand("insert into test values(@ID,@UserName)",con); sda.InsertCommand.Parameters.Add(new SqlParameter("@ID", System.Data.SqlDbType.VarChar, 10, "ID")); sda.InsertCommand.Parameters.Add(new SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 20, "UserName")); sda.SelectCommand = selectcmd; DataSet ds = new DataSet(); sda.Fill(ds,"test"); DataTable myTable = ds.Tables["test"]; DataRow dr = myTable.NewRow(); dr["ID"] = "010"; dr["UserName"] = "John"; myTable.Rows.Add(dr); sda.Update(ds.Tables["test"]); Response.Write("<h3>数据集</h3><hr>"); Response.Write("<table border=1 cellspacing=0 cellpadding=2>"); Response.Write("<tr bgcolor=red>"); foreach (DataColumn ColumnName in myTable.Columns) { Response.Write("<td>" + ColumnName.ColumnName + "</td>"); } Response.Write("</tr>"); foreach (DataRow row in myTable.Rows) { Response.Write("<tr>"); foreach (DataColumn ColumnData in myTable.Columns) { Response.Write("<td>" + row[ColumnData] + "</td>"); } Response.Write("</tr>"); } Response.Write("</table>");