如何使用linq to sql将数据插入数据库? [英] How to insert data into database using linq to sql?
本文介绍了如何使用linq to sql将数据插入数据库?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想通过使用以下storeprocedure在表中插入用户登录详细信息
创建过程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 in 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
我是新手使用linq来实现sql
以下是我的c#代码,面临传递问题该参数可以帮助我...
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,& quot; y& quot;,);
db.SubmitChanges();
return userid;
} < / pre >
解决方案
因为你有输出参数作为用户ID,你需要使用ref
keyword
int userid = 0 跨度>;
db.sp_jobseekerLogin(...., ref userid,....);
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>
解决方案
since you have output parameter as user id, you need to useref
keyword
int userid = 0; db.sp_jobseekerLogin(...., ref userid, ....);
这篇关于如何使用linq to sql将数据插入数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文