Problem with Data Access

[Newbie!]

Hi,

When i try and build my project which includes a Access Database i get a
error saying:

`Convert` is not a member of `String`

on the following code:

Public Sub SetUserNameNull()
Me(Me.tablePasswordList.UserNameColumn) = System.Convert.DBNull
End Sub
Anybody got any Ideass?

Thanks for any Help in Advance

Ta
Si

 

[Armin Zingler]

When i try and build my project which includes a Access Database i
get a error saying:

`Convert` is not a member of `String`

on the following code:

Public Sub SetUserNameNull()
Me(Me.tablePasswordList.UserNameColumn) =
System.Convert.DBNull
End Sub
Anybody got any Ideass?

You declared a variable "System As String"?

 

[Cor]

Hi Newbie

I did not know what the code means, but i think you would do something as

Me(Me.tablePasswordList.UserNameColumn) = system.DBNull.value

I hope this helps?

And as advice, put "Option Strict On" in top of your program, you will see a
lot of errors in desing time.

Cor

 

[Herfried K. Wagner [MVP]]

When i try and build my project which includes a Access Database i get a
error saying:

`Convert` is not a member of `String`

on the following code:

Public Sub SetUserNameNull()
Me(Me.tablePasswordList.UserNameColumn) = System.Convert.DBNull
End Sub
Anybody got any Ideass?

Where do you use this code? What exactly do you want to do?

 

[CJ Taylor]

Me(Me.tablePasswordList.UserNameColumn)

Did you write this line? Or was it generated... I would take that first Me
out...

 

[CJ Taylor]

Did you get my previous post about the Me(ME) thing?

 

[Armin Zingler]

Did you get my previous post about the Me(ME) thing?

Yes. Why?

(get or get?)

 

[CJ Taylor]

because I didn't see my post.. because my news server sucks.

just a little honesty =)(

 

[Newbie!]

Hi

This is the code that was generated when i built my Dataset.

My Table had about 20 Feilds in it and it create 20 instances of:

Public Sub SetUserNameNull()
Me(Me.tablePasswordList.UserNameColumn) = System.Convert.DBNull
End Sub

For each feild withing my code.

All cam up say 'Convert' is not a member of 'string'

Ta
Si

 

[Pete Skaarup]

This can be caused by using field names that are reserved words.

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

 

[Cor Ligthert]

Pete,

Can you explain this a little bit more?

"Pete Skaarup"

 

[Herfried K. Wagner [MVP]]

This can be caused by using field names that are reserved words.

?!?

'String' doesn't have a 'Convert' method/....