private void lstNames_SelectedIndexChanged(object sender, EventArgs e)
        {
            var context  = new NichiInDatabaseEntities();
            var name     = lstNames.Text;
            var selected = (from emp in context.EmpTables
                            where emp.EmpName == name
                            select emp).FirstOrDefault();

            populateData(selected);
        }
        private void btnDisplay_Click(object sender, EventArgs e)
        {
            //create the datacontext
            var context = new NichiInDatabaseEntities();
            //fetch the names
            var names = from emp in context.EmpTables
                        orderby emp.EmpName
                        select emp.EmpName;

            //associate the names to the listbox...
            lstNames.DataSource = names.ToList();
        }