C# (CSharp) DB2Command.ExecuteResultSet Examples

Example #1

File: DatabaseHelper.cs Project: Angie0725/SanitariumIliganMIS

        public DB2ResultSet QueryWithResultSet(String sql_query)
        {
            DB2ResultSet rs = null;

            try
            {
                if (!Connection.IsOpen)
                {
                    Connection.Open();
                }

                DB2Command command = new DB2Command(sql_query, Connection);
                rs = command.ExecuteResultSet(DB2ResultSetOptions.None);

                return(rs);
            }
            catch (DB2Exception ex)
            {
                MessageBox.Show("Error: " + ex.Message.ToString(), "Database Helper ResultSet");
            }

            return(rs);
        }