读书人

Fill: selectCommand.Connection 属性

发布时间: 2012-04-19 14:36:43 作者: rapoo

Fill: selectCommand.Connection 属性尚未初始化

C# code
SqlConnection thisConnection = new SqlConnection(               @"Server=CVRE1WTZRSTAGNW\SQLSERVER2008;Integrated Security=True;Database=gdbranch;");            thisConnection.Open();                       SqlCommand cmd=new SqlCommand();            SqlDataAdapter ada = new SqlDataAdapter();            System.Data.DataTable dataTable = new System.Data.DataTable();                       cmd.CommandText = @"select a.branchid,a.pkey,a.pno,a.ptime,a.pmemo,a.useid,b.pbarcode,sum(qty) from " +                @"pdacheck a inner join pdacheckd b on a.pkey=b.pkey";            ada.SelectCommand = cmd;            ada.Fill(dataTable);            this.dgData.DataSource = dataTable;


上面代码会有这个提示,请问是哪里不对,谢谢

[解决办法]
添一句
cmd.Connection = thisConnection;

读书人网 >C#

热点推荐