Get window to repaint

[=?Utf-8?B?c2lwcHl1Y29ubg==?=]

Here is scenario

Parent Form -Call Child Modal Form -Shows Mesage Box then executes Sql
Statement to delete rows in table.

When I execute the sql statement the Message box doesn't completely disappear
/repaint.
Is there a good way to get the MessageBox to hide

IF MessageBox.Show("Delete Table?", "Delete Records", ) = DialogResult.OK THEN

cmdQuery.DbExecute(sSQL)
CloseDB()
ENDIF

[Thorsten Doerfler]

sippyuconn schrieb:

Parent Form -Call Child Modal Form -Shows Mesage Box then executes Sql
Statement to delete rows in table.

When I execute the sql statement the Message box doesn't completely disappear
/repaint.
Is there a good way to get the MessageBox to hide

IF MessageBox.Show("Delete Table?", "Delete Records", ) = DialogResult.OK THEN

cmdQuery.DbExecute(sSQL)
CloseDB()
ENDIF

<ChildModalForm>.Refresh() before executing the SQL query did not help?

Thorsten Doerfler
--
Microsoft MVP Visual Basic

vb-hellfire visual basic faq | vb-hellfire - einfach anders
http://vb-faq.de/ | http://www.vb-hellfire.de/

[Jialiang Ge [MSFT]]

Hello sippyuconn,

Apart from Thorsten's suggestion, we can also consider creating a new
thread, and run the db operations in it.

If MessageBox.Show("Delete Table?", "Delete Records") = DialogResult.OK Then
Dim dbThread As New Thread(New ThreadStart(AddressOf RunDBCmd))
dbThread.Start()
End If

Private Sub RunDBCmd()
'Run db cmd.
End Sub

If you have any other concerns or questions, please feel free to let us
know.

Regards,
Jialiang Ge (ji****@online.microsoft.com, remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

[Andrew Backer]

Could you describe exactly what is happening? Is the messagebox still showing,
and usable? Or does it look like there are remanants of the messagebox on
the parent form, and the parent form is usable? Does minimizing the parent
form (or dragging off/on screen) cause visual corruption to be erased?

You can try calling ".Invalidate()" on the parent form after the parent messagebox
closes

If MessageBox.Show(...) ... Then
Me.Invalidate()
Do Stuff
End If

When I execute the sql statement the Message box doesn't completely
disappear
/repaint.
Is there a good way to get the MessageBox to hide