如何直接读取dataset的某个字段数据？

[cppsun]

 string sqlstr = "Data Source=.;Initial Catalog=DB;Integrated Security=True";
            string sqlstr1 = "select top 100 * from table1";
           
            SqlConnection conn = new SqlConnection();
            
            conn.ConnectionString = sqlstr;
            conn.Open();

            SqlCommand cmd = new SqlCommand(sqlstr1,conn);

            SqlDataAdapter ad = new SqlDataAdapter();

            ad.SelectCommand = cmd;

            DataSet ds = new DataSet();

            ad.Fill(ds);

1、大家看看这段代码有没有问题，做为连接和打开数据库用。
2、要直接读取ds的某列数据如何操作。不用数据绑定那种。

[ZengHD]

DataSet有字段吗？
DataTable才有字段吧

[q107770540]

 string sqlstr = "Data Source=.;Initial Catalog=DB;Integrated Security=True";
            string sqlstr1 = "select top 100 * from table1";
           
            using(SqlConnection conn = new SqlConnection())
            {
            conn.ConnectionString = sqlstr;
            conn.Open();

            SqlCommand cmd = new SqlCommand(sqlstr1,conn);

            SqlDataAdapter ad = new SqlDataAdapter();

            ad.SelectCommand = cmd;

            DataSet ds = new DataSet();

            ad.Fill(ds);
          }

[wuyq11]

DataSet ds = new DataSet();
using(SqlConnection conn = new SqlConnection(sqlstr))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr1,conn);
SqlDataAdapter ad = new SqlDataAdapter();
ad.SelectCommand = cmd;

ad.Fill(ds);
}
if(ds.Tables[0].Rows.Count>0)
{
string s=ds.Tables[0].Rows[0]["id"].ToString();
}

[阿双2009]

ds.Tables[0].Rows[]["列名"]

[q107770540]

string t= ds.Tables[0].Rows[0][0].ToString();

[q107770540]

string t= ds.Tables[0].Rows[0][0].ToString();

[cjh200102]

楼上OK

[harker007]

ds.Tables[0].Rows[i]["列名"].ToString();

[ganchunsaixx]

路过了