I think you are looking for this -
Create this procedure in your database and pass the values from your ASP.NET program
---Tables which I considered for this procedure, I guess you need to add DriverId in tbl_VehicleInfo as a foreign key
--See below definition
CREATE TABLE tbl_DriverInfo ([DriverName] NVARCHAR(50),[Mobile] NVARCHAR(10),[Email] NVARCHAR(50),[DOB] datetime,[BloodGroup] NVARCHAR(50),[LNo] NVARCHAR(50),[LExpDate] DATETIME,[Address] NVARCHAR(100),[DriverId] INT IDENTITY(1,1),[DriverLevel] NVARCHAR(50),[IsDeleted] bit)
CREATE TABLE tbl_VehicleInfo ([VehicleNo] NVARCHAR(50),[DriverId] INT ,[Make] NVARCHAR(10),[Model] NVARCHAR(50),[Variety] NVARCHAR(50),[isAc] BIT,[EngineNo] NVARCHAR(50),[LExpDate] DATETIME,[InsuranceNo] NVARCHAR(50),[IExpDate] DATETIME,[VehicleId] INT IDENTITY(1,1),[IsDeleted] BIT)
Store Procedure
CREATE PROCEDURE SaveUpdateDriverVehicleDetails(
@DRV_DriverName NVARCHAR(50),@DRV_Mobile NVARCHAR(10),@DRV_Email NVARCHAR(50),@DRV_DOB datetime,@DRV_BloodGroup NVARCHAR(50),@DRV_LNo NVARCHAR(50),@DRV_LExpDate DATETIME,@DRV_Address NVARCHAR(100),@DRV_DriverId INT,@DRV_DriverLevel NVARCHAR(50),
@VH_VehicleNo NVARCHAR(50),@VH_Make NVARCHAR(10),@VH_Model NVARCHAR(50),@VH_Variety NVARCHAR(50),@VH_isAc BIT,@VH_EngineNo NVARCHAR(50),@VH_LExpDate DATETIME,@VH_InsuranceNo NVARCHAR(50),@VH_IExpDate DATETIME,@VH_VehicleId INT
)
AS BEGIN
IF NOT EXISTS (SELECT 1 FROM tbl_DriverInfo WHERE DriverId=@DRV_DriverId)
BEGIN
INSERT INTO tbl_DriverInfo([DriverName] ,[Mobile] ,[Email] ,[DOB] ,[BloodGroup] ,[LNo] ,[LExpDate] ,[Address] ,[DriverLevel],[IsDeleted])
SELECT @DRV_DriverName ,@DRV_Mobile ,@DRV_Email ,@DRV_DOB ,@DRV_BloodGroup ,@DRV_LNo ,@DRV_LExpDate ,@DRV_Address,@DRV_DriverLevel,'0'
SELECT @DRV_DriverId=@@IDENTITY
END
ELSE
BEGIN
UPDATE tbl_DriverInfo SET
[DriverName] =@DRV_DriverName ,
[Mobile]=@DRV_Mobile ,
[Email]=@DRV_Email ,
[DOB]=@DRV_DOB ,
[BloodGroup]=@DRV_BloodGroup ,
[LNo]=@DRV_LNo ,
[LExpDate]=@DRV_LExpDate ,
[Address]=@DRV_Address ,
[DriverLevel]=@DRV_DriverLevel
WHERE DriverId=@DRV_DriverId
END
IF NOT EXISTS (SELECT 1 FROM tbl_VehicleInfo WHERE VehicleNo=@VH_VehicleNo AND DriverId=@DRV_DriverId )
BEGIN
INSERT INTO tbl_VehicleInfo([VehicleNo] ,[DriverId] ,[Make] ,[Model] ,[Variety] ,[isAc] ,[EngineNo] ,[LExpDate] ,[InsuranceNo] ,[IExpDate] ,[IsDeleted] )
SELECT @VH_VehicleNo,@DRV_DriverId ,@VH_Make ,@VH_Model ,@VH_Variety ,@VH_isAc ,@VH_EngineNo ,@VH_LExpDate ,@VH_InsuranceNo ,@VH_IExpDate ,'0'
SELECT @VH_VehicleId=@@IDENTITY
END
ELSE
BEGIN
UPDATE tbl_VehicleInfo
SET [VehicleNo]=@VH_VehicleNo ,
[DriverId]=@DRV_DriverId ,
[Make]=@VH_Make ,
[Model]=@VH_Model ,
[Variety]=@VH_Variety ,
[isAc]=@VH_isAc ,
[EngineNo]=@VH_EngineNo ,
[LExpDate]=@VH_LExpDate ,
[InsuranceNo]=@VH_InsuranceNo ,
[IExpDate]=@VH_IExpDate
WHERE DriverId=@DRV_DriverId AND VehicleId=@VH_VehicleId
END
SELECT @VH_VehicleNo , @DRV_DriverId
END