private void buttonExportToWord_Click(object sender, EventArgs e) { BookLoanModel bloanM = new BookLoanModel(); bookloanDAL bloanD = new bookloanDAL(); bookLoan = bloanD.Select(); Microsoft.Office.Interop.Word.Application word = new Microsoft.Office.Interop.Word.Application(); Document doc = word.Documents.Add(); Microsoft.Office.Interop.Word.Range rng = doc.Range(0, 0); doc.Content.Text = "hello"; doc.Content.Text = "dude"; Table wdTable = doc.Tables.Add(rng, bookLoan.Rows.Count + 1, bookLoan.Columns.Count); wdTable.Borders.OutsideLineStyle = WdLineStyle.wdLineStyleDouble; wdTable.Borders.InsideLineStyle = WdLineStyle.wdLineStyleSingle; try { doc = word.ActiveDocument; //i is the row index for (int i = 0; i < bookLoan.Rows.Count; i++) { for (int j = 0; j < bookLoan.Columns.Count; j++) { if (i == 0) { wdTable.Cell(i + 1, j + 1).Range.InsertAfter(bookLoan.Columns[j].ToString()); } { wdTable.Cell(i + 2, j + 1).Range.InsertAfter(bookLoan.Rows[i][j].ToString()); } } } if (saveFileDialog1.ShowDialog() == DialogResult.OK) { doc.SaveAs2(saveFileDialog1.FileName); Process.Start("winword.exe", saveFileDialog1.FileName); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { word.Quit(); word = null; doc = null; } }
public void refreshData() { DataTable dt = bookloanD.Select(); dataGridViewManageBookLoanDatabase.DataSource = dt; }