在一个web页面上有几个textbox控件,一个保存按钮,怎样将对应textbox中的内容保存到相应的数据庫中??
例如:
数据庫:表名为 userinfo
textbox: txtuserid、txtusername、txtage、txtsex、txtdepartment
求具体代码。谢谢!
例如:
数据庫:表名为 userinfo
textbox: txtuserid、txtusername、txtage、txtsex、txtdepartment
求具体代码。谢谢!
string name = txtName.Text.Trim().Replace("'", "\"");
string pwd = txtPwd.Text.Replace("'", "\"");
string pow = ddlPow.SelectedIndex.ToString();
string re = Server.HtmlEncode(txtRe.Text.Replace("'", "\""));string strConn = System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_NOC"]; //连接字符串OleDbConnection connUser = new OleDbConnection(strConn);
string strSqlUserInsert = string.Format("insert into [User] ([name], [state], [pwd], [pow], [re]) values('{0}', 1, '{1}', {2}, '{3}')", name, pwd, pow, re); // 插入记录语句
OleDbCommand cmdUserInsert = new OleDbCommand(strSqlUserInsert, connUser);
cmdUserInsert.ExecuteNonQuery();
connUser.Open();
// cmdUserInsert.ExecuteNonQuery();在此
connUser.Close();
"values("+ txtuserid.Text ",'"+txtusername.Text+"',"txtage.Text+", "+
'"+txtsex.Text+"','"+txtdepartment.Text+"' )";
"values("+ txtuserid.Text ",'"+txtusername.Text+"',"txtage.Text+", "+
"'"+txtsex.Text+"','"+txtdepartment.Text+"' )";