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

Question

0.00/5 (No votes)

See more:

VS2008

As mention on the title above, i got an error

Fill: SelectCommand.Connection property has not been initialized

Anyone here have any idea or suggestion on how to solve this error?

My code (.aspx.vb) for this program

VB

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

VB

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

Anyone here who's willing to help me? :'(

Posted 25-May-15 18:07pm

apple blue

Add a Solution

Comments

Sascha Lefèvre 26-May-15 0:27am

You're using some custom database-access code there. DRConnection isn't a class that I've heard of yet. I don't think anyone will be able to help you unless you can either post the source of that class or a link to where you got it from.

The best hint I can give you: Take a look at the parameters for the constructor of DRConnection for which you provided just empty strings. You might need to provide "something more useful" there. And: If you have some other code in your program that already accesses the database successfully, compare it to this one.

apple blue 27-May-15 0:34am

See my posting below :)

ArunRajendra 26-May-15 0:31am

Its clear that the connection is not intialiazed. You need to put the code where the connection is being established.

apple blue 27-May-15 0:35am

See my posting below :)

ArunRajendra 27-May-15 2:17am

Do you have where this is working. If it is your code then you should be able to put the break point and check the connection object is propertly intialized.

apple blue 27-May-15 20:49pm

Hi Sascha Lefèvre and ArunRajendra Smile ! :)

This code are use for manage my database transactions.

Hide Copy Code
Dim DHHConn As New DRConnection("", "")

Actually, i has another class namely as DRConnection that stored all the function for this DRConnection to open and close the connection. I don't has any idea where to fixed this error.

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).

Hide Copy Code
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

Hide Copy Code

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

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.

example :

[IMG]http://i59.tinypic.com/10ct029.png[/IMG]

My problem now :

1. i'm not be able to compare this data
2. i get this error Fill: SelectCommand.Connection property has not been initialized.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

apple blue · Accepted Answer · 2015-05-27T16:18:00

Solution 2

Hi Sascha Lefèvre and ArunRajendra :)

I'm success to solved this error ! I added the parameter on this line :

VB

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

Anyway, thanks for help :)

Posted 27-May-15 16:18pm

apple blue