当前位置:编程学习 > C#/ASP.NET >>

winform中GridView绑定了数据但为什么没有反映

我做一个学生信息系统,从上一个网页中传来一个参数,SqlDataSource已经配置好了,但是不知道怎么打开网页后GridView 没有显示?请高手指点一下!急急急!

protected void Page_Load(object sender, EventArgs e)
        {
            
            string xh=Request.QueryString["id"];
            
            if(xh!=null)
            {
                //检查配置文件中的连接字符串
                string connstr = ConfigurationManager.ConnectionStrings["XSCJConnectionString"].ConnectionString;
                //定义SQL语句
                string sql = "select XH,XM,ZYM,ZXF from XS where XH='" + xh + "'";
                SqlConnection conn = new SqlConnection(connstr);
                SqlCommand cmd = new SqlCommand(sql, conn);
                
                
                //SqlDataSource1.SelectCommand= sql;
                
                //GridView1.DataSourceID = "SqlDataSource1";
                //GridView1.DataBind();
                
                //获得记录行
                try
                {
                    conn.Open();
                    
                    SqlDataReader sdr=cmd.ExecuteReader();
                    sdr.Read();
                    stuXH.Text=string.Format("学号:{0}",sdr[0]);
                    stuXM.Text=string.Format("姓名:{0}",sdr[1]);
                    stuZY.Text=string.Format("专业:{0}",sdr[2]);
                    stuZXF.Text=string.Format("总学分:{0}",sdr[3]);
                    sdr.Close();
                }
                finally
                {
                    conn.Close();
                }


            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            if (XH_tb.Text.Trim() != string.Empty)
            {
                //获得输入的学号
                string xh = Request.Form["XH_tb"];
                //定义SQL语句
                string sql = "SELECT KC.KCM,XS_KC.CJ,KC.XF,KC.XS,KC.KKXQ FROM KC,XS,XS_KC WHERE KC.KCH=XS_KC.KCH and XS.XH=XS_KC.XH and XS.XH='" + xh + "'";
                //设置SqlDataSource1的SelectCommand
                SqlDataSource1.SelectCommand = sql;
                GridView1.DataSourceID = "SqlDataSource1";
                GridView1.DataBind();
                
                //获得配置文件中的连接字符串
                string connStr = ConfigurationManager.ConnectionStrings["XSCJConnectionString"].ConnectionString;
                
                //定义SQL语句
                string sql2 = "select XH,XM,ZYM,ZXF from XS where XH='" + xh + "'";
                SqlConnection conn = new SqlConnection(connStr);
                SqlCommand cmd = new SqlCommand(sql2, conn);
                //获得记录行
                try
                {
                    conn.Open();
                    SqlDataReader sdr = cmd.ExecuteReader();
                    sdr.Read();
                    stuXH.Text = string.Format("学号:{0}", sdr[0]);
                    stuXM.Text = string.Format("姓名:{0}", sdr[1]);
                    stuZY.Text = string.Format("专业:{0}", sdr[2]);
                    stuZXF.Text = string.Format("总学分:{0}", sdr[3]);
                    sdr.Close();
                }
                finally
                {
                    conn.Close();
                }
            }
        } --------------------编程问答-------------------- 学习... --------------------编程问答-------------------- 你都把
//SqlDataSource1.SelectCommand= sql;
   
  //GridView1.DataSourceID = "SqlDataSource1";
  //GridView1.DataBind();

注释掉了,GridView1当然没有数据了。

还有应该是
protected void Page_Load(object sender, EventArgs e)
  {
    if(!Page.IsPostBack)
    {
      //代码
    }
  } --------------------编程问答-------------------- 还有,你的标题:winform中GridView

 winform中怎么会有Page_Load呢?从你代码来看,似乎是webform
补充:.NET技术 ,  C#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,