.Net recordset equivalent and dealing with DBNull values

FelixMosses,  Thanks for replying so quickly

I tried using the recordset before, because I had it working using traditional ASP,  but could not get it to work in ASP.NET because I was using a SQLConnection Object and I could not get the recordset to work with this.

My code was as follows:

 Dim mySqlConn As New SqlConnection _
                                    ("Data Source=myServer;" _
                                    & "Initial Catalog=mytestdb;" _
                                    & "User ID=sa;" _
                                    & "Password=password")
mySqlConn.Open
Dim myQueryString As String = "Select * from " _
                       & "table where client_diwor = " _
                       & varClientRowID & ";"
Dim rsClient
rsClient = Server.CreateObject("ADODB.Recordset")
rsClient.Open = myQueryString,mySqlConn,adOpenDynamic,adLockOptimistic

It may be a problem with my syntax!

I will try your other suggestion.  I look forward to you reply on the recordset question.

Fraser

Instead of a dataset and then pushing the dataset onto a data table for access.  It sounds like you want to look through a record to take a look at them individually.  Try to take a look at the "SqlDataReader" class.  A sqlDataReader functions similiarly to a recordset with its forward-only stream reading.

Here is a small copy and paste sample from MSDN QuickStart library.

================================

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.XML
Imports Microsoft.VisualBasic

namespace HowTo.Samples.ADONET

public class employees
  public shared sub Main()
    Dim myemployees as employees
    myemployees = new employees()
    myemployees.Run()
  end sub

  public sub Run()

    Dim mySqlConnection as SqlConnection = new SqlConnection("server=(local)\NetSDK;Trusted_Connection=yes;database=northwind")
    mySqlConnection.Open()
   
    Dim mySqlCommand as SqlCommand = new SqlCommand("select * from employees order by EmployeeID", mySqlConnection)

    try
            Dim myReader as SqlDataReader = mySqlCommand.ExecuteReader()

            Dim record as Integer = 0
      Dim photoColumn as Integer = myReader.GetOrdinal("Photo")
      Dim column as Integer
     
      While myReader.Read()
                record = record + 1
                Console.Write(Chr(10) + "************************ Employee number " + record.ToString() + " ************************" + Chr(10))
               
        ' Display each column and value, skipping the "Photo" column
                For column = 0 to myReader.FieldCount-1
                    If column <> photoColumn Then
                        Console.Write(myReader.GetName(column) + ":" + Chr(9) + myReader.GetValue(column).ToString() + Chr(10))
                    End If
                Next

      End While
    catch e as Exception
      Console.WriteLine(e.ToString())
    end try
  end sub
end class

end namespace
===============================

Morphinex,

Thanks for your suggestion.  What I am trying to do is this:

Read in data from a database and display the information in multiple text boxes.

If these are updated or a new record is added then the database table has to be updated.

I managed to do this in the traditional ASP using ADODB.Recordset and I found the coding for this to be straight forward and succint.

It now seems that with ASP.NET everything seems to be so long winded.

If I use the Data Reader to displaty info then what Do I do about updating it?

Fraser