Here's my GridView and my SqlDataSource
<asp:GridView ID="ContactHist oryGrid" runat="server"
AutoGenerateCol umns="False" DataSourceID="C ontactHistoryDS "
DataKeyNames="J obHistoryID"
OnRowCreated="C ontactHistoryGr id_RowCreated"
CssClass="GridV iewTable"
GridLines="None " CellSpacing="1" CellPadding="3" AllowSorting="T rue"
AllowPaging="Tr ue">
<EmptyDataTempl ate>
<div class="NoResult sPanel">
No items were found for your search.
</div>
</EmptyDataTempla te>
<PagerTemplat e>
<div style="float: right;">
<asp:Button ID="NextButton " runat="server" Text="Next"
CommandName="Pa ge" CommandArgument ="Next" />
<asp:Button ID="LastButton " runat="server" Text="Last"
CommandName="Pa ge" CommandArgument ="Last" />
</div>
<div style="float: left;">
<asp:Button ID="FirstButton " runat="server" Text="First"
CommandName="Pa ge" CommandArgument ="First" />
<asp:Button ID="PrevButton " runat="server" Text="Prev"
CommandName="Pa ge" CommandArgument ="Prev" />
</div>
Page <asp:DropDownLi st ID="PageDropDow n" runat="server"
AutoPostBack="t rue" />
of <asp:Literal ID="PageCountLi teral" runat="server" />
</PagerTemplate>
<PagerSetting s Position="TopAn dBottom" />
<PagerStyle CssClass="table SmallHeaderCell " />
<Columns>
<asp:BoundFie ld DataField="Cust omerName" HeaderText="Com pany"
ReadOnly="True" SortExpression= "CustomerNa me" >
<ItemStyle CssClass="table DataCell" />
<HeaderStyle CssClass="table SmallHeaderCell " />
</asp:BoundField>
<asp:BoundFie ld DataField="Posi tion" HeaderText="Pos ition"
SortExpression= "Position" >
<ItemStyle CssClass="table DataCell" />
<HeaderStyle CssClass="table SmallHeaderCell " />
</asp:BoundField>
<asp:TemplateFi eld HeaderText="Sta rt Date"
SortExpression= "StartDate" >
<EditItemTempla te>
<asp:TextBox ID="EditStartDa teTextBox" runat="server" Text='<%#
Bind("StartDate ", "{0:MMM d, yyyy}") %>' />
<asp:HyperLin k ID="StartDateCa lendarLink" runat="server"
ImageUrl="~/images/calendarButton. png" />
</EditItemTemplat e>
<ItemTemplate >
<asp:Literal ID="StartDateLi teral" runat="server" Text='<%#
Eval("StartDate ", "{0:MMM d, yyyy}") %>' />
</ItemTemplate>
<ItemStyle CssClass="table DataCell" />
<HeaderStyle CssClass="table SmallHeaderCell " />
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="End Date" SortExpression= "EndDate">
<EditItemTempla te>
<asp:TextBox ID="EditEndDate TextBox" runat="server" Text='<%#
Bind("EndDate", "{0:MMM d, yyyy}") %>' />
<asp:HyperLin k ID="EndDateCale ndarLink" runat="server"
ImageUrl="~/images/calendarButton. png" />
</EditItemTemplat e>
<ItemTemplate >
<asp:Literal ID="EndDateLite ral" runat="server" Text='<%#
Eval("EndDate", "{0:MMM d, yyyy}") %>' />
</ItemTemplate>
<ItemStyle CssClass="table DataCell" />
<HeaderStyle CssClass="table SmallHeaderCell " />
</asp:TemplateFie ld>
<asp:CommandFie ld ButtonType="But ton" ShowEditButton= "True">
<HeaderStyle CssClass="table SmallHeaderCell " />
<ItemStyle CssClass="table DataCell" />
</asp:CommandFiel d>
</Columns>
</asp:GridView>
<asp:SqlDataSou rce ID="ContactHist oryDS" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:SalesCRM %>" ProviderName="< %
$ ConnectionStrin gs:SalesCRM.Pro viderName %>"
SelectCommand=" SELECT ContactID, FirstName, LastName, JobHistoryID,
CustomerNumber, CustomerName, Position, StartDate, EndDate FROM
dbo.ContactJobH istory_V WHERE ContactID = @contactid AND EndDate IS
NOT NULL" SelectCommandTy pe="text"
UpdateCommand=" dbo.UpdateJob_u sp"
UpdateCommandTy pe="StoredProce dure">
<SelectParamete rs>
<asp:QueryStrin gParameter Name="contactid "
QueryStringFiel d="contactid" />
</SelectParameter s>
</asp:SqlDataSour ce>
Here's my OnRowCreatedEve nt:
protected void ContactHistoryG rid_RowCreated (object sender,
GridViewRowEven tArgs e) {
GridView gv = (GridView) sender;
if (e.Row.RowType == DataControlRowT ype.Header) {
// Apply the sorting arrows to the header as needed.
GridViewFunctio ns.AddSortArrow (gv, e);
} else if (e.Row.RowType == DataControlRowT ype.Pager) {
// Setup the paging buttons (enable/disable the buttons, attach the
proper event function to the dropdownlist)
Button first = (Button) e.Row.Cells[0].FindControl ("FirstButton") ;
Button previous = (Button) e.Row.Cells[0].FindControl
("PrevButton ");
Button next = (Button) e.Row.Cells[0].FindControl ("NextButton ");
Button last = (Button) e.Row.Cells[0].FindControl ("LastButton ");
DropDownList pageSelect = (DropDownList) e.Row.Cells[0].FindControl
("PageDropDown" );
Literal pageCount = (Literal) e.Row.Cells[0].FindControl
("PageCountLite ral");
GridViewFunctio ns.InitializeBu ttonPager (gv, e, first, previous,
pageSelect, pageCount, next, last);
} else if (e.Row.RowType == DataControlRowT ype.DataRow &&
((e.Row.RowStat e == (DataControlRow State.Alternate |
DataControlRowS tate.Edit)) || e.Row.RowState ==
DataControlRowS tate.Edit)) {
// Set the proper javascript function for the image link to open
the popup calendar
string script = "javascript:ope nCalendar('{0}' , '{1}');";
HyperLink calLink = (HyperLink) e.Row.FindContr ol
("StartDateCale ndarLink");
TextBox startDateTB = (TextBox) e.Row.FindContr ol
("EditStartDate TextBox");
DataRowView dataItem = (DataRowView) e.Row.DataItem;
if (dataItem != null) {
string startDateString = ((DateTime)
dataItem.Row.It emArray[7]).ToString ("d-MMM-yyyy");
calLink.Navigat eUrl = String.Format (script, startDateTB.Cli entID,
Server.UrlEncod e (startDateStrin g));
}
}
}
The premise here is that in the row that gets edited, I have a textbox
with a link to open a pop-up calendar, that will write back the value
to the text box. That part works. The problem is when I try to click
the update button. The page postsback, but it doesn't leave the "edit"
mode. Instead, it comes back and all the textboxes are now blank. If I
type the values back into the textboxes and submit a second time, my
database gets updated, it leaves edit mode, etc (in other words, it
works). If I remove the third else condition in my RowCreated event,
the page works as expected form the get-go (only need to postback once
to have the update occur), but I obviously lose out on my pop-up
calendar.
Anyone got any clues what is going on here?
