Dataconnection error messages

[R]

I am new to .net but have user vb6 and in vb6 I got error messages on
everythin (that war an error..)
In .net I don't get errors when performin databare operations... the code
just exits (like exit sub)
Is there any way I could get the errormessages on this?

Ex. the line
RS23DataAdapter.Fill(RS23DataSet, "Employees")

Just exits without telling me why...

Ronny

[Cor]

Hi R

Just do

try
RS23DataAdapter.Fill(RS23DataSet, "Employees")
Catch sqlExc As SqlException 'if it is SQL and else OledbException
MessageBox.Show(sqlExc.ToString)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

I hope this helps?

Cor

[R]

OK, can I use this for general error trapping for my entire sub? Or must I
have this after each "operation"?
Cuold you explain in details how this work?

Ronny

"Cor" <no*@non.com> wrote in message
news:ey***************@TK2MSFTNGP11.phx.gbl...

Hi R

Just do

try
RS23DataAdapter.Fill(RS23DataSet, "Employees")
Catch sqlExc As SqlException 'if it is SQL and else OledbException
MessageBox.Show(sqlExc.ToString)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

I hope this helps?

Cor

[Cor]

Hi R,
Narrow it there where can be an exception.
Why do it for the full sub if an exception is impossible?
Cor