Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. How to Export DataSet to Microsoft Access Database

How to Export DataSet to Microsoft Access Database

Scheduled Pinned Locked Moved ASP.NET
databasehelptutorial
7 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Offline
    B Offline
    ballameharmurali
    wrote on last edited by
    #1

    Hi All, Can anybody help me in finding out the code for Exporting the data in DataSet to microsoft access . ITS VERY URGENT. Thanks murali

    V 1 Reply Last reply
    0
    • B ballameharmurali

      Hi All, Can anybody help me in finding out the code for Exporting the data in DataSet to microsoft access . ITS VERY URGENT. Thanks murali

      V Offline
      V Offline
      Vimalsoft Pty Ltd
      wrote on last edited by
      #2

      Nothing is Agent here. Refrain from using such words here. To Saving the Data from the Dataset to Access table is simple. see this http://msdn.microsoft.com/en-us/library/aa288452(VS.71).aspx[^] Hope it Helps

      Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

      B 1 Reply Last reply
      0
      • V Vimalsoft Pty Ltd

        Nothing is Agent here. Refrain from using such words here. To Saving the Data from the Dataset to Access table is simple. see this http://msdn.microsoft.com/en-us/library/aa288452(VS.71).aspx[^] Hope it Helps

        Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

        B Offline
        B Offline
        ballameharmurali
        wrote on last edited by
        #3

        Hi , Thanks for the need. This is working but How to Export the DataSet to .mdb format and also save on the desktop. murali

        V 1 Reply Last reply
        0
        • B ballameharmurali

          Hi , Thanks for the need. This is working but How to Export the DataSet to .mdb format and also save on the desktop. murali

          V Offline
          V Offline
          Vimalsoft Pty Ltd
          wrote on last edited by
          #4

          hi ballameharmurali Really you have to be careful when using terms like Export and Dataset. Firstly an .mdb Format is a Format used for a Access Database. Now in .NET a Dataset can have a Table and more than one table. a Dataset is not a Database in .NET. When you Save the data in the Dataset , you will be saving it in a table, and that table belongs to a Database. Secondly you wrote: and also save on the desktop. I don't really understand what you mean here, you are Confusing me. Please Clarify exactly what you want

          Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

          B 1 Reply Last reply
          0
          • V Vimalsoft Pty Ltd

            hi ballameharmurali Really you have to be careful when using terms like Export and Dataset. Firstly an .mdb Format is a Format used for a Access Database. Now in .NET a Dataset can have a Table and more than one table. a Dataset is not a Database in .NET. When you Save the data in the Dataset , you will be saving it in a table, and that table belongs to a Database. Secondly you wrote: and also save on the desktop. I don't really understand what you mean here, you are Confusing me. Please Clarify exactly what you want

            Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

            B Offline
            B Offline
            ballameharmurali
            wrote on last edited by
            #5

            HI , We want to Export the Data from DataGrid to MS-Access in ASP.NET. Actually I want the code in VB.NET. Thanks

            V 1 Reply Last reply
            0
            • B ballameharmurali

              HI , We want to Export the Data from DataGrid to MS-Access in ASP.NET. Actually I want the code in VB.NET. Thanks

              V Offline
              V Offline
              Vimalsoft Pty Ltd
              wrote on last edited by
              #6

              ballameharmurali I Actually don't have VB.NET installed in my Computer,VB.NET and C# have similar Classes so converting the code its very Simple. I need to Clarify something before i go for lunch. I have the Following Article http://www.codeproject.com/KB/vb/N-Tier_Application_VB.aspx[^] I wrote it with VB.NET 2003 and i have used Wizards a lot there and i was using SOL. So the Same way you save to SQL is the same way you save to Access. Tell me if i misunderstood what you are saying Looking Forward for your reply

              Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

              B 1 Reply Last reply
              0
              • V Vimalsoft Pty Ltd

                ballameharmurali I Actually don't have VB.NET installed in my Computer,VB.NET and C# have similar Classes so converting the code its very Simple. I need to Clarify something before i go for lunch. I have the Following Article http://www.codeproject.com/KB/vb/N-Tier_Application_VB.aspx[^] I wrote it with VB.NET 2003 and i have used Wizards a lot there and i was using SOL. So the Same way you save to SQL is the same way you save to Access. Tell me if i misunderstood what you are saying Looking Forward for your reply

                Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

                B Offline
                B Offline
                ballameharmurali
                wrote on last edited by
                #7

                Hi , Actually the code is bit lengthy and much complicated .It is better if u provide a simple code. I want to export datagrid data to Acess just like export to excel.I want atleast c# code. Thanks murali

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • World
                • Users
                • Groups