难道只能用select count(*) as cnt from table1 然后用OleDbDataReader dr……来dr["cnt"]吗?
你是说 select count(*) as aa from tabel1???
楼主,你不这样还想怎么样?你不会想直接在sql server里就赋值好给一个ASP的全局变量吧。
SqlConnection con = new SqlConnection("连接字符串");SqlCommand cmd = new SqlCommand( "Select Count(*) from table1",con );con.Open();int aa=0; try { aa = (int)cmd.ExecuteScalar(); } catch{} con.Close();
set @aa int select @aa=count(*) from table1
aa = (int)cmd.ExecuteScalar();这个方法是可行,但只能取出一个值; 要实现SELECT SUM(字段1) INTO :aa, SUM(字段2) INTO :bb from table1呢? 我是想知道除了用DATAREADER读结果外,有别的快捷方法吗? ——就是能直接在SQL里赋值给C#的变量吗?
SqlConnection con = new SqlConnection("连接字符串");SqlCommand cmd = new SqlCommand( "Select Count(字段1) As aa,Count(字段2) asbb from table1",con );con.Open();SqlDataReader reader = cmd.ExecuteReader();int aa=0,bb=0; if( reader.Read() ) { try { aa = reader.GetInt32("aa"); } catch{} try { bb = reader.GetInt32("bb"); } catch{} }reader.Close(); con.Close();
然后用OleDbDataReader dr……来dr["cnt"]吗?
select count(*) as aa from tabel1???
try {
aa = (int)cmd.ExecuteScalar();
}
catch{} con.Close();
select @aa=count(*) from table1
要实现SELECT SUM(字段1) INTO :aa, SUM(字段2) INTO :bb from table1呢?
我是想知道除了用DATAREADER读结果外,有别的快捷方法吗?
——就是能直接在SQL里赋值给C#的变量吗?
if( reader.Read() )
{
try {
aa = reader.GetInt32("aa");
}
catch{}
try {
bb = reader.GetInt32("bb");
}
catch{}
}reader.Close();
con.Close();
Select @num=Count(*) from table1return @num