public void Locationbind()
{
SqlCommand sqlCmd = new SqlCommand("SELECT Name FROM Jct_PayrollPortal_ActionCategory WHERE STATUS = 'A' ", obj.Connection());
sqlCmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(sqlCmd);
DataSet ds = new DataSet();
da.Fill(ds);
DrpLvStatus.Items.Clear();
DrpLvStatus.DataSource = ds;
DrpLvStatus.DataTextField = "NAME";
DrpLvStatus.DataValueField = "NAME";
DrpLvStatus.DataBind();
}
public void Locationbind()
{
//SqlCommand sqlCmd = new SqlCommand("SELECT Name,SName FROM Jct_PayrollPortal_ActionCategory WHERE STATUS = 'A' ORDER BY NAME ", obj.Connection());
SqlCommand sqlCmd = new SqlCommand("Jct_PayrollPortal_ActionCategory_Fetch", obj.Connection());
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@ECode", SqlDbType.VarChar, 15).Value = Session["Empcode"].ToString();
sqlCmd.Parameters.Add("@CatgF", SqlDbType.Char, 1).Value = "Y";
SqlDataAdapter da = new SqlDataAdapter(sqlCmd);
DataSet ds = new DataSet();
da.Fill(ds);
DrpLvStatus.Items.Clear();
DrpLvStatus.DataSource = ds;
DrpLvStatus.DataTextField = "SName";
DrpLvStatus.DataValueField = "NAME";
DrpLvStatus.DataBind();
}
public void Locationbind()
{
string sql = "Jct_Payroll_Reim_Attendence_LastFourMonth_Ash";
SqlCommand cmd = new SqlCommand(sql, obj.Connection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add("@employeecode", SqlDbType.VarChar, 10).Value = Session["EmpCode"];
cmd.ExecuteNonQuery();
SqlDataAdapter Da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
Da.Fill(ds);
DrpLvStatus.Items.Clear();
DrpLvStatus.DataSource = ds;
DrpLvStatus.DataTextField = "Monthyear";
DrpLvStatus.DataValueField = "Monthyear";
DrpLvStatus.DataBind();
}
