大家帮我看一下,还是数据库连接的问题

2023-09-16 09:34:13 墨初知识笔记 132阅读

% @页面语言=' c# '代码隐藏=' web窗体1 .aspx。cs ' autoeventwireup=' false ' inherits=' web application 9。web表单1 GBA(0，0，0，1)；background-color: rgba(245，245，245，1)' ' enableViewStateMac=' True ' % % % % @ import namespace=' System .数据“% % @”导入名称空间=

ba(0, 0, 0, 1); background-color: rgba(245, 245, 245, 1)">"System.Data.SqlClient" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>WebForm1</title>
        <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="">
        <script language="C#" runat="server">

    protected void Page_Load(Object sender, EventArgs e)
    {
        SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Trusted_Connection=yes");
        SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors", myConnection);

        DataSet ds = new DataSet();
        myCommand.Fill(ds, "作者");

        MyDataGrid.DataSource=ds.Tables["作者"].DefaultView;
        MyDataGrid.DataBind();
    }

        </script>
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <form id="Form1" method="post" runat="server">
            <FONT face="宋体"></FONT>
        </form>
        <h3><font face="宋体">DataGrid 控件的简单选择</font></h3>
        <ASP:DataGrid id="MyDataGrid" runat="server" Width="700" BackColor="#ccccff" BorderColor="black"
            ShowFooter="false" CellPadding="3" CellSpacing="0" Font-Name="宋体" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd"
            EnableViewState="false" />
    </body>
</HTML>

标签：