Use The Current Username For Filtering In SQL Statement

My objective is to only get the records for Current USER's region and district.  Please let me know

what I am missing....Thank you!!!

private void Page_Load(object sender, System.EventArgs e)

{

      if (!IsPostBack)

      {

            bindGrid();

      }

}

 

private void bindGrid()

{

         @username=HttpContext.Current.User.Identity.Name;

         SqlCommand getCommand = new SqlCommand();

         getCommand.Connection=sqlConnection1;

         getCommand.CommandText="SELECT DealerCode,DealerName,ClaimCount," +

         "Total$,CliamDays FROM DealerList,pwausers,pwadlrs WHERE" +

         "@username=user_name AND parts_reg=dmpreg AND parts_dist=dmpdist";

         sqlConnection1.Open();

         sqlDataAdapter1.Fill(dataSet1);

         DataGrid1.DataSource=dataSet1;

         DataGrid1.DataBind();

         Cache["DealerListData"]=dataSet1;

         sqlConnection1.Close();

}