Sending Concurrent queries to DB

[shahab]

Most of the time I have to send many quries in Page_load to
Ms Sql Server(Concurrently).See these two ways:
-------------------------------------------------------
1-
private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
Accounts();
Url();
}
}
-------------------------------------------------------
2-
SELECT
userAct.username,
userAct.password,
userAct.role,
userAct.email,
userAct.studentcode,
userAct.SignDate,
tblUrl.URLValue
FROM
tblUserAccounts as userAct
INNER JOIN
tblUrl as URLs
ON
URLs.username = userAct.username
WHERE
username = @Username

1-which one is better?
2-Why?
3-what is your suggestion?

 

[fadi]

2 is better since u r going only once to the db