Adding records to db

djobes31770 · November 27th, 2007, 07:30 AM

I am new to VB and trying to port my RealBasic mac app over to windows, rb lacks a lot of the tools and interfaces i need for the app. I have a screen that has a few text fields and a datagrid, and im just wanted to get the data added to the the correct table, i have it setup and initializes the db and table, but it does not load the test fields into the db. Here is what i have for testing so far:

Code:

' Create second column.
        column = New DataColumn()
        column.DataType = System.Type.GetType("System.String")
        column.ColumnName = "PackageID"
        column.AutoIncrement = False
        column.Caption = "PackageID"
        column.ReadOnly = False
        column.Unique = False

        ' Add the column to the table.
        table.Columns.Add(column)


        ' Make the ID column the primary key column.
        Dim PrimaryKeyColumns(0) As DataColumn
        PrimaryKeyColumns(0) = table.Columns("id")
        table.PrimaryKey = PrimaryKeyColumns

        ' Create three new DataRow objects and add 
        ' them to the DataTable
        Dim i As Integer
        For i = 0 To 2
            row = table.NewRow()
            row("id") = i
            row("PackageID") = "PackageID " + i.ToString()
            table.Rows.Add(row)
        Next i

Like i said, im new to vb 2005 is what im testing with now, as proof of concept to move forward to the latest versions of the dev tools.

gbianchi · November 27th, 2007, 08:38 AM

I there.. after you do this, are you fetching the data into the database??? with a table.acceptchanges or something like that???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

djobes31770 · November 27th, 2007, 09:20 AM

No this is all i have, it was all i could find from several referances to add data to db. the beginning vb book.

gbianchi · November 27th, 2007, 09:27 AM

well.. read it again.. you should fetch the data back to the database somewhere.. it's not an automatic process.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========