// insert member public void AddMembers(ManageMember strMB) { string sql = "INSERT INTO members(first_name, surname, email)VALUES(N'" + strMB.first_name + "', N'" + strMB.surname + "', N'" + strMB.email + "')"; SqlConnection con = db.GetConnection(); SqlCommand cmd = new SqlCommand(sql, con); // open connect con.Open(); cmd.ExecuteNonQuery(); //close connect cmd.Dispose(); con.Close(); }
//update data public void UpdateMembers(ManageMember strMB) { string sql = "UPDATE member SET first_name = N'" + strMB.first_name + "', surname = N'" + strMB.surname + "', email = '" + strMB.email + "' "; SqlConnection con = db.GetConnection(); SqlCommand cmd = new SqlCommand(sql, con); // open connect con.Open(); cmd.ExecuteNonQuery(); //close connect cmd.Dispose(); con.Close(); }
public List <ManageMember> getMember(string ID) { string sql; if (string.IsNullOrEmpty(ID)) { sql = "SELECT * FROM members"; } else { sql = "SELECT * FROM members WHERE Id = " + ID; } List <ManageMember> strList = new List <ManageMember>(); SqlConnection con = db.GetConnection(); SqlDataAdapter cmd = new SqlDataAdapter(sql, con); DataTable dt = new DataTable(); // open connect con.Open(); cmd.Fill(dt); //close connect cmd.Dispose(); con.Close(); ManageMember strMB; for (int i = 0; i < dt.Rows.Count; i++) { strMB = new ManageMember(); strMB.ID = Convert.ToInt32(dt.Rows[i]["Id"].ToString()); strMB.first_name = dt.Rows[i]["first_name"].ToString(); strMB.surname = dt.Rows[i]["surname"].ToString(); strMB.email = dt.Rows[i]["email"].ToString(); strList.Add(strMB); } return(strList); }