Community discussion forum

how to get all employee id in to single variable?

• • Reply

  3 months ago

  by cacol321

  cacol321

  , Chile

  Joined 6 months ago

  I am using .net 2005.i am doing my project in asp.net.my project title is master log attendance.how to get all employee id in to single variable?
  
  We have got employee id from single table by using single variable.but the datas are displayed for final id only.but we want to get more employee id from single variable.
  
  The following code
  
  
  protected void img_submit_Click(object sender, ImageClickEventArgs e)
  {
  from_date = txt_fr_date.Text;
  to_date = txt_to_date.Text;
  emp_name = ddl_emp_name.SelectedValue;
  check();
  }
  void check()
  {
  
  System.TimeSpan dt_diff = Convert.ToDateTime(to_date).Subtract(Convert.ToDateTime(from_date));
  days = dt_diff.Days;
  
  
  dt.Columns.Add(new DataColumn("ID", typeof(string)));
  dt.Columns.Add(new DataColumn("Name", typeof(string)));
  
  string empid1;
  com = new SqlCommand("select distinct(emp_id) from tbl_report", con);
  dr = com.ExecuteReader();
  while (dr.Read())
  {
  
  empid1 = dr.GetString(0);
  
  }
  dr.Close();
  for (int i = 0; i <= days; i++)
  
  {
  sql_date = Convert.ToDateTime(from_date).AddDays(i).ToString("MM/dd/yyyy");
  sql_date1 = Convert.ToDateTime(from_date).AddDays(i).ToString("MM/dd/yyyy");
  
  
  dt.Columns.Add(new DataColumn(sql_date1, typeof(string)));
  drow = dt.NewRow();
  
  
  
  
  com = new SqlCommand("select distinct rpt.emp_id as EmployeeID,card.username as EmployeeName,min(case when rpt.datetime1='" + sql_date + "' then rpt.datetime1 end) as '" + sql_date + "' from tbl_card as card,tbl_report as rpt where card.fkdata=rpt.emp_id and rpt.datetime1='" + sql_date + "' and emp_id='" + empid1 + "' group by rpt.emp_id,card.username", con);
  dr = com.ExecuteReader();
  while (dr.Read())
  {
  drow[0] = dr.GetString(0);
  drow[1] = dr.GetString(1);
  
  drow[i+2] ="x";
  dt.Rows.Add(drow);
  }
  dr.Close();
  
  
  }
  
  
  
  GV_musterrole.DataSource = new DataView(dt);
  GV_musterrole.DataBind();
  
  }
  
  in above code,i get all employee id into variable name as empid1.then i put empid1 for employeeid field in where condition of query in for loop.
  but displayed only one employee id as follow in grid view,
  
    ID   Name   10/11/2007 10/12/2007 10/13/2007 10/14/2007  10/15/2007
   370 ramesh                                                          x
  
  so i want to get all employee id into single variable name as empid1.then put empid1 for employeeid field in where condition of query means,i want to come all employee id details as follow.
  ID   Name   10/11/2007 10/12/2007 10/13/2007 10/14/2007 10/15/2007
  366 dinesh                        x               x                x
  367 ram                            x
  369 guru                           x                                 x
  370 ramesh                                                         x
  

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  3 months ago

  by mtaivalmaa

  Mike Taivalmaa

  , United States

  Joined 8 months ago

   Hi,

   

     Get Employee id also in the array variable. A normal variable can store only one variable at a time.so try with array .
  

  Report abuse