Newbie With VB.NET & SQL

  • Thread starter Thread starter Dongo!
  • Start date Start date
D

Dongo!

Hi Group,

Hope somebody dosn`t Mind helping a newbie (To SQL & VB.net) out with a
little problem?

I`ve created a SQL database and a Table within the Datatabse called
Passwords

I`ve used the SQLdataadapter on my VB Project. When I try to create a
Dataset it errors. When I try and run My project i get the following error:-

D:\ITMDB.net\Passwords.vb(398): 'Convert' is not a member of 'String'.

The code is as follows:-

Public Sub SetSystemNull()
Me(Me.tablePasswords.SystemColumn) = System.Convert.DBNull
End Sub

Ta
Regards
Si
 
VB.Net requires that you have a unique ID field in your
SQL Server table, and that it be assigned as the primary
key. This makes it possible for the data adapter to
traverse the database easily.
I didn't set up your code and try to run it to see why you
are getting the error, but anytime you get a message like
that where one entity is not a member of another entity or
class, then something is amiss in your code.
If you use Visual Studio .NET to write your code, it will
show you all the available members/properties/methods for
a given member/class.

S...
 
Back
Top