Questions on UI for ASP.NET AJAX Forum

1 answer

237 views

clear excel-like filter selections programmatically

Hi,

if I have an excel-like filter with a few items selected as shown in the attached image, is there any way to programmatically unselect all the values from the listbox? I am using this code to explicitly clear the filter and it works for clearing the radgrid but it does not clear the filter listbox selections:

foreach (GridColumn column in grid.MasterTableView.Columns)

{

column.CurrentFilterFunction = GridKnownFunction.NoFilter;

column.CurrentFilterValue = string.Empty;

}

grid.MasgterTableView.FilterExpression = string.Empty;

grid.Rebind();

Grid

answered on 03 Aug 2018

1 answer

62 views

Not getting expected result while deleting from Grid

Hi there,

First let me show you my code first,

<div class="content mt-3">

<div class="animated fadeIn">

<div class="row">

<div class="col-lg-12">

<div class="card">

<div class="card-header">

<h4>Language Settings</h4>

</div>

<div class="card-body">

<div class="row form-group">

<asp:Panel CssClass="col-sm-12" ID="pnlMessage" runat="server">

<div class="alert alert-success alert-dismissible fade show" role="alert">

<span class="badge badge-pill" id="message_header"> 

<asp:Label runat="server" ID="lbl_type"></asp:Label></span>

<asp:Label runat="server" ID="lblMessage"></asp:Label>

<button type="button" class="close" data-dismiss="alert" aria-label="Close">

<span aria-hidden="true">×</span>

</button>

</div>

</asp:Panel>

</div>

<div class="row form-group">

<div class="col-md-6">

<div class="row">

<div class="col-md-5">

<asp:Label ID="label" AssociatedControlID="txt_languageName" Text="Enter language Name" runat="server" />

</div>

<div class="col-md-7">

<telerik:RadTextBox runat="server" ID="txt_languageName" Skin="Glow" RenderMode="Lightweight" Width="100%">

<EnabledStyle BackColor="#FFFFFF" ForeColor="Black"></EnabledStyle>

<FocusedStyle BackColor="Black" ForeColor="#FFFFFF"></FocusedStyle>

<HoveredStyle BackColor="Black" ForeColor="#FFFFFF"></HoveredStyle>

</telerik:RadTextBox>

<small class="form-text text-muted hide_me">This is a help text</small>

</div>

<div class="col-md-6">

<div class="row">

<div class="col-md-5">

<asp:Label ID="label1" AssociatedControlID="txt_langCode" Text="Enter language Code" runat="server" />

</div>

<div class="col-md-7">

<telerik:RadTextBox runat="server" ID="txt_langCode" Width="100%" Skin="Glow" RenderMode="Lightweight">

<EnabledStyle BackColor="#FFFFFF" ForeColor="Black"></EnabledStyle>

<FocusedStyle BackColor="Black" ForeColor="#FFFFFF"></FocusedStyle>

<HoveredStyle BackColor="Black" ForeColor="#FFFFFF"></HoveredStyle>

</telerik:RadTextBox>

<small class="form-text text-muted hide_me">This is a help text</small>

</div>

<div class="row form-group">

<div class="col-md-6">

<div class="row">

<div class="col-md-5">

<asp:Label ID="label2" AssociatedControlID="txt_languageName" Text="Enter Culture Code" runat="server" />

</div>

<div class="col-md-7">

<telerik:RadTextBox runat="server" ID="txt_culture_code" Skin="Glow" RenderMode="Lightweight" Width="100%">

<EnabledStyle BackColor="#FFFFFF" ForeColor="Black"></EnabledStyle>

<FocusedStyle BackColor="Black" ForeColor="#FFFFFF"></FocusedStyle>

<HoveredStyle BackColor="Black" ForeColor="#FFFFFF"></HoveredStyle>

</telerik:RadTextBox>

<small class="form-text text-muted hide_me">This is a help text</small>

</div>

<div class="col-md-6">

<div class="row">

<div class="col-md-5">

<asp:Label ID="label3" AssociatedControlID="txt_isoValue" Text="Enter ISO Code" runat="server" />

</div>

<div class="col-md-7">

<telerik:RadTextBox runat="server" ID="txt_isoValue" Width="100%" Skin="Glow" RenderMode="Lightweight">

<EnabledStyle BackColor="#FFFFFF" ForeColor="Black"></EnabledStyle>

<FocusedStyle BackColor="Black" ForeColor="#FFFFFF"></FocusedStyle>

<HoveredStyle BackColor="Black" ForeColor="#FFFFFF"></HoveredStyle>

</telerik:RadTextBox>

<small class="form-text text-muted hide_me">This is a help text</small>

</div>

<div class="row form-group">

