How to export all records(1000) from Datagrid in asp.net

Vamsi k

Hi All,

I need a help, actually i am trying to get all records(1000) from datagrid to excel. But i am not able to do that. Many of the examples are in Gridview to export data from Gridview to excel, but my requirement is export all records(1000) from datagrid to excel.

Can anyone please suggest how to complete that work.It would be very helpful.

Thanks,

Vamsi

19 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vamsi k7y ago
Sreekanth please give reply
Vamsi k7y ago
Sreekanth in the below what i need to change. Could you please do edit in the code. It would be more helpful.

for (int i = 0; i < customRCADSDV.Count; i++)
{
if (lbRCADSFields.Items[0].Selected) s1 += "" + customRCADSDV[i]["RecordId"].ToString() + "";
if (lbRCADSFields.Items[1].Selected) s1 += "" + customRCADSDV[i]["Name"].ToString() + "";
if (lbRCADSFields.Items[2].Selected) s1 += "" + customRCADSDV[i]["Title"].ToString() + "";
if (lbRCADSFields.Items[3].Selected) s1 += "" + customRCADSDV[i]["AsOwner"].ToString() + "";
if (lbRCADSFields.Items[4].Selected) s1 += "" + customRCADSDV[i]["CPDueDate"].ToString() + "";
if (lbRCADSFields.Items[5].Selected) s1 += "" + customRCADSDV[i]["CPCompleteDate"].ToString() + "";
if (lbRCADSFields.Items[6].Selected) s1 += "" + customRCADSDV[i]["RecordedDt"].ToString() + "";
if (lbRCADSFields.Items[7].Selected) s1 += "" + customRCADSDV[i]["Type"].ToString() + "";
if (lbRCADSFields.Items[8].Selected) s1 += "" + customRCADSDV[i]["Geo"].ToString() + "";
if (lbRCADSFields.Items[9].Selected) s1 += "" + customRCADSDV[i]["Documents"].ToString() + "";
if (lbRCADSFields.Items[10].Selected) s1 += "" + customRCADSDV[i]["BUOwner"].ToString() + "";
if (lbRCADSFields.Items[11].Selected) s1 += "" + customRCADSDV[i]["ExecCert"].ToString() + "";
if (lbRCADSFields.Items[12].Selected) s1 += "" + customRCADSDV[i]["RowCreatedDt"].ToString() + "";
if (lbRCADSFields.Items[13].Selected) s1 += "" + customRCADSDV[i]["CitnStatDsc"].ToString() + "";
if (lbRCADSFields.Items[14].Selected) s1 += "" + customRCADSDV[i]["RCOwner"].ToString() + "";
if (lbRCADSFields.Items[15].Selected) s1 += "" + customRCADSDV[i]["RowUpdatedDt"].ToString() + "";
if (lbRCADSFields.Items[16].Selected) s1 += "" + customRCADSDV[i]["Entity"].ToString() + "";
if (lbRCADSFields.Items[17].Selected) s1 += "" + customRCADSDV[i]["WrkflwStatDsc"].ToString() + "";
if (lbRCADSFields.Items[18].Selected) s1 += "" + customRCADSDV[i]["JrsdctnOrgNm"].ToString() + "";
if (lbRCADSFields.Items[19].Selected) s1 += "" + customRCADSDV[i]["CPDueNote"].ToString() + "";//
if (lbRCADSFields.Items[20].Selected) s1 += "" + customRCADSDV[i]["DocketNo"].ToString() + "";
if (lbRCADSFields.Items[21].Selected) s1 += "" + customRCADSDV[i]["LegalSME"].ToString() + "";
if (lbRCADSFields.Items[22].Selected) s1 += "" + customRCADSDV[i]["Synopsis"].ToString() + "";
if (lbRCADSFields.Items[23].Selected) s1 += "" + customRCADSDV[i]["EmailSchdl"].ToString() + "";
s1 += "\n";
}
Sreekanth Reddy7y ago
@Vamsi

