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;
}
}
