Update control button

[Rudy]

Hello All!
Working on a data grid, with the edit button. Having problems with the
update button. I know my connection is being made, but I have tried so many
diffrent things, and I keep getting diffrent errors. I'm hoping sombody can
look at my code and tell what I'm doing wrong.

Public Sub grdProducts_UpdateCommand(ByVal source As Object, ByVal e As
System.Web.UI.WebControls.DataGridCommandEventArgs) Handles
grdProducts.UpdateCommand

Dim Sqlconnection1 As New SqlConnection(SQL_CONNECTION_STRING)
Dim cmdProd As SqlCommand
Dim txtProductName As String = e.Item.Cells(1).Text
Dim txtSupplier As String = e.Item.Cells(2).Text
Dim txtCost As String = e.Item.Cells(4).Text
Dim txtSRP As String = e.Item.Cells(5).Text
Dim txtInStock As String = e.Item.Cells(3).Text
Dim strUpdate As String


Dim scmd As New SqlCommand(strUpdate, Sqlconnection1)

With scmd.Parameters


.Add(New SqlParameter("@ProductID", _
SqlDbType.Int)).Value = _
CInt(grdProducts.DataKeys(grdProducts.SelectedIndex).ToString
= txbProductID.Text)
grdProducts.EditItemIndex = 1


.Add(New SqlParameter("@ProductName", _
SqlDbType.NVarChar, 40)).Value = e.Item.Cells(2)

.Add(New SqlParameter("@SupplierPart", _
SqlDbType.NVarChar, 50)).Value = e.Item.Cells(3)

.Add(New SqlParameter("@UnitCost", _
SqlDbType.Money, 8)).Value = e.Item.Cells(4)

.Add(New SqlParameter("@UnitSRP", _
SqlDbType.Money, 8)).Value = e.Item.Cells(5)

.Add(New SqlParameter("@UnitsInStock", _
SqlDbType.Int)).Value = e.Item.Cells(6)

.Add(New SqlParameter("@Discontinued", _
SqlDbType.Bit)).Value = e.Item.Cells(5)

'' '.Add(New SqlParameter("@New", _
'' ' SqlDbType.Bit)).Value = chkNew.Checked
.Add(New SqlParameter("@Used", _
SqlDbType.Bit)).Value = e.Item.Cells(5)

End With
Sqlconnection1.Open()

scmd.ExecuteNonQuery()
BindProductsGrid()
Sqlconnection1.Close()
End Sub

Sorry if my code is a little messy, I been trying diffrent things, and
commenting alot of stuff. I took all the comments out.

The error i get now is "Index was out of range. Must be non-negative and
less than the size of the collection. Parameter name: index "

I know I'm pretty close, I'm just not sure where I'm going wrong.

TIA!!!

Rudy

 

[MasterGaurav]

What's the error that you get?

Also, IMHO:

..Add(New SqlParameter("@Discontinued", SqlDbType.Bit)).Value =
e.Item.Cells(5)

should be replaced by:

bool.Parse(e.Item.Cells(5))

--
Cheers,
Gaurav Vaish
http://www.mastergaurav.org
http://mastergaurav.blogspot.com
----------------------