语句"SELECT SUM('totalprice') AS 总和 FROM equipment"一个button总价 数据显示在textbox内对sql语句转化到控件很陌生帮我写下吧
解决方案 »
- 如何给表里的行数据分配ID
- 有个关于遍历时间段的问题,请高手帮忙解答下
- B/S控制用户数目.一级单一用户只能登录一次
- 如何获取SqlDataReader中的行数??
- 日期处理(日程安排)-在固定日期段里剔除节假日等最终生成一个日期周次安排
- asp.net用ado.net 连接sql数据库字符串是怎样的?
- 在asp.net web maxtrix中怎样调用类
- 企业管理器中创建存储过程确定后提示@需要声明请问?@如何声明(在线等急!急!急!)
- Help:Visual Studio 2003下用source safe(或其它) 团队开发asp.net程序,如何合理进行?越详细越好
- Fill DataSet出现异常,如何解决
- 后台设置Chexbox属性问题
- 随机数为什么是一样的?
private void GridViewBind()
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string SqlStr = "SELECT SUM('totalprice') AS 总和 FROM equipment";
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(connStr);
try
{
if (conn.State.ToString() == "Closed")
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
da.Fill(ds);
foreach(DataRow dr in ds.Table[0].DefultView)
{
this.textbox1.text=dr["总和"].Tostring()
} }
catch (Exception ex)
{
Response.Write("数据库错误,错误原因:" + ex.Message);
Response.End();
}
finally
{
if (conn.State.ToString() == "Open")
conn.Close();
}
}
SqlConnection conn=new SqlConnection(connStr);
conn.Open();
string sql="SELECT SUM('totalprice') AS total FROM equipment";
System.Data.SqlClient.SqlCommand cmd = new SqlCommand(sql, conn);
TextBox1.Text=cmd.ExecuteScalar().ToString();
cmd.Dispose();
conn.Close();
conn.Dispose();
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd=new SqlCommand("SELECT SUM('totalprice') AS 总和 FROM equipment",conn);
try
{
this.textbox1.text=Convert.Tostring(cmd.ExecuteNonQuery());
} }
catch (Exception ex)
{
Response.Write("操作失败:原因是" + ex.Message);
Response.End();
}
finally
{
if (conn.State.ToString() == "Open")
conn.Close();
}
}
conn.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];
SqlCommand thisCommand = new SqlCommand("SELECT SUM('totalprice') AS 总和 FROM equipment", conn);
thisCommand.CommandType = CommandType.Text;
try
{
thisCommand.Connection.Open()
SqlDataReader dr = thisCommand.ExecuteReader();
while(dr.Read())
{
this.textbox1.text=dr["总和"].Tostring()}
}
catch(System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
可以在页面放文本框 或是 用下拉框 让用户来输入或选择 地点 将选择的值作为条件 SELECT SUM('totalprice') AS 总和 FROM equipment where 地点=你选择的值