c# - ASP.NET: How to create a search function just using a textbox? -

-

i have suggestions regards having search function in website. find registered customers easier admin specific customer.

can give sample code snippets can accomplish specific search function?

thank you.

here .aspx code

  <asp:textbox id="txtsearch" runat="server" borderstyle="solid" width="218px"          ontextchanged="txtsearch_textchanged"></asp:textbox> &nbsp;<asp:button id="btnsearch" runat="server" text="search" /> </p> <div style="overflow-x:auto; width:1200px">  <asp:gridview id="gvcustomer" runat="server" autogeneratecolumns="false"          backcolor="#cccccc" bordercolor="#999999" borderstyle="solid" borderwidth="3px"          caption="customer profile" cellpadding="4" cellspacing="2" datasourceid="sqldatasourcebm"          forecolor="black" onrowcommand="gvcustomer_rowcommand"          datakeynames="applicantusername" >         <columns>             <asp:boundfield datafield="branch" headertext="branch"                  sortexpression="branch" />             <asp:boundfield datafield="applicantusername" headertext="username"                  sortexpression="applicantusername" readonly="true" />             <asp:boundfield datafield="noafirstname" headertext="first name"                  sortexpression="noafirstname" />             <asp:boundfield datafield="noalastname" headertext="last name"                  sortexpression="noalastname" />             <asp:buttonfield commandname="view profile" headertext="customer profile"                  text="view" />             <asp:buttonfield commandname="edit" headertext="customer profile" text="edit" />             <asp:buttonfield commandname="view cr" headertext="credit report" text="view" />         </columns>         <footerstyle backcolor="#cccccc" />         <headerstyle backcolor="black" font-bold="true" forecolor="white" />         <pagerstyle backcolor="#cccccc" forecolor="black" horizontalalign="left" />         <rowstyle backcolor="white" />         <selectedrowstyle backcolor="#000099" font-bold="true" forecolor="white" />         <sortedascendingcellstyle backcolor="#f1f1f1" />         <sortedascendingheaderstyle backcolor="#808080" />         <sorteddescendingcellstyle backcolor="#cac9c9" />         <sorteddescendingheaderstyle backcolor="#383838" />     </asp:gridview>     <asp:sqldatasource id="sqldatasourcebm" runat="server"          connectionstring="<%$ connectionstrings:pfciconnectionstring %>"            selectcommand="select [applicantusername], [branch], [noalastname], [noafirstname] [customerregistration] (([branch] = @branch) , ([noalastname] '%' + @noalastname + '%'))">         <selectparameters>             <asp:sessionparameter name="branch" sessionfield="applicantusername"                  type="string" />             <asp:controlparameter controlid="txtsearch" name="noalastname"                  propertyname="text" type="string" />         </selectparameters>     </asp:sqldatasource>

since didn't provide code here , asked directions, here go. lets assume textbox name 'textbox1' , there button beside it. on click event of button should querying database customer names matches text inside 'textbox1'. query using search like:

select * customers customername "%" + textbox1.text + "%"; //assuming table name customers

this should return customers has textbox1.text inside name. hope give insight on start from. cheers,,


Comments

Post a Comment

Popular posts from this blog

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that? ...
Read more

routes - Laravel 4 Wildcard Routing to Different Controllers -

-
realizing i'm going take beating this, have several questions "best practices" when constructing laravel route. do laravel routes run "first come first serve" top bottom? if route found, pass control controller (or perform action) , terminate? i have part of application acts url shortner. so, route looks this: route::get('/{id}', array('as' => 'home.text', 'uses' => 'homecontroller@text'), function($id){ //make sure id exists before pushing controller. if (storage::where('shortcode','=', $id)->count() > 0) { // route found } }); how can improved? one, i'm not sure how pass processing on controller conditionally.. sort of controller::make() ..? 3) there better way in laravel check if record exists versus doing mode::where('column','=','value')->count() 4) have legacy urls http://url.com/?...
Read more

cross browser - XSLT namespace-alias Not Working in Firefox or Chrome -

-
i transforming xhtml xhtml, need xslt stylesheet part of resulting document (the stylesheet contained in <script type"text/template"> element. using the xsl:namespace-alias instruction, works fine in ie, fails in both chrome , firefox. here relevant code: <xsl:output doctype-system="about:legacy-compat" omit-xml-declaration="yes" indent="yes" method="html" media-type="application/xhml" encoding="utf-8"/> <xsl:namespace-alias stylesheet-prefix="wxsl" result-prefix="xsl" /> <xsl:template match="head"> <!-- code omitted clarity --> <script type="text/template"> <wxsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns="http://www.w3.org/1999/xhtml" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:eli="local"> ...
Read more