How to Sending Datagridview as email message in c# Winform?

See more:

C#

.NET

SQL-Server

, +

I'm retrieve the data from sql server and store it in datagridview . After this I need to send mail to my client . whatever data is in datagridview , I need to sent the datagridview data's to client as message . I tried my best but i cant add datagridview data in message. below is my code pls help me...


loading datagridview from sql server

DataTable datatable = new DataTable();
     Connection();
     datatable.Load(new SqlCommand("select * from StudentMarksHistory", cs).ExecuteReader());
     dataGridView1.DataSource = datatable.DefaultView;
     cs.Close();

sending mail to client

foreach (DataGridViewRow row in dataGridView1.Rows)
          {
                mailBody +="<tr>";
                foreach (DataGridViewCell cell in row.Cells)
                {
                   mailBody +="<td stlye='color:blue;'>" +cell.Value + "</td>";
                }
                mailBody +="</tr>";
          }
          mailBody +="</table>";

          //your rest of the original code
          mail.Body = mailBody;
string mailBody = "<table width='100%' style='border:Solid 1px Black;'>";