求教,label.text 赋值无法显示
求教各位大侠,下列代码中将数据库中 总价 列 求和后 赋值给 label2.text ,form框体上数值无法显示。求帮忙看看哪里有问题
private void label2_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
String str = "./db1.mdb";
OleDbConnection OleDbcon = new OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + str + ";User ID=admin;Password=;Jet OLEDB:Database Password=");
OleDbcon.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = OleDbcon;
string s = label2.Text;
string select = String.Format("SELECT 总价 FROM sheet1 union all SELECT sum(总价) FROM sheet1", s);
cmd.CommandText = select;
OleDbDataReader reader = cmd.ExecuteReader();
reader.Read();
label2.Text = reader.GetString(0);
}
------解决方案--------------------if(reader.Read())
{
label2.Text = reader.GetString(0);
}
------解决方案--------------------跟一下代码,这种事情,基本上都是因为你的sql没有读到结果!
目测,是因为你的sql问题!
------解决方案--------------------label2.Text = reader[0].ToString();