I want to insert user login detail in table by using following storeprocedure
create procedure sp_jobseekerLogin
@user_type varchar(100)=null,
@user_name varchar(100)=null,
@password varchar(100)=null,
@Email varchar(100)=null,
@firstName varchar(30)=null,
@mobile varchar(20)=null,
@user_address varchar(500)=null,
@active varchar(10) =null,
@user_id int output
as
begin
insert into JP_Login(user_type,user_name,password,user_email,first_name,mobile,user_address,active,date) values
(@user_type,@user_name,@password,@Email,@firstName,@mobile,@user_address,@active,GETDATE())
set @user_id=@@IDENTITY
end
I am new in using linq to sql
below is my c# code,facing problem in passing the parameter can any one help me...
public int insertlogin()
{
DataClasses1DataContext db = new DataClasses1DataContext();
int userid = db.sp_jobseekerLogin(2, txtUserName.Text, txtpassword.Text, txtEmail.Text, txtFullName.Text, txtmobile.Text, txtcurntLoc.Text, "y",);
db.SubmitChanges();
return userid;
}</pre>