<div class="col-md-12 headerClass">

<div class="btn-group">

<asp:Button runat="server" ID="btnSave" Text="Save" Width="53%" OnClick="btnSave_OnClick" CssClass="w3-btn" />

<asp:Button runat="server" ID="btnSearch" Text="Search" Width="53%" OnClick="btnSearch_OnClick" CssClass="w3-btn" />

</div>

<div class="row form-group">

<div class="col-md-12">

<telerik:RadGrid runat="server" ID="radGridLanguage" AutoGenerateColumns="False" BorderStyle="None" AllowPaging="True"

AllowSorting="True" OnItemCommand="radGridLanguage_ItemCommand" PageSize="10" RenderMode="Lightweight" Skin="Glow"

Style="margin-top: 1%; width: 98%; font-size: 13px">

<MasterTableView AllowFilteringByColumn="True" NoMasterRecordsText="No language data found" Height="10px" BackColor="#272c33" FilterItemStyle-BorderColor="white">

<Columns>

<telerik:GridBoundColumn DataField="lang_name" FilterControlAltText="Filter column column" HeaderText="Language Name" UniqueName="column" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="culture_name" FilterControlAltText="Filter column1 column" HeaderText="Culture Name" UniqueName="column1" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="culture_code" FilterControlAltText="Filter column2 column" HeaderText="Culture Code" UniqueName="column2" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="iso_639x_value" FilterControlAltText="Filter column3 column" HeaderText="ISO Value" UniqueName="column3" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Action" AllowFiltering="false">

<ItemTemplate>

<asp:Label ID="lblLangAutoId" Text='<%#Eval("autoid") %>' runat="server" Visible="false"></asp:Label>

<asp:ImageButton ID="imgBtnDelLanguage" runat="server" Width="20px" ImageUrl="~/Images/delete.png" OnClick="imgBtnDelLanguage_OnClick" OnClientClick="return confirm('want to delete?');" />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

<PagerStyle Mode="NextPrevAndNumeric" />

<GroupingSettings CollapseAllTooltip="Collapse all groups" />

<HeaderStyle BackColor="#272c33" Font-Bold="True" BorderColor="white" />

</telerik:RadGrid>

</div>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="lp" ShowLoadingPanelForPostBackControls="True" UpdatePanelsRenderMode="Inline">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="btnSearch">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="radGridLanguage" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="lp" runat="server" Transparency="30" MinDisplayTime="300" EnableEmbeddedSkins="False">

<div class="loading">

<asp:Image ID="Image1" runat="server" ImageUrl="../../Images/loading-default.gif" AlternateText="loading"></asp:Image>

</div>

</telerik:RadAjaxLoadingPanel>

Now as you could see, I have four text box controls two button controls(Save,Search) and one grid and one panel control present in page.

Flow:

Now as mentioned previously two buttons are save and search.

When User fill up the form and click on Save button data will store into database and after that panel will be popped up describing status message.(done)
Now, while user clicks on Search button grid will appear. (done)
Now while user clicks on the delete button, data gets deleted , but that panel is not showing up.(Not Done)
After clicking on the delete button I want to reset my controls (textbox) . (Not done)

protected void btnSave_OnClick(object sender, EventArgs e)

{

pnlMessage.Visible = true;

_objBelAdministration.flag = "insert";

_objBelAdministration.strLanguageName = txt_languageName.Text.Trim();

_objBelAdministration.strCultureName = txt_langCode.Text.Trim();

_objBelAdministration.strCultureCode = txt_culture_code.Text.Trim();

_objBelAdministration.strIsoValue = txt_isoValue.Text.Trim();

if ((_objBlAdministration.InsertLanguageInfo(_objBelAdministration)) > 0)

{

lbl_type.Text = "Sucess";

lblMessage.Text = "Sucessfully inserted into database";

ScriptManager.RegisterStartupScript(this.Page, typeof(Type), "alert01", "addClassSucess();", true);

}

else

{

lbl_type.Text = "Failure!";

lblMessage.Text = "Problem while inserting into database";

ScriptManager.RegisterStartupScript(this.Page, typeof(Type), "alert012", "addClassDanger();", true);

}

GetLanguages();

}

protected void imgBtnDelLanguage_OnClick(object sender, ImageClickEventArgs e)

{

pnlMessage.Visible = true;

var button = (ImageButton)sender;

var item = (GridDataItem)(button.NamingContainer);

_objBelAdministration.flag = "delete";

_objBelAdministration.autoid = ((Label)(item.FindControl("lblLangAutoId"))).Text;

if (_objBlAdministration.DeleteLanguageInfo(_objBelAdministration) > 0)

{

lbl_type.Text = "Sucess";

lblMessage.Text = "Deleted from database";

ScriptManager.RegisterStartupScript(this.Page, typeof(Type), "alert01", "addClassSucess();", true);

}

else

{

lbl_type.Text = "Error";

lblMessage.Text = "Error ocured when Deleting from database";

ScriptManager.RegisterStartupScript(this.Page, typeof(Type), "alert01", "addClassSucess();", true);

}

ResetControls();

GetLanguages();

}

