最近的学校作业,我简单的做了个登录页面,跳转到个人调查的页面,使用选择题的模式,我测试过可以获取值,不过在sql语句中就出现了”至少一个参数没有被指定值”。错误,查了很多资料都没解决。
下面是提交按钮的事件 求助,这样的该怎么写
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider = Microsoft.Jet.OleDb.4.0;Data Source=" + Server.MapPath("App_Data/manager.mdb");
string Val = RadioList[0].SelectedValue.ToString() + "," + RadioList[1].SelectedValue.ToString();
string Sql = "insert into Admin(uAnswer1_201,uAnswer2_201) values(" + Val + ")"; 此处出现错误
//string Sql = "insert into Admin(uAnswer1_201) values('a' )";
OleDbCommand InsCom = new OleDbCommand(Sql, conn);
OleDbDataAdapter da = new OleDbDataAdapter();
conn.Open();
da.InsertCommand = InsCom;
da.InsertCommand.ExecuteNonQuery();
conn.Close();
Response.Write("<script language=javascript>alert('添加成功!');</script>");
}