private static Userinfo ReadUserinfo(IDataRecord reader) { var Id = reader.GetInt32(0); var Mail = reader.GetString(1); var Phone = reader.GetInt32(2); var i = new Userinfo { Id = Id, Mail = Mail, PhoneNo = Phone }; return(i); }
public int UpdateMail(string id, Userinfo user) { SqlConnection conn = new SqlConnection(GetConnectionString); conn.Open(); string sql = $"UPDATE UserTable SET Mail = @mail, PhoneNo = @phone WHERE id = {id}"; SqlCommand command = new SqlCommand(sql, conn); command.Parameters.AddWithValue("@mail", user.Mail); command.Parameters.AddWithValue("@phone", user.PhoneNo); return(command.ExecuteNonQuery()); }