[tendaimare]

i have corrected my conn string i am now using sql connection but now when i run the code it gives me he error Object reference not set to an instance of an object.

'I put this code in the load event
ListBox1.Items.Add(CType(GetTables().ToString, String))

Public Shared Function GetTables() As String()
        Dim kon As SqlConnection
        Dim kom As New SqlCommand
        Dim i As Integer
        Dim str() As String
        kon = New SqlConnection("server=sql...,1444;uid=....;pwd=.....;database=.....")
        kon.Open()
        kom.Connection = kon
        Dim dTable As DataTable
        Try
            dTable = kon.GetSchema(SchemaType.Mapped, New Object() {Nothing, Nothing, Nothing, "TABLE"})
            For i = 0 To dTable.Rows.Count - 1
                ReDim Preserve str(i)
                str(i) = dTable.Rows(i).Item(2).ToString
            Next
            Return str
        Catch ex As Exception
            Return Nothing
        End Try

    End Function

[_HAWK_]

Public Shared Function GetTables() As String()
        Dim kon As SqlConnection
        Dim kom As New SqlCommand
        Dim i As Integer
        Dim str() As String
        kon = New SqlConnection("server=sql...,1444;uid=....;pwd=.....;database=.....")
        kon.Open()
        kom.Connection = kon
        Dim dTable As New DataTable '<<< here
        Try
            dTable = kon.GetSchema(SchemaType.Mapped, New Object() {Nothing, Nothing, Nothing, "TABLE"})
            For i = 0 To dTable.Rows.Count - 1
                ReDim Preserve str(i)
                str(i) = dTable.Rows(i).Item(2).ToString
            Next
            Return str
        Catch ex As Exception
            Return Nothing
        End Try

    End Function

[tendaimare]

okay, can someone elaborate on what is wrong with that part where in line 9 where hawkvalley pointed and said here bcoz i do not know and/or see what is wrong with that part

[Kilorn]

You need to use the 'new' keyword in order to create an instance of object type DataTable.

Dim dTable as new DataTable

This post has been edited by Kilorn: 14 January 2011 - 08:15 AM

[tendaimare]

I've done that but i still get the same error here: object refference not set to instance of an object

ListBox1.Items.Add(CType(GetTables().ToString, String))

[Kilorn]

Show us how ListBox1 is declared. Have you actually created a variable with the name ListBox1 and created a new instance of it?

[_HAWK_]

Don't call the toString method of your function. Your function returns a String array.

ListBox1.Items.AddRange(GetTables.ToArray)

[tinase]

Using the New Keyword is the first step as Kilorn said.
But I would be more helpfull, if you tell me where the code breaks(where the code starts debugging). Is it on line 9 or other lines

[_HAWK_]

Personally I would use a List(Of String) not an array.