ADO.NET

一、关于ADO.NET主要类的使用和常用操作
SqlConnection cn = new SqlConnection("server=.;database=accpdb;uid=sa;pwd=sa.");
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter("select * from student where id = @id",cn);
sda.SelectCommand.Parameters.Add("@id", SqlDbType.VarChar).Value = "S0001";
sda.Fill(ds, "tb");
foreach (DataRow dr in ds.Tables[0].Rows)
{
string Id = dr["sId"].ToString();
int age = Convert.ToInt32(dr["sAge"]);
}
DataView dv = new DataView(ds.Tables[0]);
dv.RowFilter = "Sex='男'";

DataTable dt = new DataTable();
DataRow dr = dt.NewRow();
dt.Columns.Add("id",typeof(int));
dt.Columns.Add("name", typeof(string));
ds.Tables.Add(dt);
dt.Rows.Add(dr);

二、关于ADO.NET事务类的使用
SqlConnection cn = new SqlConnection("server=.;database=accpdb;uid=sa;pwd=sa.");
SqlCommand cm = new SqlCommand();
cm.Connection = cn;
cm.CommandText = "insert into Student values(1,'Tom')";
cn.Open();
SqlTransaction trans = cn.BeginTransaction();
cm.Transaction = trans;
try
{
cm.ExecuteNonQuery();
cm.CommandText = "insert into score values(1,89)";
cm.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
}
finally
{
cn.Close();
}

三、关于SqlDataReader类的使用
SqlConnection cn = new SqlConnection("server=.;database=accpdb;uid=sa;pwd=sa.");
SqlCommand cm = new SqlCommand();
cm.Connection = cn;
cm.CommandText = "select * from student";
cn.Open();
SqlDataReader sdr = cm.ExecuteReader();
while (sdr.Read())
{
Console.WriteLine(sdr["name"].ToString());
}
cn.Close();