asp.net中的内部联接 [英] inner join in asp.net

问题描述

我想运行这个SQL查询来填充我的asp.net webform中的gridview，

  SELECT  userinfo.user_id  用户，userinfo.User_last_login  上次登录，orginfo.Dept，orginfo.Div  FROM  UserInfo 
  INNER   JOIN  OrgInfo  ON  userinfo.Org_Code = orginfo.org_code 
  WHERE  userinfo.User_ID = ' < span class =code-string> txtUserId.text' 

userinfo.user_ID值来自文本字段



gridview填充了userId，lastlogin，Dept，Div列



提前thnks ..



代码块广告ded，SQL格式化的可读性 - OriginalGriff [/ edit]

解决方案

SELECT userinfo.user_id as User，userinfo.User_last_login as [Last Login] ]，orginfo.Dept，orginfo.Div来自UserInfo INNER JOIN OrgInfo ON userinfo.Org_Code = orginfo.org_code WHERE userinfo.User_ID =''+ txtUserId.text +'';

I want to run this sql query to populate the gridview in my asp.net webform,

SELECT userinfo.user_id "User",userinfo.User_last_login "Last Login",orginfo.Dept,orginfo.Div FROM UserInfo 
INNER JOIN OrgInfo  ON userinfo.Org_Code=orginfo.org_code  
WHERE userinfo.User_ID= 'txtUserId.text'

the userinfo.user_ID value is coming from the textfield

gridview is populating with userId,lastlogin,Dept,Div columns

thnks in advance..

[edit]Code block added, SQL formatted for readability - OriginalGriff[/edit]

解决方案

"SELECT userinfo.user_id as User, userinfo.User_last_login as [Last Login], orginfo.Dept, orginfo.Div FROM UserInfo INNER JOIN OrgInfo ON userinfo.Org_Code=orginfo.org_code WHERE userinfo.User_ID=''" + txtUserId.text + "'';"

这篇关于asp.net中的内部联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！