

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> function OpenRadWindow(url) { radopen(url, "DisplayWindow"); } </script> </telerik:RadCodeBlock><p> <telerik:RadScriptManager ID="RadScriptManager1" Runat="server"> </telerik:RadScriptManager> <telerik:RadWindowManager ID="RadWindowManager1" runat="server" EnableViewState = "false"> <Windows> <telerik:RadWindow Skin="Sunset" ID="DisplayWindow" runat="server" Title="RadWindow" AutoSize="true" Left="10px" Top="10px" ReloadOnShow="true" Modal="true" ShowContentDuringLoad="false" KeepInScreenBounds="True" /> </Windows> </telerik:RadWindowManager> </p><p><asp:LinkButton ID="LinkButton1" runat="server" OnClick="OpenRadWindow('http://maps.google.com/maps?map_url'); return false;">Map It!</asp:LinkButton> </p><telerik:RadComboBox ID="rcbInitiated" runat="server" DataTextField="userName" MarkFirstMatch="true" DataValueField="eID" EnableLoadOnDemand="true" EnableAutomaticLoadOnDemand="true" ShowMoreResultsBox="false" EnableVirtualScrolling="false" OnClientDropDownClosed="OnClientDropDownClosed" EnableItemCaching="true"> <CollapseAnimation Duration="200" Type="OutQuint" /> <WebServiceSettings Path="~/ws/wsCFR.asmx" Method="GetEIDUserName" /> </telerik:RadComboBox><WebMethod()> _ Public Function GetUserIDUserName(ByVal context As RadComboBoxContext) As RadComboBoxData Return GetItems(context, "userID") End FunctionPublic Function GetItems(ByVal context As RadComboBoxContext, ByVal valueField As String) As RadComboBoxData Dim data As DataTable = GetData(context.Text) Dim comboData As New RadComboBoxData() Dim itemOffset As Integer = context.NumberOfItems Dim endOffset As Integer = Math.Min(itemOffset + ItemsPerRequest, data.Rows.Count) comboData.EndOfItems = endOffset = data.Rows.Count Dim result As New List(Of RadComboBoxItemData)(endOffset - itemOffset) For i As Integer = itemOffset To endOffset - 1 Dim itemData As New RadComboBoxItemData() itemData.Text = data.Rows(i)("userName").ToString() itemData.Value = data.Rows(i)(valueField).ToString() result.Add(itemData) Next comboData.Message = GetStatusMessage(endOffset, data.Rows.Count) comboData.Items = result.ToArray() Return comboData End Functionprotected
void grdSystemComponents_ItemCreated(object sender, GridItemEventArgs e){
if
(e.Item is GridDataItem && e.Item.IsInEditMode || e.Item is GridFilteringItem)
{
foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns)
{
if ((column is GridBoundColumn) && !((GridBoundColumn)column).ReadOnly)
{
TextBox textBox = null;
if (e.Item is GridDataItem)
{
textBox = ((TextBox)((GridDataItem)e.Item)[column.UniqueName].Controls[0]);
textBox.Style["width"] = "90%";
textBox.Style["height"] = "11px";
textBox.Style["border"] = "0px";
textBox.Style["font-size"] = "11px";
} }
//Each column is assigned UniqueName as ID of respective Column
string headerID = column.HeaderText;
int count = dtHeaderInfo.Rows.Count;
for (int i = 0; i < count; i++)
{
if (headerID == dtHeaderInfo.Rows[i][0].ToString())
column.UniqueName = dtHeaderInfo.Rows[i][0].ToString();
} } } }
Here are my two Issues:
1) Since Grid is set up this way, I have no idea how to calculate Footer Total for each columns. Number of column changes depending on the selected Item on Combo Box.
2) I also need to update Caluculation as user will enter number on textboxes of the Grid. In the grid, there is a column called "Tot Num", as user enter numbers here I need to update other columns on same row, user can change it but can't exceed value of "Tot Num" column. If "Tot Number" is zero, should not allow to enter number.
I need to have database interaction for calculation? How do I go go to accomplish this? Your help is much appreciated.
thansk
Madhu