protected void query_Click(object sender, EventArgs e)
{
String SQLString;
PDPerson pp = new PDPerson();
SQLString = "select * from [dbo].[C_Work_ObjDo] join [dbo].[C_Work_Object] on C_Work_Object.Obj_id=C_Work_ObjDo.do_objid where C_Work_Object.Obj_name=" + TxtName.Text.ToString();
DataTable dt = pp.GetObjectBySql(SQLString); this.dgQuery.DataSource = dt;
this.dgQuery.DataBind();
}其中dgQuery 为DataGrid控件,出现列名 '' 无效。什么原因啊?望指教~~
{
String SQLString;
PDPerson pp = new PDPerson();
SQLString = "select * from [dbo].[C_Work_ObjDo] join [dbo].[C_Work_Object] on C_Work_Object.Obj_id=C_Work_ObjDo.do_objid where C_Work_Object.Obj_name=" + TxtName.Text.ToString();
DataTable dt = pp.GetObjectBySql(SQLString); this.dgQuery.DataSource = dt;
this.dgQuery.DataBind();
}其中dgQuery 为DataGrid控件,出现列名 '' 无效。什么原因啊?望指教~~
SQLString = "select * from [dbo].[C_Work_ObjDo] join [dbo].[C_Work_Object] on C_Work_Object.Obj_id=C_Work_ObjDo.do_objid where C_Work_Object.Obj_name='" + TxtName.Text.ToString() + "'";
//如果还不行,看你的表中和你的绑定列对应的列名有没错的
再看看DataGrid列名配置是否正确