title: Stored procedure not working
body: <p>I have trouble converting this to stored procedure</p>
  
  <p>//The string included in the sql statement:</p>
  
  <pre><code>        string employer = Session["Employer"].ToString();
  </code></pre>
  
  <p>then the sql statement</p>
  
  <p>update tblWorkData set EmployerName='"+txtemployername.text+"' where EmployerName='"+Employer+"' //the string above</p>
  
  <p>This works fine in asp.net
  But when I turn it into stored procedure,</p>
  
  <pre><code>    create proc updateWork
  
      @EmployerName nvarchar(max)
  
      as
  
      begin
  
      update tblWorkData set EmployerName=@EmployerName where EmployerName=@EmployerName
      end
  </code></pre>
  
  <p>Now when I execute the sp on asp.net,</p>
  
  <pre><code>    string update = "updateWork '"+employer+"','"+txtemployername.text+"'";
  </code></pre>
  
  <p>I got an error saying "too many arguements". What should I do?</p>