Display SQL Server table data in a browser

最新推荐文章于 2024-07-04 07:28:07 发布

uponce

最新推荐文章于 2024-07-04 07:28:07 发布

阅读量665

点赞数

分类专栏： webform 文章标签： table sql server browser dataset datagrid server

本文链接：https://blog.csdn.net/uponce/article/details/228528

版权

webform 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

<%@ 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>

uponce

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Display SQL Server table data in a browser

void page_load(Object sender, EventArgs e) { if(!IsPostBack) { Bind(""); } } public void Bind(string table) { SqlConnection con = new SqlConnection
复制链接

扫一扫