I am running SQL 2000 sp3a and VS .net 2003 I simply want to connect to my sql server and retrieve the data from a recordset. here is my code: Someone please help... :)

Imports System
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls
Imports System.Data
Imports System.Data.SqlClient

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim myDataReader As System.Data.SqlClient.SqlDataReader
        Dim myConnection As System.Data.SqlClient.SqlConnection
        Dim myCommand As System.Data.SqlClient.SqlCommand
        Dim strSQL As String

        myConnection = New SqlConnection("server=216.254.122.15; uid=sa; pwd=*****; database=filmgigs_db;")
        myCommand = New SqlCommand(strSQL, myConnection)

        strSQL = "SELECT * FROM genre where genreid=1"

        myConnection.Open()
        myDataReader = myCommand.ExecuteReader()
        TextBox1.Text = myDataReader.Item("genretype")

End Sub

HERE IS THE ERROR I GET

Invalid attempt to read when no data is present.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present.

Source Error:

Line 49: myConnection.Open()
Line 50: myDataReader = myCommand.ExecuteReader()
Line 51: TextBox1.Text = myDataReader.Item("genretype")
Line 52:
Line 53: End Sub

Hy rperreta,

Try doing this :

1) I don't think that u need to declare reader,connection,
   command etc.. objects like this
   "Dim myDataReader As System.Data.SqlClient.SqlDataReader"
    since u've already imported the necessary files.
   they can b replaced by..
   "dim myDataReader as SqlDataReader" n wen u use them u can
    assign them memory by giving "new" like u've done in:
    "myCommand = New SqlCommand(strSQL, myConnection)"

2) reorder ur statements:

  - myConnection = New SqlConnection("server=216.254.122.15; uid=sa; pwd=*****; database=filmgigs_db;")
  - myConnection.Open()
  - strSQL = "SELECT * FROM genre where genreid=1"
  - myCommand = New SqlCommand(strSQL, myConnection)
  - myDataReader = myCommand.ExecuteReader()
  - TextBox1.Text = myDataReader.Item("genretype")

 Hope this helps.. :)

Ciao..



**************************************************
It bcums FATAL wen my brain puts my eyes on Call-Waiting ! >|B-)

hmm... No dice... Still not working.. I get there is no data to read error. My SQL table is correct my statement is correct and there is data in the table. can someone post a simple way to read data from a table in sql 2000 sp3a.

thanks
rich