Reporter Home

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class Reporter_ReporterHome : System.Web.UI.Page
{

    DBUpdate reporter = new DBUpdate();
    SqlDataReader drdr;
    protected void Page_Load(object sender, EventArgs e)
    {
       int idUser = Convert.ToInt32(Session["idUser"]);
       string name = "";
        reporter.cmd.Parameters.Clear();

        SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        p.Direction = ParameterDirection.ReturnValue;
        reporter.cmd.Parameters.Add(p);
        reporter.cmd.Parameters.AddWithValue("@userid", idUser);

        string fetchrow = "select * from tblReporterRegistration,tblUser where tblReporterRegistration.regnId = tblUser.registrationid and  tblUser.userid= " + idUser;

        drdr = reporter.datareader(fetchrow);
        while (reporter.dr.Read())
        {

            name = drdr["firstname"].ToString();
        }
        
        lbllogin.Text = "Welcome " + name;
     
    }
  }