title: INSERT INTO error message
body: <p>I created a web application with Visual Web Developer in ASP.NET and a SQL Server database. In <code>SqlDataSource</code> I made connection with <code>INSERT INTO</code>. </p>
  
  <p>So my code is:</p>
  
  <pre><code>&lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
              ConnectionString="&lt;%$ ConnectionStrings:ConnectionString %&gt;" 
              SelectCommand="SELECT * FROM [Table1]"
              InsertCommand="INSERT INTO [Table1] ([Name(nick)], [E-mail], [Text]) VALUES (@Name(nick), @E-mail, @Text)"&gt;
          &lt;InsertParameters&gt;
              &lt;asp:Parameter Name="Name(nick)" /&gt;
              &lt;asp:Parameter Name="E-mail" /&gt;
              &lt;asp:Parameter Name="Text" /&gt;
          &lt;/InsertParameters&gt;
   &lt;/asp:SqlDataSource&gt;  
  </code></pre>
  
  <p>Everything looks well without any errors. When I view my project in web browser or I start debugging I have normal web page. Then I type some text, click to send button and error in application.</p>
  
  <blockquote>
    <p><em>Description: Incorrect syntax near '('. Must declare the scalar
    variable "@Name".</em></p>
    
    <p><em>Specifications: System.Data.SqlClient.SqlException: Incorrect syntax
    near '('. Must declare the scalar variable "@Name".</em></p>
  </blockquote>
  
  <p>In my table I have all this values and in my web page I use it as well. Could you help me what is wrong?</p>
  
  <p>Many thanks!</p>