How to get sql tables columns in excel sheet after click button in c#

Question

0.00/5 (No votes)

See more:

Hai,

I have a web page.It is having control "Name" and "City" label boxes and "txtName" and "TxtCity" textboxes and "BtnSubmit" button control.If we click button it will open an excel sheet and display all the possible columns for the entered name and city should be displayed from sql server table.Can anybody plz help me

Thanks in advance

Posted 17-Dec-13 19:24pm

Member 10234093

Add a Solution

Comments

Tejas Vaishnav 24-Dec-13 5:03am

If your problem is solved by any of this listed 3 solutions then mark that solutions as your answer so it will help for others, to solve their same issue.
Or if you have solve your problem by your self then add your solution to this question it will also helps other to solve their problem

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)

Tejas Vaishnav · Answer 1 · 2013-12-17T19:35:00

Can you please review this links, it will demon strait how to export data to Excel. for your solution, you need to do this steps.

1) on web page enter value in text boxes
2) as user click on button, fire select query over your sql sever database which filter your records based on your text boxes value and filled out data table or data set as per your resulted data
3) use export to excel functionality from given links (you need to modified code for export to excel as per your requirement)

reference links for export to excel

Export to Excel[^]

Export to Excel from Gridview and Data Table[^]

Maciej Los · Answer 2 · 2013-12-17T20:13:00

I would suggest to use ADO.NET.

Using ADO.NET to work with Excel files[^]
USING ADO AND ADO.NET WITH EXCEL: Resources and Known Issues[^]
Loop through Excel Files and Tables by Using a Foreach Loop Container[^]
How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^] - my favorite!; True, it's not C#, but it's easy to understand because VB.NET language is similar to C#

For further information, please see:
ADO.NET[^]
ADO.NET Code Examples[^]

**Nirav Prabtani** · Answer 3 · 2013-12-17T19:42:00

Solution 2

refer this..:)

how-to-export-sql-data-to-excel-using-microsoft-office-interop[^]

Posted 17-Dec-13 19:42pm

Nirav Prabtani

Updated 17-Dec-13 19:43pm

v2

How to get sql tables columns in excel sheet after click button in c#

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0