TextBox显示数据的问题

[Nils]

select * from f_bbs where id=1 数据库的字段为id,f_name,f_content............

想在TextBox显示f_name的值，有什么好的解决方案吗？ 谢谢 能详细点最好。再次3Q

[wangrenda]

string strconn="************";
SqlConnection myconn=new SqlConnection(strconn);
string myStr="select * from f_bbs where id=1";
SqlCommand myCmd=new SqlCommand(myStr,myconn);
try
{
myconn.Open();
SqlDataReader myReader=myCmd.ExecuteReader();
if(myReader.Read())
{
f_name.Text=myReader["f_name"].ToString();
}
myReader.Close();

}
catch(Exception ex)
{
Response.Write(ex.Message);
Response.End();
}
finally
{
if(myconn.State==ConnectionState.Open)
{
myconn.Close();
myconn.Dispose();
}
}

[「已注销」]

SqlConnection conn = new SqlConnection("server=localhost;uid=sa;pwd=;database=db");
SqlDataAdapter da = new SqlDataAdapter("select * from f_bbs where id=1",conn);
DataSet ds = new DataSet();
da.Fill(ds);
f_name.Text = ds.Tables[0].Rows[0]["f_name"].ToString();

[hackate]

dim conn as sqlconnection=new sqlconnection(你的连接数据库的字符串)
dim rs as sqldatareader
dim cmd as sqlcommand=new sqlcommand("select * from f_bbs where id=1",conn)
conn.open
rs=cmd.executereader
if rs.read then
textbox1.text=rs("f_name").tostring
end if
rs.close
cmd.dispose
conn.close

[Bruce_H21]

1.定义Reader
If reader.Reader()
... =reader("f_Name").Tostring()
reader.Close()
End if

2. 绑定DataSet，用DataRow
dim dr as dataRow
for each dr in Dataset.Tables(0).Rows
... = Dr("f_Name").Tostring()
Next