469,643 Members | 1,634 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

Example Search Form Required

Hi,

I have a table named "Person" in a MSDE (2000) database, and am building a
search form comprising of search fields on the top section (forename,
surname, telephonenumber, etc) which all correspond to columns to search in
the database.

I'm relatively new to ADO.net and haven't the foggiest about where to start,
and need a good example to take apart and learn relatively quickly.

Does anyone have code or know of a good place to look? I've checked out MSDN
and the free vb code sites, but no-one has a flexible search form that I
could reuse.

Any ideas?

Kind Regards,
--

Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><
Nov 20 '05 #1
3 1995


--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/...ity/newsgroups
"Liddle Feesh" <l@f.com> wrote in message
news:he*******************@stones.force9.net...
Hi,

I have a table named "Person" in a MSDE (2000) database, and am building a
search form comprising of search fields on the top section (forename,
surname, telephonenumber, etc) which all correspond to columns to search in the database. The main objects you'll be working with are the DataTable and the DataView.
You can also use a DataReader and/or the Command Ojbect's Executexxx
methods. (Note that for the Command Object, you have to have a live
connection to the db so it's often not the most practical approach). The
DataTable has a .Select method, there's also a .Find, .FindRows methods and
a RowFilter property of the DataView that will help you.
I'm relatively new to ADO.net and haven't the foggiest about where to start, and need a good example to take apart and learn relatively quickly.

Does anyone have code or know of a good place to look? I've checked out MSDN and the free vb code sites, but no-one has a flexible search form that I
could reuse. I don't have a form already built, but check out any of my Efficiently using
Ado.NEt v.XXX articles, I discuss filtering and sorting in depth
http://www.knowdotnet.com/williamryan.html. I have a few other articles
(just search for DataView or DataTable in the search link).

If you get stuck, let me know. ALso, if you want to learn ADO.NET, David
Sceppa's ADO.NET core reference is an invaluable resource and he includes a
pretty cool utility with it for querying a DB and filtering,sorting. Bill
Vaughn's Ado & ADo.net book is another must have.

HTH,

Bill
Any ideas?

Kind Regards,
--

Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><

Nov 20 '05 #2
> > Does anyone have code or know of a good place to look? I've checked out
MSDN
and the free vb code sites, but no-one has a flexible search form that I
could reuse. I don't have a form already built, but check out any of my Efficiently

using Ado.NEt v.XXX articles, I discuss filtering and sorting in depth
http://www.knowdotnet.com/williamryan.html. I have a few other articles
(just search for DataView or DataTable in the search link).

If you get stuck, let me know. ALso, if you want to learn ADO.NET, David
Sceppa's ADO.NET core reference is an invaluable resource and he includes a pretty cool utility with it for querying a DB and filtering,sorting. Bill
Vaughn's Ado & ADo.net book is another must have.

HTH,


Hi Bill,

Thanks for that. I'll check out your website in depth, and thankyou also for
the book recommendation. I'll look into getting that today!
--

Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><
Nov 20 '05 #3
"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message

Hi William,

Thanks again for your post. I've not yet found the solution to my problem,
despite playing around with datagrids (they are really cool, straight out of
the box though!).

I've purchased both of the books you have recommended. The Sceppa one looks
perfect :) (it has many good reviews) and will help me with my pursuit of
MCAD.net :P )

Thanks again.
--

Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><
Nov 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Arun Nair | last post: by
6 posts views Thread by San | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.