private void ResetControls()

{

txt_languageName.Text = "";

txt_langCode.Text = "";

txt_culture_code.Text = "";

txt_isoValue.Text = "";

}

Ajax

answered on 03 Aug 2018

6 answers

388 views

SingleClick Button and 'Enter' on Search form

I have a search form with many fields set up and working fine. When I set the "Search" RadButton to SingleClick=True, it will no longer submit the form when pressing ENTER in the various input search boxes. It appears the page does a postback but the button click event is never fired. The button works as expected when clicking, but often users will use tab and enter text and then press enter on the form rather than clicking the button. Suggestions?

Button

answered on 02 Aug 2018

1 answer

376 views

foreach loop not looping properly

I have a Grid control with one column of checkboxes. When I click on the checkbox in the header, select a value in a dropdown list, and then click a button two sql commands should run. However the sql commands are only executing for the top selected row in the Grid. I need it to execute for all checked rows. What's wrong with my code? When I click on the checkbox in the header the checkboxes on each row within the visible Grid are selected as expected.

Grid Markup:

<telerik:RadGrid ID="rgUnassnd" runat="server" DataSourceID="sdsRgUnassnd" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True" AllowFilteringByColumn="True" ShowGroupPanel="True" Skin="Default" AllowMultiRowSelection="true">

<ClientSettings AllowDragToGroup="True" AllowColumnsReorder="True" ReorderColumnsOnClient="True">

<Selecting AllowRowSelect="true" />

</ClientSettings>

<MasterTableView DataSourceID="sdsRgUnassnd" DataKeyNames="assnmtIdPk" CommandItemDisplay="Top">

<CommandItemSettings ShowRefreshButton="true" ShowAddNewRecordButton="false" />

<Columns>

<telerik:GridTemplateColumn UniqueName="CheckTemp">

<ItemTemplate>

<asp:CheckBox ID="chkI" runat="server" />

</ItemTemplate>

<HeaderTemplate>

<asp:CheckBox ID="chkH" runat="server" AutoPostBack="true" OnCheckedChanged="chkH_CheckedChanged"/>

</HeaderTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="assnmtIdPk" ReadOnly="True" HeaderText="assnmtIdPk" SortExpression="assnmtIdPk" UniqueName="assnmtIdPk" DataType="System.Int32" FilterControlAltText="Filter assnmtIdPk column"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="clmNo" HeaderText="Claim" SortExpression="clmNo" UniqueName="clmNo" FilterControlAltText="Filter clmNo column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="assCrtdDt" ReadOnly="true" HeaderText="Date Received" SortExpression="assCrtdDt" UniqueName="assnmtCrtdDt" DataType="System.DateTime" FilterControlAltText="Filter assnmtCrtdDt column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="clientNm" HeaderText="Client" SortExpression="clientNm" UniqueName="clientNm" FilterControlAltText="Filter clientNm column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="carr" HeaderText="Carrier" SortExpression="carr" UniqueName="carr" FilterControlAltText="Filter carr column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="riskAddCity" HeaderText="Risk City" SortExpression="riskAddCity" UniqueName="riskAddCity" FilterControlAltText="Filter riskAddCity column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="provNm" HeaderText="Province" SortExpression="provNm" UniqueName="provNm" FilterControlAltText="Filter provNm column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="riskZip" HeaderText="Zip Code" SortExpression="riskZip" UniqueName="riskZip" FilterControlAltText="Filter riskZip column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

Here's the code behind:

protected void assignUsers_Click(object sender, EventArgs e)

