How would I revise that exact same example.
If my stored procedure looked like this.
I just want to display the name of the fruit on the label of the asp.net page for whatever fruitid i submitted in the textbox.
USE [FruitsDB]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [dbo].[GetFruitNameTest1] @FruitId INTASBEGIN SET NOCOUNT ON; SELECT [FruitId] ,[FruitName] FROM [FruitsDB].[dbo].[Fruits] WHERE FruitId = @FruitIdENDGO