This is what I want to use;

```
string insertQuery = @"insert into userinfo (UserName, FirstName, LastName, 
                      E-mail, Password,  Country) 
                      values ( '" + uname + "', '" + fname + 
                      "','" + lname + "', '" + email + "')";

```

where every one of the variables in between the + are string variables with values in them. but when I run this command, I get some incorrect syntax error.

This is the new error i get; 

> 
> errorSystem.Data.SqlClient.SqlException (0x80131904): String or binary
>  data would be truncated. The statement has been terminated. at
>  System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>  Boolean breakConnection, Action`1 wrapCloseInAction) at
>  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>  exception, Boolean breakConnection, Action`1 wrapCloseInAction) at
>  System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
>  stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
>  System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
>  SqlCommand cmdHandler, SqlDataReader dataStream,
>  BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
>  stateObj, Boolean& dataReady) at
>  System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
>  RunBehavior runBehavior, String resetOptionsString) at
>  System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
>  cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
>  async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader
>  ds) at
>  System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
>  cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
>  method, TaskCompletionSource`1 completion, Int32 timeout, Task& task,
>  Boolean asyncWrite) at
>  System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1
>  completion, String methodName, Boolean sendToPipe, Int32 timeout,
>  Boolean asyncWrite) at
>  System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
>  Registration.RegistrationPage.Button1\_Click1(Object sender, EventArgs
>  e) in c:\Users\kristhnen.jagambrum\Documents\Visual Studio
>  2012\Projects\Registration\Registration\RegistrationPage.aspx.cs:line
>  50 ClientConnectionId:6d959e49-5b62-43be-b202-76f7eb1fbd2c
> 
> 
>