Member Avatar for afaque01

Ihave been working on database but Though iam able to create But Cannot Write in data base..

Dim ADOXcatalog As New ADOX.Catalog
        Dim ADOXtable As New ADOX.Table
        Dim ADOXindex As New ADOX.Index

        On Error GoTo errhandler
        ADOXcatalog.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "c:\info.mdb")

        On Error Resume Next

        ADOXcatalog.ActiveConnection = _
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
      & "c:\newdata.mdb"

        'name table, append fields to table
        ADOXtable.Name = "Employees"
        ADOXtable.Columns.Append("Name", ADOX.DataTypeEnum.adVarWChar, 40)
        ADOXtable.Columns.Append("ID", ADOX.DataTypeEnum.adInteger)
        ADOXtable.Columns.Append("Department", ADOX.DataTypeEnum.adVarWChar, 20)

        'append tables to database
        ADOXcatalog.Tables.Append(ADOXtable)

Plz tell mo how to create Rows .. imean Adding data Under each colum .. like Names under Name colum and ID's under ID colum....

  • 2 Contributors
  • 2 Replies
  • 118 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by afaque01

Recommended Answers

All 2 Replies

Member Avatar for kvprajapati

>How to write in Access Database! in .net

.Net framework has ADO.NET database integration class lib to perform any Database operations. Take a look at MSDN pages to learn and implement.

Here is a sample - http://www.daniweb.com/forums/post1434777.html#post1434777

Edited by kvprajapati because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.