gv1.MasterTableView.Columns.Clear(); and gv1.Columns.Clear(); methods but they have not worked for me.
Please help me to fix this. Sample code will be greatly appreciated.
Thanks,
Sumanth
I have two comboboxes that are inside a panel control. The panel's visibility is false initially. When the user selects an option, the panel with the 2 combo boxes is made visible. Depending on what the user selects in the first combo box, I need to enable or disable the second combo box client side. However, I am unable to access the combo using $find('<%= cbxAdminAction.ClientID %>').
I have also tried accessing the combo boxes usingTelerik.Web.UI.RadComboBox.ComboBoxes.
I was able to find the combo controls in the Firebug console. However, when the page loads, Telerik.Web.UI.RadComboBox.ComboBoxes[14] is out of range.
How do I access the combo boxes from client side?
The function below is wired to the onClientSelectedIndexChanged event for the first combo box.
01.
function
EnableSubActionDropDown(combo, eventArgs)
02.
{
03.
var
value = Telerik.Web.UI.RadComboBox.ComboBoxes[14].get_value();
04.
05.
if
(value !=
"99"
)
06.
{
07.
Telerik.Web.UI.RadComboBox.ComboBoxes[15].disable;
08.
}
09.
else
10.
{
11.
Telerik.Web.UI.RadComboBox.ComboBoxes[15].enable;
12.
}
13.
}
if (ControlToLoad == "ConCapitalDetailsPS")
{
Financial.ConCapitalDetails ucConCapitalDetails = Page.LoadControl("~/Grants/Phases/Financial/ConCapitalDetails.ascx") as Financial.ConCapitalDetails;
ucConCapitalDetails.ID = "ConCapitalDetailsPS";
PhaseContent.Controls.Clear();
PhaseContent.Controls.Add(ucConCapitalDetails);
ucConCapitalDetails.ActivePhase = ActivePhase;
ucConCapitalDetails.BindData();
}
protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
//int iGrantID = ActivePhase.GrantId;
//int iPhaseID = ActivePhase.Id;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Thc.Gms.Services;
using Thc.Gms.Core;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data;
using System.Transactions;
using System.Data.Common;
using Telerik.Web.UI;
namespace Thc.Gms.Web.UI.Grants.Phases.Financial
{
public partial class HistoricExpenditures : System.Web.UI.UserControl
{
public Thc.Gms.Core.Phase ActivePhase
{
get { return ViewState["Phase"] as Thc.Gms.Core.Phase; }
set
{
this.ViewState.Add("Phase", value);
}
}
protected void Page_Load(object sender, EventArgs e)
{
}
protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
Thc.Gms.Core.Phase ActivePhaseSession = (Phase)Session["ActivePhase"];
int iGrantID = 267;
int iPhaseID = 1517;
//int iGrantID = ActivePhase.GrantId;
//int iPhaseID = ActivePhase.Id;
//GrantService gService = new GrantService();
//Grant grant = gService.FindBy(ActivePhase.GrantId);
//City.Text = grant.Address.City;
//State.Text = grant.Address.State.Abbreviation;
//GrantName.Text = grant.Name;
//PhaseNameTitle.Text = ActivePhase.Name;
string sql = "[dbo].[financial_getExpendituresByFtaskId]";
Database _database = DatabaseFactory.CreateDatabase("GMSData");
DataSet tempDataset = new DataSet();
DataTable DetailsData = new DataTable("Details");
DetailsData.Columns.Add("ftaskid");
DetailsData.Columns.Add("level2", typeof(string));
tempDataset.Tables.Add(DetailsData);
using (TransactionScope scope = new TransactionScope())
{
using (DbCommand command = _database.GetStoredProcCommand(sql))
{
_database.AddInParameter(command, "@grantid", DbType.Int32, iGrantID);
_database.AddInParameter(command, "@phaseid", DbType.Int32, iPhaseID);
_database.LoadDataSet(command, tempDataset, "Details");
}
scope.Complete();
}
RadGrid1.DataSource = tempDataset;
}
public void BindData()
{
//int iGrantID = ActivePhase.GrantId;
//int iPhaseID = ActivePhase.Id;
//GrantService gService = new GrantService();
//Grant grant = gService.FindBy(ActivePhase.GrantId);
//City.Text = grant.Address.City;
//State.Text = grant.Address.State.Abbreviation;
//GrantName.Text = grant.Name;
//PhaseNameTitle.Text = ActivePhase.Name;
//string sql = "[dbo].[financial_getExpendituresByFtaskId]";
//Database _database = DatabaseFactory.CreateDatabase("GMSData");
//DataSet tempDataset = new DataSet();
//DataTable DetailsData = new DataTable("Details");
//DetailsData.Columns.Add("ftaskid");
//DetailsData.Columns.Add("level2", typeof(string));
//tempDataset.Tables.Add(DetailsData);
//using (TransactionScope scope = new TransactionScope())
//{
// using (DbCommand command = _database.GetStoredProcCommand(sql))
// {
// _database.AddInParameter(command, "@grantid", DbType.Int32, iGrantID);
// _database.AddInParameter(command, "@phaseid", DbType.Int32, iPhaseID);
// _database.LoadDataSet(command, tempDataset, "Details");
// }
// scope.Complete();
//}
//RadGrid1.DataSource = tempDataset;
//RadGrid1.DataBind();
}
protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
{
int iGrantID = ActivePhase.GrantId;
int iPhaseID = ActivePhase.Id;
int iUserID = SessionHelper.CurrentUser.Id;
GridEditableItem editedItem = e.Item as GridEditableItem;
int iFTaskID = Int32.Parse(editedItem.GetDataKeyValue("ftaskid").ToString());
int iQtr = Int32.Parse((editedItem["Qtr"].Controls[0] as TextBox).Text);
int iYear = Int32.Parse((editedItem["Year"].Controls[0] as TextBox).Text);
decimal dHP6 = decimal.Parse((editedItem["H6_Exp"].Controls[0] as TextBox).Text);
decimal dPH6 = decimal.Parse((editedItem["PH_Exp"].Controls[0] as TextBox).Text);
decimal dOth6 = decimal.Parse((editedItem["Oth_Exp"].Controls[0] as TextBox).Text);
decimal dFF6 = decimal.Parse((editedItem["FF_Exp"].Controls[0] as TextBox).Text);
Dictionary<
string
, decimal> ExpColl = new Dictionary<
string
, decimal>();
ExpColl.Add("H6", dHP6);
ExpColl.Add("PH", dPH6);
ExpColl.Add("Oth", dOth6);
ExpColl.Add("FF", dFF6);
foreach (KeyValuePair<
string
, decimal> item in ExpColl)
{
string sql = "[dbo].[financial_setExpendituresByYearQtr]";
Database _database = DatabaseFactory.CreateDatabase("GMSData");
using (TransactionScope scope = new TransactionScope())
{
using (DbCommand command = _database.GetStoredProcCommand(sql))
{
_database.AddInParameter(command, "@grantid", DbType.Int32, iGrantID);
_database.AddInParameter(command, "@phaseid", DbType.Int32, iPhaseID);
_database.AddInParameter(command, "@ftaskId", DbType.Int32, iFTaskID);
_database.AddInParameter(command, "@amount", DbType.Decimal, item.Value);
_database.AddInParameter(command, "@fundtype ", DbType.String, item.Key);
_database.AddInParameter(command, "@year", DbType.Int32, iYear);
_database.AddInParameter(command, "@qtr", DbType.Int32, iQtr);
_database.AddInParameter(command, "@userid", DbType.Int32, iUserID);
_database.ExecuteNonQuery(command);
}
scope.Complete();
}
}
}
protected void RadGrid1_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
{
int iGrantID = ActivePhase.GrantId;
int iPhaseID = ActivePhase.Id;
GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
int iCategoryID = Int32.Parse(dataItem.GetDataKeyValue("FTaskID").ToString());
string sql = "[dbo].[financial_getExpendituresOVerTime]";
Database _database = DatabaseFactory.CreateDatabase("GMSData");
DataSet tempDataset = new DataSet();
DataTable DetailsData = new DataTable("Details");
DetailsData.Columns.Add("ftaskid");
DetailsData.Columns.Add("qtr", typeof(int));
DetailsData.Columns.Add("year", typeof(int));
DetailsData.Columns.Add("H6_Exp", typeof(decimal));
DetailsData.Columns.Add("H6_Use", typeof(decimal));
DetailsData.Columns.Add("PH_Exp", typeof(decimal));
DetailsData.Columns.Add("PH_Use", typeof(decimal));
DetailsData.Columns.Add("Oth_Exp", typeof(decimal));
DetailsData.Columns.Add("Oth_Use", typeof(decimal));
DetailsData.Columns.Add("FF_Exp", typeof(decimal));
DetailsData.Columns.Add("FF_Use", typeof(decimal));
tempDataset.Tables.Add(DetailsData);
using (TransactionScope scope = new TransactionScope())
{
using (DbCommand command = _database.GetStoredProcCommand(sql))
{
_database.AddInParameter(command, "@grantid", DbType.Int32, iGrantID);
_database.AddInParameter(command, "@phaseid", DbType.Int32, iPhaseID);
_database.AddInParameter(command, "@ftaskId", DbType.Int32, iCategoryID);
_database.LoadDataSet(command, tempDataset, "Details");
}
scope.Complete();
}
RadGrid1.DataSource = tempDataset;
// RadGrid1.DataBind();
}
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditFormItem && e.Item.IsInEditMode && e.Item.OwnerTableView.Name == "GridDetails")
{
GridEditFormItem editItem = (GridEditFormItem)e.Item;
if (false)
{
TextBox txt = (TextBox)editItem.FindControl("unH6_Exp");
txt.ReadOnly = true;
}
}
}
}
}
<
telerik:RadFormDecorator
ID
=
"RadFormDecorator1"
runat
=
"server"
EnableEmbeddedSkins
=
"false"
Skin
=
"Custom"
/>
<
telerik:RadSiteMap
ID
=
"RadSiteMap1"
runat
=
"server"
ShowNodeLines
=
"True"
EnableEmbeddedSkins
=
"False"
Skin
=
"Custom"
>
<
Nodes
>
<
telerik:RadSiteMapNode
runat
=
"server"
NavigateUrl
=
"~/Administrator/AdminHome.aspx"
Text
=
"Administrator Home"
ToolTip
=
"Administrator Home"
>
<
Nodes
>
<
telerik:RadSiteMapNode
runat
=
"server"
NavigateUrl
=
"~/Administrator/DeleteRoutine.aspx"
Text
=
"Delete Class Routine"
ToolTip
=
"Delete Class Routine"
>
</
telerik:RadSiteMapNode
>
<
telerik:RadSiteMapNode
runat
=
"server"
NavigateUrl
=
"~/Administrator/DeleteUser.aspx"
Text
=
"Delete User"
ToolTip
=
"Delete User"
>
</
telerik:RadSiteMapNode
>
<
telerik:RadSiteMapNode
runat
=
"server"
NavigateUrl
=
"~/Administrator/RoutineFileUpload.aspx"
Text
=
"Upload Class Routine"
ToolTip
=
"Upload Class Routine"
>
</
telerik:RadSiteMapNode
>
<
telerik:RadSiteMapNode
runat
=
"server"
NavigateUrl
=
"~/Administrator/UsersProfileEdit.aspx"
Text
=
"Edit Profile"
ToolTip
=
"Edit Profile"
>
</
telerik:RadSiteMapNode
>
<
telerik:RadSiteMapNode
runat
=
"server"
NavigateUrl
=
"~/Administrator/UsersProfileView.aspx"
Text
=
"View Profile"
ToolTip
=
"View Profile"
>
</
telerik:RadSiteMapNode
>
</
Nodes
>
</
telerik:RadSiteMapNode
>
</
Nodes
>
</
telerik:RadSiteMap
>
<
link
href
=
"../CustomSkin/SiteMap.Custom.css"
rel
=
"stylesheet"
type
=
"text/css"
/>
<
link
href
=
"../CustomSkin/FormDecorator.Custom.css"
rel
=
"stylesheet"
type
=
"text/css"
/>
GridEditCommandColumn
's and depending on there UniqueNames I want to display different content in the edit-form.
my radgid:
<
telerik:RadGrid
ID
=
"ConcertsRadGrid"
runat
=
"server"
Skin
=
"WebBlue"
AllowFilteringByColumn
=
"false"
GridLines
=
"None"
AllowPaging
=
"True"
AllowSorting
=
"True"
AutoGenerateColumns
=
"False"
ShowStatusBar
=
"true"
OnPreRender
=
"ConcertsRadGrid_PreRender"
OnNeedDataSource
=
"ConcertsRadGrid_NeedDataSource"
onitemcommand
=
"ConcertsRadGrid_ItemCommand1"
>
<
MasterTableView
GridLines
=
"None"
Width
=
"100%"
Dir
=
"RTL"
CommandItemDisplay
=
"None"
DataKeyNames
=
"CnsrtID"
>
<
Columns
>
<
telerik:GridBoundColumn
UniqueName
=
"CType"
HeaderText="<%$ Resources:Resource, PagesConcertsRadGridCTypeColumn %>" DataField="CType">
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"CnsrtName"
HeaderText="<%$ Resources:Resource, PagesConcertsRadGridCnsrtNameColumn %>" DataField="CnsrtName">
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"Choirs"
HeaderText="<%$ Resources:Resource, PagesConcertsRadGridChoirsColumn %>" DataField="Choirs">
</
telerik:GridBoundColumn
>
<
telerik:GridEditCommandColumn
UniqueName
=
"EditCommandColumn1"
EditText="<%$ Resources:Resource, PagesConcertsRadGridViewCnsrtColumn %>">
</
telerik:GridEditCommandColumn
>
<
telerik:GridEditCommandColumn
UniqueName
=
"EditCommandColumn2"
EditText="<%$ Resources:Resource, PagesConcertsRadGridViewCnsrtColumn %>">
</
telerik:GridEditCommandColumn
>
</
Columns
>
<
EditFormSettings
UserControlName
=
"~/Pages/Concerts/ConcertsSubUserControl.ascx"
EditFormType
=
"WebUserControl"
>
<
EditColumn
UniqueName
=
"EditCommandColumn1"
>
</
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
</
telerik:RadGrid
>