如何取字段的值?

[zgysc]

我新建一个asp.net工程,在page_load中定义了connection和dataadpter以及dataset对象,同时在页面中拖入一个datagrid,绑定后运行程序没有问题,能正确显示表的数据,现在我把datagrid删掉,想直接在page_load中直接用response.write把表中"bb"字段的所有数据写出来,该如何写呢?

[xd123]

用dataset
for i=0 to count-1
dr=ds.tables(0).rows(i)
response.write(dr("bb"))
next

[webdiyer]

for(int i=0;i<dataset1.Tables[0].Rows.Count;i++){
Response.Write(dataset1.Tables[0].Rows[i]["bb"]);
}

[handsomejian]

建立连接后。。。
创建SqlCommand CommandStr = null;
SqlDataReader ReaderExe = null;
CommandStr = new SqlCommand("select bb from table",Conn);//sql为你的查询语句，conn为你的连接
ReaderExe = CommandStr.ExecuteReader();
if (!ReaderExe.Read()) return;
string aaa;//假设你的bb字段是varchar型
while(ReaderExe.Read()))
{
aaa= ReaderExe.GetString(0)//循环取得
}

[smartyyp]

sqlconnection conn=new sqlconnection(connstring);
sqlcommand comm=new sqlcommand("select bb from table",Conn);
SqlDataReader reader =new SqlDataReader;
conn.open();
reader=ExecuteReader();
if (reader.read())
{
response.write(reader("bb"));
}
reader.close();
conn.close;

[smartyyp]

sqlconnection conn=new sqlconnection(connstring);
sqlcommand comm=new sqlcommand("select bb from table",Conn);
SqlDataReader reader =new SqlDataReader;
conn.open();
reader=ExecuteReader();
while (reader.read())
{
response.write(reader("bb"));
}
reader.close();
conn.close;

[smartyyp]

sqlconnection conn=new sqlconnection(connstring);
sqlcommand comm=new sqlcommand("select bb from table",Conn);
SqlDataReader reader =new SqlDataReader;
conn.open();
reader=comm.ExecuteReader();
while (reader.read())
{
response.write(reader("bb"));
}
reader.close();
conn.close;

[supnet]

you try:
for(int i=0;i<dataset1.Tables["table_name"].Rows.Count;i++)
{
Response.Write(dataset1.Tables["table_name"].Rows[i]["bb"]);
}

[smartyyp]

sorry!
sqlconnection conn=new sqlconnection(connstring);
sqlcommand comm=new sqlcommand("select bb from table",Conn);
conn.open();
SqlDataReader reader=comm.ExecuteReader();
while (reader.read())
{
response.write(reader("bb"));
}
reader.close();
conn.close;

[zgysc]

谢谢各位,我会用datareader,我不会用dataadpter,问题解决了,给分了!