DatagridView Updating and Inserting Error

Question

0.00/5 (No votes)

See more:

Hi I have a Table RevinewTable in The Database RevinewDepartment

[S.I.N.O] int Primarykey IsIdentity=yes,Increment=1,seed=1

[NameOfTheApplicant&Address] varchar(20)
[PlotNo.] varchar(20)
[Sy.No] varchar(20)
Village varchar(50)
Mandal varchar(20)
District varchar(20)
RegularisedExtent varchar(20)
[ChallanNo.&Date] varchar(50)
[Endorsement&Date] Date

Like That

I am using SqlDatasource and GridView in My Webform
I configured The SqlDatasource Fallowing way
1.smarttag-->new connection -->(local)-->db is College-->Test Succeded
2.in configure select statement i specified My RevinewTable Table and in Advanced Tab i selected Generate insert update delete and optimistic concurrency
3.I tested My query it works fine
4.I attached this datasource to My gridview
5.I enabled selecting,editing and paging all works fine except edit
when i click on edit it changed to Update and Cancel after entering new details when i click on Update it gives the Fallowing Error

Incorrect syntax near '&'.
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 '&'.

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.

Note:
This Process works fine for me when i test with Northwind database with Products table
Please help me

This is the original code

XML

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:DemoRevinew1ConnectionString %>"
            DeleteCommand="DELETE FROM [REGULARISEDGOM747] WHERE [S.I.N.O] = @original_column1 AND (([NameOfTheApplicant&Address] = @original_column2) OR ([NameOfTheApplicant&Address] IS NULL AND @original_column2 IS NULL)) AND (([PlotNo.] = @original_column3) OR ([PlotNo.] IS NULL AND @original_column3 IS NULL)) AND (([Sy.No] = @original_column4) OR ([Sy.No] IS NULL AND @original_column4 IS NULL)) AND (([Village] = @original_Village) OR ([Village] IS NULL AND @original_Village IS NULL)) AND (([Mandal] = @original_Mandal) OR ([Mandal] IS NULL AND @original_Mandal IS NULL)) AND (([District] = @original_District) OR ([District] IS NULL AND @original_District IS NULL)) AND (([RegularisedExtent] = @original_RegularisedExtent) OR ([RegularisedExtent] IS NULL AND @original_RegularisedExtent IS NULL)) AND (([ChallanNo.&Date] = @original_column5) OR ([ChallanNo.&Date] IS NULL AND @original_column5 IS NULL)) AND (([Endorsement&Date] = @original_column6) OR ([Endorsement&Date] IS NULL AND @original_column6 IS NULL))"
            InsertCommand="INSERT INTO [REGULARISEDGOM747] ([NameOfTheApplicant&Address], [PlotNo.], [Sy.No], [Village], [Mandal], [District], [RegularisedExtent], [ChallanNo.&Date], [Endorsement&Date]) VALUES (@column1, @column2, @column3, @Village, @Mandal, @District, @RegularisedExtent, @column4, @column5)"
            OldValuesParameterFormatString="original_{0}"
            SelectCommand="SELECT * FROM [REGULARISEDGOM747]"
            UpdateCommand="UPDATE [REGULARISEDGOM747] SET [NameOfTheApplicant&Address] = @column1, [PlotNo.] = @column2, [Sy.No] = @column3, [Village] = @Village, [Mandal] = @Mandal, [District] = @District, [RegularisedExtent] = @RegularisedExtent, [ChallanNo.&Date] = @column4, [Endorsement&Date] = @column5 WHERE [S.I.N.O] = @original_column1 AND (([NameOfTheApplicant&Address] = @original_column2) OR ([NameOfTheApplicant&Address] IS NULL AND @original_column2 IS NULL)) AND (([PlotNo.] = @original_column3) OR ([PlotNo.] IS NULL AND @original_column3 IS NULL)) AND (([Sy.No] = @original_column4) OR ([Sy.No] IS NULL AND @original_column4 IS NULL)) AND (([Village] = @original_Village) OR ([Village] IS NULL AND @original_Village IS NULL)) AND (([Mandal] = @original_Mandal) OR ([Mandal] IS NULL AND @original_Mandal IS NULL)) AND (([District] = @original_District) OR ([District] IS NULL AND @original_District IS NULL)) AND (([RegularisedExtent] = @original_RegularisedExtent) OR ([RegularisedExtent] IS NULL AND @original_RegularisedExtent IS NULL)) AND (([ChallanNo.&Date] = @original_column5) OR ([ChallanNo.&Date] IS NULL AND @original_column5 IS NULL)) AND (([Endorsement&Date] = @original_column6) OR ([Endorsement&Date] IS NULL AND @original_column6 IS NULL))">

                <asp:Parameter Name="original_column1" Type="Int32" />
                <asp:Parameter Name="original_column2" Type="String" />
                <asp:Parameter Name="original_column3" Type="String" />
                <asp:Parameter Name="original_column4" Type="String" />
                <asp:Parameter Name="original_Village" Type="String" />
                <asp:Parameter Name="original_Mandal" Type="String" />
                <asp:Parameter Name="original_District" Type="String" />
                <asp:Parameter Name="original_RegularisedExtent" Type="String" />
                <asp:Parameter Name="original_column5" Type="String" />
                <asp:Parameter DbType="Date" Name="original_column6" />


                <asp:Parameter Name="column1" Type="String" />

