See the comments to your previous question
How to check empty fields using VB.NET[
^]
1. You were told to use Parameterised queries. Apart from avoiding SQL Injection, using parameters very often makes other issues "go away". Highly likely that this will solve part of your problem here.
2. You were also told
Quote:
Then we move on to the fact that you're using a DataAdapter to fill a DataSet, but the query you're executing is an INSERT, which doesn't return any records. You should use an OleDbCommand and call ExecuteNonQuery instead.
If you don't apply the advice you are given then members will very quickly just stop trying to help you at all. Fix these two issues and try again.