or
Private Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound
If TypeOf e.Item Is GridDataItem Then
Dim item As GridDataItem = DirectCast(e.Item, GridDataItem)
Dim row As DataRowView = DirectCast(e.Item.DataItem, DataRowView)
item("Band").Text = row("Band").ToString()
item("capoptioname").Text = row("capoptioname").ToString()
End If
If (TypeOf e.Item Is GridEditableItem AndAlso CType(e.Item, GridEditableItem).IsInEditMode) Then
Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
Dim editMan As GridEditManager = editedItem.EditManager
Dim editor As GridDropDownListColumnEditor = CType(editMan.GetColumnEditor("Band"), GridDropDownListColumnEditor)
Dim ddlBand As DropDownList = editor.DropDownListControl
Dim ProductBus As New Product
Dim bands As Entities.Product.callbandsDataTable
bands = ProductBus.GetCallBandsList
ddlBand.DataSource = bands
ddlBand.DataTextField = "description"
ddlBand.DataValueField = "value"
ddlBand.DataBind()
End If
End Sub
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
PagerStyle-AlwaysVisible
=
"true"
AllowPaging
=
"True"
AllowSorting
=
"True"
pagesize
=
"25"
pagerposition
=
"bottom"
GridLines
=
"None"
Width
=
"99.9%"
EnableEmbeddedSkins
=
"False"
AllowMultiRowEdit
=
"True"
OnSortCommand
=
"RadGrid1_SortCommand"
ShowStatusBar
=
"True"
Skin
=
"p3"
OnNeedDataSource
=
"RadGrid1_NeedDataSource"
AllowFilteringByColumn
=
"True"
AutoGenerateColumns
=
"False"
CellSpacing
=
"0"
Culture
=
"en-GB"
>
<
MasterTableView
EditMode
=
"inplace"
AllowMultiColumnSorting
=
"true"
DataKeyNames
=
"id"
GridLines
=
"Both"
CommandItemDisplay
=
"Top"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
/>
<
RowIndicatorColumn
FilterControlAltText
=
"Filter RowIndicator column"
Visible
=
"True"
> </
RowIndicatorColumn
>
<
ExpandCollapseColumn
FilterControlAltText
=
"Filter ExpandColumn column"
Visible
=
"True"
> </
ExpandCollapseColumn
>
<
CommandItemTemplate
>
</
CommandItemTemplate
>
<
Columns
>
<
telerik:GridEditCommandColumn
HeaderStyle-Width
=
"4%"
ButtonType
=
"ImageButton"
EditImageUrl
=
"/images/edit.png"
/>
<
telerik:GridBoundColumn
UniqueName
=
"id"
DataField
=
"id"
HeaderText
=
"id"
ReadOnly
=
"True"
HeaderStyle-Width
=
"1%"
Display
=
"False"
> </
telerik:GridBoundColumn
>
<
telerik:GridDropDownColumn
DataField
=
"Band"
HeaderText
=
"Band"
UniqueName
=
"Band"
ColumnEditorID
=
"GridDropDownListColumnEditor1"
HeaderStyle-Width
=
"10%"
ListTextField
=
"description"
ListValueField
=
"value"
EnableEmptyListItem
=
"true"
EmptyListItemValue
=
"0"
EmptyListItemText
=
"please select"
FilterControlAltText
=
"Filter callband column"
DropDownControlType
=
"RadComboBox"
> </
telerik:GridDropDownColumn
>
</
Columns
>
<
PagerStyle
AlwaysVisible
=
"True"
/>
</
MasterTableView
>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"True"
ScrollHeight
=
""
SaveScrollPosition
=
"True"
></
Scrolling
>
</
ClientSettings
>
<
SortingSettings
EnableSkinSortStyles
=
"false"
></
SortingSettings
>
<
PagerStyle
Mode
=
"NumericPages"
/>
</
telerik:RadGrid
>
<
telerik:GridDropDownListColumnEditor
ID
=
"GridDropDownListColumnEditor1"
runat
=
"server"
DropDownStyle-Width
=
"200px"
> </
telerik:GridDropDownListColumnEditor
>
function onGridCreated(sender, eventArgs) {
if (rowIsSelected()) {
.....
function rowIsSelected() {
var getSeletecteRow=getSelectedRow();
......
function getSelectedRow() {
var employeeSummaryGrid = $find('<%=EmployeeSummaryGrid.ClientID%>');
if (employeeSummaryGrid != null)
{
var MasterTable = employeeSummaryGrid.get_masterTableView(); //this is returning null in some cases
return MasterTable.get_selectedItems()[0];
}
return null;
}
function
RadListBox1Deleting(sender, arg) {
var
callBackFunction = Function.createDelegate(sender,
function
(shouldSubmit) {
if
(shouldSubmit) {
// call server side RadListBox1Deleted
}
});
var
text =
"Are you sure you want to delete?"
;
radconfirm(text, callBackFunction, 300, 100,
null
,
"Deleting"
);
arg.set_cancel(
true
);
}
}
protected
void
LoadYear()
{
SqlConnection connection =
new
SqlConnection(ConfigurationManager.ConnectionStrings[
"HolidayTrackerConnectionString"
].ConnectionString);
SqlDataAdapter adapter =
new
SqlDataAdapter(
"SELECT * FROM HtVacationDay"
, connection);
DataTable dt =
new
DataTable();
adapter.Fill(dt);
rcbYear.DataTextField =
"FromDate"
;
rcbYear.DataValueField =
"VacationDayId"
;
rcbYear.DataSource = dt;
rcbYear.DataBind();
rcbYear.Items.Insert(0,
new
RadComboBoxItem(
"-Select a Year-"
));
}
Hi all member
I have a grid in asp and add GridColumnGroup and column in code behind.
i add in page load event before i set value for colums but when page post back to server raise error
Invalid column name:
this my code
plase help to me
thanks
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
txtDate.Text = clsMain.GetPersianDate();
CreateStructureTable();
fillZoneData();
fillAreaData();
fillPlacetype();
if (objZone.dtblZone.Rows.Count == 0 || objArea.dtblZone.Rows.Count==0)
{
string script = "Error('شما به منطقه ای مشخص دسترسی ندارید')";
// ScriptManager.RegisterStartupScript(this, GetType(), "MyKey", script, true);
}
else
{
FillPlaceInTable();
FillDataInTable();
}
}
}
private void CreateStructureTable()
{
int i = 0;
string s = "";
#region "GridClear"
dgdZone.MasterTableView.Columns.Clear();
// dgdZone0.MasterTableView.Columns.Clear();
dgdZone.MasterTableView.ColumnGroups.Clear();
#endregion
#region "GridColumnGroup"
objContractItem.dtblContractItem = clsMain.SelectByCondition("Select * from vContractItem where iNumber In(Select iParentNumber from vContractItem) Order by ContractItemLevel asc");
for (i = 0; i <= objContractItem.dtblContractItem.Rows.Count - 1; i++)
{
if (!dgdZone.MasterTableView.ColumnGroups.Contains(objContractItem.dtblContractItem.Rows[i]["iNumber"]))
{
GridColumnGroup grp = new GridColumnGroup();
grp.HeaderText = objContractItem.dtblContractItem.Rows[i]["strName"].ToStr().Replace(" ", "").Replace(":", "");
grp.Name = "grp" + objContractItem.dtblContractItem.Rows[i]["iNumber"].ToStr().Replace(" ", "").Replace(":", "");
grp.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
grp.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
if (objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToInt() != 0)
{
grp.ParentGroupName = "grp" + objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr().Replace(" ", "").Replace(":", "");
}
dgdZone.MasterTableView.ColumnGroups.Add(grp);
}
}
#endregion
//------------------------------ردیف
Telerik.Web.UI.GridBoundColumn iRowNumber = new Telerik.Web.UI.GridBoundColumn();
dgdZone.MasterTableView.Columns.Add(iRowNumber);
//dgdZone0.MasterTableView.Columns.Add(iRowNumber);
iRowNumber.HeaderText = "ردیف";
iRowNumber.UniqueName = "iRowNumber";
iRowNumber.DataField = "iRowNumber";
iRowNumber.Visible = true;
iRowNumber.HeaderStyle.Width = Unit.Pixel(40);
iRowNumber.ItemStyle.Width = Unit.Pixel(20);
iRowNumber.ForceExtractValue = GridForceExtractValues.Always;
iRowNumber.AllowFiltering = false;
iRowNumber.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
iRowNumber.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
iRowNumber.ItemStyle.VerticalAlign = VerticalAlign.Middle;
iRowNumber.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
dt.Columns.Add("iRowNumber", i.GetType());
dt2.Columns.Add("iRowNumber", s.GetType());
//------------------------------------------
//------------------------شناسه محل
Telerik.Web.UI.GridBoundColumn iZonePlaceNumberCol = new Telerik.Web.UI.GridBoundColumn();
dgdZone.MasterTableView.Columns.Add(iZonePlaceNumberCol);
// dgdZone0.MasterTableView.Columns.Add(iZonePlaceNumberCol);
iZonePlaceNumberCol.HeaderText = "iZonePlaceNumber";
iZonePlaceNumberCol.UniqueName = "iZonePlaceNumber";
iZonePlaceNumberCol.DataField = "iZonePlaceNumber";
iZonePlaceNumberCol.Visible = false;
iZonePlaceNumberCol.ForceExtractValue = GridForceExtractValues.Always;
dt.Columns.Add("iZonePlaceNumber", i.GetType());
dt.Columns.Add("strPlaceName", s.GetType());
//------------------------------
//--------------------------------نام محل
Telerik.Web.UI.GridBoundColumn strPlaceNameCol = new Telerik.Web.UI.GridBoundColumn();
dgdZone.MasterTableView.Columns.Add(strPlaceNameCol);
// dgdZone0.MasterTableView.Columns.Add(strPlaceNameCol);
strPlaceNameCol.HeaderText = "نام محل";
strPlaceNameCol.UniqueName = "strPlaceName";
strPlaceNameCol.DataField = "strPlaceName";
strPlaceNameCol.Visible = true;
strPlaceNameCol.HeaderStyle.Width = Unit.Pixel(180);
strPlaceNameCol.ItemStyle.Width = Unit.Pixel(180);
strPlaceNameCol.ForceExtractValue = GridForceExtractValues.Always;
strPlaceNameCol.AllowFiltering = false;
strPlaceNameCol.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
strPlaceNameCol.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
strPlaceNameCol.ItemStyle.VerticalAlign = VerticalAlign.Middle;
strPlaceNameCol.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
strPlaceNameCol.AllowSorting = false;
strPlaceNameCol.AllowFiltering = false;
dt2.Columns.Add("iZonePlaceNumber", i.GetType());
dt2.Columns.Add("strPlaceName", s.GetType());
//------------------------------
objContractItem.dtblContractItem = clsMain.SelectByCondition("Select * from vContractItem where bShowDailyReport=1" + " Order by iParentNumber asc");
for (i = 0; i <= objContractItem.dtblContractItem.Rows.Count - 1; i++)
{
Telerik.Web.UI.GridBoundColumn col = new Telerik.Web.UI.GridBoundColumn();
if (objContractItem.dtblContractItem.Rows[i]["bIncomplete"].ToBool() == true)
{
// dgdZone0.MasterTableView.Columns.Add(col);
dt2.Columns.Add(objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(), i.GetType());
}
else
{
dgdZone.MasterTableView.Columns.Add(col);
dt.Columns.Add(objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(), i.GetType());
}
if (objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr().Length > 0)
{
//col.ColumnGroupName = "grp" + objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr();
}
col.UniqueName =objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString();
col.DataField = objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString();
col.ForceExtractValue = GridForceExtractValues.Always;
col.HeaderText = objContractItem.dtblContractItem.Rows[i]["strName"].ToString();
col.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
col.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
col.ItemStyle.VerticalAlign = VerticalAlign.Middle;
col.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
col.HeaderStyle.Width = Unit.Pixel(100);
col.AllowSorting = false;
col.AllowFiltering = false;
col.Groupable = false;
}
// }
GlobalMActivity.dt = dt;
GlobalMActivity.dt2 = dt2;
dgdZone.DataSource = dt;
//dgdZone0.DataSource = dt2;
dgdZone.DataBind();
// dgdZone0.DataBind();
}
...
<
script
>
function pbBtn1() {
__doPostBack("button1", "")
}
</
script
>
</
asp:Content
>
<
asp:Content
ID
=
"Content2"
ContentPlaceHolderID
=
"ContentPlaceHolder1"
runat
=
"Server"
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"button1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"rts"
LoadingPanelID
=
"RadAjaxLoadingPanel3"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"rmp"
LoadingPanelID
=
"RadAjaxLoadingPanel3"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel3"
runat
=
"server"
/>
<
div
class
=
"mainContent_bg"
>
<
div
class
=
"mainContentContainerContent"
>
<
div
class
=
"spessore10"
></
div
>
<
br
/>
<
br
/>
<
div
id
=
"xls"
>
<
telerik:RadTabStrip
ID
=
"rts"
runat
=
"server"
MultiPageID
=
"rmp"
OnClientTabSelected
=
"pbBtn1"
>
<
Tabs
>
<
telerik:RadTab
Text
=
"page1"
selected
=
"true"
PageViewID
=
"page1"
></
telerik:RadTab
>
<
telerik:RadTab
Text
=
"page2"
selected
=
"false"
PageViewID
=
"page2"
></
telerik:RadTab
>
</
Tabs
>
</
telerik:RadTabStrip
>
<
telerik:RadMultiPage
ID
=
"rmp"
runat
=
"server"
>
<
telerik:RadPageView
runat
=
server
ID
=
"page1"
Selected
=
true
BorderColor
=
"Black"
Height
=
500
BackColor
=
"Gray"
>
<
asp:Label
ID
=
lb1
runat
=
server
Text
=
"Label1 base"
></
asp:Label
>
<
br
/>
</
telerik:RadPageView
>
<
telerik:RadPageView
runat
=
server
ID
=
"page2"
BorderColor
=
"Black"
Height
=
500
BackColor
=
"Gray"
>
<
asp:Label
ID
=
lb2
runat
=
server
Text
=
"Label2 base"
></
asp:Label
>
<
br
/>
<
br
/>
</
telerik:RadPageView
>
</
telerik:RadMultiPage
>
</
div
>
<
telerik:radButton
ID
=
"button1"
runat
=
"server"
Text
=
button1
/>
<
asp:Button
ID
=
"button2"
runat
=
"server"
OnClientClick
=
"pbBtn1()"
Text
=
button2
/>