string sqss = string.Empty;
sqss = "select sum(ckje) FROM tmypsq";
js.Text =如何把sqss = "select sum(ckje) FROM tmypsq";的值赋值给js.Text ???
sqss = "select sum(ckje) FROM tmypsq";
js.Text =如何把sqss = "select sum(ckje) FROM tmypsq";的值赋值给js.Text ???
SqlCommand comm = new SqlCommand(sqss , conn);
conn.open();
js.Text =comm.ExecuteScalar().tostring();
conn.close();
{
con.Open();
string sqss = string.Empty;
sqss = "select sum(ckje) FROM tmypsq";
using(SqlCommand cmd = new SqlCommand(sqss,con))
{
js.Text = cmd.ExecuteScalar().ToString();
}
}
sqss = "select sum(ckje) FROM tmypsq";
js.Text =
楼主声明了一个string类型的变量sqss来接受SQL语句"select sum(ckje) fro tmypsg" 查询出的数值。首先楼主要知道此程序是要与数据库进行交互的,也就是说得从数据库查出来。
那就应该要使用ADO.NET。
ADO.NET是.NET提供的与数据库交互常用的几个类
Connection 数据库连接类
Command 执行命令
DataSet 数据集
DataAdapter 数据适配器
DataReader 数据读取器示例:class Program
{
static void Main()
{
string sqss = string.Empty;
//数据库连接字符串
string connString = "Data Source =.;Initial Catalog = MySchool;User ID = sa;PWD = 123456";
using(SqlConnection connection = new SqlConnection(connString))
{
sqss = "select sum(ckje) FROM tmypsq";
using(SqlCommand objCommand = new SqlCommand(sql,connection))
{
connection.Open();
js.Text = objCommand.ExecuteScalar().ToString();
}
}
}
}