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]

"Newbie!" <s_************@yahoo.co.uk> schrieb

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"?
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[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]]

* "Newbie!" <s_************@yahoo.co.uk> scripsit:

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?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[CJ Taylor]

Me(Me.tablePasswordList.UserNameColumn)

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

"Newbie!" <s_************@yahoo.co.uk> wrote in message
news:u9********************@karoo.co.uk...

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

[CJ Taylor]

Did you get my previous post about the Me(ME) thing?
"Armin Zingler" <az*******@freenet.de> wrote in message
news:Oa**************@TK2MSFTNGP10.phx.gbl...

"Newbie!" <s_************@yahoo.co.uk> schrieb

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"?
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Armin Zingler]

"CJ Taylor" <no****@blowgoats.com> schrieb

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

Yes. Why?

(get or get?)
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[CJ Taylor]

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

just a little honesty =)(

"Armin Zingler" <az*******@freenet.de> wrote in message
news:uv**************@tk2msftngp13.phx.gbl...

"CJ Taylor" <no****@blowgoats.com> schrieb

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

Yes. Why?

(get or get?)
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[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

"CJ Taylor" <no****@blowgoats.com> wrote in message
news:vt************@corp.supernews.com...

Me(Me.tablePasswordList.UserNameColumn)

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

"Newbie!" <s_************@yahoo.co.uk> wrote in message
news:u9********************@karoo.co.uk...

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

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.550 / Virus Database: 342 - Release Date: 09/12/2003

[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"

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

[Herfried K. Wagner [MVP]]

"Pete Skaarup" <ms******@rcn-dot-com.no-spam.invalid> schrieb:

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

?!?

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

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>