Question

C#里， access 插入数据库，提示“无法找到表 0”

插入的代码：
string strConn = "Provider=Microsoft.ACE.OLEDB.4.0;DataSource=E:\\多条件无刷新查询示例源码下载\\AjaxGeneralSearch\\App_Data\\东山再起.mdb";
string strInsert = "insert into Tenancy([序号],[日期],[矿别],[客户],[订单编号],[煤种],[车数],[发运量],[平均单价]) VALUES ('" + xh.Text + "','" + rq.Text + "','" + kb.Text + "','" + kh.Text + "','" + ddbh.Text + "','" + mz.Text + "','" + cs.Text + "','" + fyl.Text + "','" + pjdj.Text + "')";
this.DataSource = DSZQ.DataAccess.DataSet(strInsert).Tables[0];
bind();
运行后，提示“无法找到表 0”。
但是，按日期查询就可以。代码如下
#region 按日期查询按钮
protected void Button1_Click(object sender, EventArgs e)
{
string sqlSyntax = "";
sqlSyntax = "select * from Tenancy";
sqlSyntax += " where (" + "日期>=#" + TextBox1.Text + "# and 日期<=#"+TextBox2.Text + "# )";
this.DataSource = DSZQ.DataAccess.DataSet(sqlSyntax).Tables[0];
bind();
GV.Visible = true;
GridView1.Visible = false;

string hj;
hj = "select sum(车数) as 合计车数,sum(发运量) as 合计发运量,sum(平均单价) as 合计平均单价 from Tenancy";
hj += " where (" + "日期>=#" + TextBox1.Text + "# and 日期<=#" + TextBox2.Text + "# )";
GV1.DataSource = this.DataSource;
GV1.DataBind();
this.DataSource = DSZQ.DataAccess.DataSet(hj).Tables[0];
bind();
GV1.Visible = true;
}
#endregion

请教高手插入代码 如何写
GV GV1是无数据源的 Gridview1是有数据源的

Answer 1

this.DataSource = DSZQ.DataAccess.DataSet(strInsert).Tables[strInsert];