.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Database search

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :ASP.Net

I need to develop an asp.net page that lets users search the "User Comments", "Agent Comments" and "SME comments" sections of the another application.

All of the comments are stored in the database as seperate columns and the difficult part is none of the comments are structured, Users can practically comment in any casing (Upper or lower case letters) using abbreviations or full product names.

I am using asp.net 3.5 ajax and oracle as the database.

Users need to be able to type in a keyword like "hewlett packard" and be able to get all the related entries - hp OR hew pack or hewlett pack etc.

I am not sure how to approahc this to begin with, any good search routines/techniques or custom grids available online that can be used here?

currently there are about 15k records in the DB and growing...

any help is appreciated.





View Complete Post

More Related Resource Links

search in mysql database, mvc



I have set up a mysql connection in visual studio 2010 and now i have a connection and dont really know where to go next.

I want to be able to search the data and get the result in a view.

using asp.net mvc

Creating an database search application in VS C#

Hello everyone, I wish to create a C# application that will have a form and a text box where I can enter a text, and then ask the application to search if this text exists in a database. If it exists, I want all the information associated with this text to be displayed in a datagrid view or list box. I am able to create a database in SQL Server and I can connect to my database from VS 2005 C#. If this is possible, how do I go about it? Many thanks in advance.

Change SSP and Search database names

While creating SSP, besides the Admin site and MySite content databases, two more databases get created. They are usually named MySSP_DB and MySSP_Search_DB. If later we have a need to change these database names, what is the procedure? Thanks

problem rename sharepoint 2010 search service application admin database

Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Any Third Party Tool for Database Search for Backend User

Hi,   Anyone has idea/clue for any third party tool, that help us for searching database items from different tables within a single database.Thanks & Regards, Satish Srivastava

Any Third Party Tool for Database Search for Backend User

Hi,   Anyone has idea/clue for any third party tool, that help us for searching database items from different tables within a single database.Thanks & Regards, Satish Srivastava

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

How to search record from database in windows apllication

I hav to search records from database.Means if i entered B.E. in qualification column then it gives me all the records having qualification as B.E...my db is in sql plz rply me asap.

Search a word in all the tables(all columns) of a database

Dear Friends, I am developing the Home page of a Client. Apart from various things on this home page I have a text box and search button.Having said that, I have a database in which I have almost 12 tables with varying number of columns.Now my question is,Is there anyway to search a word typed by a user in the textbox to search it in all the tables(all columns) of the database.A simple,concise and easy to follow solution would be a great help.

how do I search record from database and display that in Datagridview.

hi,I am working in windows application.I wanted to search record while entering into textbox and respective data should be displayed in datagridview..

Need help with simple database search



Ive got a textbox and a button. When I type a name of a customer I want to perform a search in my database and display the result as a table. I cant find anything on google that shows me how to do this.

Some of you got any examples of how to do this with ADO.net?

Can i use Windows desktop search indexing service to index a full sql database ?



i wonder if i can use the windows indexing service to perform indexing on a database instead of file system ?

i.e we need to use the windows indexing service to create index table that contains information from all rows in the database



Is this a BUG?(Storyboard + database search + Storyboard = badly delayed animation)(Cannot run a sto

//push a button play the first storyboard animation : ListView fade-out

private void image4_MouseDown(object sender, MouseButtonEventArgs e)


   Storyboard sb2 = (Storyboard)this.FindResource("daychange_Copy1") as Storyboard;

   sb2.Completed += new EventHandler(sb_Completed);



//when the first animation is end, get data from database , fill the ListView and play the second storyboard animation

void sb_Completed(object sender, EventArgs e)


   getlist();//get data from database , fill the ListView

   Storyboard sbkk = (Storyboard)this.FindResource("daychange_Copy2") as Storyboard;



//get data from database , fill the ListView

private void getlist()



Manually specify database name for Microsoft SharePoint Foundation Search Service Settings


Hi Team,

I wanted to specify database name manually for Microsoft SharePoint Foundation Search Service under Application management | Manage services on server | Sharepoint Foundation Search . Under Search database settings,  it says 'Use of the default database server and database name is recommended for most cases. Refer to the administrator's guide for advanced scenarios where specifying database information is required.' . Specifying database name field is coming grayed out and can't have option to specify my own database name. Any help to specify database name for foundation search will be highly ppreciated.





Search Text at database level.

How to search text value in the databse schema, it might be used in store procedures, views, tables and as an record within tables or views any where in database.

Search for Clustered Index in database on varchar, nvarchar column



I have very big database, i am running a Re-index job and it's keep failing throwing everyday error stating "Online index operation cannot be performed on clustered index as index contains column of data type text, nvarchar.

is there any way i can search and change all such datatype of culstered into non-clustered indexes or any better solution i have.



Below is my entire code of a mobile application. The 4th form with the ID "bookDetails" is supposed to be used to retrieve data from a database called butternut3.mbd. I am currently stuck on writing a code in the script part, for a user to search and view details of a book from an access database, the user enters a book title in the textbox to view details of that particular book. :-/ Please help.
<%@ Page Inherits="System.Web.UI.MobileControls.MobilePage"
Language="c#" %>
<%@ Register TagPrefix="mobile"
Assembly="System.Web.Mobile" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server" language="C#">
    private void Command1_Click(object sender, System.EventArgs e)

    void Page_Load(Object sender, EventArgs e)
        if (!IsPostBack)

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend