public static GruposVariablesDataset.GruposVariablesRow GetByPk(long IdGrupo, long IdVariable) { GruposVariablesDataset data = new GruposVariablesDataset(); SqlCommand cmd = new SqlCommand("Pr_GruposVariables_GetByPk", dbhelper.Connection.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IdGrupo", SqlDbType.BigInt)); cmd.Parameters["@IdGrupo"].Value = IdGrupo; cmd.Parameters.Add(new SqlParameter("@IdVariable", SqlDbType.BigInt)); cmd.Parameters["@IdVariable"].Value = IdVariable; SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.TableMappings.Add("Table", "GruposVariables"); adapter.Fill(data); if (data.GruposVariables.Rows.Count == 1) { return((GruposVariablesDataset.GruposVariablesRow)data.GruposVariables.Rows[0]); } return(null); }
public static void Update(GruposVariablesDataset dataSet) { Update(dataSet.GruposVariables); }
public static GruposVariablesDataset GetList() { GruposVariablesDataset data = new GruposVariablesDataset(); return(( GruposVariablesDataset )GetList(data)); }