Question about Store Procedure on SQL Server 2000.

M

Manny

Hi there,

I'm kind of new with Store Procedures here and I'm trying to do the
following;

I'm trying to convert the following line of code into a store procedure

Me.DA.SelectCommand.CommandText = "SELECT * FROM tbData WHERE ID= " &
Me.ID.Value

I want to pass the current ID value to the store procedure and the store
procedure should return the data specific for that ID record.

Any help here would be much appreciated

Manny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use store procedures? 2
Optimize Store Procedure routine 1
LINQ to XML: stored procedure returning result of FOR XML PATH 4
Easy(?) SQL Stored Procedure Question 1
Retrieve the stored procedure script with ADO.NET 5
How to execute a parameterized Sql store procedure within Excel? 3
How to retrieve the returned function value? 3
ms sql # temp table - invalid object name in data source 2

Top