public static int sqlcountcmd(string sql)
{
OracleConnection constr = new OracleConnection("Data Source=txun;User ID='" + dataconn.uname + "'" + ";" + "Password='" + dataconn.psw + "'" + ";Integrated Security=no");
constr.Open();
OracleDataAdapter da = new OracleDataAdapter();
da.SelectCommand = new OracleCommand(sql,constr);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
System.Data.DataTable table = ds.Tables[0];
return (int)table.Rows[0][0];
constr.Close();
}然后调用这个方法
dataconn.sqlcountcmd("select count(*) from users")
为什么会提示我说强制类型转换错误。请问大家,统计函数 返回的不是二维表吗?
{
OracleConnection constr = new OracleConnection("Data Source=txun;User ID='" + dataconn.uname + "'" + ";" + "Password='" + dataconn.psw + "'" + ";Integrated Security=no");
constr.Open();
OracleDataAdapter da = new OracleDataAdapter();
da.SelectCommand = new OracleCommand(sql,constr);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
System.Data.DataTable table = ds.Tables[0]; constr.Close(); return (int)table.Rows[0][0].tostring();
}