读 Access mdb 文件 DataSet 和 DataGrid 显示

最新推荐文章于 2020-09-04 14:41:13 发布

wide288

最新推荐文章于 2020-09-04 14:41:13 发布

阅读量2.3k

点赞数

文章标签： datagrid dataset access textbox server asp

本文链接：https://blog.csdn.net/wide288/article/details/97669

版权

Asp.net 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

此网页创建一个表，一个按钮，一个文本框，在文本框内输入一个索引号，单击按钮。从表中显示出现表中相应的记录内容，如无则不显示。此表能正确读数据库。主要是个小例子。

文件名：test_1.aspx

<%@ Page Language="C#" Debug=true %>
<script runat="server">

// Insert page code here
//

        System.Data.DataSet MyQueryMethod(int id) {
            string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=E://wwwroot//adat" +
    "a.mdb";
            System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);

            string queryString = "SELECT [one].* FROM [one] WHERE ([one].[id] = @id)";
            System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
            dbCommand.CommandText = queryString;
            dbCommand.Connection = dbConnection;

            System.Data.IDataParameter dbParam_id = new System.Data.OleDb.OleDbParameter();
            dbParam_id.ParameterName = "@id";
            dbParam_id.Value = id;
            dbParam_id.DbType = System.Data.DbType.Int32;
            dbCommand.Parameters.Add(dbParam_id);

            System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
            dataAdapter.SelectCommand = dbCommand;
            System.Data.DataSet dataSet = new System.Data.DataSet();
            dataAdapter.Fill(dataSet);

return dataSet;
}

    void Button1_Click(object sender, EventArgs e) {
        //DataGrid1.DataSource = GetOrderDetails(CInt(TextBox1.Text));
        //DataGrid1.DataSource = GetOrderDetails(Convert.ToInt32(TextBox1.Text));
        DataGrid1.DataSource = MyQueryMethod(int.Parse(TextBox1.Text));
        DataGrid1.DataBind();
    }

</script>

=================The end======================

此文件是手工写的，读若干个表的代码，也是个小例子用到了 DataSet, DataGrid 不过后者，的应用没有写，因为本人也正在学习中。

文件名 : test_2.aspx

<%@ Page Language="C#" Debug="true" %>
<%@ assembly name="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System" %>
<script runat="server">

    void Page_Load(Object sender, EventArgs e)
    {


        if(!IsPostBack)
        {
            string str1 = "select * from admin";
            string str2 = "select * from one";
            string strConn=@"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=";
                    strConn+=Server.MapPath("adata.mdb");
            OleDbConnection MyConnection = new OleDbConnection(strConn);
            OleDbDataAdapter myCommand1 = new OleDbDataAdapter(str1,MyConnection);
            OleDbDataAdapter myCommand2 = new OleDbDataAdapter(str2,MyConnection);
            //ADODataSetCommand myCommand1 = new ADODataSetCommand(str1,MyConnection);
            //ADODataSetCommand myCommand1 = new ADODataSetCommand(str1,MyConnection);
            DataSet ds = new DataSet();
            //myCommand1.FillDataSet(ds, "admin");
            //myCommand2.FillDataSet(ds, "one");
            myCommand1.Fill(ds, "admin");
            myCommand2.Fill(ds, "one");
            /*DataGrid mylist1, mylist2;*/
            mylist1.DataSource = ds.Tables["admin"].DefaultView;
            mylist2.DataSource = ds.Tables["one"].DefaultView;
            mylist1.DataBind();
            mylist2.DataBind();
        }
    }

</script>
<html>
<head>
    <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR" />
</head>
<body>
    <form runat="server">
        <table>
            <tbody>
                <tr>
                    <td>
                        <asp:DataGrid id="mylist1" runat="server" AutoGenerateColumns="false" EnableViewState="false" Font-Size="8pt" Font-Name="" CellSpacing="1" CellPadding="2" ShowFooter="false" GridLine="None">
                            <Columns>
                                <asp:TemplateColumn>
                                    <ItemTemplate>
                                        <asp:Label runat="server" text='<%#"<font size=2>"+DataBinder.Eval(Container, "DataItem.name")+"</font>" %>' id="Label2"></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn>
                                    <ItemTemplate>
                                        <asp:Label runat="server" text='<%# "<font size=2>"+DataBinder.Eval(Container, "DataItem.password")+"</font>" %>' id="Label3"></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                            </Columns>
                        </asp:DataGrid>
                    </td>
                    <td>
                        <asp:DataGrid id="mylist2" runat="server" AutoGenerateColumns="false" EnableViewState="false" Font-Size="8pt" Font-Name="" CellSpacing="1" CellPadding="2" ShowFooter="false" GridLine="None">
                            <Columns>
                                <asp:TemplateColumn>
                                    <ItemTemplate>
                                        <asp:Label runat="server" text='<%#"<font size=2>"+DataBinder.Eval(Container, "DataItem.id")+"</font>" %>' id="Label4"></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn>
                                    <ItemTemplate>
                                        <asp:Label runat="server" text='<%# "<font size=2>"+DataBinder.Eval(Container, "DataItem.wt")+"</font>" %>' id="Label5"></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn>
                                    <ItemTemplate>
                                        <asp:Label runat="server" text='<%# "<font size=2>"+DataBinder.Eval(Container, "DataItem.a")+"</font>" %>' id="Label5"></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                            </Columns>
                        </asp:DataGrid>
                    </td>
                </tr>
            </tbody>
        </table>
    </form>
</body>
</html>