Navigating A Datatable

[girldemsuga]

I have been programming in Visual Basic 6 for some time now i decided to learn Visual Basic.Net 2005.
I found a basic tutorial at the like below but i'm trying to find out how to navigate the datatable.
VB.Net 2005 Tutorial

[Mixmasterxp]

I got lots of problems with working with databases/ado (mircosoft access) and vb.net. such as saving text from a textbox to a field in the database.....That made me lost alot of marks on my programming SBA....

[girldemsuga]

I got lots of problems with working with databases/ado (mircosoft access) and vb.net. such as saving text from a textbox to a field in the database.....That made me lost alot of marks on my programming SBA....

I found some ways to avoid so of the little problems in VB.Net in reguard to a textbox --> Database but i still have a problem where if i have the following string in my textbox "The Boy's Book", i cant save that to the database.

I Know how to navigate a dataset but not a datatable.
Needing help here.

[Artificial_Intelligence]

I found some ways to avoid so of the little problems in VB.Net in reguard to a textbox --> Database but i still have a problem where if i have the following string in my textbox "The Boy's Book", i cant save that to the database.

I Know how to navigate a dataset but not a datatable.
Needing help here.

You may have to find away of QUOTEING the sting, the Apostrophe character has a meaning to MSSQL sql server. Nrmally text in a mssql server is 'A ME MAN'
so when it sees "A ME'S MAN" it would break.

Possible solutions
a: " A ME''S MAN"
B: 'A ME''S MAN'
check this link = http://www.freevbcode.com/ShowCode.Asp?ID=60

let me know if that helps

[girldemsuga]

Artificial_Intelligence, thanx for the help.
The function on that site worked out beautifully.