Problem in Declaration and using SqlParameter[].ERROR:Use of unassigned local variable 'sqlparam'

Question

I have to Declare a SqlParameter[]. It's size is dynamic based on the dropdownlist selection. I have implemented a method as below

protected void BindGrid()
{
    SqlParameter[] sqlparam;
    string SP = string.Empty;

    if (ddlKPIType.SelectedIndex == 0)//For Overall
    {
        sqlparam = PrepareSqlParams();

    }
    else if (ddlKPIType.SelectedIndex == 1)//For Parameterwise
    {
        sqlparam = PrepareSqlParamsForParameterWise();

    }
    else if (ddlKPIType.SelectedIndex == 2)//For Measurement Criteria wise
    {
        sqlparam = PrepareSqlParamsForMeasurmentCriteriaWise();

    }


    DataSet dsReport = GetReportDataSet(sqlparam, SP);

    if (isDataSetValid(dsReport))
        gridMonthlyReport.DataSource = dsReport.Tables[0];
    gridMonthlyReport.DataBind();

}

But in this code when I pass the sqlparam as a Parameter to GetReportDataSet() it is showing the error"Use of unassigned local variable 'sqlparam'.

The methods :PrepareSqlParams() , PrepareSqlParamsForParameterWise() and PrepareSqlParamsForMeasurmentCriteriaWise() will return SqlParameter[].

Where I am making a mistake? Any one please help me. Thanks in advance.

Are all celles of sqlparam nun null?

Harold Sota
– Harold Sota

2011-07-20 08:39:50 +00:00
Commented Jul 20, 2011 at 8:39 — Harold Sota
– Harold Sota, Commented Jul 20, 2011 at 8:39

Daniel Hilgarth · Accepted Answer · 2011-07-20 08:42:55Z

4

sqlparam is not guaranteed to be assigned, because there is no else clause. If ddlKPIType.SelectedIndex is 3 or greater, sqlparam will not be assigned, because none of the branches of your if-else if clause will be executed.
You can overcome this in several ways:

If you are sure, that it can never be 3 or greater, insert an else clause that throws an ArgumentOutOfRangeException
If you are not sure that it can never be 3 or greater, just initialize sqlparam.

edited Jul 20, 2011 at 8:42

answered Jul 20, 2011 at 8:36

Daniel Hilgarth

175k41 gold badges346 silver badges450 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem in Declaration and using SqlParameter[].ERROR:Use of unassigned local variable 'sqlparam'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related