I dont know what im doing wrong, but the dataadapter, doesnt
find the table im looking for:
Public Shared Function DSet(ByVal ID As Integer, ByVal Name As String, ByVal Address As String, ByVal City As String, ByVal State As String, _
ByVal ZipCode As Integer, ByVal Phone As String) As DataSet
Dim daAdapter As SqlDataAdapter
Dim scConnection As SqlConnection = Nothing
Dim ds As DataSet = Nothing
Try
Dim rCommand As String
rCommand = "INSERT INTO WholeSaler_Details VALUES (" & ID & ", " & Name & ", " & Address & ", " & _
City & ", " & State & ", " & ZipCode & ", " & Phone & ")"
scConnection = GetConnection()
daAdapter = New SqlDataAdapter
ds = New DataSet
daAdapter.InsertCommand = New SqlCommand(rCommand, scConnection)
daAdapter.Update(ds, "WholeSaler_Details")
scConnection.Close()
Return ds
Catch sqlEx As SqlException
MessageBox.Show(sqlEx.Message, _
"Error Encontrado", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
Return ds
Finally
scConnection.Close()
End Try
End Function