public bool updateGiaoVien(Entities.tblGiaoVien sv) { bool check = false; string sql = "sp_tblGiaoVien_Update"; try { con = ds.getConnect(); cmd = new SqlCommand(sql, con); con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = sql; cmd.Connection = con; cmd.Parameters.Add("@id", SqlDbType.Int).Value = sv.Id; cmd.Parameters.Add("@idchucvu", SqlDbType.Int).Value = sv.Idchucvu; cmd.Parameters.Add("@idlop", SqlDbType.Int).Value = sv.Idlop; cmd.Parameters.Add("@idkhoa", SqlDbType.Int).Value = sv.Idkhoa; cmd.Parameters.Add("@idmonhoc", SqlDbType.Int).Value = sv.Idmonhoc; cmd.Parameters.Add("@idtaikhoan", SqlDbType.Int).Value = sv.Idtaikhoan; cmd.ExecuteNonQuery(); check = true; } catch (Exception ex) { ex.ToString(); } finally { cmd.Dispose(); con.Close(); } return(check); }