c#一个问题

来源：百度知道 编辑：UC知道 时间：2024/06/02 15:55:51
我想在网页中加段代码 每点击一次这网页 就向数据库中Member表的MemberDj字段+1 应该怎么写

在pageLoad事件中写:
if(!isPostBack)
{
string sql = "update Member set MemberDj=MemberDj+1";
SqlConnection conn = new SqlConnection("连接字符串");
SqlTransaction mytran;
SqlCommand cmd = conn.CreateCommand();
mytran = conn.BeginTransaction();
cmd.CommandText = sql;
cmd.Transaction = mytran;
cmd.Connection = conn;
try
{
conn.Open();
int i = cmd.ExecuteNonQuery();
mytran.Commit();
//加一成功
}
catch
{
mytran.Rollback();
//加一失败
}
finally
{
cmd.Dispose();
mytran.Dispose();
conn.Close();
conn = null;