Search box to pull data from SQL db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top