创建了一个 Button1,TextBox1,想把这样一条SQL语句——“select sum(shl*jhj) from chengben2”
点击Button1后在TextBox1显示出来,怎么操作?
就是单单显示结果(shl*jhj)——数量*计划价;
我已经这样写了:
protected void Button1_Click(object sender, EventArgs e)
{
Cn = new SqlConnection("Data Source=CHINA-4DB156EC6\\SQLEXPRESS;
Initial Catalog=dianjichang;Integrated Security=True");
string selectstring="select sum(shl*jhj) from chengben2";
SqlCommand cmd=new SqlCommand (selectstring ,Cn );
Cn.Open();
SqlDataReader dtr=cmd.ExecuteReader (CommandBehavior.CloseConnection );
DataSet ds = new DataSet();
TextBox1.Text =Convert.ToString ( get (dtr ));(????)
} 有什么问题和如何继续,请给位指导一二.....谢谢啦。
点击Button1后在TextBox1显示出来,怎么操作?
就是单单显示结果(shl*jhj)——数量*计划价;
我已经这样写了:
protected void Button1_Click(object sender, EventArgs e)
{
Cn = new SqlConnection("Data Source=CHINA-4DB156EC6\\SQLEXPRESS;
Initial Catalog=dianjichang;Integrated Security=True");
string selectstring="select sum(shl*jhj) from chengben2";
SqlCommand cmd=new SqlCommand (selectstring ,Cn );
Cn.Open();
SqlDataReader dtr=cmd.ExecuteReader (CommandBehavior.CloseConnection );
DataSet ds = new DataSet();
TextBox1.Text =Convert.ToString ( get (dtr ));(????)
} 有什么问题和如何继续,请给位指导一二.....谢谢啦。
{
TextBox1.Text ="select sum(shl*jhj) from chengben2";
}
{
string selectstring="select sum(shl*jhj) from chengben2";
TextBox1.Text =selectstring;
}
{
Cn = new SqlConnection("Data Source=CHINA-4DB156EC6\\SQLEXPRESS;
Initial Catalog=dianjichang;Integrated Security=True");
string selectstring="select sum(shl*jhj) from chengben2";
SqlCommand cmd=new SqlCommand (selectstring ,Cn );
Cn.Open();
string s = string.Empty;
try
{
s = cmd.ExecuteScalar().ToString();
}
catch(Exception ee)
{
Cn.Close();
}
TextBox1.Text =s; }