Inserting Into Sql Express With Vb.net

Hi guys.

I have couple question about inserting values into tables. First of all I like to know , how do you start on designing multiple table data entry screens? Do you design bound items? or you would design the form without bounding any component and insert data with ado (manually)?



Also, I want to know which way is better to insert tables? ADO or bound items and data forms. AS you all know after making components (objects like textboxes) you could add a new row and update the table like this.

me.mydataAdapter.update(me.mydataset.mytable)

how ever I know there is more way to do that which shown below;

Dim newRow As KasaDataSet.transactionsRow = Me.KasaDataSet1.transactions.NewRow()

newRow.adet = Me.txtquantity.Text

newRow.trproductid = CInt(Me.txtproductid.Text)

Me.KasaDataSet1.transactions.Rows.Add(newRow)

on 3rd line TRPRODUCTID is uniqueIdentifier type of sqlexpress (FK) field. I get error message when I try to rund this message saying that;

Error 1 Value of type 'Integer' cannot be converted to 'System.Guid'

Do you have a solution for me?

Or should I use ADO.net old ASP like connection and user SQL insert command??

what you guys think please let me know.

thanks