62,254
社区成员
发帖
与我相关
我的任务
分享 public void getSqlDataReader()
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "...";
string sql = "...";
SqlCommand cmd = new SqlCommand(sql, conn);
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
//...
}
}
}
}
public SqlDataReader returnSqlDataReader(int id)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "...";
string sql = "select * from table where id=" + id + "";
SqlCommand cmd = new SqlCommand(sql, conn);
return cmd.ExecuteReader();
}
}
public SqlDataReader returnSqlDataReader(string name)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "...";
string sql = "select * from table where name='" + name + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
return cmd.ExecuteReader();
}
}
public static SqlConnection con = new SqlConnection("连接数据库字符串");
public SqlDataReader GetReader(string sql)
{
con.Open();
SqlCommand com = new SqlCommand(sql,con);
SqlDataReader reader = com.ExecuteReader();
return reader;//读取完数据后,要关闭reader con
}
public SqlDataReader GetReader(string sql,SqlParameter [] param)
{
con.Open();
SqlCommand com = new SqlCommand(sql, con);
com.Parameters.AddRange(param);
SqlDataReader reader = com.ExecuteReader();
return reader;//读取完数据后,要关闭reader con
}
