Search results matching tag 'Search'

Search

ckblues123 — Thu, 17 Dec 2009 05:00:00 GMT

I need to code for serching a keyword from a folder with doc n txt files if the keyword found i need to dispaly the files in which it is there i need it in c#, if anyone can help me thats so great thanks in advance

Table Entries not visible during execution

nencarnacion — Wed, 09 Dec 2009 05:00:00 GMT

I made a simple search function which makes use of a textbox, a button and a listview. Using this code, i was able to successfully execute a search for a particular entry:

string strConString = ConfigurationManager.ConnectionStrings["pubsConnectionString1"].ConnectionString;
            SqlConnection myConnect = new SqlConnection(strConString);

            string cmd = "SELECT * FROM authors WHERE au_lname=@au_lname";

            SqlDataAdapter da = new SqlDataAdapter(cmd, myConnect);
            da.SelectCommand.Parameters.AddWithValue("@au_lname", TextBox1.Text);
            // here yu can see the passed value in textbox   
            DataSet ds = new DataSet();
            da.Fill(ds, "authors");

            ListView1.DataSource = ds.Tables["authors"];
            ListView1.DataBind();

But during the initial run of the page, there are no entries to be displayed. So what should i do so that when i first run the page,all of the entries are going to appear and when i click the button, thats the only time that the the table will show the results of the search.?How do i do this?

Search Function for Listview

nencarnacion — Tue, 08 Dec 2009 05:00:00 GMT

How do i make a simple search function that can search for entries in a listviews. do i use a textbox and a button? if yes, how do i do it?

Wild card not returning search values from database...

dcwhitson — Fri, 06 Nov 2009 05:00:00 GMT

Thanks in advance for anyone able to help me with this. I have been going over this for hours and it's probably something simple that I am missing.

I have a search page that looks for adverstising listings in an MSSQL Database. I can get return results for exact word matches, but I cannot get any wild card matches. I have dummy ads in there now and if I type in a word I know is in the index, such as landscaping, I get all the rows returned for that word. If I shorten the same word I just successfully found and put an * or % in the text box and search for landsc* or landsc%, I get no results. I get the same result if I am putting the wild card in the text box like a web savvy user would, or if I insert them while the page is building the query.

Any tips or advice would be greatly appreciated. I am using 1&1 shared hosting so it's asp.net 2.0 and sql server 2005 that is being used.

here is where I am testing it (you must select NW as the location to get any results. Some valid keywords are test, description, landscaping, painting, accounting)

<%@ Page Title="" Debug="true" Language="VB" MasterPageFile="promo.master" %>

<%@ Import Namespace="System.Data.SqlClient" %>

<script runat="server">
    Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim myConnection As Data.SqlClient.SqlConnection
        Dim myCommand As Data.SqlClient.SqlCommand
        Dim strSearch As String
        Dim arrTerms() As String
        Dim strSQL As String
        Dim I As Integer

        strSearch = adsearch.Text
		
        If strSearch.Length > 0 Then
            
            strSearch = strSearch.Replace("'", "''")
			
            arrTerms = strSearch.Split()

            strSQL = "SELECT * FROM ad_listings WHERE "
			
            For I = arrTerms.GetLowerBound(0) To arrTerms.GetUpperBound(0)
                
                strSQL = strSQL & "CONTAINS(*,'%" & arrTerms(I) & "%')"
                strSQL = strSQL & " AND quad = '" & quadid.SelectedValue & "'"

                If I < arrTerms.GetUpperBound(0) Then
                    strSQL = strSQL & " AND "
                End If
            Next I

            myConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True")

            myConnection.Open()
            myCommand = myConnection.CreateCommand()
            myCommand.CommandText = strSQL

            DataList1.DataSource = myCommand.ExecuteReader()
            DataList1.DataBind()


            myConnection.Close()
        Else
            adsearch.Text = "Enter Search Here"
        End If
    End Sub
