How do I cure the Unhandled Exception Error Issue

[vafishing]

I have a button on a dataform that when pushed is designed to load some data from an sql database. Here is the code:

Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click
objcustomer.Clear()
Try
SqlDataAdapter1.Fill(objcustomer)
Catch ex As Exception
MsgBox(ex.ToString)
Stop
End Try


End Sub

In reading the error message, the problem appears to be the statement SqlDataAdapter1.Fill(objcustomer) Is there something I did wrong in generating the dataset? Is that what causes these unhandled errors. How do I cure the issue so I can load the data. The debug section does not tell me much. Is there a more decriptive window in vb net that tells me what this problem is?

 

[JohnYingling]

There must be 1000 things that can cause an error during Fill. Connection, command, command.select, command.parameters, objCustomet not set to instance of dataset. The ex.Tostring text would be helpful.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)