Question

C#html中内容写入SQL

protected void Page_Load(object sender, EventArgs e)

{

string a = this.title.Value.ToString();

string b = this.name.Value.ToString();

string c = this.email.Value.ToString();

string d = this.telephone.Value.ToString();

string f = this.content.Value.ToString();

}

protected void Button1_Click(object sender, EventArgs e)
{

//应该写什么，才能提交到数据库（feedback表）

}

Answer 1

//Access数据库连接字串以及方法
const string strPath = "数据库地址";
const string ACCESS_CONN_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strPath + ";User Id=admin;Password=;";
static OleDbConnection conn = new OleDbConnection(ACCESS_CONN_STRING);
conn.Open();

protected void Button1_Click(object sender, EventArgs e)
{
string strSql = "INSERT INTO feedback(字段,字段)VALUES(值,值)";
OleDbCommand cmd = new OleDbCommand(strSql, conn);
cmd.CommandType = CommandType.Text;
using (OleDbTransaction trans = conn.BeginTransaction())
{
cmd.Transaction = trans;
try
{
cmd.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
finally
{
conn.Close();
}
}
}

追问

我用sql2005数据库！谢谢

追答

那就改一下数据库连接字符串，这个在网上一搜一大把的。