SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conn"]);
conn.Open();
//string sql = "Select count(*) sum(money)from detail where zy='" + Session["unit"].ToString() + "' convert(varchar(10),time,120)='"+Session["date"]+"'";
string sql = "select sum(jifen),sum(amount),count(*) from detail where convert(varchar(10),time,120)='2008-03-26'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
this.TextBox1.Text = ???????;
}
else
{
Response.Write("出错");
}
上边是连接数据库,然后查询,然后写入的结果。我的意思是把查询到的sum写入。textbox1.text里边。帮我完成问号里边的内容就可以了。。20分。在线等。。正确的第一个给分。
conn.Open();
//string sql = "Select count(*) sum(money)from detail where zy='" + Session["unit"].ToString() + "' convert(varchar(10),time,120)='"+Session["date"]+"'";
string sql = "select sum(jifen),sum(amount),count(*) from detail where convert(varchar(10),time,120)='2008-03-26'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
this.TextBox1.Text = ???????;
}
else
{
Response.Write("出错");
}
上边是连接数据库,然后查询,然后写入的结果。我的意思是把查询到的sum写入。textbox1.text里边。帮我完成问号里边的内容就可以了。。20分。在线等。。正确的第一个给分。
if (reader.Read())
{
this.TextBox1.Text = reader["jifen"].ToString();;
}
也可以
this.TextBox1.Text = reader["jifen"].ToString();
this.TextBox2.Text = reader["amount"].ToString();
this.TextBox3.Text = reader["count"].ToString();
conn.Open();
//string sql = "Select count(*) sum(money)from detail where zy='" + Session["unit"].ToString() + "' convert(varchar(10),time,120)='"+Session["date"]+"'";
string sql = "select sum(jifen) as jifen,sum(amount),count(*) from detail where convert(varchar(10),time,120)='2008-03-26'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
if(reader.Read())
{
this.TextBox1.Text = reader["jifen"].ToString();
}
else
{
Response.Write("出错");
}
浪费我宝贵时间。