[RESOLVED] Error "Fill: SelectCommand.Connection property has not been initialized"

[appleblue]

Hi all.

I am using VS 2008 and SQL Server Management Studio 2008.

As mention on the title above, i got an error : Fill: SelectCommand.Connection property has not been initialized
This error occur after i debug my program and try to delete the Path ID that i want .

My code (.aspx.vb) for this program

 
Protected Sub btnDelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDelete.Click
        Dim i As Integer
        Dim result As DataSet
        Dim hypID As HyperLink
        Dim chkRemove As New CheckBox
        Dim clsPath As New Path()
        Try
            For i = 0 To grdPath.Rows.Count - 1
                chkRemove = DirectCast(grdPath.Rows(i).FindControl("chkRemove"), CheckBox)
                hypID = DirectCast(grdPath.Rows(i).FindControl("hypID"), HyperLink)
                If chkRemove.Checked Then
                    result = clsPath.getComparedPathID(chkRemove.Text)
                End If
            Next i
            lblErrorMessage.Text = "Paths delete successfully."
            BindGrid("%", "%", drpArea.SelectedValue, drpType.SelectedValue)
        Catch ex As Exception
            lblErrorMessage.Text = ex.Message
        End Try
    End Sub

And my .vb code is

Public Function getComparedPathID(ByVal DeletePathID As String) As DataSet
        Dim DHHConn As New DRConnection("", "")
        Dim ds As DataSet
        Try
            ds = DHHConn.RunSPReturnDS("sp_Path_ID", New SqlParameter("@M_C", DeletePathID))
            Return ds
        Catch ex As Exception
            LogManager.WriteLog(ex.Message)
            Throw New Exception(ex.Message)
        Finally
            DHHConn.CloseConnection()
        End Try
    End Function

This are used for open and close the connection.

 Dim DHHConn As New DRConnection("", "")

DRConnection is a class.

Actually, this program works like this :

1. user will choose path ID (retrieve all this data from table TPATH) that they want to delete.
2. before the path ID would be delete, it will compare this path ID from table TTENS of database SDO and table TPATH of database SDO where this two table share the same column namely as M_C.
3. this comparing method was write in Stored Procedure(SP).
4. after done compared, then if path ID that user choose are not in table TTENS so, the path ID can be delete. But if path ID choose by user are in table TTENS, so the path ID cannot be delete.

Code for my Stored Procedure :

CREATE PROCEDURE [dbo].[sp_Path_ID] @M_C varchar(20)
AS
BEGIN
    SELECT M_C FROM [dbo].[TPATH]
    WHERE M_C  NOT IN (SELECT M_RTE_C FROM [dbo].[TTENS])
    and M_C = @M_C
END

and here the line where i'm call my SP

 ds = DHHConn.RunSPReturnDS("sp_Path_ID", New SqlParameter("@M_C", DeletePathID))

Anyone here know how to solve this error? where i should fixed this error?

[NeedSomeAnswers]

What the error is telling you is that a Command object you are using does not have a database connection associated with it and there fore cannot run whatever SQL or Stored Procedure you are asking it to.

However you have not posted the code for that bit so i cant tell you exactly where !!!

We could do with seeing this method - RunSPReturnDS

And knowing what

Dim DHHConn As New DRConnection("", "")

expects as Arguments ???

You passing in to blank arguments, could either one of them expect the connection string ?

[appleblue]

Hi NeedSomeAnswers

Thanks a lot for your help. I'm able to figure out where its the error possibly occur.

Yes! I'm passing in the blank arguments. After realize that, I add up the parameter into it

from this code :

 Dim DHHConn As New DRConnection("", "")

to this code :

Dim DHHConn As NEw DRConnection("", "DDH_CONN")

Now, the error was gone! Thank you

[NeedSomeAnswers]

No problem,

if your happy your question has been answered then please set this thread as Resolved using the Thread tools

[appleblue]

Hi NeedSomeAnswers !

Done marking resolved for this thread

But, one more question. Its there any thread for SQL Server? I want to ask regarding to my SQL problem.

If yes, may I know which thread that I can join to ask about this SQL problem

Thanks for your help!

[NeedSomeAnswers]

Yes well there is a forum,

post your question in the Database Development forum as a new Thread and state you are using SQL Server !!!

[appleblue]

Alrite! Thank you NeedSomeAnswers