C# SQL Select - source text file

Question

1.00/5 (1 vote)

See more:

Hi,

I need help abut getting rows from database based on lines in text file. I have text file in which I keep records in form unique key written one key in one line,like this:
AA5GTS
JK2UTD
...

I have the same keys in database, now I have to select all rows from database where keys are in text file. How to do that and how to show data in form, maybe in datagridview!?

Thank's

Posted 16-Jun-13 23:45pm

drazenmd

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)

JeremH · Answer 1 · 2013-06-16T23:55:00

Solution 1

hi,

see This

good luck

jeremy

Posted 16-Jun-13 23:55pm

JeremH

OriginalGriff · Answer 2 · 2013-06-16T23:58:00

First, read your text file, and convert your keys to a comma separated list of items, surrounded by quote characters:

'AA5GTS','JK2UTD',...

Then, create your SQL query as normal, using an IN clause and the string you made earlier:

SQL

SELECT * FROM myTable WHERE key IN ('AA5GTS','JK2UTD')

Execute your query, probably with a DataTable and a DataAdapter but basically with whatever you are used to using.
The data can then be presented as necessary.

Anudeep Jaiswal - MCA · Answer 3 · 2013-06-17T00:42:00

Solution 3

Above Query Is Correct, But If You Want To Match String As Like Then
You Should Split That String As A Table.
And Use Cursor To Implement Further....

Posted 17-Jun-13 0:42am

Anudeep Jaiswal - MCA