UpdateCommand="UPDATE [Task] SET [Region] = @Region, [InquiryText] = @InquiryText, [WaitingTime] = @WaitingTime, [QuantityMonth] = @QuantityMonth, [RateOn] = @RateOn, [ExecutedDay] = @ExecutedDay, [ExecutedMonth] = @ExecutedMonth, [ExecutedTotal] = @ExecutedTotal WHERE [ID] = @original_ID AND [Region] = @original_Region AND [InquiryText] = @original_InquiryText AND [WaitingTime] = @original_WaitingTime AND [QuantityMonth] = @original_QuantityMonth AND (([RateOn] = @original_Rate) OR ([RateOn] IS NULL AND @original_RateOn IS NULL)) AND (([ExecutedDay] = @original_ExecutedDay) OR ([ExecutedDay] IS NULL AND @original_ExecutedDay IS NULL)) AND (([ExecutedMonth] = @original_ExecutedMonth) OR ([ExecutedMonth] IS NULL AND @original_ExecutedMonth IS NULL)) AND (([ExecutedTotal] = @original_ExecutedTotal) OR ([ExecutedTotal] IS NULL AND @original_ExecutedTotal IS NULL))">

........

<Columns>

<asp:TemplateField  HeaderText="Region" SortExpression="Region">

    <EditItemTemplate>

         <asp:DropDownList ID="DDLRegion" runat="server" Height="21px" Width="206px"

              DataSourceID="SqlDataSourceRegion" DataTextField="Region" DataValueField="Region">

         </asp:DropDownList>

          

    </EditItemTemplate>

                                    

    <ItemTemplate>

              <%# Eval("Region") %>    

    </ItemTemplate>

 

    </asp:TemplateField>

                            <%-- ==================================================================================== --%>