public bool Update(pdetails u) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "UPDATE pm SET password=@password where sno =@sno"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@password", u.password); cmd.Parameters.AddWithValue("@sno", u.sno); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { //Query Successfull isSuccess = true; } else { //Query Failed isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
public bool Insert(pdetails u) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { String sql = "INSERT INTO pm(title,username,password) values(@title,@username,@password)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@username", u.username); cmd.Parameters.AddWithValue("@title", u.title); cmd.Parameters.AddWithValue("@password", u.password); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }