<
telerik:RadComboBox
ID
=
"ddlState"
runat
=
"server"
AllowCustomText
=
"true"
MaxHeight
=
"100px"
EnableAutomaticLoadOnDemand
=
"true"
></
telerik:RadComboBox
>
public
void
fillState(
long
countryId)
{
g_frontendDataContext fdc =
new
g_frontendDataContext();
try
{
var states = from i
in
fdc.tbl_sfl_states
where i.fk_country_id == countryId
select
new
{
stateId = i.pk_state_id,
stateName = i.state_name
};
ddlState.DataSource = states.ToList();
ddlState.DataBind();
ddlState.DataTextField =
"stateName"
;
ddlState.DataValueField =
"stateId"
;
fdc.Dispose();
}
}
protected void dgdZone_InsertCommand(object sender, GridCommandEventArgs e)
{
Hashtable newValues = new Hashtable();
GridEditableItem editedItem = e.Item as GridEditableItem;
e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem);
objZone.SelectAll();
if (objZone.dtblZone.Select("strName='" + newValues["strName"].ToString() + "'").Length == 0)
{
objZone.StrName = newValues[
"strName"].ToString();
objZone.StrAddress = newValues[
"strAddress"].ToString();
objZone.Insert();
}
else
{
}
}
newValues is null therefor cause this error
<
body>
<form id="form1" method="post" runat="server">
<div>
<telerik:RadScriptManager ID="RadScriptManager1" Runat="server">
</telerik:RadScriptManager>
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="dgdZone">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="dgdZone" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadGrid ID="dgdZone" runat="server" AutoGenerateColumns="False" MasterTableView-Dir="RTL"
CellSpacing="0" GridLines="None" Width="50%" AutoGenerateHierarchy="True"
Skin="Outlook" onneeddatasource="dgdZone_NeedDataSource"
oninsertcommand="dgdZone_InsertCommand"
onupdatecommand="dgdZone_UpdateCommand" ondeletecommand="dgdZone_DeleteCommand">
<ClientSettings>
<Selecting AllowRowSelect="True" EnableDragToSelectRows="True" />
</ClientSettings>
<ExportSettings FileName="ErikaGridExport">
</ExportSettings>
<ClientSettings>
<Selecting AllowRowSelect="True" />
</ClientSettings>
<
MasterTableView HierarchyLoadMode="Client" CommandItemDisplay="Top" Dir="RTL" EditMode="EditForms" Font-Names="Tahoma">
<
CommandItemTemplate>
<telerik:RadButton ID="btnEdit" CommandName="EditSelected" runat="server" Skin="Office2007" Font-Names="tahoma" Font-Size="8.5pt" Visible='<%# dgdZone.EditIndexes.Count == 0 %>' Text="ویرایش">
</telerik:RadButton>
<telerik:RadButton ID="btnCancel" CommandName="CancelAll" runat="server" Skin="Office2010Blue" Font-Names="tahoma" Font-Size="8.5pt" Text="انصراف" Visible='<%# dgdZone.EditIndexes.Count > 0 || dgdZone.MasterTableView.IsItemInserted %>'></telerik:RadButton>
<telerik:RadButton ID="btnSave" CommandName="UpdateEdited" runat="server" Skin="Office2010Blue" Font-Names="tahoma" Font-Size="8.5pt" Text="ذخیره" Visible='<%# dgdZone.EditIndexes.Count > 0 %>'></telerik:RadButton>
<telerik:RadButton ID="btnNew" CommandName="InitInsert" runat="server" Skin="Office2010Blue" Font-Names="tahoma" Font-Size="8.5pt" Text="منطقه جدید" Visible='<%# !dgdZone.MasterTableView.IsItemInserted %>'></telerik:RadButton>
<telerik:RadButton ID="btnSaveNewItem" CommandName="PerformInsert" Skin="Office2010Blue" Font-Names="tahoma" Font-Size="8.5pt" runat="server" Text="ثبت منطقه جدید" Visible='<%# dgdZone.MasterTableView.IsItemInserted %>'></telerik:RadButton>
<telerik:RadButton ID="btnDelete" CommandName="DeleteSelected" Skin="Office2010Blue" Font-Names="tahoma" Font-Size="8.5pt" runat="server" Text="حذف"></telerik:RadButton>
<%
--<telerik:RadToolBar ID="RadToolBar1" runat="server" OnClientButtonClicking="onToolBarClientButtonClicking" OnButtonClick="RadToolBar1_ButtonClick" Skin="Outlook">
<Items>
<telerik:RadToolBarButton Text="ویرایش" Font-Names="Tahoma" CommandName="EditSelected" ImageUrl="StyleStandars/Images/users_into.png" Visible='<%# dgdZone.EditIndexes.Count == 0 %>'></telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="ذخیره" CommandName="UpdateEdited" ImageUrl="StyleStandars/Images/users_into.png" Visible='<%# dgdZone.EditIndexes.Count > 0 %>'></telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="انصراف" CommandName="CancelAll" ImageUrl="StyleStandars/Images/users_into.png" Visible='<%# dgdZone.EditIndexes.Count > 0 || dgdZone.MasterTableView.IsItemInserted %>'></telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="منطقه جدید" CommandName="InitInsert" ImageUrl="StyleStandars/Images/users_into.png" Visible='<%# !dgdZone.MasterTableView.IsItemInserted %>'></telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="ثبت منطقه جدید" CommandName="PerformInsert" ImageUrl="StyleStandars/Images/users_into.png" Visible='<%# dgdZone.MasterTableView.IsItemInserted %>'></telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="حذف" CommandName="DeleteSelected" ImageUrl="StyleStandars/Images/users_into.png"></telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="بازآوری" CommandName="RebindGrid" ImageUrl="StyleStandars/Images/users_into.png"></telerik:RadToolBarButton>
</Items>
</telerik:RadToolBar>--
%>
</CommandItemTemplate>
<
CommandItemSettings ExportToPdfText="Export to PDF" ShowExportToExcelButton="True"
ShowExportToPdfButton="True"></CommandItemSettings>
<
RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
<
HeaderStyle Width="20px"></HeaderStyle>
</
RowIndicatorColumn>
<
ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
<
HeaderStyle Width="20px"></HeaderStyle>
</
ExpandCollapseColumn>
<Columns >
<telerik:GridTemplateColumn DataField="strName"
FilterControlAltText="Filter strName column" HeaderText="نام منطقه"
UniqueName="strName">
<EditItemTemplate>
<telerik:RadTextBox ID="strNameTextBox" Skin="Office2010Blue" Font-Names="Tahoma" Text='<%# Bind("strName") %>' runat="server">
</telerik:RadTextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="strNameLabel" runat="server" Text='<%# Eval("strName") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="iNumber"
FilterControlAltText="Filter iNumber column" UniqueName="iNumber"
ForceExtractValue="Always" Visible="False" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn DataField="strAdress"
FilterControlAltText="Filter strAdress column" HeaderText="آدرس"
UniqueName="strAddress">
<EditItemTemplate>
<telerik:RadTextBox ID="strAdressTextBox" Skin="Office2010Blue" Width="400px" Font-Names="Tahoma" Text='<%# Bind("strAddress") %>' runat="server">
</telerik:RadTextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="strAdressLabel" runat="server" Text='<%# Eval("strAddress") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="400px" />
<ItemStyle Width="400px" />
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="iParentNumber"
FilterControlAltText="Filter iParentNumber column" ForceExtractValue="Always"
UniqueName="iParentNumber" Visible="False" ReadOnly="True">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings>
<
EditColumn UniqueName="EditCommandColumn1" Visible="false" ButtonType="PushButton" InsertText="ذخیره" UpdateText="ذخیره"
CancelText="انصراف"></EditColumn>
<FormMainTableStyle Font-Names="tahoma" Font-Size="9pt"/>
<FormTableStyle Font-Names="tahoma" Font-Size="9pt"/>
</
EditFormSettings>
<EditItemStyle Font-Names="Tahoma" />
<
EditFormSettings>
<
EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</
EditFormSettings>
</
MasterTableView>
<
FilterMenu EnableImageSprites="False">
<
WebServiceSettings>
<
ODataSettings InitialContainerName=""></ODataSettings>
</
WebServiceSettings>
</
FilterMenu>
<
HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">
<
WebServiceSettings>
<
ODataSettings InitialContainerName=""></ODataSettings>
</
WebServiceSettings>
</
HeaderContextMenu>
</telerik:RadGrid>
</div>
</form>
</
body>
public
override
void
Initialize()
{
base
.Initialize();
Owner.Page.ClientScript.RegisterClientScriptResource(
this
.GetType(),
"Common.js"
);
}
public
override
void
PrepareCell(TableCell cell, GridItem item)
{
base
.PrepareCell(cell, item);
if
(!(item
is
GridDataItem))
return
;
var clickScript =
string
.Format(
"javascript:tfbc_Click('{0}','{1}');"
,
this
.Owner.ClientID, CommandName);
var linkButton =
new
HtmlAnchor() { ID =
"lnk"
, InnerText = cell.Text, HRef = clickScript };
cell.Controls.Clear();
cell.Controls.Add(linkButton);
}
function
tfbc_Click(owner, command, argument) {
$find(owner).fireCommand(command, argument);
}
if
(e.CommandName ==
"commandName"
)
{
var item = (GridDataItem) e.Item;
var strKey = item.GetDataKeyValue(
"Id"
).ToString();
var control = (Details)Page.LoadControl(
"~/Controls/Details.ascx"
);
control.Id =
long
.Parse(strKey);
MPS.AddPopup(control);
}