Hi,

I'm filling a GridView with a simple sproc select statement. I'm
trying to use the Update tab to create an update statement and using
the following:

Update Shipping_Requests
Set Shipped = @Shipped

The Shipped column is a bit type column that is returned in the
initial sproc call to fill the GridView. I'm getting the error:

"Incorrect syntax near 'nvarchar'" when trying to update the row.

The stack trace is below. This seems like a no brainer but I can't
seem to get it to work. Any ideas? Thanks in advance.

[SqlException (0x80131904): Incorrect syntax near 'nvarchar'.]
  System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) +859322
  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +736198

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) +188
  System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj) +1959
  System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
ds, RunBehavior runBehavior, String resetOptionsString) +149

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async) +903
  System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result) +132

System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe) +415
  System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135

System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand
command, DataSourceOperation operation) +401

System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary
keys, IDictionary values, IDictionary oldValues) +721
  System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary
values, IDictionary oldValues, DataSourceViewOperationCallback
callback) +78
  System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row,
Int32 rowIndex, Boolean causesValidation) +1215
  System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean
causesValidation, String validationGroup) +858
  System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source,
EventArgs e) +95
  System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
args) +35
  System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source,
EventArgs e) +117
  System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
args) +35
  System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
+115
  System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
eventArgument) +163

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
  System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+174
  System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+5102