Hi I complityly new in .NET and have a lot of problems
I would like to do basic task:
1) Open connection
2) fill data set
3) find out if dataset is bof or eof but in ado net there is no bof and eof property haw can i do this task
Here is my code

Dim CN As New SqlConnection
Dim DA As New SqlDataAdapter
Dim DS As New DataSet
Dim cmd As New SqlClient.SqlCommand


Dim strSQL As String
dim cnString as String

cnString = "someString"
strSQL = "SELECT SUBJEKT,GESLO from CONTACTS " _
 & " WHERE USERID = '" & UserName & "'"

CN.ConnectionString = cnString
cmd.CommandText = strSQL
cmd.CommandType = CommandType.Text
cmd.Connection = CN

CN.Open()


DA.SelectCommand = cmd
DA.SelectCommand.ExecuteNonQuery()

        Try

            DA.Fill(DS)


        Catch ex As Exception

        End Try

Here i want to ask for dataset if it is bof or eof

Thanks
Aleksandar

Hi Aleksandar,

A DataSet does not have an EOF or BOF property, like an ADO Recordset does. You can, however, find out whether one of the tables in the DataSet contains 1 or more rows: This code checks whether the first table in the DataSet contains at least a row.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.