我这样做:
首先拖了个sqldatasource控件到界面上然后代码:strSQL = "SELECT TK200709.bh,TK200709.mc,TK200709.bj,LB200709.mc as lb FROM LB200709,TK200709 WHERE LB200709.lb = TK200709.lb";string strConn = @"Provider=VFPOLEDB.1;Data Source=d:\My Documents\Visual Studio 2005\WebSites\myd\dbf\khf;Collating Sequence=MACHINE";SqlDataSource1.ProviderName = "System.Data.OleDb";
SqlDataSource1.ConnectionString = strConn
SqlDataSource1.SelectCommand = strSQL;
GridView1.DataSourceID = "SqlDataSource1";
GridView1.DataBind();为什么运行后看不到GridView??根本就没有东西?但是如果不写代码,直接用控件绑阿什么的就能正常?
但我现在必须用代码绑,怎么才能做啊!!!跪求
首先拖了个sqldatasource控件到界面上然后代码:strSQL = "SELECT TK200709.bh,TK200709.mc,TK200709.bj,LB200709.mc as lb FROM LB200709,TK200709 WHERE LB200709.lb = TK200709.lb";string strConn = @"Provider=VFPOLEDB.1;Data Source=d:\My Documents\Visual Studio 2005\WebSites\myd\dbf\khf;Collating Sequence=MACHINE";SqlDataSource1.ProviderName = "System.Data.OleDb";
SqlDataSource1.ConnectionString = strConn
SqlDataSource1.SelectCommand = strSQL;
GridView1.DataSourceID = "SqlDataSource1";
GridView1.DataBind();为什么运行后看不到GridView??根本就没有东西?但是如果不写代码,直接用控件绑阿什么的就能正常?
但我现在必须用代码绑,怎么才能做啊!!!跪求
参考如下提供的写法
www.connectionstrings.com
DataSet Ds = new DataSet();
Da.Fill(Ds);
GridView1.DataSource = Ds.Tables[0].DefaultView;
GridView1.DataBind();改成这样无济于事
绑定之前,设置GridView1.AutoGenerateColumns为true
对 楼上说的好,要把在运行时自动创建设为true