basic data access

[Bryan]

Ok, I am trying to just do basic data access with ado.net. I remember with ADO it was quite simple

 

if you wanted to go to the next record in a record set you would use rs.movenext

 

if you want to set a text box's text property to a value in a record you would use textbox.text=rs.fields("Field1).value.tostring

 

it was a lot simpler.

 

Can someone point me to a resource that might have a basic tutorial for data access? something as simple as viewing the data would be nice.

 

thanks,

bryan

[Tamer_Ahmed]

hi Bryan

well data acess in Ado.net is so easy well for me for example if u want move to next record

Me.BindingContext(the name of the dataset, "Table name").position + = 1

well i didn't work with last ado alot but i think if u r in last record

and wanted to move to next record this will throw exception so u must handle it but in Ado.net if u wanted to move to next record and there wasn't any record the application r not gone throw exception

in Ado.net if you want to set a text box's text property to a value in a record you would use databinding u write the code like this

Textbox.DataBindings.Add("Text", Dataset name, "Tablename.column name")

well hope i was useful if u want anything about ado.net ask

[quwiltw]

Your question touches on two different things: navigating a dataset and data binding. You should be able to find a nice tutorial on both from this site. The navigating a dataset part will be under "Common Tasks Quickstart" then Data and ADO.Net. The databinding depends on whether you're talking Windows or Web forms but you should find it with no problem.

 

It appears I forgot to add in the link:confused:

http://samples.gotdotnet.com/quickstart/

Edited February 3, 2004 by quwiltw