Incorrect syntax near 'nvarchar'.

[Mark B]

When I click the 'Update' button on a ASP.Net 3.5 GridView record, I get an
error:

Incorrect syntax near 'nvarchar'.

Everything else there works OK. Here is the code:


<%@ Page Language="VB" AutoEventWireup ="false" CodeFile="defau lt.aspx.vb"
Inherits="pages _verify_groups_ Default" Debug="true"
MasterPageFile= "~/pages/master_page/MasterPage.mast er"
Title="Page1"%>

<asp:Content ID="Content1" ContentPlaceHol derID="ContentP laceHolderMain1 "
Runat="Server">

</tr><tr><td><h2>


Title</h2>
<p>


<asp:GridView
ID="GridView1" runat="server" AutoGenerateCol umns="False"
DataSourceID="S qlDataSource1"
AllowPaging="Tr ue" AllowSorting="T rue">
<Columns>
<asp:CommandFie ld
ShowEditButton= "True" />
<asp:BoundFie ld
DataField="ID" HeaderText="ID" InsertVisible=" False"
ReadOnly="True"
SortExpression= "ID" />
<asp:BoundFie ld
DataField="Lang uage" HeaderText="Lan guage"
SortExpression= "Language"
/>
<asp:BoundFie ld
DataField="Engl ish ID" HeaderText="Eng lish ID"
SortExpression= "English
ID" />
<asp:BoundFie ld
DataField="Engl ish" HeaderText="Eng lish"
SortExpression= "English"
/>
<asp:BoundFie ld
DataField="Text " HeaderText="Tex t" SortExpression= "Text" />
</Columns>
</asp:GridView>
<asp:SqlDataSou rce
ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$
ConnectionStrin gs:MyConnection String %>"

SelectCommand=" SELECT
tblLanguageValu es.AutoNumberID AS ID, tblLanguageValu es.LanguageCode AS
Language, tblLanguageValu es.LookupID AS [English ID],
tblLanguageValu es_1.LanguageTe xt AS English, tblLanguageValu es.LanguageText
AS Text FROM tblLanguageValu es INNER JOIN tblLanguageValu es AS
tblLanguageValu es_1 ON tblLanguageValu es.LookupID =
tblLanguageValu es_1.AutoNumber ID WHERE (tblLanguageVal ues.LanguageCod e =
'FR-FR')"

UpdateCommand=" UPDATE
tblLanguageValu es SET LanguageText = @LanguageText WHERE (LanguageCode =
@LanguageCode) AND (LookupID = @LookupID)">
<UpdateParamete rs>
<asp:Paramete r
Name="LanguageT ext" type="String" />
<asp:Paramete r
Name="LanguageC ode" type="String"/>
<asp:Paramete r
Name="LookupID" type="Int32" />
</UpdateParameter s>
</asp:SqlDataSour ce>
</p>
</td>
</tr>
<tr>
<td>
<p>
</p>
</td>
</tr>
<tr>
<td>
&nbsp;</td>
</tr>
<tr>
<td>

</td>
</tr>
<tr>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
&nbsp;</td>
</tr>
</asp:Content>
<asp:Content ID="Content2" runat="server" contentplacehol derid="head">

</asp:Content>

[Munna]

Re: Incorrect syntax near 'nvarchar'.

Hi

This is a invalid sql string message... your update sql string have
some problem...
check that your database columns datatype and sql string is good...

Best of luck

-------
Munna

https://www.munna.shatkotha.com/blog

https://www.munna.shatkotha.com

https://www.shatkotha.com

[Mark B]

Re: Incorrect syntax near 'nvarchar'.


UPDATE [dbo].[tblLanguageValu es]
SET [LanguageCode] = <LanguageCode , varchar(10),>
,[LookupID] = <LookupID, int,>
,[LanguageText] = <LanguageText , nvarchar(4000), >
WHERE <Search Conditions,,>


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFI ER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblLanguageValu es](
[AutoNumberID] [int] IDENTITY(1,1) NOT NULL,
[LanguageCode] [varchar](10) NOT NULL CONSTRAINT
[DF_tblLanguageV alues_LanguageC ode] DEFAULT ('EN-US'),
[LookupID] [int] NOT NULL,
[LanguageText] [nvarchar](4000) NOT NULL,
CONSTRAINT [PK_tblLanguageV alues] PRIMARY KEY CLUSTERED
(
[LanguageCode] ASC,
[LookupID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORE COMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCK S = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF




"Munna" <munnaonc@gmail .comwrote in message
news:21725e68-ad2a-49e2-b839-176d72fd1f35@s5 0g2000hsb.googl egroups.com...

Hi
>
This is a invalid sql string message... your update sql string have
some problem...
check that your database columns datatype and sql string is good...
>
Best of luck
>
-------
Munna
>

https://www.munna.shatkotha.com/blog

https://www.munna.shatkotha.com

www.shatkotha.com