Member Avatar for moshe12007

hi i use database access(2003) and i dont know how to search in my database
i think about something like this :

...
a = Tclients.Rows[j][i].ToString()
if(a == b)
//ok
...

but i dont know if this the true way because that very slow when i check 10000 users.
someone know how?
thanks.

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by mcriscolo
Member Avatar for mcriscolo

You really want to try to develop a query for your data. Searching serially through a database defeats the purpose of using a database in the first place.

See this post:

http://vbcity.com/forums/t/112704.aspx

to see how to set up C# code to query an Access database. You can either use a "SELECT" statement in your code, or you can set up an Access Query and call that from the C# code.

Good luck!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.