ASP.NET开发过程中的学习点

1、读取数据，后填充进网页控件中。 

 

      string kshcx = ksh.Text.ToString();
        string sql = "select * from jxgkcj where ksh=" + kshcx + "";
             SqlDataReader sdr = op.GetDataReader(sql);
                while (sdr.Read())
                {
                    this.xm.Text = sdr.GetString(2);
                    this.zkzh.Text = sdr.GetString(1);
                    this.xb.SelectedValue = sdr.GetString(3);
                    this.sfzh.Text = sdr.GetString(4);
                    this.yw.Text = sdr.GetInt16(5).ToString();
                    this.sx.Text = sdr.GetInt16(6).ToString();
                    this.yy.Text = sdr.GetInt16(7).ToString();
                    this.zh.Text = sdr.GetInt16(8).ToString();
                    this.zf.Text = sdr.GetInt16(10).ToString();
                    this.pmf.Text = sdr.GetInt16(13).ToString();
                    this.pm.Text = sdr.GetInt64(14).ToString();
                    this.kl.SelectedValue = sdr.GetString(0).ToString().Substring(9,1);
              
                   
                }
                sdr.Close();