Update and delete not Work in Girdview

Question

0.00/5 (No votes)

See more:

I used datasource object to bind grid as well as edit grid. bind is work fine. but Update and delete not work for me.

This is my code .

C#

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CssClass="style1" DataKeyNames="_id" DataSourceID="SqlDataSource1">
                    <Columns>
                        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                        <asp:BoundField DataField="_id" HeaderText="_id" InsertVisible="False" ReadOnly="True" SortExpression="_id" />
                        <asp:BoundField DataField="_videoName" HeaderText="_videoName" SortExpression="_videoName" />
                        <asp:BoundField DataField="_videoUrl" HeaderText="_videoUrl" SortExpression="_videoUrl" />
                        <asp:BoundField DataField="_category" HeaderText="_category" SortExpression="_category" />
                        <asp:BoundField DataField="_subCategory" HeaderText="_subCategory" SortExpression="_subCategory" />
                        <asp:BoundField DataField="_createdBy" HeaderText="_createdBy" SortExpression="_createdBy" />
                        <asp:BoundField DataField="_createdIp" HeaderText="_createdIp" SortExpression="_createdIp" />
                        <asp:BoundField DataField="_createTime" HeaderText="_createTime" SortExpression="_createTime" />
                        <asp:BoundField DataField="_modifyIp" HeaderText="_modifyIp" SortExpression="_modifyIp" />
                        <asp:BoundField DataField="_modifyTime" HeaderText="_modifyTime" SortExpression="_modifyTime" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    DeleteCommand="DELETE FROM [tbl_video] WHERE [_id] = @original_column1 AND (([_videoName] = @original_column2) OR ([_videoName] IS NULL AND @original_column2 IS NULL)) AND (([_videoUrl] = @original_column3) OR ([_videoUrl] IS NULL AND @original_column3 IS NULL)) AND (([_category] = @original_column4) OR ([_category] IS NULL AND @original_column4 IS NULL)) AND (([_subCategory] = @original_column5) OR ([_subCategory] IS NULL AND @original_column5 IS NULL)) AND (([_createdBy] = @original_column6) OR ([_createdBy] IS NULL AND @original_column6 IS NULL)) AND (([_createdIp] = @original_column7) OR ([_createdIp] IS NULL AND @original_column7 IS NULL)) AND (([_createTime] = @original_column8) OR ([_createTime] IS NULL AND @original_column8 IS NULL)) AND (([_modifyIp] = @original_column9) OR ([_modifyIp] IS NULL AND @original_column9 IS NULL)) AND (([_modifyTime] = @original_column10) OR ([_modifyTime] IS NULL AND @original_column10 IS NULL))" 
                    InsertCommand="INSERT INTO [tbl_video] ([_videoName], [_videoUrl], [_category], [_subCategory], [_createdBy], [_createdIp], [_createTime], [_modifyIp], [_modifyTime]) VALUES (@column1, @column2, @column3, @column4, @column5, @column6, @column7, @column8, @column9)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [tbl_video]" 
                    UpdateCommand="UPDATE [tbl_video] SET [_videoName] = @column1, [_videoUrl] = @column2, [_category] = @column3, [_subCategory] = @column4, [_createdBy] = @column5, [_createdIp] = @column6, [_createTime] = @column7, [_modifyIp] = @column8, [_modifyTime] = @column9 WHERE [_id] = @original_column1 AND (([_videoName] = @original_column2) OR ([_videoName] IS NULL AND @original_column2 IS NULL)) AND (([_videoUrl] = @original_column3) OR ([_videoUrl] IS NULL AND @original_column3 IS NULL)) AND (([_category] = @original_column4) OR ([_category] IS NULL AND @original_column4 IS NULL)) AND (([_subCategory] = @original_column5) OR ([_subCategory] IS NULL AND @original_column5 IS NULL)) AND (([_createdBy] = @original_column6) OR ([_createdBy] IS NULL AND @original_column6 IS NULL)) AND (([_createdIp] = @original_column7) OR ([_createdIp] IS NULL AND @original_column7 IS NULL)) AND (([_createTime] = @original_column8) OR ([_createTime] IS NULL AND @original_column8 IS NULL)) AND (([_modifyIp] = @original_column9) OR ([_modifyIp] IS NULL AND @original_column9 IS NULL)) AND (([_modifyTime] = @original_column10) OR ([_modifyTime] IS NULL AND @original_column10 IS NULL))">
                    <DeleteParameters>
                        <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_column5" Type="String" />
                        <asp:Parameter Name="original_column6" Type="String" />
                        <asp:Parameter Name="original_column7" Type="String" />
                        <asp:Parameter Name="original_column8" Type="String" />
                        <asp:Parameter Name="original_column9" Type="String" />
                        <asp:Parameter Name="original_column10" Type="String" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="column1" Type="String" />
                        <asp:Parameter Name="column2" Type="String" />
                        <asp:Parameter Name="column3" Type="String" />
                        <asp:Parameter Name="column4" Type="String" />
                        <asp:Parameter Name="column5" Type="String" />
                        <asp:Parameter Name="column6" Type="String" />
                        <asp:Parameter Name="column7" Type="String" />
                        <asp:Parameter Name="column8" Type="String" />
                        <asp:Parameter Name="column9" Type="String" />
                        <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_column5" Type="String" />
                        <asp:Parameter Name="original_column6" Type="String" />
                        <asp:Parameter Name="original_column7" Type="String" />
                        <asp:Parameter Name="original_column8" Type="String" />
                        <asp:Parameter Name="original_column9" Type="String" />
                        <asp:Parameter Name="original_column10" Type="String" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="column1" Type="String" />
                        <asp:Parameter Name="column2" Type="String" />
                        <asp:Parameter Name="column3" Type="String" />
                        <asp:Parameter Name="column4" Type="String" />
                        <asp:Parameter Name="column5" Type="String" />
                        <asp:Parameter Name="column6" Type="String" />
                        <asp:Parameter Name="column7" Type="String" />
                        <asp:Parameter Name="column8" Type="String" />
                        <asp:Parameter Name="column9" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>

