都写那么多了,把查询出来的结果集放到ds里去.你查询的值不就在表里了吗?string sqltxt = "select count(*) from em.T_COMM_CUSTOMER ”; OleDbConnection con = new OleDbConnection(ConnectionDB2String); con.Open(); OleDbCommand cmd = new OleDbCommand(sqltxt, con); OleDbAdapter da = new OleDbAdapter(cmd); DataSet ds = new DataSet(); ds.Fill(ds,"Table1"); int iCount = (int)ds.Tables["Table1"].Rows[0][0];
SQL语句改为: select count(*) as Count from em.T_COMM_CUSTOMER 和其它: 用DataSet读取:
Int64 intcount; string str1 = ""; str1 = "select count(*) as ID from table ";
OleDbConnection con = new OleDbConnection(ConnectionDB2String); SqlCommand cmd = new SqlCommand(str1, conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { intcount = int.Parse(dr[0].ToString()); } else { intcount = 0; } dr.Close(); dr.Dispose(); conn.Close(); conn.Dispose();
string sqltxt = "select count(*) from em.T_COMM_CUSTOMER ”; OleDbConnection con = new OleDbConnection(ConnectionDB2String); con.Open(); OleDbCommand cmd = new OleDbCommand(sqltxt, con); int count=(Int32)cmd.ExecuteScalar(); con.Close();
int a=cmd.ExecuteScalar();这个效率很快 只获取单行数据 web应用程序 我不推荐用DATASET.
OleDbConnection con = new OleDbConnection(ConnectionDB2String);
con.Open();
OleDbCommand cmd = new OleDbCommand(sqltxt, con);
OleDbAdapter da = new OleDbAdapter(cmd);
DataSet ds = new DataSet();
ds.Fill(ds,"Table1");
int iCount = (int)ds.Tables["Table1"].Rows[0][0];
select count(*) as Count from em.T_COMM_CUSTOMER
和其它:
用DataSet读取:
string str1 = "";
str1 = "select count(*) as ID from table ";
OleDbConnection con = new OleDbConnection(ConnectionDB2String);
SqlCommand cmd = new SqlCommand(str1, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
intcount = int.Parse(dr[0].ToString());
}
else
{
intcount = 0;
} dr.Close();
dr.Dispose();
conn.Close();
conn.Dispose();
这个应该是你想要的结果:
a=int.parse(cmd.xecuteScalar().tostring())
OleDbConnection con = new OleDbConnection(ConnectionDB2String);
con.Open();
OleDbCommand cmd = new OleDbCommand(sqltxt, con);
int count=(Int32)cmd.ExecuteScalar();
con.Close();
web应用程序 我不推荐用DATASET.