我来了,
以后有什么问题
找我好了 ,咱们共同解决!

解决方案 »

  1.   

    <%@Import Namespace="System.Data.SqlClient"%>
    <%@Import Namespace="System.Data"%>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <HTML>
    <HEAD>
    <title>_808</title>
    <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.0">
    <meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
    <meta name="vs_defaultClientScript" content="JavaScript">
    <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    <SCRIPT runat="server"> 
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            '在此处放置初始化页的用户代码        Dim objConn As SqlConnection=new SqlConnection("server=localhost;uid=sa;pwd=;database=Northwind")        'open connection
            Dim objCmd As  sqlDataAdapter=new   sqlDataAdapter ("select * from Customers", objConn)        'fill dataset
            Dim ds As DataSet = New DataSet()
            objCmd.Fill(ds)
            DataGrid1.DataSource = ds
            DataGrid1.DataBind()
        End Sub
    </SCRIPT>
    </HEAD>
    <body MS_POSITIONING="GridLayout">
    <form id="Form1" method="post" runat="server">
    <FONT face="宋体">
    <asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 13px; POSITION: absolute; TOP: 29px" runat="server" Width="356px" Height="122px" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="4" Font-Names="宋体" Font-Size="X-Small">
    <SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
    <ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
    <HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
    <FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
    <Columns>
    <asp:HyperLinkColumn Text=" Enter" Target="_self" NavigateUrl="dispnews.asp"></asp:HyperLinkColumn>
    </Columns>
    <PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
    </asp:DataGrid></FONT>
    </form>
    </body>
    </HTML>