public static void saveDoctorTable()
{
SaveFileDialog savefile = new SaveFileDialog();
// set a default file name
savefile.FileName = "Doctors.xls";
// set filters - this can be done in properties as well
savefile.Filter = "Excel files (*.xls)|*.xls";
bool res = savefile.ShowDialog() ?? false;
if (res)
{
using (StAbraamEntities db = new StAbraamEntities())
{
var query = db.Doctors.Select(i => i).AsQueryable();
var adapter = (IObjectContextAdapter)db;
var objectContext = adapter.ObjectContext;
//try
//{
EntityToExcelSheet(savefile.FileName, "Doctors", query, objectContext);
//}
//catch (Exception ex)
//{
// MessageBox.Show("Error: " + ex.Message,
// "Error Creating Excel File");
//}
}
}
}
