I've a bit problem with my coding. What i m trying to do is to add a row in a table, but i m having errors. Any idea Pls help me

this links will guide you

http://www.homeandlearn.co.uk/net/nets12p10.html[^]

http://www.wallaceit.co.uk/asp-net-vb/adding-a-new-row-to-datatable-with-vb-net/208/article.aspx[^]

http://msdn.microsoft.com/en-us/library/5ycd1034(v=vs.71).aspx[^]

Dim dsNewRow As DataRow

If you want to add a new row to your DataSet, you need a DataRow object. This line just sets up a variable called dsNewRow. The type of variable is a DataRow.

To create the new DataRow object, this line comes next:

dsNewRow = ds.Tables("AddressBook").NewRow()

We're just saying, "Create a New Row object in the AddressBook DataSet, and store this in the variable called dsNewRow." As you can see, NewRow() is a method of ds.Tables. Use this method to add rows to your DataSet.

The actual values we want to store in the rows are coming from the textboxes. So we have these two lines:

dsNewRow.Item("FirstName") = txtFirstName.Text
dsNewRow.Item("Surname") = txtSurname.Text

The dsNewRow object we created has a Property called Item. This is like the Item property you used earlier. It represents a column in your DataSet. We could have said this instead:

dsNewRow.Item(1) = txtFirstName.Text
dsNewRow.Item(2) = txtSurname.Text

The Item property is now using the index number of the DataSet columns, rather than the names. The results is the same, though: to store new values in these properties. We're storing the text from the textboxes to our new Row.

We now only need to call the Method that actually adds the Row to the DataSet:

ds.Tables("AddressBook").Rows.Add(dsNewRow)

To add the Row, you use the Add method of the Rows property of the DataSet. In between the round brackets, you need the name of your DataRow (the variable dsNewRow, in our case).

In your debugger, have a look at your variable ds. Is it valid, does it contain a reference to a dataset or is it null?

Also, you are trying to access a table named 'Admin' within the DataSet. If the dataset is valid, does it contain a table named Admin? If not, this would return null.

Check both of these out in your debugger, you should be able to determine where the problem is.