>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.aspxAlso, 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