Display SQL Server table data in a browser

Just supply your database connection string and this code will give you a radio button list of all your SQL Server tables and will show their fields. This could be built on to create an ASP.NET version of GenericDB.

<%@ Page Language="c#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

   void page_load(Object sender, EventArgs e) {
   
       if(!IsPostBack) {
           Bind("");
       }
   }
   
   public void Bind(string table) {
       SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]);
       SqlDataAdapter da = new SqlDataAdapter("select name from sysobjects where xtype='U' and name<>'dtproperties'", con);
       DataSet ds = new DataSet();
       da.Fill(ds, "xxx");
       dg.DataSource = ds.Tables[0].DefaultView;
       dg.DataBind();
   
       //list columns in one table
       if(table!="") {
           SqlDataAdapter da2 = new SqlDataAdapter("SELECT syscolumns.name AS [Fields in Items Database], syscolumns.type, syscolumns.length, syscolumns.isnullable FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = '" + table + "' ORDER BY syscolumns.colid", con);
           DataSet ds2 = new DataSet();
           da2.Fill(ds2, "xxx");
           dg2.DataSource = ds2.Tables[0].DefaultView;
           dg2.DataBind();
       }
   }
   
   void dg_SelectedIndexChanged(Object sender, EventArgs e) {
       Bind(dg.SelectedItem.Text);
   }

</script>
<html>
<head>
</head>
<body>
   <form runat="server">
       <table border="0" cellpadding="5" cellspacing="5">
           <tbody>
               <tr>
                   <td valign="top" bgcolor="tan">
                       <asp:RadioButtonList id="dg" runat="server" DataValueField="Name" DataTextField="Name" AutoPostBack="True" OnSelectedIndexChanged="dg_SelectedIndexChanged"></asp:RadioButtonList>
                   </td>
                   <td valign="top">
                       <asp:DataGrid id="dg2" Cellpadding="2" BackColor="LightGoldenrodYellow" runat="server" GridLines="None" BorderWidth="1px" BorderColor="Tan" ForeColor="Black">
                           <FooterStyle backcolor="Tan"></FooterStyle>
                           <HeaderStyle font-bold="True" backcolor="Tan"></HeaderStyle>
                           <PagerStyle horizontalalign="Center" forecolor="DarkSlateBlue" backcolor="PaleGoldenrod"></PagerStyle>
                           <SelectedItemStyle forecolor="GhostWhite" backcolor="DarkSlateBlue"></SelectedItemStyle>
                           <AlternatingItemStyle backcolor="PaleGoldenrod"></AlternatingItemStyle>
                       </asp:DataGrid>
                   </td>
               </tr>
           </tbody>
       </table>
   </form>
</body>
</html>

You might also like...

Comments

Edward Tanguay Edward Tanguay updates his personal web site tanguay.info weekly with code, links, quotes and thoughts on web development. Sign up for the free newsletter.

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“If Java had true garbage collection, most programs would delete themselves upon execution.” - Robert Sewell