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