dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: [RESOLVED] Error : Must declare the scalar variable

  1. #1
    Join Date
    Dec 2011
    Posts
    14

    [RESOLVED] Error : Must declare the scalar variable

    Right im a junior programmer and im trying to build a system which shows data from a database. I have about 18 check boxes will all different types of data. Depending on what is ticked will depend on what is displayed in the data grid. Im having to use sql parameters in my SQL statement. Below is the code im using in my function which is called in each of the checkboxes checked changed methods aswell. The current error is Must Declare the scalar variable Filter0 Below is the function -
    strQualified is an array of strings and paramArray is an array of sqlParameter
    much help is needed :-)
    Code:
    private void chkBoxFilter()
            {
               
                if (chkBlood.Checked)
                    strQualified[0] = "BloodTransfusion1";
                else
                    strQualified[0] = "";
                if (chBlood2.Checked)
                    strQualified[1] = "BloodTransfusion2";
                else
                    strQualified[1] = "";
                if (chkDementia.Checked)
                    strQualified[2] = "Dementia";
                else
                    strQualified[2] = "";
                if (chkEpidural.Checked)
                    strQualified[3] = "Epidural";
                else
                    strQualified[3] = "";
                if (chkEqualityDiversity.Checked)
                    strQualified[4] = "EqualityDiversity";
                else
                    strQualified[4] = "";
                if (chkInfectionControl.Checked)
                    strQualified[5] = "InfectionControl";
                else
                    strQualified[5] = "";
                if (chkInformationGovernance.Checked)
                    strQualified[6] = "InformationGovern";
                else
                    strQualified[6] = "";
                if (chkInsulin.Checked)
                    strQualified[7] = "Insulin";
                else
                    strQualified[7] = "";
                if (chkIV.Checked)
                    strQualified[8] = "IV";
                else
                    strQualified[8] = "";
                if (chkMandatoryA.Checked)
                    strQualified[9] = "MandatoryA";
                else
                    strQualified[9] = "";
                if (chkMandatoryB.Checked)
                    strQualified[10] = "MandatoryB";
                else
                    strQualified[10] = "";
                if (chkMandatoryC.Checked)
                    strQualified[11] = "MandatoryC";
                else
                    strQualified[11] = "";
                if (chkManualHandling.Checked)
                    strQualified[12] = "ManualHandling";
                else
                    strQualified[12] = "";
                if (chkMedicine.Checked)
                    strQualified[13] = "MedicineManagement";
                else
                    strQualified[13] = "";
                if (chkMentorsUpdate.Checked)
                    strQualified[14] = "MentorsUpdate";
                else
                    strQualified[14] = "";
                if (chkPDR.Checked)
                    strQualified[15] = "PDR";
                else
                    strQualified[15] = "";
                if (chkPIN.Checked)
                    strQualified[16] = "PIN";
                else
                    strQualified[16] = "";
                if (chkSafeGuarding.Checked)
                    strQualified[17] = "SafeGuardingAdults";
                else
                    strQualified[17] = "";
                for(int i = 0; i < strQualified.Length;i++)
        {
            paramArray[i] = new SqlParameter();
            paramArray[i].ParameterName = "@Filter" + i.ToString();
            paramArray[i].Value = strQualified[i];
            
        }
                command = @"Select * from view_TrainingHist where training_Type = @Filter0 OR
     training_Type = @Filter1 OR training_Type = @Filter2 OR training_Type = @Filter3 OR
     training_Type = @Filter4 OR training_Type = @Filter5 OR training_Type = @Filter6 OR
     training_Type = @Filter7 OR training_Type = @Filter8 OR training_Type = @Filter9 OR
     training_Type = @Filter10 OR training_Type = @Filter11 OR training_Type = @Filter12 OR
     training_Type = @Filter13 OR training_Type = @Filter14 OR training_Type = @Filter15 OR
     training_Type = @Filter16 OR training_Type = @Filter17";
                dc.GainConnection(command, dgv1, "view_TrainingHist");       
    
            }

  2. #2
    Join Date
    Apr 2002
    Location
    Egypt
    Posts
    2,210

    Re: Error : Must declare the scalar variable

    You don't pass the paramArray to the command. So sql server does not know about your parameters.
    Hesham A. Amin
    My blog , Articles


    <a rel=https://twitter.com/HeshamAmin" border="0" /> @HeshamAmin

  3. #3
    Join Date
    Dec 2011
    Posts
    14

    Re: Error : Must declare the scalar variable

    thanks for your help i went for a more effcient approach in the end

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)