ADO.NET中数据库连接的两种模式:连接模式和断开模式
连接模式:
SqlConnection sqlConnection = new SqlConnection(“Server = ; database = ; user id = ; password = ;”);
SqlCommand sqlComm = new SqlCommand(“select * from authors”, sqlConn);
sqlConn.open();
SqlDataReader dr = sq1Comm.ExecuteReader();
while(dr.Read())
{
for(int i = 0; i < dr.FieldCount; i++)
{
Console.Write(dr.GetValue(i).ToString() + ” “);
}
Console.WriteLine();
}
dr.Close();
sqlConn.Close();
//数据的读取在连接关闭之前
断开模式:
SqlConnection sqlConn = new SqlConnection(“Server = ; database = ; user id = ; password = ;”);
SqlDataAdapter adapter = new SqlDataAdapter(“select * from authors”, sqlConn);
//用来自动生产更新命令
SqlCommandBuilder cb = new SqlCommandBuilder( adapter );
sqlConn.Open();
DataSet ds = new DataSet();
adapter.Fill(ds);
sqlConn.Close();
//处理数据在打开和关闭之后
for( int i =0; i < ds.Table[0].Rows.Count; i ++)
{
for ( int j = 0; j < ds.Table[0].Columns.Count; j ++)
{
Console.Write(ds.Table[0].Rows[i][j] + ” “);
}
Console.WriteLine();
}
ds.Table[0].Rows[0][1] = “ZA”;
ds.Table[0].Rows[1].Delete();
//更新数据库
sqlConn.Open();
adapter.Update(ds);
sqlConn.Close();