如何获取特定的用户详细信息? [英] how to get perticular user details?

问题描述

您好，如何在登录后获取更多的用户详细信息?
只是查询还是存储过程?

tblTable1

sbidID	int	
sbidDID	varchar(20)	
sbidDocType	varchar(4)	
sbidUserID	int	

来自tblTable1的记录

  1   88 诺基亚 146  

tblTableLogin

 linLoginID linUserGroupID linUserDetailsID linLoginName linPassword
1个 1  admin admin
 146   1   146  shahid shahid 

所以登录后我想在登录到特定用户ID后在网格中显示记录..使用linUsrDetailsID或linLoginID


我想从tblTable1获取记录，以使用其linUserDetailsID在网格中显示记录
请帮我谢谢. 登录后将Userid分配到会话中

字符串strSQL = " 
SqlCommand sqlcommand =新的SqlCommand(sql，sqlconn);
    sqlcommand.CommandType = CommandType.文本;
    sqlcommand.CommandText = sql;

    sqlcommand.Parameters.添加(新的SqlParameter(" ，会话[  uid"].ToString()));
    SqlDataAdapter da =新的SqlDataAdapter(sql，sqlconn);
    da.Fill(ds);

   GridView1.datasource = ds;
   GridView1.Databind(); 

谢谢
Ashish

字符串sqlQuery = "  + sbidIDVariable +  " 

甚至您都可以为其创建一个过程.

 创建 过程 getUserDetails( @UserID   INT )
为
开始
设置 没有计数 在上
从中选择 sbidID，sbidDID，sbidDocType，sbidUserID  tblTable1 其中 sbidID =  @ UserID ;
结束 

hi how to get perticualr user details after log in ?
simply query or stored procedure?

tblTable1

sbidID	int	
sbidDID	varchar(20)	
sbidDocType	varchar(4)	
sbidUserID	int	

this records from tblTable1

1   88  Nokia    146

tblTableLogin

linLoginID linUserGroupID linUserDetailsID linLoginName linPassword
1             	1                  	1	                admin	         admin	
146	1	146	shahid  shahid

so after login in i want to display records in grid after login to perticular user ID..using linUsrDetailsID or linLoginID


and i want to get records from tblTable1 to display records in grid using their linUserDetailsID
please help me thank you..

解决方案

--Improved Solution
assign Userid into session after login

string strSQL="select * from tblTable1 where sbidUserID	=@UserID"
SqlCommand sqlcommand = new SqlCommand(sql,sqlconn);
    sqlcommand.CommandType = CommandType.Text;
    sqlcommand.CommandText = sql;

    sqlcommand.Parameters.Add(new SqlParameter("@UserID", Session["uid"].ToString()));
    SqlDataAdapter da = new SqlDataAdapter(sql, sqlconn);
    da.Fill(ds);

   GridView1.datasource=ds;
   GridView1.Databind();

Thanks
Ashish

string sqlQuery="Select sbidID,	sbidDID, sbidDocType, sbidUserID from tblTable1 where sbidID = "+ sbidIDVariable +""

even you can create a procedure for it.

create procedure getUserDetails (@UserID INT)
as
begin
set nocount on
Select sbidID,	sbidDID, sbidDocType, sbidUserID from tblTable1 where sbidID = @UserID;
end

这篇关于如何获取特定的用户详细信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！