New Topic/Question
Reply
I'm new to ASP.net and I'm having a tough time getting my sql to update/delete/update my database. My select statement reads fine. I'm wondering if its because I am auto-generating columns at run time when the user selects a control on my .aspx form. I'm using VB.net for the background code, though I'm not sure it comes into play here. Here's my asp code for the data source and the gridview control.
<asp:SqlDataSource ID="dsApp" runat="server"
SelectCommand="SELECT [fldAppName] as 'Application', [fldGroupName] as 'Group Name', [fldAppSymID] as 'Symposium ID',
[fldAppPhone] as 'Phone', [fldAppPhoneOpt] as 'Options' FROM [tblApplication]
WHERE ([fldGroupName] = @fldGroupName) ORDER BY [fldAppName]"
ConnectionString="<%$ ConnectionStrings:DiscussSQLConnectionString %>"
DeleteCommand="DELETE FROM [tblApplication] WHERE [fldAppName] = @original_fldAppName AND
(([fldGroupName] = @original_fldGroupName) OR ([fldGroupName] IS NULL AND @original_fldGroupName IS NULL)) AND
(([fldAppSymID] = @original_fldAppSymID) OR ([fldAppSymID] IS NULL AND @original_fldAppSymID IS NULL)) AND
(([fldAppPhone] = @original_fldAppPhone) OR ([fldAppPhone] IS NULL AND @original_fldAppPhone IS NULL)) AND
(([fldAppPhoneOpt] = @original_fldAppPhoneOpt) OR ([fldAppPhoneOpt] IS NULL AND @original_fldAppPhoneOpt IS NULL))"
InsertCommand="INSERT INTO [tblApplication] ([fldAppName], [fldGroupName], [fldAppSymID], [fldAppPhone], [fldAppPhoneOpt])
VALUES (@fldAppName, @fldGroupName, @fldAppSymID, @fldAppPhone, @fldAppPhoneOpt)"
OldValuesParameterFormatString="original_{0}"
UpdateCommand="UPDATE [tblApplication] SET [fldGroupName] = @fldGroupName, [fldAppSymID] = @fldAppSymID,
[fldAppPhone] = @fldAppPhone, [fldAppPhoneOpt] = @fldAppPhoneOpt
WHERE [fldAppName] = @original_fldAppName AND (([fldGroupName] = @original_fldGroupName) OR
([fldGroupName] IS NULL AND @original_fldGroupName IS NULL)) AND (([fldAppSymID] = @original_fldAppSymID) OR
([fldAppSymID] IS NULL AND @original_fldAppSymID IS NULL)) AND (([fldAppPhone] = @original_fldAppPhone) OR
([fldAppPhone] IS NULL AND @original_fldAppPhone IS NULL)) AND (([fldAppPhoneOpt] = @original_fldAppPhoneOpt) OR
([fldAppPhoneOpt] IS NULL AND @original_fldAppPhoneOpt IS NULL))">
<SelectParameters>
<asp:ControlParameter ControlID="cboGroup" Name="fldGroupName"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_fldAppName" Type="String" />
<asp:Parameter Name="original_fldGroupName" Type="String" />
<asp:Parameter Name="original_fldAppSymID" Type="String" />
<asp:Parameter Name="original_fldAppPhone" Type="String" />
<asp:Parameter Name="original_fldAppPhoneOpt" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="fldAppName" Type="String" />
<asp:Parameter Name="fldGroupName" Type="String" />
<asp:Parameter Name="fldAppSymID" Type="String" />
<asp:Parameter Name="fldAppPhone" Type="String" />
<asp:Parameter Name="fldAppPhoneOpt" Type="String" />
<asp:Parameter Name="original_fldAppName" Type="String" />
<asp:Parameter Name="original_fldGroupName" Type="String" />
<asp:Parameter Name="original_fldAppSymID" Type="String" />
<asp:Parameter Name="original_fldAppPhone" Type="String" />
<asp:Parameter Name="original_fldAppPhoneOpt" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="fldAppName" Type="String" />
<asp:Parameter Name="fldGroupName" Type="String" />
<asp:Parameter Name="fldAppSymID" Type="String" />
<asp:Parameter Name="fldAppPhone" Type="String" />
<asp:Parameter Name="fldAppPhoneOpt" Type="String" />
<asp:Parameter Name="original_fldAppName" Type="String" />
<asp:Parameter Name="original_fldGroupName" Type="String" />
<asp:Parameter Name="original_fldAppSymID" Type="String" />
<asp:Parameter Name="original_fldAppPhone" Type="String" />
<asp:Parameter Name="original_fldAppPhoneOpt" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<asp:GridView ID="gvGroupApps" runat="server"
AutoGenerateColumns="True"
ShowFooter="True" AllowPaging="True" CellPadding="4"
DataSourceID="dsApp" ForeColor="#333333" GridLines="None">
<RowStyle BackColor="#E3EAEB" />
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Columns>
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#7C6F57" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
When I try to edit a record in my Gridview, I get the fields to open up and make my changes, then after I click "Update", I get this error within my browser...
Server Error in '/DISCuSS' Application.
--------------------------------------------------------------------------------
Incorrect syntax near 'nvarchar'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Incorrect syntax near 'nvarchar'.]
System.Data.SqlClient.SqlConnection.onerror(SqlException exception, Boolean breakConnection) +1950522
System.Data.SqlClient.SqlInternalConnection.onerror(SqlException exception, Boolean breakConnection) +4856715
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(Runbehavior runbehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1121
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, Runbehavior runbehavior, String resetOptionsString) +200
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(Commandbehavior cmdbehavior, Runbehavior runbehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(Commandbehavior cmdbehavior, Runbehavior runbehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +386
System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +325
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +92
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +907
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +704
System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +123
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
Hope someone can help me solve this. Any help is greatly appreciated.
Thank you,
Brad
MultiQuote
I found this was being caused by the spaces in my alias'. Once I replaced the spaces with underscores...voila. I actually ended up removing all of the alias' and manually defining my columns in the gridview and setting the "HeaderText" property with what I wanted them to display as. The worked perfectly. Thanks again for your help.
| 