{

string tascnxn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

GridHeaderItem hItem = rgUnassnd.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem;

if (hItem != null)

{

foreach (GridDataItem item in rgUnassnd.MasterTableView.Items)

{

CheckBox ChkChange = item.FindControl("chkI") as CheckBox;

if (ChkChange.Checked)

{

string assidpk = item.GetDataKeyValue("assnmtIdPk").ToString();

using (SqlConnection tasconn = new SqlConnection(tascnxn))

{

SqlCommand repAssnmtCmd = new SqlCommand(

"INSERT INTO repAssnmts (raCrtdBy, raCrtdDt, assnmtIdFk, repId) VALUES (LTRIM(RTRIM(@raCrtdBy)), LTRIM(RTRIM(@raCrtdDt)), LTRIM(RTRIM(@assnmtIdFk)), LTRIM(RTRIM(@repId)))"

, tasconn);

{

repAssnmtCmd.Parameters.AddWithValue("@assnmtIdFk", assidpk); //need to get the id of the checked row

repAssnmtCmd.Parameters.AddWithValue("@raCrtdBy", HttpContext.Current.User.Identity.GetUserId());

repAssnmtCmd.Parameters.AddWithValue("@raCrtdDt", DateTime.Now.ToString());

repAssnmtCmd.Parameters.AddWithValue("@repId", userList.SelectedValue);

tasconn.Open();

repAssnmtCmd.ExecuteNonQuery();

}

SqlCommand assnmtStatCmd = new SqlCommand(

"INSERT INTO assnmtStats (asCrtdBy, asCrtdDt, assnmtIdFk, aStatId) VALUES (LTRIM(RTRIM(@asCrtdBy)), LTRIM(RTRIM(@asCrtdDt)), LTRIM(RTRIM(@assnmtIdFk)), LTRIM(RTRIM(@aStatId)))"

, tasconn);

{

assnmtStatCmd.Parameters.AddWithValue("@assnmtIdFk", assidpk); //need to get the id of the checked row

assnmtStatCmd.Parameters.AddWithValue("@asCrtdBy", HttpContext.Current.User.Identity.GetUserId());

assnmtStatCmd.Parameters.AddWithValue("@asCrtdDt", DateTime.Now.ToString());

assnmtStatCmd.Parameters.AddWithValue("@aStatId", 2);

assnmtStatCmd.ExecuteNonQuery();

tasconn.Close();

if (IsPostBack)

{

lblBtnAssignUsers.ForeColor = System.Drawing.ColorTranslator.FromHtml("#0AA10A");

lblBtnAssignUsers.Text = "The file(s) were successfully assigned.";

Response.Redirect(Request.RawUrl);

}

else

{

lblBtnAssignUsers.ForeColor = System.Drawing.ColorTranslator.FromHtml("#CA2823");

lblBtnAssignUsers.Text = "The assignment(s) failed. Please try again.";

}

Here's the CheckChanged code:

protected void chkH_CheckedChanged(object sender, EventArgs e)

{

foreach (GridDataItem item in rgUnassnd.MasterTableView.Items)

{

CheckBox chkbx = (CheckBox)item["CheckTemp"].FindControl("chkI");

chkbx.Checked = !chkbx.Checked;

}

Grid

answered on 02 Aug 2018

3 answers

173 views

CheckList Filter Menu Select All is cleared after filtering

Hello-

All checklist options get selected if I check, "Select All" but they are cleared after I click, "Filter". All grid data is displayed properly. However, I would expect all checklist options to remain selected if I open the filter menu again. Is this working properly? Thanks!

Grid

answered on 02 Aug 2018

14 answers

789 views

Controlling width of an expand column

Hello,

Having a problem where the expand/collapse icon is getting cut off on the right hand side of the expand/collapse column because the column is not wide enough (see attached image). Is there a way to control how width the expand/collapse column renders via the style sheet? Either so I can change the padding/margin on the left of the icon or to make the column wider? I can't seem to find a way to make this look nice.

Thanks,
--nick

Grid

answered on 02 Aug 2018

7 answers

579 views

AllowFilteringByColumn

Hello,

I have a radgrid definition that has AllowFilteringByColumn enabled. One of the grid column's is populated from a RadComboBox using a lookup table (via a foreign key). The filter in this case, only works on the foreign key value. (see screen shot)

Is it possible to configure this filer to accept the text value.

<telerik:GridDropDownColumn DataField="UnitId"
UniqueName="Unit"
HeaderText="Unit"
AllowSorting="true"
ItemStyle-Width="100px"
DataSourceID="EntityDataSource1"
DropDownControlType="RadComboBox"
ListTextField="Unit"
ListValueField="UnitId"
EmptyListItemText=""
EmptyListItemValue="">
</telerik:GridDropDownColumn>

Thanks,

SteveO

Grid

answered on 02 Aug 2018

9 answers

1.0K+ views

don't allow user to write special characters in RadTextBox

Hi,
how can I disable the user to write special characters in RadTextBox ?
I'm also using the EmptyMessage property.

I want something like ajax toolkit filter extender

Input

answered on 02 Aug 2018

8 answers

119 views

about Raddatapager problem

Hello Support

      I create a search box in one asp.net page. When I input keyword and click submit button then show the Radlistview data result. All is ok, no problem. but when I click the page 2, or page 3 or page..... no result in the radlistview. I checked query string. it show the messed code.

     I have some customes from china. so this problem only appear when I input chinese charactar in the search box.

     Please help me resolve this problem. Thank you

ListView