我用VS做了一个网站,其中有一页是用于注册用户的,请问如何将用户信息写入到数据库中?这是我写的,运行后输入的数据并没有进入数据库(我用的是access数据库),求教!
protected void Button1_Click(object sender, EventArgs e)
{
//连接数据库
string ConnString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\Administrator\Desktop\PandM\用户信息.mdb";
OleDbConnection les = new OleDbConnection(ConnString);
OleDbCommand lem;
//将数据输入到注册表内
les.Open();
string sql = "insert into UserInfo(user,code1,email,name)value (@UserName,@Code,@Email,@Name)";
lem = new OleDbCommand(sql, les);
lem.Parameters.AddWithValue("@UserName", TextBox1.Text.ToString());
lem.Parameters.AddWithValue("@Code", TextBox2.Text.ToString());
lem.Parameters.AddWithValue("@Email", TextBox4.Text.ToString());
lem.Parameters.AddWithValue("@Name", TextBox5.Text.ToString());
les.Close();
}
------解决方案--------------------------------------------------------
demo
//添加
protected void add_Button_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString();
OleDbConnection conn = new OleDbConnection(connStr);
conn.Open();
string sql = "insert into form (gzsx,fzr,jdr,jhwcsj,sjwcsj,knd,wcjg) values ('" + gzsx_TextBox.Text + "','" + fzr_TextBox.Text + "','" + jdr_TextBox.Text + "','" + jhwcsj_TextBox.Text + "','" + sjwcsj_TextBox.Text + "','" + knd_TextBox.Text + "','" + wcjg_TextBox.Text + "')";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
------解决方案--------------------------------------------------------
Access的语法比较严格一点儿,一般在字段的两边尽量加上中括号就不会提示语法错误了,如下:
//----------------------函数开始------------------------
protected void Button1_Click(object sender, EventArgs e)
{
//连接数据库
string ConnString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=
------解决方案--------------------------------------------------------
DataDirectory
------解决方案--------------------------------------------------------
用户信息.mdb";