SqlDataReader使用
SqlDataReader myReader = null;
SqlConnection mySqlConnection = new SqlConnection("数据库连接");
SqlCommand mySqlCommand = new SqlCommand("select * from customers", mySqlConnection);
try
{
mySqlConnection.Open();
myReader = mySqlCommand.ExecuteReader();
while (myReader.Read())
{
Console.Write(myReader["CustomerID"].ToString() + " ");
Console.WriteLine(myReader["CompanyName"].ToString());
}
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
if (myReader != null)
myReader.Close();
if (mySqlConnection.State == ConnectionState.Open)
mySqlConnection.Close();
}
//操作这个对象
SqlConnection myConnection = new SqlConnection("server=(local)\NetSDK;Integrated Security=SSPI;database=northwind");
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("select * from customers", myConnection);
mySqlDataAdapter.InsertCommand.CommandText = "sp_InsertCustomer";
mySqlDataAdapter.InsertCommand.CommandType = CommandType.StoredProcedure;
mySqlDataAdapter.Update(myDataSet);
mySqlDataAdapter->Update(myDataSet);