public static void Qr() {
string strConn = "Data Source=DESKTOP-QDQS9F8;Initial Catalog=QQ用户信息;User ID=sa;pwd =root";
SqlConnection conn = null;
SqlDataReader Reader = null;
try
{
conn = new SqlConnection(strConn);
conn.Open();
string sal = string.Format("select *from userinfo");
SqlCommand comm = new SqlCommand(strConn);
SqlCommand com = new SqlCommand(sal, conn);
Reader = com.ExecuteReader();
while (Reader.Read())
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}", Reader["UserId"], Reader["UserName"], Reader["levelId"], Reader["Email"], Reader["OnlinDay"]);
}
}
catch (Exception w) {
Console.WriteLine(w.Message);
}
finally
{
if (Reader != null) {
Reader.Close();
}
if (conn != null) {
conn.Close();
}
}
这个代码不会死循环,读取完就会返回false停止了,是不是数据量太大了导致UI假死
您好,我是有问必答小助手,您的问题已经有小伙伴解答了,您看下是否解决,可以追评进行沟通哦~
如果有您比较满意的答案 / 帮您提供解决思路的答案,可以点击【采纳】按钮,给回答的小伙伴一些鼓励哦~~
ps:问答VIP仅需29元,即可享受5次/月 有问必答服务,了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632