Visual Basic

Public Class myDataGridView
    Inherits DataGridView

    Protected Overrides Function ProcessCmdKey( _
              ByRef msg As System.Windows.Forms.Message, _
              ByVal keyData As System.Windows.Forms.Keys) _
              As Boolean

        '** When the Enter key is pressed in the textbox column,
        '** substitute Ctrl^Enter
        If keyData = Keys.Enter Then
            SendKeys.SendWait("^{ENTER}")
            Return True
        Else
            Return MyBase.ProcessDialogKey(keyData)
        End If

    End Function

End Class

Public Class Form1

    Dim dgv As New myDataGridView

    Private Sub Form1_Load(ByVal sender As System.Object, _
                           ByVal e As System.EventArgs) _
                           Handles MyBase.Load

        '** Add the datagridview to the form
        Controls.Add(dgv)
        dgv.Left = 10
        dgv.Top = 10

        '** Add a textbox column
        Dim dgvCol As New DataGridViewTextBoxColumn
        With dgvCol
            .HeaderText = "Text Column"
            .Name = "chdrTextCol"
            .Width = 130
        End With
        dgv.Columns.Add(dgvCol)
        dgvCol = Nothing

        '** Add a row
        dgv.Rows.Add()

    End Sub

End Class

imports system.net.mail

dim msg as new mailmessage(senderemail,recemail,subject,body)
dim client as new smtpclient
client.host="smtpserver"
client.send(msg)

OleDbConnection con = new OleDbConnection(string.Format("Data Source={0};Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;", excelfileName));

sqlToRun= string.Format("insert into mytable(mycolumn1,mycolumn2) values ('{0}','{1}'",val1,val2);
cmd = new OleDbCommand(sqlToRun, con);
cmd.ExecuteNonQuery();