<tr>
<td id="GridArea" runat="server" class="GridArea" valign="top" align="center" style="height: 378px;">
<table cellpadding="0" cellspacing="0" style="width: 100%">
<tr>
<td align="right" colspan="3" style="width: 100%;">
<asp:Label ID="lblCount1" runat="server" Visible="false"></asp:Label>
<asp:Label ID="lblpassword" runat="server" Visible="false"></asp:Label>
</td>
</tr>
<tr>
<td colspan="3" style="height: 165px;" valign="top" align="center">
<div class="divTop row">
<div style="text-align: right;" class="GridAction">
<span class="hint--left clsIcon" data-hint="Export To Excel">
<asp:LinkButton ID="lnkExportExcel" runat="server" CausesValidation="False" ForeColor="#46484A"
OnClick="lnkExportExcel_Click"><span class="glyphicon glyphicon-download-alt" style="color:rgb(15, 114, 15);"></span></asp:LinkButton>
</span><span class="hint--left clsIcon" data-hint="Advance Search" style="color: #1C7C75;">
<a href="#" id="FilterSerch" onclick="funPopup();"><span class="glyphicon glyphicon-filter">
</span></a></span><span class="hint--left clsIcon" data-hint="Show All">
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" ForeColor="#f56954"
OnClick="lnkShowAll_Click"><span class="glyphicon glyphicon-th-list" style="color:#f56954"></span></asp:LinkButton>
</span><span class="hint--left clsIcon" data-hint="Add User">
<asp:LinkButton ID="lnkAddNew" runat="server" CausesValidation="False" OnClick="lnkAddNew_Click"><span class="glyphicon glyphicon-plus" style="color:rgb(0, 173, 0);"></span></asp:LinkButton></span>
<span class="hint--left clsIcon" data-hint="Search" style="float: right;">
<asp:LinkButton ID="LinkButton2" OnClick="btnsearchAny_Click" runat="server"><span class="glyphicon glyphicon-search"></span></asp:LinkButton>
</span>
<asp:DropDownList ID="ddlSearch" runat="server" CssClass="form-control txt" Width="50px"
Style="float: right;" Visible="false">
</asp:DropDownList>
<asp:TextBox ID="txtsearch" CssClass="form-control txt" Width="150px" Style="float: right;"
runat="server"></asp:TextBox>
</div>
</div>
<asp:DataGrid ID="Grid" runat="server" CssClass="table table-bordered Grid" AutoGenerateColumns="False"
AllowSorting="true" AllowPaging="false" OnItemCommand="Grid_ItemCommand1" OnSortCommand="Grid_SortCommand"
OnPageIndexChanged="Grid_PageIndexChanged">
<HeaderStyle CssClass="Headingtext"></HeaderStyle>
<Columns>
<asp:TemplateColumn SortExpression="ExamId" HeaderText="Exam Id" Visible="False">
<HeaderStyle CssClass="pagerheader"></HeaderStyle>
<ItemTemplate>
<asp:Label ID="lblid" runat="server" Text='<%# DataBinder.Eval(Container.DataItem ,"UserID") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="UserName" SortExpression="UserName" HeaderText="User Name">
<HeaderStyle HorizontalAlign="Left" Width="200px" CssClass="HeaderItem" />
<ItemStyle HorizontalAlign="Left" Width="200px" />
</asp:BoundColumn>
<asp:BoundColumn DataField="UserName" SortExpression="UserName" HeaderText="Full Name">
<HeaderStyle HorizontalAlign="Left" Width="300px" CssClass="HeaderItem" />
<ItemStyle HorizontalAlign="Left" Width="300px" />
</asp:BoundColumn>
<asp:TemplateColumn SortExpression="Isactive" HeaderStyle-HorizontalAlign="Center"
HeaderText="Active" Visible="True" ItemStyle-HorizontalAlign="Center">
<HeaderStyle CssClass="HeaderItem" />
<ItemTemplate>
<asp:CheckBox ID="chkIsActv" runat="server" Enabled="false" Checked='<%# Convert.ToBoolean(Eval("Isactive")) %>' />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="40px"></ItemStyle>
</asp:TemplateColumn>
<asp:ButtonColumn Text="<i class='fa fa-fw fa-edit EditIcon' ></>" HeaderText="Edit"
CommandName="Edit">
<HeaderStyle CssClass="HeaderItem" />
<ItemStyle HorizontalAlign="Center" Width="40px"></ItemStyle>
</asp:ButtonColumn>
<asp:ButtonColumn Text="<i class='fa fa-fw fa-times-circle-o delIcon' ></>"
HeaderText="Delete" CommandName="Delete">
<HeaderStyle CssClass="HeaderItem" />
<ItemStyle HorizontalAlign="Center" Width="40px"></ItemStyle>
</asp:ButtonColumn>
</Columns>
</asp:DataGrid>
<div id="paging" runat="server" visible="false" class="paging">
<span style="float: left">Total:
<asp:Label ID="lblCount" runat="server" Font-Bold="True"></asp:Label>
<asp:Label ID="lblhdnQuery" runat="server" Visible="false"></asp:Label>
</span>
<div style="float: right">
<asp:Button Text="<< " runat="server" CssClass="btn btn-navi" ID="btnFirst" CausesValidation="false"
OnClick="btnFrist_Click" />
<asp:Button Text="< " runat="server" CssClass="btn btn-navi" ID="btnPrevious" CausesValidation="false"
OnClick="btnPrevious_Click" />
<asp:DropDownList ID="ddlPageSelector" runat="server" Style="width: 70px; height: 26px;"
AutoPostBack="true" OnSelectedIndexChanged="ddlPageSelector_SelectedIndexChanged">
</asp:DropDownList>
<asp:Button Text=" >" runat="server" CssClass="btn btn-navi" ID="btnNext" CausesValidation="false"
OnClick="btnNext_Click" />
<asp:Button Text=" >>" runat="server" CssClass="btn btn-navi" ID="btnLast" CausesValidation="false"
OnClick="btnLast_Click" />
</div>
<label>
Show
<asp:DropDownList ID="ddlSize" runat="server" Style="width: 75px; height: 28px;"
AutoPostBack="true" OnSelectedIndexChanged="ddlSize_SelectedIndexChanged">
<asp:ListItem Value="10" Selected="True">10</asp:ListItem>
<asp:ListItem Value="25">25</asp:ListItem>
<asp:ListItem Value="50">50</asp:ListItem>
<asp:ListItem Value="100">100</asp:ListItem>
</asp:DropDownList>
entries</label>
</div>
</td>
</tr>
</table>
</td>
</tr>
I have one gridview which have searchoption i want to replace my sql scalarfunction on codebehind of it but i dont know how to do plz help
#region btnsearchAny_Click
protected void btnsearchAny_Click(object sender, EventArgs e)
{
try
{
string query = string.Empty;
if (txtsearch.Text != "" && ddlSearch.SelectedValue == "0")
query += " and UserName+' '+FullName like'%" + txtsearch.Text + "%'";
if (txtsearch.Text != "" && ddlSearch.SelectedValue == "Any")
query += " and Contains(*,'\"" + txtsearch.Text + "*\"')";
if (txtsearch.Text != "" && ddlSearch.SelectedValue == "Exact")
query += " and freetext(*,'" + txtsearch.Text + "')";
lblhdnQuery.Text = query;
FillGrid(query);
FillNavigator(query);
}
catch (Exception ex)
{
ErrorWrite("Backoffice/User.aspx -btnsearch_Click", ref ex);
}
}
#endregion
this is my code behind
CREATE FUNCTION SearchResult(@Search VARCHAR(50))
RETURNS VARCHAR(50)
AS
BEGIN
DECLARE @Result VARCHAR(50);
SELECT @Result= UserName FROM tblUser
WHERE REPLACE(UserName,' ', '') Like '%'+ REPLACE(@Search,' ','') + '%'
RETURN @Result;
END
GO
this is my scalar function code which is working but i dnt knw how to replace this query in code behind