>ok, thank you for reply me.You mean SqlConnection.open in before ,i will need to try .... Catch .....End Try.
>But if i use dataset, TableAdapterManger then how to handle or not? Thank you
>
>
>

>
> Me.TableAdapterManager.UpdateAll(Me.MyDataSet)
>

I don't use TableAdapter, but you can put that call in a try/catch block, and catch for SqlException. Take a look at the MSDN article on SqlException:

http://msdn.microsoft.com/en-us/library/686y883x.aspx

Also, you might want to do a Google search on .NET SqlException. I found several blogs on the topic ... so, do a little reading there, you'll probably find some good ideas.

~~Bonnie