how to save bulk data from gridview having paging to show 5000 records to mssql table

Question

0.00/5 (No votes)

See more:

hello to all
My problem is that i have an Excel file with 2 columns and 5000 records or may be more i uploaded the excel file successfully and bind it with the gridview successfully but now my problem is that is have to save that data from gridview to database but it picks only the records showing in Ist page only. as after biding the excel with gridview user also enter some other information that is required in gridview.
please help me if anyone has solution for this prob.
thanks in advance.
waiting for reply

Posted 30-Oct-12 23:10pm

Amit Jamwal

Add a Solution

3 solutions

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)

Aditya Magotra · Answer 1 · 2012-10-30T23:35:00

Solution 1

hi,

Use datatable to bind data with gridview on save scan gridview & then use bulk upload to save data in database.

Posted 30-Oct-12 23:35pm

Aditya Magotra

Comments

Amit Jamwal 31-Oct-12 5:44am

thnx for reply...
gridview is binding with datatable only.....
i am creating datatable from data coming from excel file.......
but after binding gridview user also add some additional data in gridview......

[no name] 31-Oct-12 5:48am

When user clicks on save scan gridview once update datatable values, then use bulk upload to save data.

Amit Jamwal 31-Oct-12 5:54am

How to scan gridview can u giv some example..............

SoumenBanerjee · Answer 2 · 2012-10-30T23:58:00

Use your custom class and make it [Serializable]
then create your list of data from excel or use Datatable bind grid also store it in in viewstate and retrieve your collection or datatable from viewstate on postback update your collection by user changes restore it in viewstate then finally store it in database using OPENXML.

you can try this article for further help

Serialized collection of classes or List of objects into XML and bulk insert using OpenXML[^]

_Amy · Answer 3 · 2012-10-31T00:04:00

Use Table valued parameters to save bulk data from gridview. Refer the links below for an article:
Sending a DataTable to a Stored Procedure[^]
C# and Table Value Parameters[^]
Table-Valued Parameters[^]
Use Table-Valued Parameters (Database Engine)[^]

Hope it helps!
--Amit

how to save bulk data from gridview having paging to show 5000 records to mssql table

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0