Browse by Tags

Home ›

All Tags » sql » search (RSS)

%
"Asp.net 2.0%2
.net
.net 2.0 ASPX
.NET 3.0
.NET based CMS
access database
ADO.NET
AJAX
API
asp .NET 2.0
asp .NET 2.0 database objects sql
asp.net
ASP.NET 2.0
ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName
ASP.NET 3.5
c#
CONTAIN() function
Contains
csharp
data
Data access
data access layer
database
databinding
datasource
dotnet
dynamic sql
Find
FORM
GridView
GridView asp.net
If Statement
label
like
method
Null
object-relational
one record
parameter
problem
Productivity
Programming
query
querystring
records
results page
rows
Search Function Database Problem
search results
SELECT
servers
show
Simple
sql 2005 full text
Sql Server Query
SQL 2005 .NET full-text indexing
sql 2005 express
sqldatasource
stored Procedure
string
table adapter
tags
textbox
Updateparameters
VB
web application
Web applications
web components
where

First Web & Web 2.0 oriented database is released

The first release of Eloquera, the fusion database, is out. Eloquera's architecture and technology specifically targets at the Web developer. It provides the desired objectives of speedier development and maintenance. At the same time, it provides the seemingly contradictory benefit of startlingly...

Posted to Announcements (Forum) by bablind on 11-21-2008, 12:00 AM
Filed under: object-relational, Productivity, Programming, query, Search, servers, sql, web application, Web applications, web components, .NET 3.0, .NET based CMS, AJAX, asp .NET 2.0 database objects sql, asp.net, ASP.NET 2.0, ASP.NET 3.5, c#, csharp, Data access, dotnet, asp .NET 2.0, API, Find
search engine using dynamic sql?

i'm currently working on the search engine of my website and there are some optional criteria... so i decided to build where clause at run time so i now have two choices: either build where clause using c# and send it and parameters to stored procedure or build the where clause within the stored...

Posted to Data Access and ObjectDataSource Control (Forum) by ScobY9 on 09-15-2008, 12:00 AM
Filed under: search, sql, dynamic sql, stored Procedure
Re: Simple search using 'where' and 'like'

Any hints on this one? It has me stumped. I'm fairly new to creating SQL commands. Basics are tags are uploaded in a similar fashion to this forum. They be any word, any order and separated by commas. For example it may be "tree, flower, sun" entered into the database or "fruit, sky"...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by magicjoef on 07-24-2008, 12:00 AM
Filed under: search, SQL, like, Contains, tags
Simple search using 'where' and 'like'

Hi, I am looking to create a simple search that will display records from one of the columns in my database that contain the searched term. I have generated the SQL statement as follows SELECT * FROM [gallery] WHERE ([Tags] LIKE '%' + @Tags + '%') and I know that this will create a list...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by magicjoef on 07-24-2008, 12:00 AM
Filed under: querystring, search, Simple, where, like, SQL
Search 1 sql column > results page > details about that record page

i don't know how advanced this is or anything, i am new to asp. i have my server all setup and working with asp / aspx pages i have a page with two html forms on, each with a text box and a submit button. i want them to search different columns in my MS SQL 2005 express database. from the development...

Posted to Web Forms (Forum) by joepitt91 on 07-06-2008, 12:00 AM
Filed under: one record, results page, search, search results, show, sql, sql 2005 express, form
problem with retrieving/displaying data based on form input

Hi, I've developed a form which accesses a database through a data layer and sends parameters based on the form input. I have written the following code which works by checking if the textbox is empty and passing a null value as a string to the search parameter in the query, of which there are five:...

Posted to Data Presentation Controls (Forum) by tomosap on 02-22-2007, 12:00 AM
Filed under: Null, parameter, problem, querystring, records, rows, search, sql, sqldatasource, string, table adapter, textbox, Updateparameters, VB, access database, ADO.NET, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, data, data access layer, database, databinding, datasource, If Statement, method, SELECT, FORM, GridView, label, GridView asp.net
Wild card not returning search values from database...

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...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by dcwhitson on 11-06-2009, 12:00 AM
Filed under: SQL, SQL 2005 .NET full-text indexing, Search Function Database Problem, CONTAIN() function, search, %, .net, Sql Server Query, "Asp.net 2.0%2, .net 2.0 ASPX, sql 2005 full text