2023年6月21日发(作者：)

表为User，字段有 编号： int id，用户名：string UserName，密码：string UserPwd

///

/// 添加

///

/// 用户名

/// 密码

///

[WebMethod]

public int Add(string name,string pwd)

{

SqlConnection conn = new SqlConnection("连接字符串");

();

string sql = "intsert into User (UserName,UsersPwd)

values(@UserName,@UsersPwd)";

SqlCommand cmd = new SqlCommand(sql, conn);

SqlParameter parn = new SqlParameter("@UserName", name);

(parn);

SqlParameter parp = new SqlParameter("@UsersPwd", pwd);

(parp);

int result = eNonQuery();

();

e();

return result;

}

///

/// 修改

///

/// 用户名

/// 密码

/// 编号

///

[WebMethod]

public int Update(string name, string pwd, int id)

{

SqlConnection conn = new SqlConnection("连接字符串");

();

string sql = "update User set

UserName=@UserName,UsersPwd=@UsersPwd where id=@id";

SqlCommand cmd = new SqlCommand(sql, conn);

SqlParameter parn = new SqlParameter("@UserName", name);

(parn); SqlParameter parp = new SqlParameter("@UsersPwd", pwd);

(parp);

SqlParameter pari = new SqlParameter("@id", id);

(pari);

int result = eNonQuery();

();

e();

return result;

}

///

/// 删除

///

/// 编号

///

[WebMethod]

public int Delete(int id)

{

SqlConnection conn = new SqlConnection("连接字符串");

();

string sql = "delete from User where id=@id";

SqlCommand cmd = new SqlCommand(sql, conn);

SqlParameter pari = new SqlParameter("@id", id);

(pari);

int result = eNonQuery();

();

e();

return result;

}

2023年6月21日发(作者：)

表为User，字段有 编号： int id，用户名：string UserName，密码：string UserPwd

///

/// 添加

///

/// 用户名

/// 密码

///

[WebMethod]

public int Add(string name,string pwd)

{

SqlConnection conn = new SqlConnection("连接字符串");

();

string sql = "intsert into User (UserName,UsersPwd)

values(@UserName,@UsersPwd)";

SqlCommand cmd = new SqlCommand(sql, conn);

SqlParameter parn = new SqlParameter("@UserName", name);

(parn);

SqlParameter parp = new SqlParameter("@UsersPwd", pwd);

(parp);

int result = eNonQuery();

();

e();

return result;

}

///

/// 修改

///

/// 用户名

/// 密码

/// 编号

///

[WebMethod]

public int Update(string name, string pwd, int id)

{

SqlConnection conn = new SqlConnection("连接字符串");

();

string sql = "update User set

UserName=@UserName,UsersPwd=@UsersPwd where id=@id";

SqlCommand cmd = new SqlCommand(sql, conn);

SqlParameter parn = new SqlParameter("@UserName", name);

(parn); SqlParameter parp = new SqlParameter("@UsersPwd", pwd);

(parp);

SqlParameter pari = new SqlParameter("@id", id);

(pari);

int result = eNonQuery();

();

e();

return result;

}

///

/// 删除

///

/// 编号

///

[WebMethod]

public int Delete(int id)

{

SqlConnection conn = new SqlConnection("连接字符串");

();

string sql = "delete from User where id=@id";

SqlCommand cmd = new SqlCommand(sql, conn);

SqlParameter pari = new SqlParameter("@id", id);

(pari);

int result = eNonQuery();

();

e();

return result;

}