Export Gridview to Access Database(.mdb) via ASP.net C#

Question

0.00/5 (No votes)

See more:

Hi,
I want to export a gridview into an access database. I have the same header created in the database. Just wanted to know how to export gridview into that database. Any code sample would be highly appreciated. The header for the gridview and database is as follows:
SID,Degree,Semester,Course,Marks,Discipline

Posted 25-Dec-12 0:02am

09hadi

Add a Solution

Comments

chester_it21 25-Dec-12 6:19am

I think, so far no such thing straight ... I mean, from a Gridview to an Access database ..
My solution "you must enter his data per row of the GridView to the database access .."

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2012-12-25T00:16:00

Solution 1

You will not be able to generate Access database file on client side.
You have to dynamically create the access database file on server side, and serve it as downloadable content.

For how to serve dynamically generated file, have a look here:
Create and download a text file from a web page[^] and here: http://chrisfulstow.com/sending-dynamically-generated-files-to-the-browser-in-asp-net[^]

For how to generate an mdb file (catalog), look here: http://support.microsoft.com/?id=317867[^](it is vb.net, but really simple). The good news is, that you don't need to have access installed!

Be aware, that generating the file might take longer than the execution timeout!

Posted 25-Dec-12 0:16am

Zoltán Zörgő

Comments

09hadi 25-Dec-12 6:21am

Thank you, it worked perfectly

09hadi 25-Dec-12 6:55am

can u help me solve the timeout now?

Zoltán Zörgő 25-Dec-12 7:11am

First look here: http://msdn.microsoft.com/en-us/library/system.web.configuration.httpruntimesection.executiontimeout.aspx
If the execution takes really long (above 30s) or there is a cnahce to have too high load on the server, you should make it asnyc: create a service, that takes a fifo (from a db table for example), where you put the mdb generation parameters. On request you just add a new job to the fifo, and notify the user, that the generation has begone. When finished, you put the result in an "inbox" like function on the site. On client side you can make scheduled ajax calls to the backend to check if there is anything in the inbox and notify the user.