问题描述
protectedvoidButton1_Click(objectsender,EventArgse){stringstrnum=TextBox1.Text.Trim();stringstrdepartment=TextBox2.Text.Trim();stringstrterm=TextBox3.Text.Trim();DataSetdsInfo=newDataSet();stringFCARegConnString=System.Configuration.ConfigurationManager.AppSettings["FoxconnCaDBConnString"];stringselectUserBasicInfo="SELECT*fromexcel表wherenum='"+TextBox1.Text+"'anddepartment='"+TextBox2.Text+"'andterm='"+TextBox3.Text+"'";SqlDataAdaptersda=newSqlDataAdapter(selectUserBasicInfo,FCARegConnString);DataSetds=newDataSet();sda.Fill(dsInfo);GridView1.DataSource=dsInfo.Tables[0];GridView1.DataBind();}}
解决方案
解决方案二:
privatestaticDataSetSelectRows(DataSetdataset,stringconnectionString,stringqueryString){using(SqlConnectionconnection=newSqlConnection(connectionString)){SqlDataAdapteradapter=newSqlDataAdapter();adapter.SelectCommand=newSqlCommand(queryString,connection);adapter.Fill(dataset);returndataset;}}
解决方案三:
要建立sqlconnection对象,并将其赋给sqldataadapter
解决方案四:
太多了。。。。。。。。。。。。。。。。。。。
解决方案五:
数据库连接都没有连接对象,而且连数据库都没打开。。。。。