Searching from SQL 2008 database with asp.net4

Question

0.00/5 (No votes)

See more:

, +

Dear friends, my database "ComputerData" has a table "ItemSet" with the following fields:
int ID, nvarchar(100) PCSLNo, nvarchar(100) MonitorSLNO, nvarchar(30) Location,....

What I have done: The clients need to enter the entire PCSLNo or MonitorSLNO in text boxes and submit to retrieve information from the table in aspx page through ListView pertaining to that field.

What I need to do: The clients will enter a few strings of PCSLNo or MonitorSLNo in text boxes. On submit, they will get whole information from the table pertaining to that field in aspx page (thrgough ListView or other suitable data control)

Further I would like to mention that I am using EF (asp.net4 with sql2008)foe database query in developing my project and I am writing all the codes in aspx.cs(code behind)pages.

Hope reply/suggestion from friends with excellent background will sort out my problem very soon. Waiting for solution from all...Thanks a lot.

Posted 14-Mar-12 5:01am

Brajabas

Updated 14-Mar-12 5:51am

v3

Add a Solution

Comments

OriginalGriff 14-Mar-12 11:05am

And your problem is?
What have you tried?

Brajabas 14-Mar-12 11:38am

What I have done: The clients need to enter the entire PCSLNo or MonitorSLNO in text boxes and submit to retrieve information from the table in aspx page through ListView pertaining to that field.

What I need to do: The clients will enter a few strings of PCSLNo or MonitorSLNo in text boxes. On submit, they will get whole information from the table pertaining to that field in aspx page (thrgough ListView or other suitable data control)

Herman<T>.Instance 14-Mar-12 11:06am

what is your question?

Brajabas 14-Mar-12 11:31am

What I Have done: if he clients enter entire PCSLNo or MonitorSLNO in the text boxes and submit, they can retrieve other data pertaining to that field in aspx page (in ListView).
What I want to do: the clients will enter few strings pertaining to a field which will retrieve all the related data in on aspx page (through List view or other suitable data control).

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)

shreekar · Answer 1 · 2012-03-14T06:01:00

Solution 1

My guess would be that your problem is of wildcard search. Look into the like operator to be used in SQL queries or EF queries.

Posted 14-Mar-12 6:01am

shreekar