<asp:Parameter Name="column2" Type="String" />
<asp:Parameter Name="column3" Type="String" />
<asp:Parameter Name="Village" Type="String" />
<asp:Parameter Name="Mandal" Type="String" />
<asp:Parameter Name="District" Type="String" />
<asp:Parameter Name="RegularisedExtent" Type="String" />
<asp:Parameter Name="column4" Type="String" />
<asp:Parameter DbType="Date" Name="column5" />

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="S.I.N.O" DataSourceID="SqlDataSource1" ForeColor="#333333"
GridLines="None">
<rowstyle backcolor="#F7F6F3" forecolor="#333333">
<columns> <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowSelectButton="True" />
<asp:BoundField DataField="S.I.N.O" HeaderText="S.I.N.O" InsertVisible="False"
ReadOnly="True" SortExpression="S.I.N.O" />
<asp:BoundField DataField="NameOfTheApplicant&Address"
HeaderText="NameOfTheApplicant&Address"
SortExpression="NameOfTheApplicant&Address" />
<asp:BoundField DataField="PlotNo." HeaderText="PlotNo."
SortExpression="PlotNo." />
<asp:BoundField DataField="Sy.No" HeaderText="Sy.No" SortExpression="Sy.No" />
<asp:BoundField DataField="Village" HeaderText="Village"
SortExpression="Village" />
<asp:BoundField DataField="Mandal" HeaderText="Mandal"
SortExpression="Mandal" />
<asp:BoundField DataField="District" HeaderText="District"
SortExpression="District" />
<asp:BoundField DataField="RegularisedExtent" HeaderText="RegularisedExtent"
SortExpression="RegularisedExtent" />
<asp:BoundField DataField="ChallanNo.&Date"
HeaderText="ChallanNo.&Date" SortExpression="ChallanNo.&Date" />
<asp:BoundField DataField="Endorsement&Date"
HeaderText="Endorsement&Date" SortExpression="Endorsement&Date" />
<footerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<pagerstyle backcolor="#284775" forecolor="White" horizontalalign="Center">
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<editrowstyle backcolor="#999999">
<alternatingrowstyle backcolor="White" forecolor="#284775">

[edit]Code moved from comment to question - OriginalGriff[/edit]

Posted 31-May-11 22:57pm

krishna_goluguri

Updated 31-May-11 23:22pm

v3

Add a Solution

Comments

Kiran Sonawane 1-Jun-11 5:01am

Can u provide sqldatasource code from aspx page

krishna_goluguri 1-Jun-11 5:08am

sorry actually i given an example

This is the original code

[edit]Moved to question - OriginalGriff[/edit]

OriginalGriff 1-Jun-11 5:14am

In future, please use the "Improve question" widget to provide code samples: it can preserve the formatting and make it a lot more readable!
I have moved it for you.

OriginalGriff 1-Jun-11 5:02am

In order to help, we would need to see the code you use: just the relevant fragment where you build the info and do the update.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

krishna_goluguri · Answer 1 · 2011-05-31T23:42:00

Solution 1

I found my solution I used S.I.N.O and [ChallanNo.&Date] Columns in them . and & creates The problem I removed . and & now it works fine The thing is it automatically add &
i dont know why the error comes but i solved it is if any body knows the reason please tell me

Posted 31-May-11 23:42pm

krishna_goluguri