Inserting Data From A Store Procedure

Hi,

This is more store procedure:ALTER PROCEDURE dbo.InsertSpecialOrders

(@OrderID int,

@DepotName nvarchar(50),@CustomerName nvarchar(50),

@OrderDate nvarchar(50),@TelephoneNumber nvarchar(50),

@ObtainedFrom nvarchar(50),@CustomerCanCollect nvarchar(50),

@DepositPaid nvarchar(50),@PriceQuoted nvarchar(50),

@OrderTakenBy nvarchar(50),@BalancePaid nvarchar(50),

@Status nvarchar(50),@TransferedBy nvarchar(50),@CarriagePrice nvarchar(50)

)

 

AS

Declare @LatestID Int

 INSERT INTO Specials

(

OrderID,

DepotName,

CustomerName,

OrderDate,

TelephoneNumber,

ObtainedFrom,

CustomerCanCollect,

DepositPaid,

PriceQuoted,

OrderTakenBy,

BalancePaid,

Status,

TransferedBy,

CarriagePrice

 

)

VALUES

(

@OrderID,

@DepotName,

@CustomerName,

@OrderDate,

@TelephoneNumber,

@ObtainedFrom,

@CustomerCanCollect,

@DepositPaid,

@PriceQuoted,

@OrderTakenBy,

@BalancePaid,

@Status,

@TransferedBy,

@CarriagePrice

)

 SELECT @LatestID = Scope_Identity()

 INSERT INTO SpecialParts

(

OrderID,

PartNo,

Quantity

)

VALUES

(

@LatestID,

@DepotName,

@CustomerName

 

)

RETURN

 

Now I want to insert data and create the tables:

 SqlDataSource ordersDataSource = new SqlDataSource();ordersDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["SpecialsConnectionString1"].ToString();

 

 

ordersDataSource.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;

 So to insert data for the first field I need:

ordersDataSource.InsertParameters.Add("@CustomerName", CustomerName.Text) Is this right? Any help is appreciated.