Hello all,

I've created a datagrid with four columns which included the hyperlink column for viewing more details about the particular data. Click the hyperlink and it will show the details on the different or seperate page based on the querystring. The problem is, when I click the link, it won't load the particular data on the next page. It only load the header instead of the whole row of the particular data.

This is the code for the view details page.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim myConnection As MySqlConnection

Dim myCommand As MySqlDataAdapter

Dim strSQL As String

Dim mydataset As DataSet

strSQL = "SELECT speciesid, scientificname,commonname FROM species WHERE speciesid = @speciesid"

myConnection = New MySqlConnection("server=localhost; uid=root; password=kucemari; database=plantsnherbs")

myCommand = New MySqlDataAdapter(strSQL, myConnection)

myCommand.SelectCommand.Parameters.Add(New MySqlParameter("@speciesid", MySqlDbType.Int32))

myCommand.SelectCommand.Parameters("@speciesid").V alue = Request.QueryString("id")

mydataset = New DataSet

myCommand.Fill(mydataset, "species")

Dgspeciesview.DataSource = mydataset.Tables("species").DefaultView

Dgspeciesview.DataBind()

End Sub

Hope you guys can help this out. It doesn't says any error occured but this is not what I wanted. I'm using MySQL for the database and my asp.net is version 1.1.

Thanks

Are you sure you are passing the ID? Also, make sure there is actually data for that ID.

Jim

yes I'm sure. Because when I tested by putting the Response.Write (Request.QueryString("id")), the id is passed in the next page. Is it something wrong with the code?

test your query, make sure you have rows in the table based on that id

I've tested the query and everything is ok but still it won't appear in the next page details. what should i do? is it something wrong with the code or something else?

Try:
myCommand.SelectCommand.Parameters("@speciesid").V alue = CInt(Request.QueryString("id"))

I have tried the code. Nothing happen. Still the same. Nothing appear in the datagrid.
Thanks for your quick reply jbenson001

Why do you have these?

Dim myConnection As MySqlConnection

Dim myCommand As MySqlDataAdapter

then you just reacreate the objects later on? remove them

Then:

    myConnection = New sqlconnection("server=localhost; uid=root; password=kucemari; database=plantsnherbs")

        myCommand = New sqldataadapter(strSQL, myConnection)

also, trace through your code

Jim

When I removed the Dim myconnection and dim mycommand, replacing them with the codes that you gave, it keeps underlined the myCommand = New MySqlDataAdapter. Saying that overload resolution failed.

Look up the syntax in vs help..