Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » General » Downloads
 
Add your own
alternative version

Universal Database Admin for ASP.NET and SQL Server (Reloaded)

, 15 Apr 2006
A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.
admin.zip
Admin
Admin.csproj.webinfo
bin
Admin.dll
classes
Global.asax
images
Admin.gif
admindb.jpg
admindetails.jpg
CreateTable.jpg
custom.jpg
dataAccess.jpg
Delete.jpg
DeleteTable.JPG
Edit.jpg
Editfield.jpg
InAction.jpg
login.jpg
placeholder-100.jpg
placeholder-200.jpg
placeholder-600.jpg
readtable.jpg
TableDetails.jpg
Tables.jpg
View.jpg
includes
screen1.bmp
SQLI.jpg
admin2005.zip
Admin2005
App_Code
ClassDiagram.cd
classes
Migrated
bin
Admin.dll
classes
Global.asax
images
Admin.gif
admindb.jpg
admindetails.jpg
CreateTable.jpg
custom.jpg
dataAccess.jpg
Delete.jpg
DeleteTable.JPG
Edit.jpg
Editfield.jpg
InAction.jpg
login.jpg
placeholder-100.jpg
placeholder-200.jpg
placeholder-600.jpg
readtable.jpg
TableDetails.jpg
Tables.jpg
View.jpg
includes
screen1.bmp
SQLI.jpg
adminlite.zip
AdminLite
AdminLite.csproj.webinfo
bin
AdminLite.dll
classes
Global.asax
images
Admin.gif
admindb.jpg
admindetails.jpg
clear.gif
CreateTable.jpg
custom.jpg
dataAccess.jpg
Delete.jpg
deleterow.gif
DeleteTable.JPG
edit.gif
Edit.jpg
Editfield.jpg
InAction.jpg
Login.jpg
placeholder-100.jpg
placeholder-200.jpg
placeholder-600.jpg
readtable.jpg
TableDetails.JPG
tables.jpg
View.jpg
includes
admin_src.zip
Admin_Src
Admin.csproj.webinfo
bin
Admin.dll
Admin.pdb
Global.asax
images
Admin.gif
admindb.jpg
admindetails.jpg
dataAccess.jpg
Delete.jpg
Edit.jpg
InAction.jpg
Login.jpg
TableDetails.JPG
tables.jpg
View.jpg
includes
dbadmin_src.zip
dbadmin
images
add.gif
btn_check_update.gif
btn_databases.gif
btn_dbadmin_hp.gif
btn_ftquery.gif
btn_home.gif
btn_procedures.gif
btn_relations.gif
btn_stpworks.gif
btn_tables.gif
btn_views.gif
check.gif
cycle.gif
DBAdmin_logo.gif
delete.gif
edit.gif
excel.gif
folder.gif
ftquery.gif
icon_hide.gif
icon_logoff.gif
icon_settings.gif
icon_show.gif
icon_submit_bug.gif
key.gif
link.gif
linked.gif
logo.jpg
msaccess.gif
query.gif
refresh.gif
rename.gif
run.gif
spacer.gif
structure.gif
table.gif
tables.gif
table_shadow_bottom.gif
table_shadow_corner.gif
table_shadow_right.gif
table_title_center.gif
table_title_left.gif
table_title_right.gif
un_key.gif
view.gif
xml.gif
languages
dbadmin_en.lang
plugins
htmleditor
aleft.gif
aright.gif
blist.gif
bold.gif
center.gif
copy.gif
cut.gif
delete.gif
help.gif
ileft.gif
image.gif
instable.gif
iright.gif
italic.gif
nlist.gif
parea.gif
paste.gif
redo.gif
tbdown.gif
tpaint.gif
under.gif
undo.gif
wlink.gif
scripts
<?xml version="1.0" encoding="utf-8"?>
<root>
  <!-- 
    Microsoft ResX Schema 
    
    Version 1.3
    
    The primary goals of this format is to allow a simple XML format 
    that is mostly human readable. The generation and parsing of the 
    various data types are done through the TypeConverter classes 
    associated with the data types.
    
    Example:
    
    ... ado.net/XML headers & schema ...
    <resheader name="resmimetype">text/microsoft-resx</resheader>
    <resheader name="version">1.3</resheader>
    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
    <data name="Name1">this is my long string</data>
    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
        [base64 mime encoded serialized .NET Framework object]
    </data>
    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
        [base64 mime encoded string representing a byte array form of the .NET Framework object]
    </data>
                
    There are any number of "resheader" rows that contain simple 
    name/value pairs.
    
    Each data row contains a name, and value. The row also contains a 
    type or mimetype. Type corresponds to a .NET class that support 
    text/value conversion through the TypeConverter architecture. 
    Classes that don't support this are serialized and stored with the 
    mimetype set.
    
    The mimetype is used forserialized objects, and tells the 
    ResXResourceReader how to depersist the object. This is currently not 
    extensible. For a given mimetype the value must be set accordingly:
    
    Note - application/x-microsoft.net.object.binary.base64 is the format 
    that the ResXResourceWriter will generate, however the reader can 
    read any of the formats listed below.
    
    mimetype: application/x-microsoft.net.object.binary.base64
    value   : The object must be serialized with 
            : System.Serialization.Formatters.Binary.BinaryFormatter
            : and then encoded with base64 encoding.
    
    mimetype: application/x-microsoft.net.object.soap.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter
            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64
    value   : The object must be serialized into a byte array 
            : using a System.ComponentModel.TypeConverter
            : and then encoded with base64 encoding.
    -->
  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xsd:element name="root" msdata:IsDataSet="true">
      <xsd:complexType>
        <xsd:choice maxOccurs="unbounded">
          <xsd:element name="data">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" msdata:Ordinal="1" />
              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="resheader">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" />
            </xsd:complexType>
          </xsd:element>
        </xsd:choice>
      </xsd:complexType>
    </xsd:element>
  </xsd:schema>
  <resheader name="resmimetype">
    <value>text/microsoft-resx</value>
  </resheader>
  <resheader name="version">
    <value>1.3</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <data name="$this.TrayAutoArrange" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
    <value>True</value>
  </data>
  <data name="$this.DefaultModifiers" type="System.CodeDom.MemberAttributes, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
    <value>Private</value>
  </data>
  <data name="$this.TrayLargeIcon" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
    <value>False</value>
  </data>
</root>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

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

About the Author


| Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 15 Apr 2006
Article Copyright 2005 by Raj Lal
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid