110,533
社区成员
发帖
与我相关
我的任务
分享
......
SqlCommand MyCommand = new SqlCommand(command, MyConnection);
datareader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);//这表明当我们手工关闭dataReader后,数据库连接会自动关闭。
//MyConnection.Close();
...........
......
//MyConnection.Close();
该句已经被我//了!不然在别的页面就的不到返回的SqlDataReader.public static DataTable TiredQuery(string command)
{
SqlConnection MyConnection = new SqlConnection(MyConn);
SqlDataAdapter da = new SqlDataAdapter(command,MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
/// <summary>
/// 批量读取数据
/// </summary>
/// <param name="command">查询语句 </param>
/// <returns>返回SqlDataReader数据留 </returns>
public static SqlDataReader TiredQuery(string command)
{
SqlDataReader datareader = null;
try
{
string MyConn = dbconn();
SqlConnection MyConnection = new SqlConnection(MyConn);
MyConnection.Open();
SqlCommand MyCommand = new SqlCommand(command, MyConnection);
datareader = MyCommand.ExecuteReader();
while (datareader.Read())
{
string f1 = (string)datareader["Field1"];
string f2 = (string)datareader["Field2"];
string f3 = (string)datareader["Field3"];
//.......
}
datareader.Close();
MyConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误!");
}
return datareader;
}