我在C#想显示SQL的一个执行结果,用Gridview绑定了datatable,结果只能显示"总价格",而sum(fare)却怎么也不显示,单步调试时可以确定SQL语句是正确的,而且reader里有值,也没报错,只是不显示数据...WHY??
string bronumber = tb0.Value;
int i = Convert.ToInt32(bronumber); string startdate = tb1.Value;
string enddate = tb2.Value; OracleCommand comm;
String sql = "select sum(fare) from broker_fund where tx_date between " + startdate + " and " + enddate + " and broker_no =" + i + "";
comm = new OracleCommand(sql, conn);
conn.Open();
table = new DataTable();
// 在DataTable对象中添加列
table.Columns.Add("总价格");
reader = comm.ExecuteReader(); while (reader.Read())
{ ///构造新的数据行
row = table.NewRow(); row["总价格"] = reader[0].ToString();
table.Rows.Add(row);
}
// 释放对象
reader.Close();
conn.Close();
GridView1.DataSource = table;
GridView1.DataBind();
谢谢大家!
string bronumber = tb0.Value;
int i = Convert.ToInt32(bronumber); string startdate = tb1.Value;
string enddate = tb2.Value; OracleCommand comm;
String sql = "select sum(fare) from broker_fund where tx_date between " + startdate + " and " + enddate + " and broker_no =" + i + "";
comm = new OracleCommand(sql, conn);
conn.Open();
table = new DataTable();
// 在DataTable对象中添加列
table.Columns.Add("总价格");
reader = comm.ExecuteReader(); while (reader.Read())
{ ///构造新的数据行
row = table.NewRow(); row["总价格"] = reader[0].ToString();
table.Rows.Add(row);
}
// 释放对象
reader.Close();
conn.Close();
GridView1.DataSource = table;
GridView1.DataBind();
谢谢大家!
{ ///构造新的数据行
row = table.NewRow(); row["总价格"] = reader[0].ToString();
table.Rows.Add(row);
}
就跳过去了,进不了大括号里,很奇怪,谁能知道怎么回事啊?苦恼中..