DB/Reporting :: Using The SQLCommandBuilder Class - Updating Database With Dataset ?

I have got problem when using the SQLCommandBuilder class. For me it throws an error saying that the select statement does not return any primary columns.... Which is weird becouse i am sure it does since the select statement is "SELECT * FROM MyTable" I am prety sure that selects everything including the primary column which is set to primary , realy i checked and doublechecked.

Secondly i tried to manually set the column(0) as primary by setting it's property bu no such luck of making it work.

I have these two functions in a class that i instanciate an object from in the main program:

Code:
Public Function GetDB(ByVal DBName As String) As Data.DataSetDim SQLAdapter As SqlClient.SqlDataAdapter = Nothing

Try_SQLdataSet = Nothing

[CODE]...

This Functtion fills the dataset and returns it to my main program where i do lovely stuff with it. (Just as a side note this is a SCADA system and i always need the entire DB which is never bigger then just a few ( 6 ) entries so i must go for "*" ^^). Good part is, this works like a charm, i love it. Now i need to reset a few status bits etc and i assume with the update command. And that is where my joy starts to get stomped on a bit.... The code:

Code:
Public Function SetDB(ByVal dataTable As Data.DataSet, ByVal DBName As String) As BooleanDim SQLAdapter As SqlClient.SqlDataAdapter = Nothing
Dim SQLCommandBuilder As SqlClient.SqlCommandBuilder

[CODE]...

Now this would have been a great and small sollution to updating datasets with the server but obviously it doesn't work. There is that pesky error about my table having no primary key and I know it's lying it just want to annoy me :P. But seriously I am puzzeld why that error wont go away and i have exhausted all the tutorials i can find on this.