Click here to Skip to main content
Click here to Skip to main content

Database Viewer and Updater for any Database

, 25 Jul 2006
Rate this:
Please Sign up or sign in to vote.
View and update any database table and metadata. Includes sample databases.

MyDbViewer

Introduction

This is a completely dynamic database viewer. It can be used to:

  • View any database
  • Navigate between tables
  • Select data by simply entering the values in the fields
  • Perform updates of table data
  • Display data in grids
  • Display data as single records
  • View metadata

GridView

Purpose of the DbViewer

The purpose of this viewer is to enable direct manipulation of tables without having to use SQL Server or MS Access. It is mainly a tool for developers and not for end users although it could be customized for users.

Uses of DbViewer

  • Quick manipulation of tables
  • Content management

Using the code

Unzip and open in VS2005 as a Web Site. Run the code from the default.htm page.

(default.htm is a dummy page which loads the relevant aspx pages in the _Chapter13_databaseviewer folder.)

The database class DbData

All the database logic of the application has been placed in the database class, DbData.

Code snippets

The metadata information about tables is not obtained by reading tables but by using the GetSchema command. See the functions in the DbData class which shows how to retrieve columns.

private string dbFieldsSQL(string astrTable, string astrField, bool abReadOnly)
{
    DataTable oDataTable, oIndexTable;
    SqlConnection oConn;
    string        strRows;

    try
    {
        oConn       = dbSqlConnection();
        oConn.Open();
        oDataTable  = oConn.GetSchema("Columns");
        oIndexTable = oConn.GetSchema("IndexColumns");
        strRows     = dbFields(oDataTable, oIndexTable, 
                      astrTable, astrField, abReadOnly);
        oConn.Close();
    }
    catch (Exception err)
    {
        strRows = err.Message;
    }
    return strRows;
}

private string dbFields(DataTable oDataTable, DataTable oIndexTable, 
               string astrTable, string astrField, bool abReadOnly)
{
    int      intNo, intMax;
    string   strCol, strRows;
    string[] arrFields = new string[1000];
    
    strRows  = "\n\n";
    strRows += dbStyle();
    
    // SORT BY ORDINAL_POSITION
    intMax = 0;
    strRows += "<TABLE BORDER=0 CELLSPACING=1>\n";
    foreach (DataRow oRow in oDataTable.Rows)
    {
        if (astrTable == oRow["TABLE_NAME"].ToString())
        {
            if (astrField == "" || astrField.ToLower().Trim() 
                == oRow["COLUMN_NAME"].ToString().ToLower().Trim())
            {
                // intNo = (int) oRow["ORDINAL_POSITION"];
                intNo            = Convert.ToInt32(oRow["ORDINAL_POSITION"]);
                intMax           = (intNo > intMax) ? intNo : intMax;
                strCol           = oRow["COLUMN_NAME"].ToString();
                arrFields[intNo] = "<TR><TD CLASS=Smalls " + 
                                   "ALIGN='left'>" + strCol + 
                                   "<BR /><INPUT NAME=INPUT_" + 
                                   strCol + " ###" + strCol + "### ";
                // READONLY if Key/Index Field
                if (abReadOnly)
                {
                    foreach (DataRow oIndexRow in oIndexTable.Rows)
                    {
                        if (astrTable == oIndexRow["table_name"].ToString() && 
                            oRow["COLUMN_NAME"].ToString() == 
                            oIndexRow["column_name"].ToString())
                        {
                            arrFields[intNo] += 
                                " READONLY STYLE='background: #C0C0C0;' ";
                            break;
                        }
                    }
                }
                arrFields[intNo] += "></TD></TR>\n";
            }
        }
    }
    for (intNo=1;intNo<intMax+1;intNo++)
        {strRows += (arrFields[intNo] != "") ? arrFields[intNo] : "";}
    strRows += "</TABLE>\n";

    return strRows;
}

History

  • 25 July 2006 - updated download

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

avronp
Web Developer
Israel Israel
Jazz Drummer (1½/2½/3.5++), Writer, Grandfather, Possibly World's Oldest Web Developer, Rebel, Anti-globalization, Prisoner of conscience

Comments and Discussions

 
GeneralGreat PinmemberVitali Halershtein4-Jun-08 5:39 
Generalopen database Pinmembergeorgeen29-May-07 10:11 
QuestionAccess databse connectivity Pinmemberhygeenams18-Jan-07 18:51 
QuestionHow to connect to Oracle DB?? PinmemberGsPandian27-Dec-06 22:52 
GeneralWhen I substitute a different Access database I get an error PinmemberGixxer1k8-Oct-06 10:49 
GeneralWhy you use SQLConnection in your example Pinmemberjpazgier26-Jul-06 6:45 
GeneralRe: Why you use SQLConnection in your example Pinmemberavronp29-Jul-06 10:07 
QuestionError when accessing Access Table: MSysAccessObjects Pinmemberchengkc25-Jul-06 3:41 
AnswerRe: Error when accessing Access Table: MSysAccessObjects Pinmemberavronp29-Jul-06 10:00 
GeneralRe: Error when accessing Access Table: MSysAccessObjects Pinmemberchengkc30-Jul-06 6:16 
GeneralMissing Files Pinmember-JeRoK-18-Jul-06 9:22 
GeneralRe: Missing Files Pinmember-JeRoK-18-Jul-06 11:49 
GeneralRe: Missing Files Pinmemberyermalpavan24-Jul-06 19:46 
GeneralRe: Missing Files Pinmemberavronp29-Jul-06 9:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140823.1 | Last Updated 25 Jul 2006
Article Copyright 2006 by avronp
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid