ASp.net stored procedures parameters for search functions

[.Net Sports]

I'm able to find info for using input parameters for stored procedures
to do inserts and update type SQL functions in asp.net (vb.net), but I
need to find something that will use input parameters with Select sql
statements to do search functions in an sql dbase and sql tables.
TIA
..NetSports

[Lucas Tam]

".Net Sports" <ba********@cox.net> wrote in news:1115831196.772726.135070
@g44g2000cwa.googlegroups.com:

I
need to find something that will use input parameters with Select sql
statements to do search functions in an sql dbase and sql tables.

This all depends on how your stored procedure is written... and what you're
searching.

Also consider using Full Text Searching if you're doing alot of text
searches.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[David Young]

Using input parameters in a select command is no different than using them
in a update, insert or delete command. Then only thing that changes is your
sql query.

CREATE PROCEDURE dbo.mySelectStoredProcedure
(
@parameter1 varchar(10)
}
AS
SELECT * FROM MyTable where MYFIELD = @parameter1;

Then you create your command object, assign the parameter and it's value,
then execute the command.

Is that what you were looking for or am I just not getting your question.
".Net Sports" <ba********@cox.net> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

I'm able to find info for using input parameters for stored procedures
to do inserts and update type SQL functions in asp.net (vb.net), but I
need to find something that will use input parameters with Select sql
statements to do search functions in an sql dbase and sql tables.
TIA
.NetSports

[Robbe Morris [C# MVP]]

Or, have the code generated for you:

http://www.eggheadcafe.com/articles/..._generator.asp

Here is some additional sample code:

http://www.eggheadcafe.com/articles/...s_property.asp

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

".Net Sports" <ba********@cox.net> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

I'm able to find info for using input parameters for stored procedures
to do inserts and update type SQL functions in asp.net (vb.net), but I
need to find something that will use input parameters with Select sql
statements to do search functions in an sql dbase and sql tables.
TIA
.NetSports