select 语句简化问题．

Question

有一数据库ＴＡＢＬＥ　一记录为：id=1,name=abc,sex=11,year=2000;Sqlcommand cmd=new Sqlcommand(select * from table where ID='1');
string name=Convert.toString(cmd.ExeScholor());
string sex=Convert.ToString(cmd.ExeScholor());
string year=Convert.toString(cmd.ExeScholor());this.Lable1.text=name;
this.Lable2.text=sex;
this.Lable3..text=year;如何将上面的语句简化．

Answer 1

Sqlcommand cmd=new Sqlcommand(select * from table where ID='1');this.Lable1.text=Convert.toString(cmd.ExeScholor());
this.Lable2.text=Convert.ToString(cmd.ExeScholor());
this.Lable3..text=Convert.toString(cmd.ExeScholor());如此？可否说明白点？

Answer 2

你的意思应该就是这样吧:this.Lable1.text=Convert.toString(cmd.ExeScholor());
this.Lable2.text=Convert.ToString(cmd.ExeScholor());
this.Lable3..text=Convert.toString(cmd.ExeScholor());

Answer 3

string connString = "server=(local);uid=sa;pwd=;database=pubs";
string cmdText = "select * from tableName where id='1'";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter adp = new SqlDataAdapter(cmdText, conn);
DataSet ds = new DataSet();
adp.Fill(ds);
if(ds.Tables[0].Rows.Count == 1)
{
   this.Lable1.Text = ds.Tables[0].Rows[0]["name"].ToString();
   this.Lable2.Text = ds.Tables[0].Rows[0]["sex"].ToString();
   this.Lable3.Text = ds.Tables[0].Rows[0]["year"].ToString();
}