Adding rows to a table

[daticus]

I know this question is very basic but I couldn't find it in my help or any of the forums on this site (Yeah, I searched first). Basically, all I want to know is how to add rows to a table using VB.net. I'm certain it requires a dataset but not sure. You don't have to explain how to do add but just point me in the right direction. Thanks!

[Neoharuo]

I think this is what you are looking for.

Dim newCol As New DataColumn("New Column", GetType(Integer))
        newCol.DefaultValue = 0
        newCol.ReadOnly = False
        oTempTbl.Columns.Add(newCol)

--EDIT--

No its not, hold on, let me fix this...sorry

[Neoharuo]

THIS is what you want...

Dim newRow As DataRow
        newRow.Item(0) = "Whatever"
        newRow.Item(1) = "Something Else"
        oTempTbl.Rows.Add(newRow)

You just have to make sure that the items you are adding correspond to the correct value types in the table columns. Also if the table comes for a database, you may or may not have issues with your primary key field.

[daticus]

THIS is what you want...

Dim newRow As DataRow
        newRow.Item(0) = "Whatever"
        newRow.Item(1) = "Something Else"
        oTempTbl.Rows.Add(newRow)

You just have to make sure that the items you are adding correspond to the correct value types in the table columns. Also if the table comes for a database, you may or may not have issues with your primary key field.

Neoharuo, thank you for replying but where did the oTempTbl object come from? Did you create it from a data source? (I Havea TestDataSet from adding a database named Test with a table named Links, if that helps). This is so much more convoluted than php :\

[Neoharuo]

I'll clarify, the oTempTbl is well just a table that was filled from a database. You can use a data set as well.

TestDataSet.Tables("Links").Rows.Add(newRow)

--EDIT--

Do you say you already filled a dataset or do you need to know how to do that as well?

Also, by adding a row to the Data set, you aren't adding it to the actual database until you do an update on your data adapter. If you need more info let me know.

[mar_zim]

here's the way to add rows to your datatable.

'dt is a datatable
dim dr as datarow=dt.newrow
dr(0)="thanks"<---referring to the first column of your datatable
dt.rows.add(dr)

[daticus]

Hrmm, did I mention that this is done with vb.net 2005 express? I guess I should have.

[daticus]

I'll clarify, the oTempTbl is well just a table that was filled from a database. You can use a data set as well.

TestDataSet.Tables("Links").Rows.Add(newRow)

--EDIT--

Do you say you already filled a dataset or do you need to know how to do that as well?

Also, by adding a row to the Data set, you aren't adding it to the actual database until you do an update on your data adapter. If you need more info let me know.

I appreciate your help, but I think I should go to Borders and just open a book on ADO.net and hope that its similar for .net 2.0 :|

[daticus]

Alright, I'm at a lost; I can't find any books for ado.net for vb.net 2k5 (But plenty for 2k3). BUT! I read the "Introducing VB.net 2k5" and I read the ado.net part and it says that the 2k5 version is just like the 2k3 version (for legacy code and to lessen the learning curve for 2k3 developers). However, I can't get 2k3 code to work! Here's what I understand so far for ado.net for 2k5...

1) Connect to a db (sqlexpress) using a sqladapter (done for me using wizard)
2) Create a tableAdapter to fill a dataSet using the fill method (I can do this)

Now how do I add records to the dataset? Well this is what I THINK...

3) Create a datarow from the dataset defined in step 2 and fill it with data
4) Add the row to the dataset (I'm sure I went wrong here)
5) Update the dataSet to the database using the tableAdapter.

Can someone post a dummy project or code doing this within a button click event so I can learn this already? THANK!

[uk_codemonkey]

Daticus, I'm using VS2002, and I tend to use the wizards for creating DataAdaptors and Datasets. It makes life 100 times easier, even if the DataAdaptor you build isn't the finished article.

What I generally do is run the wizard so that at least the code gets written "on the fly". Then once it's finished, I go into the properties for the DataAdaptor and modify the SQL statements where necessary - I almost always build DA's that use Stored Procedures, rather than having naked SQL code hard-wired into the application.

Once you've got the DataAdaptor properly configured, and you can browse it's contents by testing it, you can then go ahead and build the DataSet object and bind your fields to it. I tend to bind the fields programmatically too, so that if I add more fields, or change field bindings, I have a single subroutine that I can go to for that.

HTH

[daticus]

I've been reading a book on ado.net 1.1 and discovered that you can execute sql commands against the SqlCommand object to do whatever you want to the database. I've got it to work and adding records was fine, but they don't save into the database, it seems it only saves into the in memory temporary database, here's the code:

Dim con As New System.Data.SqlClient.SqlConnection()
  con.ConnectionString = My.Settings.SqlX
        Dim cmd As New System.Data.SqlClient.SqlCommand()
        cmd.CommandText = "insert into Names values('Bob')"
        cmd.Connection = con
        Try
            con.Open()
            Dim i As Integer = cmd.ExecuteNonQuery
 
 
            MsgBox(i.ToString())
        Catch ex As Exception
            MsgBox(ex.ToString())
        Finally
 
            con.Close()
        End Try

If you're not using a dataAdapter or dataSet do you still have to "update" the database? I don't see why you would have to but I'm a novice.

Thanks!

[rikimaruXP]

Try using the "update" method of DataAdapter.

Refer to this example:

your_dataadapter.UPDATE(your_dataset, "your_tablename")