写入数据库小问题,请人指点

[ice2927276]

//前台代码:
<asp:TextBox ID="firstname" runat="server"></asp:TextBox>
<asp:TextBox ID="lastname" runat="server"></asp:TextBox>
<asp:Button ID="Button" runat="server" Text="提 交" OnClick="Button_Click" />
//后台代码:
protected void Button_Click(object sender, EventArgs e)
{
string Fname = this.firstname.Text;
string Lname = this.lastname.Text;
string dbConnect1;
string dbSql;
dbConnect1 = string.Format("Provider={0};Data Source={1}{2}",
"Microsoft.Jet.OLEDB.4.0;",
System.AppDomain.CurrentDomain.BaseDirectory,
"data/Sales.mdb");
dbSql = "Insert Into Customers(FirstName,LastName) Values(Fname,Lname);";

OleDbConnection dbConn1 = new OleDbConnection(dbConnect1);
OleDbCommand dbComm1 = new OleDbCommand(dbSql, dbConn1);
dbConn1.Open();
dbComm1.ExecuteNonQuery();
dbConn1.Close();
}
我想在数据库中插入textbox中输入的数据,但是一点"提交"按钮IE就提示"至少一个参数没有被指定值",请各位高手看一下,是不是dbsql语句没写对啊,直接把值写在Values里就可以插入,但是一用变量又说没指定值了,

[resen_tu]

Insert Into Customers(FirstName,LastName) Values(Fname,Lname);参数无值。。。

[zhaozhao110]

dbSql = "Insert Into Customers(FirstName,LastName) Values(Fname,Lname);";
改为

dbSql = "Insert Into Customers(FirstName,LastName) Values('"+Fname+"','"+Lname+"')";

[愚者只看星不看答案]

同意 zhaozhao110()

[New919]

同意楼上的楼上

[ice2927276]

谢谢,马上试试

[rgmlkthh]

对头，做程序，检查要特别细心，我有时候也是一个字母而检查一天的都有啊！！

[ice2927276]

搞定了,结贴了,谢谢zhaozhao110()