c#.Net : Execute two SQL statements at a time

Question

请问有没有办法执行多条SQL语句。就像我想获得计数和值(value)一样。我如何在 C# 中执行此操作？

查询 1:

cmd = new SqlCommand("select count(*) from tblStock where prodName=@prodName", con); // to get count

查询 2:

cmd = new SqlCommand("select quantity from tblStock where prodName=@prodName", con);// to get qty

int count, qty;

        try
        {
            con.Open();
            count = (Int32)cmd.ExecuteScalar(); //returns null if doesnt exist
            qty = (Int32)cmd.ExecuteScalar();

        }

这可能吗？

Answer 1

您不能只在一个选择查询中同时选择两个值吗？

cmd = new SqlCommand("select quantity, count(*) from tblStock where prodName=@prodName", con);