By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,246 Members | 1,755 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,246 IT Pros & Developers. It's quick & easy.

Example Search Form Required

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a


--
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

P: n/a
> > 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

P: n/a
"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.