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

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

C# SQL Select - source text file

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

C# SQL Select - source text file

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us