private void BindDDLWorkShift()
{
SqlParameter[] arrparm = new SqlParameter[2];
arrparm[0] = new SqlParameter("@Action", "SELECT_ByStatus");
arrparm[1] = new SqlParameter("@Status", true);
DataSet DSRecordWorkShift = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_EmployeeWorkShift_CRUD", arrparm);
if (DSRecordWorkShift.Tables[0].Rows.Count > 0)
{
DDLWorkingShift.DataSource = DSRecordWorkShift.Tables[0];
DDLWorkingShift.DataTextField = "Name";
DDLWorkingShift.DataValueField = "ID";
DDLWorkingShift.DataBind();
DDLWorkingShift.Items.Insert(0, new ListItem("Select", "0"));
}
}