</script>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <meta name="keywords" content="Albuquerque Business Search, local, find, look" runat="server" />
    <meta name="description" content="Perform a local Albuquerque business search. ABQpromo provides an alternative to the 'haystack' search engines and gives you a relevant Albuquerque Business Search." runat="server" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="LeftContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" Runat="Server">
    <h1>Do an Albuquerque business search here!</h1>
    <h1>Select a location...</h1>
    <asp:DropDownList ID="quadid" runat="server">
        <asp:ListItem Selected="True" Value="0">Select One...</asp:ListItem>
        <asp:ListItem Value="2">NE</asp:ListItem>
        <asp:ListItem Value="1">NW</asp:ListItem>
        <asp:ListItem Value="3">SE</asp:ListItem>
        <asp:ListItem Value="4">SW</asp:ListItem>
        <asp:ListItem Value="5">Rio Rancho</asp:ListItem>
    </asp:DropDownList>
    <asp:CompareValidator ID="locValidator" runat="server" 
        ControlToValidate="quadid" ErrorMessage="Location is required!" 
        Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>
    <h1>Enter your search words...</h1>
    
    <asp:TextBox id="adsearch" runat="server" />   
    <asp:Button id="btnSearch" runat="server"

	Text= "Search Local!"
	style="height: 26px" PostBackUrl="findit.aspx" onclick="btnSearch_Click" />
<br />
    <asp:ValidationSummary ID="ValidationSummary1" runat="server" />
    <br />

	<br />
	<asp:DataList ID="DataList1" runat="server" BorderColor="#5D5A59" 
        BorderWidth="2px" GridLines="Both">
        <ItemTemplate>
        <asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl='<%# "http://www.abqpromo.com/abqpromo/adview.aspx?adID=" & Eval("adID").ToString %>'>
            <table width="450px" cellspacing="1" class="style2">
                <tr>
                    <td rowspan="3" width="20px">
                    
                          </td>
                    <td rowspan="4" width="100px" valign="middle">
                        <asp:Image ID="logoImage" runat="server" 
                            ImageUrl='<%# Bind("logoURL", "/ABQpromo/images/Logos/{0}") %>' Width="80" />
                    </td>
                    <td width="160px">
                        
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("bizName") %>' 
                            style="font-weight: 700; color: #000066; font-size: medium; text-decoration:underline;" />
                    </td>
                    <td width="20px">
                          </td>
                    <td>
                         </td>
                    <td width="10px">
                         </td>
                </tr>
                <tr>
                    <td>
                        <asp:Label ID="Label2" runat="server" Text='<%# Eval("bizPhone") %>' 
                            style="font-size: medium;" />
                    </td>
                    <td rowspan="2"> </td><td rowspan="2">
                        <asp:Label ID="Label4" runat="server" Text='<%# Eval("bizCat1") %>' 
                            style="font-size: small; color: #808080;" />
                        <br />
                        <asp:Label ID="Label5" runat="server" Text='<%# Eval("bizCat2") %>' 
                            style="font-size: small; color: #808080;" />
                        <br />
                        <asp:Label ID="Label6" runat="server" Text='<%# Eval("bizCat3") %>' 
                            style="font-size: small; color: #808080;" />
                        <br />
                    </td>
                    <td rowspan="2">
                         </td>
                </tr>
                <tr>
                    <td>
                        <asp:Label ID="Label3" runat="server" Text='<%# Eval("bizSite") %>' 
                            style="font-style: italic; color: #006600" />
                    </td>
                </tr>
                </table>
                       </asp:HyperLink>
                        </ItemTemplate></asp:DataList><br />
</asp:Content>

Thanks!

Searching through xml

yuszz_ayie — Wed, 30 Sep 2009 04:00:00 GMT

hello,

I'm quite new to asp.net and xml.

I have a problem here which is i need to search through the xml depending on the criteria given in a dropdownlist.

could anyone help me.

thanks anyway.

on ('text') open div id="('text')"

sallads — Wed, 16 Sep 2009 04:00:00 GMT

I'm doing, what you would call, a search box.

This is what I'm trying to do.

(This is the normal way to do it, make a link, then the div id matching will be opened.)<td width="43"><DIV onclick="show('1')">TEXT</DIV></td>

(But I want a text box, so people can write, ex: lost and then the div id lost will be opened.)

thank you for all the help!!

How to Perform Facet Search in Lucene.net

milan.s — Fri, 11 Sep 2009 04:00:00 GMT

Hi,

I have searched but cannot find any examples of Lucene.net Faceted search, Solr has it (based on lucene), but is there any other way of getting Faceted search, like any other free library.

How can I make a search in MVC

joaoluizbt — Thu, 10 Sep 2009 04:00:00 GMT

Hi friends,

I have an enterprise form, and I want to implement a search tool in that view with a list of all enterprises founded. It could be done by the enterprise's code or name.

I tried to add a textbox and an actionlink, but is going wrong. The idea is the user fill the textbox with a code and, clicking in the search actionlink, appear a screen with the list of enterprises that have that code or name.

I put my code down here:

