string mysql = "select zs=count(*) from(SELECT name,number,sum(zj) fs FROM main WHERE convert(char(10),date1,120)between Ltrim(year(getdate())-1)+'-12-21'and Ltrim(year(getdate()))+'-12-20'and dw='" + Session["dw"].ToString() + "'and bm='" + Session["bm"].ToString() + "'" GROUP BY name,number)tb where fs >=" + hf1.Value;string mysql = "select zs1=count(*) from(SELECT name1,number1,sum(zj) fs1 FROM main WHERE convert(char(10),date1,120)between Ltrim(year(getdate())-1)+'-12-21'and Ltrim(year(getdate()))+'-12-20' GROUP BY name,number)tb where fs1 >=" + hf1.Value;
SqlCommand cmd = new SqlCommand(mysql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read() )
{然后读取dr["zs"].tostring()和dr["zs1"].tostring()}要能实现读取dr["zs"].tostring()和dr["zs1"].tostring(),前面的怎么改
再读zs1
{
string mysql = "select zs=count(*) from(SELECT name,number,sum(zj) fs FROM main WHERE convert(char(10),date1,120)between Ltrim(year(getdate())-1)+'-12-21'and Ltrim(year(getdate()))+'-12-20'and dw='" + Session["dw"].ToString() + "'and bm='" + Session["bm"].ToString() + "'" GROUP BY name,number)tb where fs >=" + hf1.Value;
Response.Write((ReturnDataTable(mysql) as DataTable).Rows.Count>0?(ReturnDataTable(mysql) as DataTable).Rows[0]["zs"].ToString():""); }
public static DataTable ReturnDataTable(string cmdtext)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "数据库连接字符串";
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand(cmdtext, cn);
cmd.CommandType = CommandType.Text; ;
SqlDataReader dr = null;
using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(dr);
}
return dt;
}
SqlCommand cmd = new SqlCommand(mysql1, conn);
string zs = cmd.ExecuteScalar().ToString(); cmd = new SqlCommand(mysql2, conn);
string zs1 = cmd.ExecuteScalar().ToString();string zs和zs1就是你要获取的值,注意打开数据库 conn.Open();