SqlConnection conn = new SqlConnection("你的数据库连接字符串");
conn.Open() //打开连接SqlCommand cmd = new SqlCommand("你的执行SQL语句", conn);
SqlDataReader reader = cmd.ExecuteReader();//执行并获得结果
while(reader.Read())
{
//读取结果
}
conn.Open() //打开连接SqlCommand cmd = new SqlCommand("你的执行SQL语句", conn);
SqlDataReader reader = cmd.ExecuteReader();//执行并获得结果
while(reader.Read())
{
//读取结果
}
SqlConnection cn=new SqlConnection("server=.;database=pubs;uid=sa;pwd=sa");
SqlCommand cm=new SqlCommand("select * from jobs",cn)
cm.EndExecuteReader();
cn.closed();
SqlConnection cn=new SqlConnection("DataSource=.;Integrated Security=SSPI;Initialog=NorthWind");
try
{
if (con.State != ConnectionState.Open) con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "proc_GetAccessories";
com.Parameters.Add(new SqlParameter("@ContactID", SqlDbType.Int));
com.Parameters["@ContactID"].Value = ContactID;
com.Parameters["@ContactID"].Direction = ParameterDirection.Input;
SqlDataAdapter ada = new SqlDataAdapter(com);
DataTable dt = new DataTable();
ada.Fill(dt);
return dt.Rows;
}
catch (Exception error)
{
error.ToString();
return null;
}
finally
{
if (con.State != ConnectionState.Closed) con.Close();
}