c# - Must declare the scalar variable "@lblCmpUserName" -

when user logs in username, send username next page below code in page_load

 lblcmpusername.text = server.urldecode(request.querystring["parameter"].tostring()); 

and want store "company details" username in sql server 2008 table.

i got error

must declare scalar variable "@lblcmpusername"

code:

    protected void btncmpapproval_click(object sender, eventargs e)     {        sqlconnection sqlcon = new sqlconnection(getconnectionstring());        string query = "insert company_info2 values (@lblcmpusername, @txtcmpname,  @txtregcountry, @txtcmpregno, @txtcmpestdate,@afu1, @txtcmpaddress, @ddladdrin)";        try        {           sqlcon.open();            sqlcommand cmd = new sqlcommand(query, sqlcon);           cmd.commandtype = commandtype.text;           cmd.parameters.addwithvalue("@username", lblcmpusername.text);           cmd.parameters.addwithvalue("@cmp_name", txtcmpname.text);           cmd.parameters.addwithvalue("@commercial_regno", txtregcountry.text);           cmd.parameters.addwithvalue("@comm_country", txtcmpregno.text);           cmd.parameters.addwithvalue("@cmp_establishdate", txtcmpestdate.text);           cmd.parameters.addwithvalue("@cmp_docpath", afu1.filename);           cmd.parameters.addwithvalue("@txtcmpaddress", txtcmpaddress.text);           cmd.parameters.addwithvalue("@ddladdrin", ddladdrin.selecteditem.text);            cmd.executenonquery();       }       catch (exception ex)       {          throw new exception(ex.message);       }             {           sqlcon.close();       }     }  

try this

protected void btncmpapproval_click(object sender, eventargs e)     {     sqlconnection sqlcon = new sqlconnection(getconnectionstring());     string query = "insert company_info2 values (@lblcmpusername,@txtcmpname,     @txtregcountry,@txtcmpregno,@txtcmpestdate,@txtcmpaddress,@ddladdrin)";     try     {      sqlcon.open();      sqlcommand cmd = new sqlcommand(query, sqlcon);      cmd.commandtype = commandtype.text;      cmd.parameters.addwithvalue("@lblcmpusername", lblcmpusername.text);      cmd.parameters.addwithvalue("@txtcmpname", txtcmpname.text);      cmd.parameters.addwithvalue("@txtregcountry", txtregcountry.text);      cmd.parameters.addwithvalue("@txtcmpregno", txtcmpregno.text);      cmd.parameters.addwithvalue("@txtcmpestdate", txtcmpestdate.text);      cmd.parameters.addwithvalue("@cmp_docpath", afu1.filename);       cmd.parameters.addwithvalue("@txtcmpaddress", txtcmpaddress.text);      cmd.parameters.addwithvalue("@ddladdrin", ddladdrin.selecteditem.text);      cmd.executenonquery();   }   catch (exception ex)   {      throw new exception(ex.message);   }     {             sqlcon.close();   }   } 

actually except last two, none of added parameters match parameters present in query. parameters defined in query & parameter added command using

cmd.parameters.addwithvalue(...) 

or

cmd.parameters.add(...) 

must same or else errors sure.