且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

错误“连接属性尚未初始化”

更新时间:2022-10-25 22:53:39

this._connection 必须是未初始化的。

您将需要发布更多有关code对我们是肯定的。

I am getting error ExecuteReader: Connection property has not been initialized. below is the code i am using.

SqlDataReader oReader = new SqlDataReader();
string sSQL = @"
    WITH TAB_CTE AS (
    SELECT fbominum, fbompart, fparinum, flevel, fsono
    FROM sodbom
    WHERE  fbompart= @fbompart and fsono = @fsono
    UNION ALL
    SELECT e.fbominum, e.fbompart, e.fparinum,   e.flevel, e.fsono
    FROM sodbom e 
    INNER JOIN TAB_CTE ecte ON ecte.fbominum = e.fparinum  where e.fsono = @fsono
    )
    SELECT *
    FROM TAB_CTE where fbompart <> @fbompart 
    ";
SqlCommand oCommand = new SqlCommand(sSQL, this._connection);
oCommand.CommandType = System.Data.CommandType.Text;
oCommand.Parameters.Add("@fbompart", ItemSODBOM.fbompart);
oCommand.Parameters.Add("@fsono", ItemSODBOM.SONO);
oReader = oCommand.ExecuteReader();//Here I am getting error

this._connection must be un-initialized.

You would need to post more of the relevant code for us to be sure.