How to avoid duplicate entries of a record when Exporting SQL server data to an Excel in C#?

Question

I have requirement to export SQL Script data to an excel using C#.Net. Currently I face issue in avoiding duplicat values for columns, when a record has multiple values for a column it should look like as in the bellow, the entire record should not repeated for each values of the column.

should I handle it in application level or in Sql script. please advice me.

Currently I get data set and bind it to a grid view and then do the export to excel function.

Excel format

for example Sql Data could be

 select B.BID, B.BName, M.Year from tbl_B B inner join tbl_Master M ON B.BID = fm.BIDFK where B.BName = 'B9' Group By B.BID, B.BName, M.Year

And the Result

enter image description here

Do I need to go with nested grid view?

vml19
– vml19

2011-09-23 02:30:33 +00:00
Commented Sep 23, 2011 at 2:30 — vml19
– vml19, Commented Sep 23, 2011 at 2:30

vml19 · Accepted Answer · 2011-09-25 14:31:28Z

I have cleared out this issue on C# side, I use nested grid-view to bind multiple valued columns for a record, when exporting to excel clear controls inside the parent grid-view to export data from all grid-view.

Gregory Nozik · Accepted Answer · 2011-09-22 11:17:24Z

0

I think it need to be done in SQL script. It's not complicated logic to apply .

answered Sep 22, 2011 at 11:17

Gregory Nozik

3,3823 gold badges35 silver badges48 bronze badges

4 Comments

vml19 Over a year ago

Can you please elaborate a bit on how the SQL Query can be constructed?

Gregory Nozik Over a year ago

I think the column should be splited by some delimeter. It's obvious need to be done in store procedure. SP's are compiled and run faster

vml19 Over a year ago

Yes I do SP. you meant to say that a record should be in a single row and multiple valued columns as string of values spited by delimiter, if so how do we export the data to excel as in the figure?

Gregory Nozik Over a year ago

Please add to the question data that you need to export

Larry Smithmier · Accepted Answer · 2011-09-22 11:21:11Z

I would seriously look at using the Report Viewer control and a local report rather than trying to build the Excel sheet by hand. Check out GotReportViewer.com and the examples on the right cover exporting to Excel, and using the control from a console application.

Collectives™ on Stack Overflow

How to avoid duplicate entries of a record when Exporting SQL server data to an Excel in C#?

3 Answers 3

Comments

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Related