首页 > 数据库技术 > 详细

新手小白,学生,刚刚接触asp,老师让与自己做的access表格联系起来,希望大神指点一下,代码如下

时间:2019-12-15 11:16:27      阅读:69      评论:0      收藏:0      [点我收藏+]

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Ling;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Ling;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
    OleDbConnection conn;


    protected void Page_Load(object sender, EventArgs e)
    {
        conn = new OleDbConnection();
        conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/WebSite2/0001.accdb";

        OleDbDataAdapter ad1 = new OleDbDataAdapter();
        ad1.SelectCommand = new OleDbCommand("select  *  from students");
        ad1.SelectCommand.Connection = conn;

        
        DataSet myset = new DataSet();

        conn.Open();
        ad1.Fill(myset);
        conn.Close();

// Label1.Text = myset.Tables[0].Rows[0][0].ToString();
  //      Label2.Text = myset.Tables[0].Rows[0][1].ToString();
        for (int i = 0; i < myset.Tables[0].Rows.Count; i++)
        {
            DropDownList1.Items.Add(myset.Tables[0].Rows[i][0].ToString());

 

        }



    }
}

新手小白,学生,刚刚接触asp,老师让与自己做的access表格联系起来,希望大神指点一下,代码如下

原文:https://www.cnblogs.com/tjj9/p/12042086.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!