private static int iMonth = 1;
        public DataSet GetRecentEmpData2(int branchid)
        {
            SqlCommand command = new SqlCommand();

            command.CommandText = "GetRecentEmp2";
            command.CommandType = CommandType.StoredProcedure;
            command.Connection = con;
            SqlParameter param = new SqlParameter("@iMonth", SqlDbType.Int);
            param.Value = iMonth;
            command.Parameters.Add(param);
            param = new SqlParameter(paramChg("branchid"), SqlDbType.Int);
            param.Value = branchid;
            command.Parameters.Add(param);

            commandAdp.SelectCommand = command;

            DataSet data = new DataSet();
            try
            {
                commandAdp.Fill(data);
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.ToString());
            }
            con.Close();
            return data;

        }