My code below if the item exists, the mpe shows, howerver if its added the mpe wont show?
Public Sub ADDACCOUNT()
'Creating a new Item
'Make sure Item doesn't already exist
SqlAddAcct.SelectCommand = "SELECT * FROM FTPGroup WHERE ACCTNUM = '" & Server.HtmlEncode(txtAcctId.Text) & "'"
Dim dv As DataView = CType(SqlAddAcct.Select(DataSourceSelectArguments.Empty), DataView)
If dv.Count > "0" Then
lblText.Text = "EXISTS"
mpe.Show()
Exit Sub
End If
'Item doesn't exist so create new
If txtAcctId.Text <> "" Then
SqlAddAcct.InsertCommand = "INSERT INTO FTPGroup(ACCTNUM,GCONTFIRST,GCONTLAST,GCONTEMAIL) VALUES('" & Server.HtmlEncode(txtAcctId.Text) & "','" & Server.HtmlEncode(txtGFirstName.Text) & "','" & Server.HtmlEnc ...
Go to the complete details ...