不知道错误提示怎么改!!

[iwinyoung]

行 260: SqlDataAdapter da = new SqlDataAdapter(strsql, aconn);
行 261: DataSet ds = new DataSet();
行 262: da.Fill(ds);行 263: aconn.Close();
行 264: this.GridView1.DataSource = ds.Tables;
红字体的地方报错..

[fsvbboy]

用try 捕捉一下,看一下是什么错误!

[iwinyoung]

[iwinyoung]

这到底是类型转换语法有误,,还是我写数据填充有误?,,

[yjl99]

填充有错误，应该是 SqlDataAdapter da = new SqlDataAdapter(strsql, aconn);
DataSet ds = new DataSet();
da.Fill(ds,"table"); aconn.Close();
this.GridView1.DataSource = ds.Tables["table"].DefaultView;;

[iwinyoung]

改过还是没用,代码如下:
SqlConnection aconn = new SqlConnection(ConfigurationSettings.AppSettings["myconn"]);
SqlCommand acmd = new SqlCommand();
acmd.CommandText = "select cdepartname,invcode,ccuscode,csocode,qty,rqdate,mocode,prdatee,prqty,sonoqty,status,ttime,stime,sdtime,xrate,srate,prqty6,prqty7,prqty1,prqty2,prqty3,prqty4,prqty5,remark from Jx_momorderp";
if (bb != "")
{
acmd.CommandText += "where cdepartname like '%+bb+%'";
}
SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = new SqlCommand();
//da.SelectCommand.Connection = aconn;
//da.SelectCommand.CommandText = acmd.CommandText;
DataSet ds = new DataSet();
aconn.Open();
da.Fill(ds,"table");
aconn.Close();
GridView1.DataSource = ds.Tables["table"].DefaultView;
GridView1.DataBind();
错误提示为:

[yjl99]

你都没有执行acmd命令，怎么会有结果呢？
SqlDataAdapter da = new SqlDataAdapter();
改为 SqlDataAdapter da = new SqlDataAdapter(acmd,aconn);
试一下

[yjl99]

你可以先试一下简单的，不要查找那么多字段

[jsddj]

在SqlDataAdapter da=new SqlDataAdapter();语句下面添加两句:
acmd.Connection=aconn;
da.selectCommand=acmd;

[iwinyoung]

按楼上的改过之后还是出现错误: