void populateProject()
{
DataTable dt = new DataTable();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
string sqlString = "SELECT Project_ID,Project_Name,Project_Description FROM Project_Master_table";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlString, con);
sda.Fill(dt);
}
if (dt.Rows.Count > 0)
{
EmpView.DataSource = dt;
EmpView.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
EmpView.DataSource = dt;
EmpView.DataBind();
EmpView.Rows[0].Cells.Clear();
EmpView.Rows[0].Cells.Add(new TableCell());
EmpView.Rows[0].Cells[0].ColumnSpan = dt.Columns.Count;
EmpView.Rows[0].Cells[0].Text = "No Data Found";
EmpView.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
void populateEmpview()
{
DataTable dt = new DataTable();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
string sqlString = "SELECT Emp_ID,First_Name,Last_Name,Email,Mobile_number,DOB FROM Employee_Master_Table";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlString, con);
sda.Fill(dt);
}
if (dt.Rows.Count > 0)
{
EmpView.DataSource = dt;
EmpView.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
EmpView.DataSource = dt;
EmpView.DataBind();
EmpView.Rows[0].Cells.Clear();
EmpView.Rows[0].Cells.Add(new TableCell());
EmpView.Rows[0].Cells[0].ColumnSpan = dt.Columns.Count;
EmpView.Rows[0].Cells[0].Text = "No Data Found";
EmpView.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
void populateEmpview()
{
DataTable dt = new DataTable();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
string sqlString = "SELECT Emp_ID,User_Name,Date,Start_Time,End_Time,Project_Name FROM Time_sheet T JOIN Project_Master_table P on E.Project_ID = P.Project_ID JOIN Employee_Master_Table E on E.Emp_ID =";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlString, con);
sda.Fill(dt);
}
if (dt.Rows.Count > 0)
{
EmpView.DataSource = dt;
EmpView.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
EmpView.DataSource = dt;
EmpView.DataBind();
EmpView.Rows[0].Cells.Clear();
EmpView.Rows[0].Cells.Add(new TableCell());
EmpView.Rows[0].Cells[0].ColumnSpan = dt.Columns.Count;
EmpView.Rows[0].Cells[0].Text = "No Data Found";
EmpView.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}