Looping record from database

khempire · January 9th, 2008, 01:53 AM

I am a new runner database project which using C# and MS. Access.
How can I retrive data from db if I use one textbox for a criteria?

For example(VB.6)

strSql = "Select * From tbl_db Where dbUser = '" & txtUser.Text & "'"

If rst.recordset > 0 Then
MessageBox ("Testing")
End if

Regards,

Just another step straight into coding.

samjudson · January 9th, 2008, 05:34 AM

You will want to do some reading up on ADO.Net then. Things you will want to look for are OleDbConnection (practically the same as an old VB Ado.Connection), OleDbCommand (also practically the same as Ado.Command) and OleDbDataReader (similar to a record only forward ADO.Recordset).

/- Sam Judson : Wrox Technical Editor -/

khempire · January 9th, 2008, 09:01 PM

Can you give the example?
It seems pretty difficult for a new runner.
Thanks.

Just another step straight into coding.

samjudson · January 10th, 2008, 05:11 AM

I don't plan on trying to reproduce things that are already available elsewhere on the internet. Try a quick search for "ADO.Net tutorial" - I found this one here: http://www.csharp-station.com/Tutori.../Lesson01.aspx

/- Sam Judson : Wrox Technical Editor -/

khempire · January 10th, 2008, 10:37 PM

Thanks.
It is useful website that I am looking for.

Just another step straight into coding.