Welcome Guest Search | Active Topics | Sign In | Register

Saving changes from the grid Options
DiscoverSoft
Posted: Thursday, March 17, 2011 4:19:11 PM
Rank: Advanced Member
Groups: Member

Joined: 2/27/2010
Posts: 69
Could you please tell me what the heck is wrong with this code? I can't get a postback return any changes to the grid to save my life. I need the FullRowMode="False" so we don't have to use the edit link.


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>

<eo:Grid ID="Grid1" runat="server" BorderColor="#828790" BorderWidth="1px"
ColumnHeaderAscImage="00050204" ColumnHeaderDescImage="00050205"
ColumnHeaderDividerImage="00050203" ColumnHeaderHeight="24"
FixedColumnCount="1" Font-Bold="False" Font-Italic="False" Font-Names="Tahoma"
Font-Overline="False" Font-Size="8.75pt" Font-Strikeout="False"
Font-Underline="False" FullRowMode="False" GridLineColor="240, 240, 240"
GridLines="Both" Height="200px" ItemHeight="19" Width="372px">
<FooterStyle CssText="padding-bottom:4px;padding-left:4px;padding-right:4px;padding-top:4px;" />
<ItemStyles>
<eo:GridItemStyleSet>
<ItemStyle CssText="background-color: white" />
<ItemHoverStyle CssText="background-image: url(00050206); background-repeat: repeat-x" />
<SelectedStyle CssText="background-image: url(00050207); background-repeat: repeat-x" />
<CellStyle CssText="padding-left:8px;padding-top:2px;white-space:nowrap;" />
</eo:GridItemStyleSet>
</ItemStyles>
<ColumnTemplates>
<eo:TextBoxColumn>
<TextBoxStyle CssText="BORDER-RIGHT: #7f9db9 1px solid; PADDING-RIGHT: 2px; BORDER-TOP: #7f9db9 1px solid; PADDING-LEFT: 2px; FONT-SIZE: 8.75pt; PADDING-BOTTOM: 1px; MARGIN: 0px; BORDER-LEFT: #7f9db9 1px solid; PADDING-TOP: 2px; BORDER-BOTTOM: #7f9db9 1px solid; FONT-FAMILY: Tahoma" />
</eo:TextBoxColumn>
<eo:DateTimeColumn>
<DatePicker ControlSkinID="None" DayCellHeight="16" DayCellWidth="19"
DayHeaderFormat="FirstLetter" DisabledDates="" OtherMonthDayVisible="True"
SelectedDates="" TitleLeftArrowImageUrl="DefaultSubMenuIconRTL"
TitleRightArrowImageUrl="DefaultSubMenuIcon">
<TodayStyle CssText="font-family: tahoma; font-size: 12px; border-right: #bb5503 1px solid; border-top: #bb5503 1px solid; border-left: #bb5503 1px solid; border-bottom: #bb5503 1px solid" />
<SelectedDayStyle CssText="font-family: tahoma; font-size: 12px; background-color: #fbe694; border-right: white 1px solid; border-top: white 1px solid; border-left: white 1px solid; border-bottom: white 1px solid" />
<DisabledDayStyle CssText="font-family: tahoma; font-size: 12px; color: gray; border-right: white 1px solid; border-top: white 1px solid; border-left: white 1px solid; border-bottom: white 1px solid" />
<PickerStyle CssText="border-bottom-color:#7f9db9;border-bottom-style:solid;border-bottom-width:1px;border-left-color:#7f9db9;border-left-style:solid;border-left-width:1px;border-right-color:#7f9db9;border-right-style:solid;border-right-width:1px;border-top-color:#7f9db9;border-top-style:solid;border-top-width:1px;font-family:Courier New;font-size:8pt;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:1px;padding-left:2px;padding-right:2px;padding-top:2px;" />
<CalendarStyle CssText="background-color: white; border-right: #7f9db9 1px solid; padding-right: 4px; border-top: #7f9db9 1px solid; padding-left: 4px; font-size: 9px; padding-bottom: 4px; border-left: #7f9db9 1px solid; padding-top: 4px; border-bottom: #7f9db9 1px solid; font-family: tahoma" />
<TitleArrowStyle CssText="cursor:hand" />
<DayHoverStyle CssText="font-family: tahoma; font-size: 12px; border-right: #fbe694 1px solid; border-top: #fbe694 1px solid; border-left: #fbe694 1px solid; border-bottom: #fbe694 1px solid" />
<MonthStyle CssText="font-family: tahoma; font-size: 12px; margin-left: 14px; cursor: hand; margin-right: 14px" />
<TitleStyle CssText="background-color:#9ebef5;font-family:Tahoma;font-size:12px;padding-bottom:2px;padding-left:6px;padding-right:6px;padding-top:2px;" />
<OtherMonthDayStyle CssText="font-family: tahoma; font-size: 12px; color: gray; border-right: white 1px solid; border-top: white 1px solid; border-left: white 1px solid; border-bottom: white 1px solid" />
<DayHeaderStyle CssText="font-family: tahoma; font-size: 12px; border-bottom: #aca899 1px solid" />
<DayStyle CssText="font-family: tahoma; font-size: 12px; border-right: white 1px solid; border-top: white 1px solid; border-left: white 1px solid; border-bottom: white 1px solid" />
</DatePicker>
</eo:DateTimeColumn>
<eo:MaskedEditColumn>
<MaskedEdit ControlSkinID="None"
TextBoxStyle-CssText="BORDER-RIGHT: #7f9db9 1px solid; PADDING-RIGHT: 2px; BORDER-TOP: #7f9db9 1px solid; PADDING-LEFT: 2px; PADDING-BOTTOM: 1px; MARGIN: 0px; BORDER-LEFT: #7f9db9 1px solid; PADDING-TOP: 2px; BORDER-BOTTOM: #7f9db9 1px solid; font-family:Courier New;font-size:8pt;">
</MaskedEdit>
</eo:MaskedEditColumn>
</ColumnTemplates>
<ColumnHeaderHoverStyle CssText="background-image:url('00050202');padding-left:8px;padding-top:4px;" />
<Columns>
<eo:RowNumberColumn Width="20">
</eo:RowNumberColumn>
<eo:StaticColumn DataField="CustRef" HeaderText="Ref ID" Name="CustRef">
</eo:StaticColumn>
<eo:StaticColumn DataField="WorkOrderNumber" HeaderText="WO#">
</eo:StaticColumn>
<eo:TextBoxColumn DataField="AssignedToTech" HeaderText="Assigned To"
Name="AssignedToTech">
</eo:TextBoxColumn>
</Columns>
<ColumnHeaderStyle CssText="background-image:url('00050201');padding-left:8px;padding-top:4px;" />
</eo:Grid>

