**.aspx 文件<asp:Label ID="Label4" runat="server"></asp:Label>**.aspx.cs 文件
protected int ys;
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection Donn1 = new OleDbConnection();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select * from admin ", Donn1);
ys = ?????????
Donn1.Close();
}Label4.Text = ys.ToString();这样怎么读出来? 我只想读 admin表里cc项,cc数据=10,大家帮帮忙!帮帮忙啊!
可以又会表达错意思,大家没事关注一下小弟,拜托了~!!!!!!
VS.net 2005写啊
protected int ys;
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection Donn1 = new OleDbConnection();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select * from admin ", Donn1);
ys = ?????????
Donn1.Close();
}Label4.Text = ys.ToString();这样怎么读出来? 我只想读 admin表里cc项,cc数据=10,大家帮帮忙!帮帮忙啊!
可以又会表达错意思,大家没事关注一下小弟,拜托了~!!!!!!
VS.net 2005写啊
ys = Convert.ToInt32(cmd1.ExecuteScalar());
改成
select cc from admin
{
OleDbConnection Donn1 = new OleDbConnection();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select * from admin ", Donn1);
SqlDataReader dr = cmd1 .ExecuteReader(CommandBehavior.CloseConnection);
while(dr.read())
{
ys = dr["cc"].ToString();
}
ys = Convert.ToInt32(cmd1.ExecuteScalar());
这样还不行吗?
OleDbCommand cmd1 = new OleDbCommand("select top 1 cc from admin ", Donn1);
ys = Convert.ToInt32(cmd1.ExecuteScalar());
{
OleDbConnection Donn1 = new OleDbConnection();
Donn1.ConnectionString = strConn;
Donn1.Open();
OleDbCommand cmd1 = new OleDbCommand("select * from admin ", Donn1);
int ys ="" ;
ys =Convert.ToInt32(cmd1.ExecuteScalar());
Donn1.Close();
}
OleDataReader dr = cmd1.ExecuteReader(CommandBehavior.SingleResult);
ys = dr.Get..();//查下帮助吧
dr.Close();
首先,查询,按你的意思,语句是select cc from admin where cc=10 ,(但我不明白这样的查询有什么意义).然后Label4.Text =Convert.ToString(cmd1.ExecuteScalar()); 就OK了!
B表,用来设置每页有多少条!CC就是设置每页多少条的
现在我只想把ys=B表里的CC!就是不明白怎么读出来!
同时**.aspx里的Label4=ys!就是这个样子了,不知道大家明白不!
救救我吧!
ys=Convert.ToInt32(ds.Tables["admin"].Rows[0]["cc"].ToString());即可取出 cc 值 10;然后在外面使用 Label4.Text = ys.ToString(); 即可我的理解是这样,不知道是否理解正确了