OleDbConnection Donn1 = new OleDbConnection();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select count(*) from admin ", Donn1);
ys = ????这不会读了!
Donn1.Close();想读出 admin表里的CC表里的数据啊,请问YS=怎么写!
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select count(*) from admin ", Donn1);
ys = ????这不会读了!
Donn1.Close();想读出 admin表里的CC表里的数据啊,请问YS=怎么写!
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select count(*) from admin ", Donn1);
DataSet ds =new DataSet();
int count = cmd1.Fill(ds);
Donn1.Close();
if( o != null )
{
int n = int.Parse(o.ToString() )
}
问一下:想读出 admin表里的CC表里的数据啊不是读出admin表里的数据吗?
ys是什么?OleDbConnection Donn1 = new OleDbConnection();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select count(*) from admin ", Donn1);
DataSet ys =new DataSet();
int count = cmd1.Fill(ys);
Donn1.Close();
OleDbConnection Donn1 = new OleDbConnection();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select count(*) from admin ", Donn1);
int count = cmd1.ExecuteNonQuery()
Donn1.Close();
cmd1.Fill(ds);for (int i=0;i<ds.Table[0].Rows.Count;i++)
{
(int)ds.Table[0].Rows[i]["cc"]
}
OleDbConnection Donn1 = new OleDbConnection();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select count(*) from admin ", Donn1);
OleDbDataAdapter da = OleDbDataAdapter();
da.SelectCommand=cmd1;
DataSet ds =new DataSet();
int count = da.Fill(ds);
Donn1.Close();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select cc from admin ", Donn1);
ys = ????这不会读了!
Donn1.Close();
Label4.Text = ys.ToString();想读出 admin表里的CC项的数据啊,请问YS=怎么写!、
各位表达能力比较差,
Label4.Text = ds.Tables["admin"].Rows[0]["cc"].ToString();
Label4本来可以这么读出的!
protected int recNum, PageCount, ys;
cmd.ExecuteScalar()执行效果最好,
如果需要返回多行或多列数据,只有使用
OleDbDataAdapter da = OleDbDataAdapter();
da.SelectCommand=cmd1;
DataSet ds =new DataSet();
int count = da.Fill(ds);这样的形式了
想要什么根据sql字符串确定