public bool updateTk(tbltk tk) { using (SqlConnection cnn = dtcn.getconnect()) { cnn.Open(); try { using (SqlCommand cmd = new SqlCommand("updatetk", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@matk", tk.Matk); cmd.Parameters.AddWithValue("@maquyen", tk.Fk_maquyen); cmd.Parameters.AddWithValue("@tendn", tk.Tendn); cmd.Parameters.AddWithValue("@mk", tk.Matkhau); cmd.Parameters.AddWithValue("@trangthai ", tk.Trangthai); cmd.ExecuteNonQuery(); cnn.Close(); } } catch (Exception e) { return(false); } return(true); } }
public DataTable timkiem_tk(tbltk tk) { DataTable data = new DataTable(); using (SqlConnection cnn = dtcn.getconnect()) { cnn.Open(); using (SqlCommand cmd = new SqlCommand("timkiem_tk", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@maquyen", tk.Fk_maquyen); cmd.Parameters.AddWithValue("@tendn", tk.Tendn); SqlDataReader abc = cmd.ExecuteReader(); if (abc.HasRows) { data.Load(abc); } cnn.Close(); return(data); } } }