string connstr="workstation id=LLF;packet size=4096;Trusted_Connection=Yes;data source=IMAGE;persist security info=False;initial catalog=KYGLdatabase ";
SqlConnection sqlConnection1=new SqlConnection( connstr);
sqlConnection1.Open(); string strCommandString="select Item_Name,Item_Class,Study_Category,Budget_Category,Item_Source,User_Name,Place_section,Application_Datetime from [XMLRTB] where Item_Name=txb_xmmc";
SqlDataAdapter adAdapter = new SqlDataAdapter(strCommandString,connstr);
sqlConnection1.Close(); DataSet dsDataset = new DataSet();
adAdapter.FillSchema(dsDataSet,SchemaType.Source,"XMLRTB");
adAdapter.Fill(dsDataSet,"XMLRTB");
MyDataGrid.DataSource=dsDataSet;
MyDataGrid.DataBind();
为什么总是提示
参数dataset值不能为空,代码那里有错????
SqlConnection sqlConnection1=new SqlConnection( connstr);
sqlConnection1.Open(); string strCommandString="select Item_Name,Item_Class,Study_Category,Budget_Category,Item_Source,User_Name,Place_section,Application_Datetime from [XMLRTB] where Item_Name=txb_xmmc";
SqlDataAdapter adAdapter = new SqlDataAdapter(strCommandString,connstr);
sqlConnection1.Close(); DataSet dsDataset = new DataSet();
adAdapter.FillSchema(dsDataSet,SchemaType.Source,"XMLRTB");
adAdapter.Fill(dsDataSet,"XMLRTB");
MyDataGrid.DataSource=dsDataSet;
MyDataGrid.DataBind();
为什么总是提示
参数dataset值不能为空,代码那里有错????
下面
直接这样不对吧,一般格式是:
DataGrid1.DataSource = DataSet.Tables[0].DefaultView;
试一下,顺便问一下你的数据库是什么的?
你太过分了
我本来就是个女的
什么叫楞说是女的
要不要视频啊?????????
SqlConnection sqlConnection1=new SqlConnection( connstr);
sqlConnection1.Open();
DataSet dsDataset = new DataSet();string strCommandString="select Item_Name,Item_Class,Study_Category,Budget_Category,Item_Source,User_Name,Place_section,Application_Datetime from [XMLRTB] where Item_Name=txb_xmmc";
SqlDataAdapter adAdapter = new SqlDataAdapter(strCommandString,connstr);
adAdapter.Fill(dsDataSet,"XMLRTB");
MyDataGrid.DataSource=dsDataSet;
MyDataGrid.DataMember="XMLRTB";
MyDataGrid.DataBind();
该成这些试试!
这个改成你 自己的
这个链接语句你在其他地方试过没有?
要是这个语句没问题你就不要改这个!
光改其他的就行
string strCommandString="select Item_Name,Item_Class,Study_Category,Budget_Category,Item_Source,User_Name,Place_section,Application_Datetime from [XMLRTB] where Item_Name=txb_xmmc"; DataSet ds = new DataSet(); SqlConnection MyConn = new SqlConnection(MyConnString);
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"XMLRTB"); MyDataGrid.DataSource = ds;
MyDataGrid.DataMember = "XMLRTB";
MyDataGrid.DataBind();
这个是 access 的数据库,你就把链接语句改成你的就行了,试试行不?
string connstr="workstation id=IMAGE;packet size=4096;Trusted_Connection=Yes;data source=localhost;persist security info=False;initial catalog=KYGLdatabase ";在其他地方可以实现但刚才的问题仍然存在
sqlConnection1.Open();
谢谢mzg008(长风宇)