再问个小问题???

我在程序中定义一个string

我定义的string 怎样来得到数据库中的数据哦...

如:string str;
table A
id name
1 a
2 b
sql: select name from A where id = 1

我怎样来得到str=a???


[解决办法]
string strSql = "select name from A where id = 1 ";
SqlDataAdapter myCommand = new SqlDataAdapter(strSql, myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "t_dict ");
DataView dv = new DataView();
str=ds.Tables[ "A "].Columns[0].Caption;
[解决办法]
- -!

为什么那么复杂

string strSql = "select name from A where id = 1 ";
SqlCommand comm = new SqlCommand(strSql, myConnection);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
str = dr.GetString(0);
}
[解决办法]
string strSql = "select name from A where id = 1 ";
SqlCommand comm = new SqlCommand(strSql, myConnection);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
str = dr.GetString(0);
}
是好方法,用SqlDataReader比快,
可是段代存在著,
出在dr.GetString(0);句,中的name字段空
vsDBNull的,
用dr[0].ToString();就不有了