private void openLectureBtn_Click(object sender, EventArgs e) { readerPdf rd = new readerPdf(); try { MySqlDataAdapter ad; MySqlConnection con = new MySqlConnection(); con.ConnectionString = login.dbConnection; string bookdetail = "select * from lecture where lecture_id = '" + lect_id + "'"; MySqlCommand com = new MySqlCommand(bookdetail, con); try { con.Open(); if (Lcheck == true) { // MySqlDataReader reader; ad = new MySqlDataAdapter(com); // reader = com.ExecuteReader(); DataTable table = new DataTable(); ad.Fill(table); try { byte[] book = (byte[])table.Rows[0][2]; //wrinting a Pdf File using (Stream file = File.Create("C:/Users/" + currentComputerUserName + "/AppData/Roaming/UdoRead/Lectures/Lecture.pdf")) { file.Write(book, 0, book.Length); } //opening the pdf file rd.axAcroPDF1.src = "C:/Users/" + currentComputerUserName + "/AppData/Roaming/UdoRead/Lectures/Lecture.pdf"; rd.Show(); } catch { } ad.Dispose(); } else { MessageBox.Show("Please Select Lecture to View"); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } con.Close(); } catch { MessageBox.Show("No book selected..!", "Alert", MessageBoxButtons.OK); } }
private void viewBtn_Click(object sender, EventArgs e) { var button = sender as BunifuFlatButton; readerPdf rd = new readerPdf(); MySqlConnection con = new MySqlConnection(); con.ConnectionString = login.dbConnection; string bookdetail = "select item from sentitems where item_id = '" + button.Name + "'"; MySqlCommand com = new MySqlCommand(bookdetail, con); DataTable table = new DataTable(); MySqlDataReader reader; try { con.Open(); reader = com.ExecuteReader(); table.Load(reader); reader.Close(); byte[] book = (byte[])table.Rows[0][0]; //wrinting a Pdf File C:/Users/"+currentComputerUserName+"/AppData/Roaming/UdoRead/Videos/ using (Stream file = File.Create("C:/Users/" + computerUserName + "/AppData/Roaming/UdoRead/Books/book.pdf")) { file.Write(book, 0, book.Length); } //opening the pdf file rd.axAcroPDF1.src = "C:/Users/" + computerUserName + "/AppData/Roaming/UdoRead/Books/book.pdf"; rd.Show(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } con.Close(); }