ASMX Web服务使用SQL Server存储用户数据SQL错误

我试图在Visual Web Developer中创建一个ASMX Web服务。我已经成功地实现了以下

• 创建了一个列为"电子邮件"、"名称"的数据库
• 创建了服务

我还指定了类似的连接字符串web.config

<connectionStrings>
  <add name="mydb" connectionString="data source=.'SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|Database.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    </connectionStrings>

但在服务表单中输入数据后，我得到了一个SQL异常"@Name附近语法不正确"

[WebMethod]
public string insertuser(String UserName,String Email)
{
    string connectionString = ConfigurationManager.ConnectionStrings["mydb"].ConnectionString;
    SqlConnection sqlCon = new SqlConnection(connectionString);
    SqlCommand nonqueryCommand = sqlCon.CreateCommand();
    sqlCon.Open();
    nonqueryCommand.CommandText = "INSERT  INTO UID (Email, Name) VALUES (@Email, @Name";
    // Add Parameters to Command Parameters collection
    nonqueryCommand.Parameters.Add("@Email", SqlDbType.VarChar, 10);
    nonqueryCommand.Parameters.Add("@Name", SqlDbType.VarChar, 20);

    nonqueryCommand.Parameters["@Email"].Value = UserName;
    nonqueryCommand.Parameters["@Name"].Value = Email;

    nonqueryCommand.ExecuteNonQuery();
    return "done";
}