Fecthing the data from the mainframe

See more:

.NET4

hi i am able to fecth the values from tha sql server database using code like this

public class MyCustomDataSource
    {
        private List<Employee> _employee = new List<Employee>();
        public IQueryable<Employee> employee { get { return _employee.AsQueryable(); } }
        string ConnectionString = "Data Source=(local);Initial Catalog=Employee;Integrated Security=True";
        public SqlConnection Con = null;
        public MyCustomDataSource()
        {
            GetData();
        }
        public void GetData()
        {
            Con = new SqlConnection(ConnectionString);
            Con.Open();
            string str = "select * from Employee";
            SqlCommand Cmd = new SqlCommand(str, Con);
            SqlDataReader sqlDataReader = Cmd.ExecuteReader();
            while (sqlDataReader.Read())
            {
                Employee emp = new Employee();
                emp.id = sqlDataReader.GetInt32(0);
                emp.name = sqlDataReader.GetString(1);
                _employee.Add(emp);
            }
        }
    }

similarly in my company they have been store the data in the mainframe so any one knows the code to fetch that data and returning data should be iqueryable so please any one help me

hi anyone please help me on this question