The name does not exist in current context

Question

Hi,

 have written this code and getting the below error i am not able to resolve. Can someone please help.

I am getting error in below line "The name does not exist in current context"

 using (SqlCommand cmd = new SqlCommand("Update rtest set ierrcode = 1 where importid = @importid", con))

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;


namespace AddressObjectSample
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }


        public class Customer
        {
            public string importid { get; set; }
            public string address1 { get; set; }
            public string city { get; set; }
            public string state { get; set; }
            public string zipcode { get; set; }
        }

        public string DataPathLocation = @"C:\Program Files\Melissa Data\DQT\Data";

       
        public string LicenseString = "DEMO";

        //Address Object Interfaces
        MelissaData.mdAddr addrobj = new MelissaData.mdAddr();
        MelissaData.mdParse parseObj = new MelissaData.mdParse();
        MelissaData.mdStreet streetObj = new MelissaData.mdStreet();
        MelissaData.mdZip zipObj = new MelissaData.mdZip();

         
        

        #region Initialize Objects
        private void Form1_Load(object sender, System.EventArgs e)
        {
            //****Initialize Address Object Address Check Interface****//
            addrobj.SetLicenseString(LicenseString);

            //Set Path To Data Files
            addrobj.SetPathToUSFiles(DataPathLocation);

            
            if (addrobj.InitializeDataFiles() != 0)
            {
                //Initialization failed
                lblInitError.Text = addrobj.GetInitializeErrorString();
                btnVerify.Enabled = false;
            }
            else
            {
                //Initialized
                btnVerify.Enabled = true;
                lblBuild.Text = addrobj.GetBuildNumber();
                lblDatabaseDate.Text = addrobj.GetDatabaseDate();
                lblExpiration.Text = addrobj.GetExpirationDate();
            }



            //****Initialize Address Object Parse  Interface****//
            parseObj.Initialize(DataPathLocation);


            //****Initialize Address Object Street Data Interface****//
            streetObj.SetLicenseString(LicenseString);
            if (streetObj.Initialize(DataPathLocation, DataPathLocation, "") != 0)
            {
                // Initialize failed
                lblStreetInitError.Text = streetObj.GetInitializeErrorString();
                btnFindStreet.Enabled = false;
            }
            else
            {
                btnFindStreet.Enabled = true;
                lblStreetBuild.Text = streetObj.GetBuildNumber();
                lblStreetDatabaseDate.Text = streetObj.GetDatabaseDate();
                lblStreetInitError.Text = streetObj.GetInitializeErrorString();
            }




            //****Initialize Address Object Zip Data Interface****//
            zipObj.SetLicenseString(LicenseString);
            if (zipObj.Initialize(DataPathLocation, DataPathLocation, "") != 0)
            {
                // Initialize failed
                lblZipErrorString.Text = zipObj.GetInitializeErrorString();
                btnCityInState.Enabled = false;
                btnZipInCity.Enabled = false;
                btnFindZip.Enabled = false;
            }
            else
            {
                // Initialize successful
                lblZipBuild.Text = zipObj.GetBuildNumber();
                lblZipDatabase.Text = zipObj.GetDatabaseDate();
                lblZipErrorString.Text = zipObj.GetInitializeErrorString();
                btnCityInState.Enabled = true;
                btnZipInCity.Enabled = true;
                btnFindZip.Enabled = true;
            }
        }
        #endregion

        #region Address Check
        private void btnVerify_Click(object sender, System.EventArgs e)
        {

            List<Customer> customers = new List<Customer>();
            using (SqlConnection con = new SqlConnection("Server=SERVERNAME;Database=DBNAME;User ID=USERNAME;Password=PASS"))
            {
                con.Open();
                using (SqlCommand cmd = new SqlCommand("Select * from rtest", con))
                {
                    using (SqlDataReader rdr = cmd.ExecuteReader())
                    {
                        while (rdr.Read())
                        {
                            customers.Add(new Customer
                            {
                                importid = Convert.ToString(rdr["importid"]),
                                address1 = Convert.ToString(rdr["address1"]),
                                city = Convert.ToString(rdr["city"]),
                                state = Convert.ToString(rdr["state"]),
                                zipcode = Convert.ToString(rdr["zipcode"]),
                            });
                        }
                    }
                }
            }


            foreach (var item in customers)
            {
                //check for some condition here
                if (item.address1 != null)
                {
                    //addrobj.ClearProperties();

                    //addrobj.Address = item.address1;
                    //addrobj.City = item.city;
                    //addrobj.State = item.state;
                    //addrobj.Zip = item.zipcode;
                    //addrobj.VerifyAddress();

                    //clear any previous results


                    //set input address
                    addrobj.ClearProperties();
                    //addrobj.SetCompany(txtCompany.Text);
                    addrobj.SetAddress(item.address1);
                    //addrobj.SetAddress2(txtAddress2.Text);
                    addrobj.SetCity(item.city);
                    addrobj.SetState(item.state);
                    addrobj.SetZip(item.zipcode);
                    // addrobj.SetLastName(txtLastName.Text);

                    //verify address
                    addrobj.VerifyAddress();


                    // Get the Result Codes
                    //String ResultsString = addrobj.Results;
                    // Get the Result Codes
                    String ResuString = addrobj.GetResults();
                    String RessOut = "";

                    using (SqlCommand cmd = new SqlCommand("Update rtest set ierrcode = 1 where importid = @importid", con))
                    {
                        cmd.Parameters.AddWithValue("@importid", item.importid);
                        // cmd.Parameters.AddWithValue("@CustomerID", item.CustomerID);
                        cmd.ExecuteNonQuery();

                    }
                }
            }