</div>
<asp:Button ID="btnSave" runat="server" Text="Save" />
</form>
</body>
</html>


Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Dim connStr As String = getDataConnection()
Dim conn As New SqlClient.SqlConnection(connStr)
conn.Open()



Dim myCmd As New SqlClient.SqlCommand
myCmd.Connection = conn
myCmd.CommandType = CommandType.StoredProcedure
myCmd.CommandText = "SP_StatusMonitor"
myCmd.Parameters.Add(New SqlClient.SqlParameter("@AssignedTo", SqlDbType.Int)).Value = 4


Dim FiveDays As String = ConfigurationManager.AppSettings("5DayVal").ToString() '30
Dim ThreeDays As String = ConfigurationManager.AppSettings("3DayVal").ToString() '30

myCmd.Parameters.Add(New SqlClient.SqlParameter("@5DayVal", SqlDbType.Int)).Value = FiveDays
myCmd.Parameters.Add(New SqlClient.SqlParameter("@3DayVal", SqlDbType.Int)).Value = ThreeDays

Dim reader As SqlClient.SqlDataReader
reader = myCmd.ExecuteReader()
Grid1.DataSource = reader
Grid1.DataBind()

End Sub

Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnSave.Click
Debug.Print(Grid1.ChangedItems.Length)

End Sub
------------------------------------------------------------------------------------------------------------------
eo_support
Posted: Thursday, March 17, 2011 4:22:11 PM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
Hi,

You are repopulating the Grid (thus wipes our all changes) every time in your Page_Load. Remember Page_Load is also called during post back.

Thanks!
DiscoverSoft
Posted: Thursday, March 17, 2011 4:42:34 PM
Rank: Advanced Member
Groups: Member

Joined: 2/27/2010
Posts: 69
Dah!! Thanks, I just noticed that too!
eo_support
Posted: Thursday, March 17, 2011 4:46:25 PM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
No problem. You worked too hard. : )


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.