Search box to pull data from SQL db

20 Oct 2006 9:01 PM

JerHiggs

I apologize... I am completely new to SQL and to ADO so this may seen very
easy to some but I am at a complete loss here.

I have been searching the entire day so far for some sort of lead on how to
do this.

I have a "hardware inventory" database that has columns like first and last
name, Model, HDD size, RAM, and asset number. I want to create a search
"box" where I can put in someones last name or the asset number and it will
query the db and bring back the rest of the corresponding data.

I am by far a COMPLETE NEWBIE but I am a very quick learner and am usually
very good at finding what I need or at least close to it on the internet. I
think I just don't know the correct terminology which is limiting my search.

So again... I am looking for a way to create a web page that can query my
database according to the search phrase that I input and have it return the
results.

Thanks!

21 Oct 2006 4:30 AM

Cor Ligthert [MVP]

Jer,

The name is ADO.Net, Ado is a term for a complete other methodology,

You have to use with that SQL transaction code what is a kind of querry
code, wherin are phrases as OR, Where and Like.
http://msdn2.microsoft.com/en-us/library/ms166026.aspx

In AdoNet are things like Datasets to save the data in memory and
DataAdapters to get that.
To do that you have first to make connection to your database (server)

Have for those a search on msdn yourself.

I hope this gives an idea,

Cor

Show quote

"JerHiggs" <JerHi***@discussions.microsoft.com> schreef in bericht
news:7DA4EC93-553F-4A18-9846-D7F3F7D4BDBC@microsoft.com...
>I apologize... I am completely new to SQL and to ADO so this may seen very
> easy to some but I am at a complete loss here.
>
> I have been searching the entire day so far for some sort of lead on how
> to
> do this.
>
> I have a "hardware inventory" database that has columns like first and
> last
> name, Model, HDD size, RAM, and asset number. I want to create a search
> "box" where I can put in someones last name or the asset number and it
> will
> query the db and bring back the rest of the corresponding data.
>
> I am by far a COMPLETE NEWBIE but I am a very quick learner and am usually
> very good at finding what I need or at least close to it on the internet.
> I
> think I just don't know the correct terminology which is limiting my
> search.
>
> So again... I am looking for a way to create a web page that can query my
> database according to the search phrase that I input and have it return
> the
> results.
>
> Thanks!