problem with search application

hi friends please help me with my problem i have a code for search application it is searching one record from the data base at a time but i have so many records with that name but its not searching the whole list please help me how i can search the whole list of the same names
my code is like this

Expand|Select|Wrap|Line Numbers

 
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Report.aspx.cs" Inherits="SearchReport.Report" %>
 
<!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 runat="server">

    <title>Report</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    <table cellpadding="0" width="700" align="center" border="1">

    <tr>

    <td height="50"><img src="header.jpg" alt="header" width="700"/>

    </td>

    </tr>

    <tr>

    <td>

    Search:

    <asp:TextBox ID="txtreport" runat="server"></asp:TextBox>

     <asp:DataGrid ID="gridreport" runat="server" AutoGenerateColumns="false">

     <Columns>

     <asp:BoundColumn DataField="Name" HeaderText="Name" HeaderStyle-BackColor="Gray"></asp:BoundColumn>

     <asp:BoundColumn DataField="Path" HeaderText="Path" HeaderStyle-BackColor="gray"></asp:BoundColumn>

     <asp:BoundColumn DataField="Description" HeaderText="Description" HeaderStyle-BackColor="gray"></asp:BoundColumn>
 
     </Columns>
 
     </asp:DataGrid>

    </td>

    </tr>

    <tr>

    <td>

    <asp:Button ID="cmdbutton" align="center" Text="Search" runat="server" OnClick="cmdbutton_Click" />

    </td>

    </tr>

    </table>

    </div>

    </form>

</body>

</html>
 
using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Data.SqlTypes;
 
namespace SearchReport

{

    public partial class Report : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {
 
        }
 
        protected void txtreport_TextChanged(object sender, EventArgs e)

        {
 
        }
 
        protected void cmdbutton_Click(object sender, EventArgs e)

        {

            SqlConnection oConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]);

            SqlDataAdapter da = new SqlDataAdapter("dbo.win_ReportListSearch", oConn);

            da.SelectCommand.CommandType = CommandType.StoredProcedure;
 
            DataSet ds = new DataSet();
 
               da.SelectCommand.Parameters.Add(new SqlParameter("@Name",txtreport.Text));
 
              //if (txtreport.Text.ToString() != "")

              //{

               //da.SelectCommand.Parameters.Add(new SqlParameter("@Name", txtreport.Text));

               //}
 
            oConn.Open();

            da.SelectCommand.ExecuteNonQuery();

            oConn.Close();
 
            da.Fill(ds);
 
            this.gridreport.DataSource = ds;

            this.DataBind();
 
            da.Dispose(); 
 
        }

    }

}

and the store procedure is like this

Expand|Select|Wrap|Line Numbers

 
ALTER PROCEDURE [dbo].[win_ReportListSearch]

@Name varchar(30)

as
 
SELECT [Name],

       [Path],

       [Description]

FROM Catalog

WHERE [Name] like (@name)
 
please help me with this problem

Dec 26 '07 #1

Subscribe Post Reply

1089

Shashi Sadasivan

1,435

Expert 1GB

Please try the following

Expand|Select|Wrap|Line Numbers

 ALTER PROCEDURE [dbo].[win_ReportListSearch]

@Name varchar(30)

as
 
SELECT [Name],

       [Path],

       [Description]

FROM Catalog

WHERE [Name] like ('%'+@name+'%')

the % symbols are place holders allowing the name to be at any location in the text

Your previous code was as good as "Where [Name] = @name"

Dec 27 '07 #2

preeti13

thanks so much it worked for me thanks once again to helping me with this problem

Dec 27 '07 #3

by: Pierre Rouleau | last post by:

Hi all, When building a exe for a Python application under Windows XP with The McMillan installer, the insttaltion succeeds but when I run the resulting executable the application tracebacks...

Python

Problem with ft_min_word_len

by: Phil Powell | last post by:

I read numerous accounts about how to set ft_min_word_len only which cannot be done using the SET statement. The client wants to be able to use a portable web application I built, with its own...

MySQL Database

ldap connection problem

by: Amar | last post by:

I am trying to connect to my college LDAP directory using ASP.NET. This LDap does not have security as it returns only user demographic information. i do not need to bind with a username or...

.NET Framework

Session variables problem

by: Simon Matthews | last post by:

I am having issues with the right way to architecture the following (using c# asp.net):- The question I have is how best pass the collected data from one web page for use in another. The...

ASP.NET

Post Back Problem

by: Sunil Sabir | last post by:

Dear All, I have a search form which has 3 drop down boxes dropID ,dropPostCode, dropName. when I select some thing in the dropID name lets say 0001 I press go button.It displays a Record of...

ASP.NET

Resize table problem in Firefox for Web App

by: Giggle Girl | last post by:

Hi there, I am having a problem with the behavior of Firefox, where lefthand column content is not resized properly after it is "collapsed" and then "re-expanded". An online demo is available...

Javascript

UTF-8 encoding problem

by: shreshth.luthra | last post by:

Hi All, I am having a GUI which accepts a Unicode string and searches a given set of xml files for that string. Now, i have 2 XML files both of them saved in UTF-8 format, having characters...

Visual Basic .NET

Strange problem with HttpWebRequest

by: Blackstar | last post by:

I have a website I am trying to download a file from. This website is strange in the fact that there is no direct link to the URL of the file. The way the site works is as follows: 1) Enter in...

ASP.NET

Snake Game problem

by: foolsmart2005 | last post by:

I have written a snake game. There are 2 levels in the game(I finished 1st level). It can run in VC++ without problem but, when I run it on the dev C++ 4.9.9.2, it cannot run. I want to...

C / C++

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

problem with search application

Similar topics