Trying to insert Data in sqlsever from loginpage
Hi,
I am using a stored procedure,which first insert into usertable,then using userid as dealerid it will insert into dealertable,but when I am trying to config sqldatasource with this sp,it is showing insert fails as login can't be null.
My stored procedure is:
CREATE PROCEDURE sp_delinsert(@Login varchar(64) , @Pwd varchar(32),@SQuest varchar(64),@SAns varchar(64),@DealerID int,
@Name varchar(128) ,
@Addr1 varchar(128),
@Addr2 varchar(64) ,
@Place varchar(64) ,
@County varchar(64) ,
@Country varchar(64) ,
@Phone varchar(64) ,
@Fax varchar(32) ,
@Email varchar(64) ,
@MCFName varchar(64) ,
@MCLname varchar(64) ,
@MCPhone varchar(32) ,
@MCEmail varchar(64) ,
@SCFName varchar(64),
@SCLName varchar(64),
@SCPhone varchar(32),
@SCEmail varchar(64),
@CreateDate datetime) AS
BEGIN TRAN
declare @uid int
Set @uid=(SELECT UserID from [CarBid].[dbo].[CB_TblUsers])
If @uid IS NULL
Begin
declare @userid int ,@UType int
INSERT INTO [CarBid].[dbo].[CB_TblUsers]([Login] ,[Pwd] ,[SQuest] ,[SAns] ,[UType] )
VALUES
(@Login,@Pwd,@SQuest,@SAns,@UType)
Set @userid =(Select UserID from [CarBid].[dbo].[CB_TblUsers] where UType='3')
INSERT INTO [CarBid].[dbo].[CB_TblDealer]([DealerID],[Name]
,[Addr1]
,[Addr2]
,[Place]
,[County]
,[Country]
,[Phone]
,[Fax]
,[Email]
,[MCFName]
,[MCLname]
,[MCPhone]
,[MCEmail]
,[SCFName]
,[SCLName]
,[SCPhone]
,[SCEmail]
,[CreateDate] )
VALUES
(@userid
,@Name ,@Addr1
,@Addr2
,@Place
,@County
,@Country
,@Phone
,@Fax
,@Email ,@MCFName
,@MCLname
,@MCPhone
,@MCEmail
,@SCFName
,@SCLName
,@SCPhone
,@SCEmail
,@CreateDate )
End
Go
DROP PROCEDURE sp_delinsert.
Pls suggest me its very urgent for my job.
|
