public sms_institute get_sms_institute() { sms_institute ins = new sms_institute(); using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string)) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "SELECT* FROM sms_institute"; cmd.Connection = con; //cmd.CommandType = System.Data.CommandType.StoredProcedure; try { con.Open(); Byte[] institute_logo; Byte[] male_image; Byte[] female_image; MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); institute_logo = (byte[])(reader["institute_logo"]); male_image = (byte[])(reader["male_image"]); female_image = (byte[])(reader["female_image"]); ins = new sms_institute() { institute_name = Convert.ToString(reader["institute_name"].ToString()), institute_logo = institute_logo, male_image = male_image, female_image = female_image, mac = Convert.ToString(reader["mac"].ToString()), isMultiPartSMSAccess = Convert.ToString(reader["isMultiPartSMSAccess"]), }; } catch (Exception ex) { throw ex; } return(ins); } } }
public MainWindow() { InitializeComponent(); try { ReadDatabaseFile(); insDAL = new InstituteDAL(); empDAL = new EmployeeDAL(); digital_clock(); TabControlMain.SelectedIndex = 0; ins = insDAL.get_sms_institute(); institute_grid.DataContext = ins; image_grid.DataContext = ins; } catch (Exception ex) { error_grid.Visibility = Visibility.Visible; error_grid.DataContext = ex.Message; isInitialized = false; } }