how to search excel sheet by user ID and display matched data in grid view.

Question

1.00/5 (1 vote)

See more:

Hi,I have an excel sheet and it contains some employ details like their name address DOB and ID no.I am finding problem in searching excel data by employee ID no.its not displaying data related to entered ID no in data grid view.Please help me out how can i do that.How to search by employee ID and how to display it in Data Grid View.

Posted 26-Jul-15 7:48am

shamshad.s

Add a Solution

Comments

Maciej Los 27-Jul-15 4:20am

What have you tried? Where are you stuck?

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)

Wendelius · Answer 1 · 2015-07-26T07:57:00

Solution 1

If I understand your question correctly, you try to read the Excel file from C# to get som data out of it. IN that case, have a look at:
- Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^]
- Reading and Writing Excel using OLEDB[^]

Posted 26-Jul-15 7:57am

Wendelius