Exemplo n.º 1
0
        public void fetchReferenceTableInfowithIdAndCode(String schemaName, String tableName, out DataTable dtRet, out String sID)
        {
            DataTable ret             = null;
            String    ID              = string.Empty;
            var       storedProcedure = new StoredProcedure();

            storedProcedure.StoredProcedureName = schema + ".[AdministrativeFunctions.EditReferenceTableForm.Load]";
            storedProcedure.Parameters.Add(new StoredProcedureParameter("@schemaName", ParameterType.DBString, schemaName));
            storedProcedure.Parameters.Add(new StoredProcedureParameter("@tableName", ParameterType.DBString, tableName));
            storedProcedure.ExecuteDataSetWithOutputParam(out ret, out ID);
            dtRet = ret; sID = ID;
        }