问题描述
GridView不显示任何结果。。。。。。高手来帮帮忙啊dal里面usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;namespacedal{publicclassDALClass{publicstaticstringconnectionstring=@"DataSource=.SQLEXPRESS;integratedsecurity=SSPI;database=tupian";publicstaticDataSetdt(stringsql){SqlConnectionconnection=newSqlConnection(connectionstring);SqlCommandcommand=newSqlCommand();command.Connection=connection;command.CommandText=sql;try{connection.Open();SqlDataAdapterda=newSqlDataAdapter(command);DataSetds=newDataSet();da.Fill(ds);returnds;}catch(SqlExceptionex){throwex;}}}}页面里protectedvoidPage_Load(objectsender,EventArgse){stringstrsql=string.Format("SELECTmingcheng,yonghuming,fabushijian,dianjiFROMtupianWHEREshenli=1ANDgongkai=0ORDERBYdianjiDESC");this.GridView1.DataSource=dal.DALClass.dt(strsql);}结果GridView没有任何内容，这怎么回事？
解决方案
解决方案二：
sql里没有对应内容？
解决方案三：
dal里面usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;namespacedal{publicclassDALClass{publicstaticstringconnectionstring=@"DataSource=.SQLEXPRESS;integratedsecurity=SSPI;database=tupian";publicstaticDataSetdt(stringsql){SqlConnectionconnection=newSqlConnection(sql,connectionstring);SqlCommandcommand=newSqlCommand(sql,connection);try{connection.Open();SqlDataAdapterda=newSqlDataAdapter();da.SelectCommand=command;DataSetds=newDataSet();da.Fill(ds);returnds;}catch(SqlExceptionex){throwex;}}}}试试这种写法，你那种好像有问题
解决方案四：
改成这样了还是不行啊。。。。帮帮忙。。。。publicstaticDataTabledt(stringsql,stringdst){SqlConnectionconnection=newSqlConnection(connectionstring);SqlCommandcommand=newSqlCommand();command.Connection=connection;command.CommandText=sql;try{connection.Open();SqlDataAdapterda=newSqlDataAdapter(command);DataSetds=newDataSet();da.Fill(ds,dst);returnds.Tables[dst];}catch(SqlExceptionex){connection.Close();throwex;}}stringstrsql=string.Format("SELECTmingcheng,yonghuming,fabushijian,dianjiFROMtupianWHEREshenli=1ANDgongkai=0ORDERBYdianjiDESC");stringsds="tupian.mingcheng,tupian.yonghuming,tupian.fabushijian,tupian.dianji";GridView1.DataSource=dal.DALClass.dt(strsql,sds);GridView1.DataBind();
解决方案五：
你第一次贴的代码好像少了DataBind()绑定，但你第二次的就不知道了，建议你自己调试一下吧，看问题出在哪里
解决方案六：
你可以把publicstaticstringconnectionstring=@"DataSource=.SQLEXPRESS;integratedsecurity=SSPI;database=tupian";这句话的publicstaticstringconnectionstring改为Stringconnectionstring=@"DataSource=.SQLEXPRESS;integratedsecurity=SSPI;database=tupian";这句看看。我记得好像这句话被你用在了publicstatic这是肯定会出问题的!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
解决方案七：
usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;namespacedal{publicclassDALClass{publicstaticstringconnectionstring=@"DataSource=.SQLEXPRESS;integratedsecurity=SSPI;database=tupian";publicstaticDataSetdt(stringsql){try{SqlConnectionconnection=newSqlConnection();connection.ConnectionString=connectionstring;connection.Open();SqlDataAdapterda=newSqlDataAdapter(sql,connection);DataSetds=newDataSet();da.Fill(ds,"表名");returnds;}catch(SqlExceptionex){thrownewException（ex.Message）;}}}}页面里protectedvoidPage_Load(objectsender,EventArgse){stringstrsql=string.Format("SELECTmingcheng,yonghuming,fabushijian,dianjiFROMtupianWHEREshenli=1ANDgongkai=0ORDERBYdianjiDESC");this.GridView1.DataSource=dal.DALClass.dt(strsql);this.DataBind();}以上代码中，有一个问题哦，就是你连接字符串中的database是tupian，怎么你sql语句中也有个表名称叫tupian呢？还有一点就是你数据库表中没有记录，当然查不出结果显示了啊！
解决方案八：
看一下gridview的前台代码,还有就是看一下返回的dataset是否有值
解决方案九：
this.GridView1.DataSource=dal.DALClass.dt(strsql);this.GridView1.DataBind();//加上这个