Posted 4-Apr-13 21:25pm

Archit Patel

Add a Solution

Comments

Chinmaya C 5-Apr-13 3:53am

Hi,

If the DatakeyName is _id then why are you writing such a long condition while updating or deleting.

Where is the mapping of original_column* and the actual values?

Please try with the following code for Update

UPDATE [tbl_video]
SET [_videoName] = @_videoName,
[_videoUrl] = @_videoUrl,
[_category] = @_category,
[_subCategory] = @_subCategory,
[_createdBy] = @_createdBy,
[_createdIp] = @_createdIp,
[_createTime] = @_createTime,
[_modifyIp] = @_modifyIp,
[_modifyTime] = @_modifyTime
WHERE [_id] = @original__id

[no name] 5-Apr-13 3:57am

thank you it's work

Chinmaya C 5-Apr-13 4:00am

If the above solution helps then please mark the question as answered to help others.. :)

[no name] 5-Apr-13 4:09am

How can i do it ?

[no name] 5-Apr-13 4:11am

Please one more help
i want this type of think

[_modifyIp] = <%= Request.UserHostAddress %>,
[_modifyTime] = <%= DateTime.Now.ToString() %>
"This above code not work"

in place of

[_modifyIp] = @_modifyIp,
[_modifyTime] = @_modifyTime

Chinmaya C 5-Apr-13 4:14am

Are these values part of GridView???

[no name] 5-Apr-13 4:14am

yes it part of it.

Chinmaya C 5-Apr-13 4:20am

If this is the requirement then while populating the datasource for gridview you can store the IP address...
or you can try with the following code :

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
e.NewValues["_modifyTime"] = DateTime.Now.ToString();
e.NewValues["_modifyIp"] = Request.UserHostAddress;
}

[no name] 5-Apr-13 4:23am

for one more time thank you

Chinmaya C 5-Apr-13 4:24am

my pleasure... :)

Chinmaya C 5-Apr-13 4:30am

:)e.NewValues is a collection.
So if the fields are the part of GridView then the entries will be there in the collection and you need to update the values.
And if the fields are not part of GridView then you need to add those values to the collection.

So the code will be as below:

e.NewValues.Add("_modifyTime", DateTime.Now.ToString());
e.NewValues.Add("_modifyIp", Request.UserHostAddress);

Hope this helps. :)

[no name] 5-Apr-13 4:33am

yes i got it.

[no name] 5-Apr-13 4:45am

when i press edit than all field in same row it converted to text box but i don't want to edit some filed like "createdBy" and some place i need dropdown box in place of "Category" for that what should i do ?

Chinmaya C 5-Apr-13 4:53am

The fields which you don't want to modify, you can set ReadOnly property to True for that column. And regarding dropdown controls in some places you needs to add a templatefield instead of bound fields.

Example :
<asp:TemplateField ShowHeader="False">
<edititemtemplate>
<asp:DropDownList ID="drpItems" runat="server">
<asp:ListItem Text="Item1">
<asp:ListItem Text="Item2">
<asp:ListItem Text="Item3">

<itemtemplate>
<asp:Label ID="lblItem" runat="server" Text='<%# Eval("_modifyIp") %>'>

Please refer the below link to get more details
http://www.asp.net/web-forms/tutorials/data-access/custom-formatting/using-templatefields-in-the-gridview-control-cs

Chinmaya C 5-Apr-13 4:13am

I have posted the solution in answer section and you can mark that as answered. :)

[no name] 5-Apr-13 4:14am

yes i done it

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)

Chinmaya C · Accepted Answer · 2013-04-04T22:12:00

Please try with the following code for Update

C#

UPDATE [tbl_video] 
SET [_videoName] = @_videoName, [_videoUrl] = @_videoUrl, [_category] = @_category,
    [_subCategory] = @_subCategory, [_createdBy] = @_createdBy, 
    [_createdIp] = @_createdIp, [_createTime] = @_createTime, 
    [_modifyIp] = @_modifyIp, [_modifyTime] = @_modifyTime 
WHERE [_id] = @original__id

Similarly for Delete you can try with the following code:

C#

DELETE FROM [tbl_video] 
WHERE [_id] = @original__id