怎么取得这个数据值？

[希偌]

………………
public int Dg() {
SqlDataAdapter sda = new SqlDataAdapter("select count(*) from bbs1", myConnection);
sda.Fill(ds);
int c=这里应该怎么写，才能得到count的值;//如果不用this.ds.Tables[0].Rows.Count
return(c);
}
……………………

[hgknight]

The Better Way is——
public int Dg() {
OleDbCommand myCmd = new OleDbCommand("select count(*) from screcord",myConn);
int c=int.Parse(myCmd.ExecuteScalar().ToString());
return(c);

[spring_ok]

Agree.

int c = System.Convert.ToInt32(myCmd.ExecuteScalar());

[ljjhm]

string sql="select count(*) from screcord";
SqlCommand myCmd = new SqlCommand ("select count(*) from screcord",myConn);
myConn.open();
SqlDataReader MyReader=myCmd.ExecuteReader();
int c=myCmd.GetInt32(0);

[ljjhm]

错！！！了！！！
最后一句改为:
int c=MyReader.GetInt32(0);

[htouch]

int count=0;
SqlCommand myCommand = new SqlCommand("select count(*) from bbs1", myConnection);
myConnection.Open();
SqlDataReader reader = myCommand.ExecuteReader();
while(reader.Read())
{
count = (int)reader[0];
}

[ljjhm]

怎么还可以回贴