Loop through Datatable and call Modal popup if data not exists

Fedex rep is a column name in datatable.

Why don't you check the Fedex rep before inserting the data?

Loop through datatable and check for Fedex rep.

If no rep  show modal popup

Again need to loop through datatable, if everything looks fine, then start inserting in another for loop.

Code should look something like this!!

Sub Save()

For each prow as datarow in datatable
Check for rep
If no rep show a message and exit sub
Next
For each prow as datarow in datatable
Insert row
Next


End sub

Thanks

Here is my datatable

accountnumber   fedexRep   shipmentdate county state zip orderby
12345                  john doe     5/13/2011      Springfield    ca   jsmith
etc

I am checking john doe if exist on my Representative table,
 if john doe exists,
    insert 12345                  john doe     5/13/2011      Springfield    ca   jsmith
to my Clientorder table

if he does not
 Modal display, allows a user to select other rep or  insert john doe to Representative table
  then insert  12345                  Tom Jones(if user select a different name)    5/13/2011      Springfield    ca   jsmith

#1, I can loop and check rep, no problem, then display Modal pop up and exit?
Could you show me how to do in code behind? I am not 100% sure what you meant.
Sub Save()

1. For each prow as datarow in datatable
Check for rep
If no rep show a message and exit sub
Next
2. For each prow as datarow in datatable
Insert row
Next
End sub

The main reason why I am checking Rep name first is the sometime clients send rep like this

john doe
or john a doe
or jdoe

This is just a sample, Basically, this is the same rep.

i would like to see code behind for sample.

if i understand ur req correctly,    you can show the modalpopup , in code behind like

For Loop
       if (Condition)
            (YOUR MODEL POPUP ID).show()
            Exit For
       End if
Next

Select allOpen in new window

For Loop
       if (Condition)
            (YOUR MODEL POPUP ID).show()
            Exit For                                           << what if there are a few that can't find, this wouldn'  work,   would it?
       End if
Next
For Loop
      Loop through Datatable from row 1 to the end and insert row in DB?
Next

Ya that should be the way. See this link for msg box.

http://www.codeproject.com/KB/webforms/NingLiangSimpleControl.aspx

I need Modal. See above comment. Not Msg.

http://mattberseth.com/blog/2008/04/masterdetail_with_the_gridview.html