I want to loop through my datatable rows and check for valid email addresses, if the address is valid, I want to add the row to the database, if not I want to add it to another datatable, but my main problem at the moment is checking for a valid email address, the code I have so far is

VB Code:
  1. 'Loop through the rows of the DataTable
  2.         Do While i <= dt.Rows.Count - 1
  3.             checkEmail = dt.Rows(i).Item("E-Mail")
  4.             'If curCat = "" Then
  5.             If InStr(checkEmail, "@") = 1 Then
  6.                 'prevCat = curCat
  7.                 lblMessage.Text = "Email Checked"
  8.                 'Dim shRow As DataRow = dt.NewRow
  9.                
  10.                 'dt.Rows.InsertAt(shRow, i)
  11.  
  12.  
  13.                 i += 1
  14.             End If
  15.  
  16.             i += 1
  17.         Loop