I fill in a dataset its data table and use it for binding some textboxes

        con.Open()

        da = New SqlDataAdapter("SELECT * FROM Item", connection)

        da.Fill(ds, "Item")

        cmb = New SqlCommandBuilder(da)

        txtItemName.DataBindings.Add(New Binding("Text", ds.Tables("Item"), "Item_Name"))
        txtItemDescription.DataBindings.Add(New Binding("Text", ds.Tables("Item"), "Item_Description"))
        txtCurrentStock.DataBindings.Add(New Binding("Text", ds.Tables("Item"), "CurrentStock"))
        txtUnitPrice.DataBindings.Add(New Binding("Text", ds.Tables("Item"), "UnitPrice"))

DGV1.DataSource = ds.Tables("Item")

  Dim dr As DataRow = ds.Tables("Item").NewRow

        dr("Item_Name") = txtItemName.Text
        dr("Item_Description") = txtItemDescription.Text
        dr("CurrentStock") = txtCurrentStock.Text
        dr("UnitPrice") = txtUnitPrice.Text

        ds.Tables("Item").Rows.Add(dr)

        da.Update(ds, "Item")
        ds.Tables("Item").AcceptChanges()

OK, I am not sure how you start with the add new. Do you using a BindingSource as the datasoruce?
By reading you describption,

"Now when i want to insert a new record to the table, i clear all the current textboxes and let the user type the new information
Item Name,Item Description,Current Stock and Unit Price"

Here is my guess:
You table does not have a primary key or unit key.

1. Your DataGirdView has the current row (focus) on the first row
2. You click a Add new button, what you are doing is simply clear all the text box.
--- This is not good as all the text box is still bound to the first row in the datagridview, and the corresponing datarow.
3. You let user enter something on the text boxes.
4. User click on the save button.
5. The save button do this:

Dim dr As DataRow = ds.Tables("Item").NewRow

dr("Item_Name") = txtItemName.Text
dr("Item_Description") = txtItemDescription.Text
dr("CurrentStock") = txtCurrentStock.Text
dr("UnitPrice") = txtUnitPrice.Text
ds.Tables("Item").Rows.Add(dr)
da.Update(ds, "Item")
ds.Tables("Item").AcceptChanges()

Thisis what happens
In step 2-3, you are changing the first row in the datagridview.
ds.Tables("Item").Rows.Add(dr)-- one new row add to the bottom of the datatable
da.Update(ds, "Item") -- this new row added to the database
ds.Tables("Item").AcceptChanges() -- the first row is changed (like the new row), and the last row is the actual new row.

Anyway, I think you are not doing the right thing for adding new row.

Some suggestions:
1) Read some article from Microsoft DataAccess technologies here: http://msdn.microsoft.com/en-us/library/wzabh8c4.aspx
I also wrote a instruction style blog here for your reference: http://jcsharp.spaces.live.com/blog/cns!7FF4CD2B1E6A7D55!328.entry?&_c02_vws=1

2) Recommend you use BindingSource in your data binding application.

Create a BindingSource,

Set the BindingSource.DataSource to the DataTable

Set your DataGridView.DataSource to the BindingSource

Bind you TextBox to the field of the same BindingSource

When Add a new item programmatically (you can sure usea BindingNavigator), call BindingSource.AddNew

Hope this help.

John

As I replied before:

"When Add a new item programmatically (you can usea BindingNavigator as well), call BindingSource.AddNew"
That is you call bs.AddNew, this will move your DGV1 to aadd new state and at the same time the textboxes will be cleared.

Have you tried this?

OK, I am not sure how you start with the add new. Do you using a BindingSource as the datasoruce?
By reading you describption,

"Now when i want to insert a new record to the table, i clear all the current textboxes and let the user type the new information
Item Name,Item Description,Current Stock and Unit Price"

Here is my guess:
You table does not have a primary key or unit key.

1. Your DataGirdView has the current row (focus) on the first row
2. You click a Add new button, what you are doing is simply clear all the text box.
--- This is not good as all the text box is still bound to the first row in the datagridview, and the corresponing datarow.
3. You let user enter something on the text boxes.
4. User click on the save button.
5. The save button do this:

Dim dr As DataRow = ds.Tables("Item").NewRow

dr("Item_Name") = txtItemName.Text
dr("Item_Description") = txtItemDescription.Text
dr("CurrentStock") = txtCurrentStock.Text
dr("UnitPrice") = txtUnitPrice.Text
ds.Tables("Item").Rows.Add(dr)
da.Update(ds, "Item")
ds.Tables("Item").AcceptChanges()

Thisis what happens
In step 2-3, you are changing the first row in the datagridview.
ds.Tables("Item").Rows.Add(dr)-- one new row add to the bottom of the datatable
da.Update(ds, "Item") -- this new row added to the database
ds.Tables("Item").AcceptChanges() -- the first row is changed (like the new row), and the last row is the actual new row.

Anyway, I think you are not doing the right thing for adding new row.

Some suggestions:
1) Read some article from Microsoft DataAccess technologies here: http://msdn.microsoft.com/en-us/library/wzabh8c4.aspx
I also wrote a instruction style blog here for your reference: http://jcsharp.spaces.live.com/blog/cns!7FF4CD2B1E6A7D55!328.entry?&_c02_vws=1

2) Recommend you use BindingSource in your data binding application.

Create a BindingSource,

Set the BindingSource.DataSource to the DataTable

Set your DataGridView.DataSource to the BindingSource

Bind you TextBox to the field of the same BindingSource

When Add a new item programmatically (you can sure usea BindingNavigator), call BindingSource.AddNew

Hope this help.

John

As I replied before:

"When Add a new item programmatically (you can usea BindingNavigator as well), call BindingSource.AddNew"
That is you call bs.AddNew, this will move your DGV1 to aadd new state and at the same time the textboxes will be cleared.

Have you tried this?

What is the error (if any), and what do you mean not functioning?
DateTimePicker control seems not very easy for databinding. There seems a lot questions on the web.
Here is a similar question I searched: http://www.tech-archive.net/Archive/DotNet/microsoft.public.dotnet.framework.windowsforms.databinding/2004-12/0005.html
I do not have the experience yet, but i believe there should be a solution out there.