예제 #1
0
        /// <summary>
        /// Add your parameters in correct order by using this adapters (Select)Command in AddParameter and addSystemParameters
        /// </summary>
        /// <param name="sConnectionString"></param>
        /// <param name="sCommandText"></param>
        /// <param name="sTable"></param>
        /// <returns></returns>
        public static System.Data.IDbDataAdapter GetDbDataAdapter(string sConnectionString, string sCommandText, string sTable)
        {
            // Copied SelectCommand from generated AdoDataSetCommand (changed param values)
            XrDbDataAdapter daDataAdapter = new XrDbDataAdapter();
            XrDbCommand     oCmd          = new XrDbCommand();
            XrDbConnection  oConn         = (XrDbConnection)GetConnection(sConnectionString);

            oCmd.Connection  = oConn;
            oCmd.CommandText = sCommandText;
            oCmd.CommandType = System.Data.CommandType.StoredProcedure;

            daDataAdapter.SelectCommand = oCmd;

            daDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", sTable) });

            return(daDataAdapter);
        }
예제 #2
0
        /// <summary>
        /// Returns an Initialized DataAdapter
        /// </summary>
        /// <param name="oConn">A DataBase Connection</param>
        /// <param name="sCommandText">The Command Text</param>
        /// <param name="lUserID">The UserID</param>
        /// <param name="lOwnerID">The OwnerID</param>
        /// <param name="lLanguageID">The LanguageID</param>
        /// <param name="lRoleID">The RoleID</param>
        /// <returns>The Initialized DataAdapter</returns>
        public static System.Data.IDbDataAdapter GetListDbDataAdapter(System.Data.IDbConnection oConn, string sCommandText, long lUserID, long lOwnerID, long lLanguageID, long lRoleID)
        {
            // Copied SelectCommand from generated AdoDataSetCommand (changed param values)
            XrDbDataAdapter oDataAdapter = new XrDbDataAdapter();
            XrDbCommand     oCmd         = new XrDbCommand();

            oCmd.Connection  = (XrDbConnection)oConn;
            oCmd.CommandText = sCommandText;
            oCmd.CommandType = System.Data.CommandType.StoredProcedure;

            AddStandardParameters(oCmd, lUserID, lOwnerID, lLanguageID, lRoleID);

            oDataAdapter.SelectCommand = oCmd;

            oDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "List", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("l_value", "l_value"),
                                                                                                                                                                                                  new System.Data.Common.DataColumnMapping("s_text", "s_text") }) });
            return(oDataAdapter);
        }