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
Enter your message below
Sign in or Join us (it's free).