Question

C# access 数据库，怎么获取select查询count(*)中的值

string tm_count = "select count(*) from `fly_user`;";
com = new OleDbCommand(tm_count, con);
try
{
con.Open();
adread = com.ExecuteReader();
if (adread.HasRows)
{
while (adread.Read())
{
int a = adread.GetInt16(0);
}
}
else
{
label7.Text = "未知";
}
}
catch (OleDbException ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}

Answer 1

GetInt16得到的好像是字节吧，或者你可以试试int.Parse(string)

Answer 2

这是什么列啊？ COUNT（* ）

Answer 3

改成
int a = adread.GetInt32(0);