Model:

        public IQueryable<Empresa> BuscarEmpresas(int codigo)
        {
            return from empresa in db.Empresas
                   where empresa.cod_empresa == codigo
                   orderby empresa.nome
                   select empresa;
        }

Controller:

        //
        // GET: /Empresa/Buscar
        [Authorize]
        public ActionResult Buscar(int? page, int codigo)
        {
            const int pageSize = 10;
            var Empresas = EmpresaRepositorio.BuscarEmpresas(codigo);
            var PaginatedEmpresas = new PaginatedList<Empresa>(Empresas,
                                                         page ?? 0,
                                                         pageSize);
            return View(PaginatedEmpresas);
        }

View:

    <p>
        <label for="buscar">Buscar pelo cógigo:</label>
        <%= Html.TextBox("Buscar")%>
        <%= Html.ActionLink("Buscar", "Buscar") %>        
    </p>
    <ul>
        <% foreach (var empresa in Model) { %>
            <li>
                -
                <%= Html.ActionLink(empresa.nome, "Detalhe", new { id=empresa.cod_empresa }) %>
            </li>
        <% } %>
    </ul>
    <a href='<%=Url.Action("Adicionar","Empresa") %>'>
            <img src="../../Content/img/adicionar.jpg" alt="Adicionar" class="image" /></a>

Once more, thanks.

João Luiz

Multiple Keyword Search in SQL Server

covertblack — Tue, 04 Aug 2009 04:00:00 GMT

I am using ASP.net 2.0 on Visual Studio 2005 and trying to search a SQL Server 2000 database table based on user input of Multiple Keywords into a texbox. I am having trouble generating the correct syntax.

For Example:

If user inputs something like "English Songs" then it should be split into 2 saperate keywords of "English" and "Songs" and then those records should be fetched which contain these 2 keywords, irrelevant of their occuring in the string,

It should fetch the following Records if user Inputs "English Songs" in the textbox:

"Free English Songs"
"Songs in English"

I have been searching for a sweet and simple solution for 2 3 days but I am still not able find it :-(

Please help...

Thanks in Advance.

Url to search Access 97, VB.

Mike.Brown — Wed, 29 Jul 2009 04:00:00 GMT

I have a page which you can add records to the database and works fine.

However, what I am trying to do now is create an edit record page by clicking on the record number.

For example

Page 1 displays

ID	Cheque No	Date	Payee	Description	ClaimID & P.O.	Amount	Action	Notes
12	4567890	22/04/09	ray	paid	4567	£400,000,000.00	on hold	waiting on work completion

So when they click on ID 12 the url changes to post the link to the next page ( http://myurlco.uk/raytest1.asp?id=12 )
I have now got the next page to display the variable 12, but the variable does not give me the record result 12, it just gives me all of them and I cant work out the correct variable to search the database.

Example of page 2 (Editing Page)

ID	ChqNo	Date	Payee	Description	ClaimId_po	Amount	Action	Notes
10	45678`	22/02/09	e3w	e2w	ty67u8	3888	basildon	basildon
11	56789876	22/04/09	dws	dws	test1	4000000	paid	paid
12	4567890	22/04/09	ray	paid	4567	400000000	on hold	waiting on work completion

Here is the code for the page 2 (Editing page), please could anyone help me.....Thanks in advance.

---------------------CODE-------------------------

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_RayTest_STRING
Recordset1_cmd.CommandText = "SELECT * FROM Basildon"
Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 10
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<% Dim variable
variable=Request.QueryString("id")
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<table border="0">
<tr>
    <td>ID</td>
    <td>ChqNo</td>
    <td>Date</td>
    <td>Payee</td>
    <td>Description</td>
    <td>ClaimId_po</td>
    <td>Amount</td>
    <td>Action</td>
    <td>Notes</td>
</tr>
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>
    <tr>
      <td><%=(Recordset1.Fields.Item("ID").Value)%></td>
      <td><%=(Recordset1.Fields.Item("ChqNo").Value)%></td>
      <td><%=(Recordset1.Fields.Item("Date").Value)%></td>
      <td><%=(Recordset1.Fields.Item("Payee").Value)%></td>
      <td><%=(Recordset1.Fields.Item("Description").Value)%></td>
      <td><%=(Recordset1.Fields.Item("ClaimId_po").Value)%></td>
      <td><%=(Recordset1.Fields.Item("Amount").Value)%></td>
      <td><%=(Recordset1.Fields.Item("Action").Value)%></td>
      <td><%=(Recordset1.Fields.Item("Notes").Value)%></td>
    </tr>
    <%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

-----------CODE---------------

Mike