低级程序问题，在线等，急

[lijiangws]

try{
SqlConnection conn=new SqlConnection("server=localhost;database=insure;uid=sa;pwd=");
string sql="select productname,kindid,companyid,age,paymode,paydeadline,ensdeadline,characteristic,duty from product";
conn.Open();
SqlCommand cmd=new SqlCommand(sql,conn);
SqlDataReader rs=cmd.ExecuteReader();
if (rs.Read()) {
//读取相关信息
lblpname.Text = rs.GetString(0);
lblage.Text=rs.GetString(3);
lblpaymode.Text=rs.GetString(4);
this.lblpaydate.Text=rs.GetString(5);
this.lblensuredate.Text=rs.GetString(6);
this.lblcharicter.Text=rs.GetString(7);
this.lblresponsibility.Text=rs.GetString(8);
int cid=rs.GetInt32(1);
string sqlc="select conanyname from company where cid='"+cid+"'";

SqlCommand cmdc=new SqlCommand(sqlc,conn);
SqlDataReader rsc=cmdc.ExecuteReader();
if(rsc.Read()){
this.lblcompany.Text=rsc.GetString(0);
}
int kid=rs.GetInt32(2);
string sqlk="select productname from insurekinds where id='"+kid+"'";

SqlCommand cmdk=new SqlCommand(sqlk,conn);
SqlDataReader rsk=cmdk.ExecuteReader();
if(rsk.Read()){
this.lblkindname.Text=rsk.GetString(0);
}
rsc.Close();
rsk.Close();
rs.Close();
conn.Close();
}
}catch(Exception ex){
throw ex;
}
finally{

}
这段代码是为页面中的label读取数据的，可总不能显示数据，也不报错，大虾们看下，是不是数据没从数据库中得到，怎么调试，希望指点一下

[zhangaipl]

跟踪看一下呢。

[humin1906]

this.lblcompany.Text=rsc.GetString(0);
this.lblkindname.Text=rsk.GetString(0);

得到的只是最后一个满足条件的数据，
怎么调试还不知道的话，那得去看看最清楚的教材

[wuhanyh]

我是菜鸟。
rs.GetString(0) 定义你没写出来啊。

[股神]

j