asp.net(c#)同时执行多个select语句

最新推荐文章于 2021-04-08 16:21:52 发布

bydxyj

最新推荐文章于 2021-04-08 16:21:52 发布

阅读量3.5k

点赞数

分类专栏： ASP.Net 文章标签： asp.net c# cmd

本文链接：https://blog.youkuaiyun.com/bydxyj/article/details/3546402

版权

ASP.Net 专栏收录该内容

87 篇文章

订阅专栏

本文演示了如何使用C#中的SqlCommand执行多个SQL查询，并通过SqlDataReader读取结果，最后将查询结果存储到Hashtable中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

        Hashtable hs = new Hashtable();
        int j = 0;
        SqlConnection con = Infcon.create();
        con.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "select count(*) from V_BYD_jc where average between 85 and 100;";
        cmd.CommandText += " select count(*) from V_BYD_jc where average between 80 and 84;";
        cmd.CommandText += " select count(*) from V_BYD_jc where average between 70 and 79";
        cmd.CommandText += " select count(*) from V_BYD_jc where average<=69 and average>0";
        cmd.CommandText += " select count(*) from V_BYD_jc where average=0;";
        cmd.CommandText += "select count(*) from v_byd_jc where jcsize='大';";
        cmd.CommandText += "select count(*) from v_byd_jc where jcsize='小'";
        SqlDataReader dr = cmd.ExecuteReader();
        do
        {
            if (dr.Read())
            {
                hs[j] = dr.GetInt32(0);//获取查询的结果
            }
            else
            {
                hs[j] = 0;//如果没有，则赋值为0
            }
            j++;
        } while (dr.NextResult());//读取下一个结果集