ndfweb.cn

asp.net2.0(vb) access读取操作


2009-12-04 18:07:52 (5485)


web.config: 

<connectionStrings>
  <add name="NDFConn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\NDF#Data.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
 </connectionStrings>

 

-------------------------------------------
文件代码:


Partial Class Left_sort
    Inherits System.Web.UI.UserControl
    Private strConn As String = System.Configuration.ConfigurationManager.ConnectionStrings("ndfconn").ToString
    Private DBconn As OleDbConnection
    Private DBComm As OleDbCommand
    Private Dr As OleDbDataReader
    Private DBconn2 As OleDbConnection
    Private DBComm2 As OleDbCommand
    Private Dr2 As OleDbDataReader
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        LeftSort()
    End Sub
    Function LeftSort()
        Dim Tr As New TableRow
        Dim Td As New TableCell
        Dim I As Integer
        Dim S As String

 

        DBconn = New OleDbConnection(strConn)
        DBComm = New OleDbCommand("select  * from sort", DBconn)
        DBconn.Open()
        Dr = DBComm.ExecuteReader
        While Dr.Read
            Td = New TableCell
            'Td.ID = "Left_Td"
            'Td.CssClass = "Bold"
            Td.Text = "<a href=""List.aspx?Sort=" & Dr("id") & """ class=""LBig"">" & Dr("name") & "</a>"
            Tr = New TableRow
            Tr.Cells.Add(Td)
            Left_sort1.Rows.Add(Tr)

            DBconn2 = New OleDbConnection(strConn)
            DBComm2 = New OleDbCommand("select  * from sorts where [sort]= " & Dr("id") & " ", DBconn2)
            DBconn2.Open()
            Dr2 = DBComm2.ExecuteReader
            While Dr2.Read
                S = S & Dr2("name")
                Td = New TableCell
                'Td.ID = "Left_Td" & I

                Td.Text = "<a href=""List.aspx?Sort=" & Dr("id") & "&Sorts=" & Dr2("id") & """ >" & Dr2("name") & "</a>"
                Tr = New TableRow
                Tr.Cells.Add(Td)
                Left_sort1.Rows.Add(Tr)
            End While
            Dr2.Close()
            DBconn2.Close()

        End While
        Dr.Close()
        DBconn.Close()
    End Function

   
End Class

了解更多请访问:http://www.ndfweb.cn/news-482.html
  NDF俱乐部
  国际域名注册
  建站咨询
合作伙伴:万网 | 新网 | 新网互联 NDF网站建设淘宝店 | 实用工具 | 外貿網站建設 | 联系我们
鲁公网安备 37110202000336号 鲁ICP备2021027697号-1 Sitemap - RSSRSS订阅