Display two fields from different databases
<p>I am creating a simple Leave Management application for which User Management is required.</p>

<p>For this I used ASP.NET Configuration tool and created roles, users and permissions. A <code>ASPNETDB.mdf</code> database was generated under <code>App_Code</code>. Next I created few .aspx pages like <code>login.aspx</code>, <code>register.aspx</code>, <code>changepassword.aspx</code>, <code>displayinfo.aspx</code>, etc. I placed the required Login controls in each page. In <code>displayinfo.aspx</code> (after the user login.aspx) I placed a <code>LoginName</code> control which displays a message like "Welcome LoginNameControl(UserName)". Next I created another database called "LMS" for maintaining Employees Leave Information which has tables like employee, dept, LeaveType, LeavePolicy, etc. </p>

<p>Now my question is when a user authenticates, how do I display the <code>EmployeeID</code> from the <code>Employee</code> table in <code>display.aspx</code> along with the <code>UserName</code> which has no relation with the <code>ASPNETDB.mdf</code> database? </p>

<p>I guess this can be achieved with datarelation concept of a <code>DataSet</code>, but I have no idea how to do it. Can anyone please provide me clear guidelines with proper code? I am not sure when to use ASP.NET Configuration tool and whether it's the right choice in this case.</p>