Exactly..
Now you dont want to compare right ?
Directly you can access from that datatable where it coantains only selected/checked items.
Vamsi k7y ago
Hi Sreekanth,

Could you see the below code.

Like this you suggested me to write in the Listbox selectedIndexChanged event?
Now i stored all items in the datatable.

protected void lbRCADSFields_SelectedIndexChanged(object sender, EventArgs e)
{
int items = 0;

dtglobal.Columns.Add("Items");
foreach (ListItem li in lbRCADSFields.Items)
{
if (li.Selected)
{
items++;
DataRow dr = dtglobal.NewRow();
dr[0] = li.Value;
dtglobal.Rows.Add(dr);
}
}
}
Sreekanth Reddy7y ago
@Vamsi K

Exactly.

By doing so, within the dt or list we can have only checked items.
So that, we dont need to check the condition(means optimizing the time I hope).

If still not clarified you are welcome with your query.
If got it Please do accept the answer.

Thank you.
Vamsi k7y ago
Sreekanth,

Sorry for asking again, please give the answer.

So when the user selects listbox items , do i need to take the total selected items and store it to a Datatable.and after that i should store that dt to a Session["list"]

I am confused.
Vamsi k7y ago
Sreekanth i could not understand your answer.

Sorry for asking again

So when the user selects listbox items , do i need to take the total selected items and store it to a Datatable.and after that i should store that dt to a Session["list"]

I am confused.
Sreekanth Reddy7y ago
Try this approach.

Whenever user selects the item from the listbox : There itself(SelectedIndexChanged event) create a DataTable(global dt as session or viewstate).

And finally while doing export, loop the dt which you stored.
Vamsi k7y ago
Please give one example for your case 1 with my code.
Sreekanth Reddy7y ago
Okay, understood the scenario.
Sreekanth Reddy7y ago
Cae 1 :
To the gridview bind only "selected"(lbRCADSFields.Items[0].Selected) records.

So that we dont want to go for condition checking. Directly we can loop without condition.

Caes 2 :
If you are not allowed to customize the gridview records :

Then directly call data from procedure whose "Selected" value is "True" and loop them without conditions.
Vamsi k7y ago
bRCADSFields is List box having (lbRCADSFields.Items[0].Selected) total 24 listbox items are there. Total 24 if conditions written inside the forloop. There more time it is taking.
Vamsi k7y ago
Yes Sreekanth i need optimization at there( if conditions)
Sreekanth Reddy7y ago
@Vamsi

for (int i = 0; i < customRCADSDV.Count; i++)
{
// Seems here taking time because :
//you had written lot of if conditions.
//If your rgid "customRCADSDV" rows count is huge...
//Obviously it will take time...
}

Your code contains lot of "if" statements inside the for loop of the grid rows.

Are you expecting an optimization at this place ?
Vamsi k7y ago
We need to take the data from backend and export to excel. But the problem is for loop contains if conditions. So every iteration all if conditions should exceute.Total 16000 records aer there now it is increased to 34400. How to solve that.

Please provide answer for the requirement.
Sreekanth Reddy8y ago
Are you facing any timeout expiration issue while exporting large data to excel ?
Sreekanth Reddy8y ago
Okay.
Can you provide your code ?
If you want only 1000 records they loop with limit as 1000 with condition.
Vamsi k8y ago
Hi Sreekanth,

In my code the forloop excecution happening for 16000 records. Because of this it takes lot of time. I couldnot see and load the data in excel. It is keep on exceuting without showing any result.

My requirement is in asp.net datagrid not datagridview.

Kindly provide the solution for my requierment. I am struggling with this issue from the last
1 and half month.
Sreekanth Reddy8y ago
This would work as per your expected result :

https://www.c-sharpcorner.com/UploadFile/hrojasara/export-datagridview-to-excel-in-C-Sharp/