我的数据表是table" + sqlhis + "
sqlhis是按日期变化的,请问在绑定时“数据表”处怎么填表名啊我填成"table" + sqlhis + ""运行报错
DataSet ds = new DataSet();
sdaqueryhis.Fill(ds,"数据表");
GridViewhis.DataSource = ds;
GridViewhis.DataMember = "数据表 ";
GridViewhis.DataBind();
sqlhis是按日期变化的,请问在绑定时“数据表”处怎么填表名啊我填成"table" + sqlhis + ""运行报错
DataSet ds = new DataSet();
sdaqueryhis.Fill(ds,"数据表");
GridViewhis.DataSource = ds;
GridViewhis.DataMember = "数据表 ";
GridViewhis.DataBind();
=================================
GridViewhis.DataMember = "数据表";多了个空格
数据表填table" + sqlhis + "吗?
GridViewhis.DataMember = "数据表";
数据表填table" + sqlhis + "吗?
---------------------------------
填你查询sql语句时的表名
string sqlqueryhis = "select * from sms"+sqlhis+" where TelNo='" + Txtbphone.Text.Trim() + "'";
表明就是sms"+sqlhis+"
数据表填table" + sqlhis + "吗?
----------------------
GridViewhis.DataMember =ds.Tables["sqlhis"];
GridViewhis.DataMember =ds.Tables["'"+ sqlhis +"'"];
我没赋值,另外GridViewhis.DataMember =ds.Tables["'"+ sqlhis +"'"];这句报错
string tblName = "table" + sqlhis;DataSet ds = new DataSet();
sdaqueryhis.Fill(ds, tblName);
GridViewhis.DataSource = ds;
GridViewhis.DataMember = tblName
下次请将问题表达清楚,还有,要明白,
DataAdapter.Fill(DataSet, string tableName); // 这里的 tableName 跟 select from 用的表名不必对应,这里的 tableName 设置的是内存中DataTable.TalbeName