ASP.NET

ASP.NET RSS

Problem with Edit/Update in GridView...

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2008

Posts: 5

Reputation: b007 is an unknown quantity at this point

Solved Threads: 0

b007

Offline

Newbie Poster

Problem with Edit/Update in GridView...

Nov 28th, 2008

Hi,
I just add a GridView with Edit option.
I connected it to DataSource.
Now, one field is a date, so I convert it's column to a template and added in the editItem template an ajax calendar extender which connected to the Texbox and works by clicking a button which I also added in the editItem template.
my problem is,
When the caldendar appears and I select a new date,
it show in the Textbox but when I press Update
the new date I just entered isnt update at all..
what I did wrong?

aspx code of editItem template:

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
<asp:TemplateField HeaderText="ord_date" SortExpression="ord_date">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" 
                            Text='<%# Bind("ord_date", "{0:d}") %>'></asp:TextBox>
                        <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/calendar.gif" />
                        <cc1:CalendarExtender ID="CalendarExtender1" runat="server" 
                            PopupButtonID="ImageButton1" TargetControlID="ord_date">
                        </cc1:CalendarExtender>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("ord_date", "{0:d}") %>'></asp:Label>
                        &nbsp;<br />
                    </ItemTemplate>
                </asp:TemplateField>
<asp:TemplateField HeaderText="ord_date" SortExpression="ord_date">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" 
                            Text='<%# Bind("ord_date", "{0:d}") %>'></asp:TextBox>
                        <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/calendar.gif" />
                        <cc1:CalendarExtender ID="CalendarExtender1" runat="server" 
                            PopupButtonID="ImageButton1" TargetControlID="ord_date">
                        </cc1:CalendarExtender>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("ord_date", "{0:d}") %>'></asp:Label>
                        &nbsp;<br />
                    </ItemTemplate>
                </asp:TemplateField>

and aspx code of update:

Help with Code Tags

asp.net Syntax (Toggle Plain Text)

 UpdateCommand="UPDATE [sales] SET [ord_date] = @ord_date, [qty] = @qty, [payterms] = @payterms WHERE [stor_id] = @original_stor_id AND [ord_num] = @original_ord_num AND [title_id] = @original_title_id AND [ord_date] = @original_ord_date AND [qty] = @original_qty AND [payterms] = @original_payterms">

How to fix it.
Thanks.

Last edited by peter_budo; Nov 29th, 2008 at 5:59 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Sep 2007

Posts: 80

Reputation: reach_yousuf is an unknown quantity at this point

Solved Threads: 14

reach_yousuf reach_yousuf is offline

Offline

Junior Poster in Training

Re: Problem with Edit/Update in GridView...

Nov 29th, 2008

Hi

Try to find the value of the grid's control

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
Dim MyTxt As TextBox
 
MyTxt = CType(Mygridview.FindControl("ord_Date"), TextBox)
Dim MyTxt As TextBox

MyTxt = CType(Mygridview.FindControl("ord_Date"), TextBox)