Pages

Wednesday, May 8, 2013

TELERIK: Search filter water mark fix.

C# CODE:

protected void gvProjectsList_OnItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridFilteringItem)
{
GridFilteringItem filerItem = (GridFilteringItem)e.Item;

TextBox textItem = (TextBox)filerItem["ProjectNameFilter"].Controls[0];

if (string.IsNullOrEmpty(textItem.Text))
{
textItem.Text = @"Search project Name...";

textItem.Attributes.Add("onBlur", "return SetMessage(" + textItem.ClientID + ");");

}              
 
textItem.Attributes.Add("onFocus", "return ClearMessage(" + textItem.ClientID + ");");
}

}

 

SCRIPT CODE:

<script language="javascript" type="text/javascript">

//code to hide/show water mark on search box.

function ClearMessage(obj) {

if (obj.value == "Search project Name...")

obj.value = "";
}

function SetMessage(obj) {

if (obj.value == "")

obj.value = "Search project Name...";

}
 
</script>

       

       





 

TELERIK: Search with dropddown option.

GRID BOUND COLUMN: 


<telerik:GridBoundColumn UniqueName="emname" DataField="EM" HeaderText="EM"

HeaderStyle-Width="70px">

<FilterTemplate>

<telerik:RadComboBox ID="RadComboBoxEM" DataSourceID="sdsEmList" DataTextField="emname"

DataValueField="emname" Height="200px" Width="90" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("emname").CurrentFilterValue %>'

runat="server" OnClientSelectedIndexChanged="TitleIndexChangedEM" HeaderStyle-Width="60px">

<Items>

<telerik:RadComboBoxItem Text="All" />

</Items>

</telerik:RadComboBox>

<telerik:RadScriptBlock ID="RadScriptBlockEM" runat="server">

<script type="text/javascript">

function TitleIndexChangedEM(sender, args) {

var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");

tableView.filter("emname", args.get_item().get_value(), "EqualTo");



}

</script>

</telerik:RadScriptBlock>

</FilterTemplate>

</telerik:GridBoundColumn>









DATA SOURCE:

<asp:SqlDataSource ID="sdsEmList" runat="server" ConnectionString="<%$ ConnectionStrings:MGSIProcessConnectionString %>" SelectCommand="select distinct em.employeename as emname,em.EmployeeId from Project p
join Employee em on em.EmployeeId=p.emid
order by emname"></asp:SqlDataSource>
 

 


 

TELERIK: make telerik search case sensitive

<telerik:RadGrid ID="gvProjectsList" runat="server" MasterTableView-ShowHeadersWhenNoRecords="true" AllowMultiRowSelection="false" AutoGenerateColumns="false" EnableViewState="true" MasterTableView-
ImagesPath="~/Skins/Vista/Grid" OnItemCommand="GvProjectsList_ItemCommand">

<GroupingSettings CaseSensitive="false" />

<PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>