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(); }