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#