i having a datagrid which having a button Named select... it is select the row data and store into another table. Below is my code but it cant run.. Can anyone help me?
Code:
 
Private Sub details_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles details.ItemCommand

        Dim sqlstr3 As String
        Connect()
        sqlstr3 = "Insert Into AssetMovement (Ass_Code, Ass_Category,Ass_Status,CheckInDate,CheckOutDate,ExpiryDate)" & _
                  "VALUES ('" & e.Item.Cells(1).Text() & "','" & e.Item.Cells(3).Text() & "','" & e.Item.Cells(8).Text() & "','" & DateTime.Now & "',' ','','" & "'30days')"


        If (e.CommandName = "Select") Then
            RunQuery(sqlstr3)
            hidMsg.Value = "S"
            Dps()
        End If
        Response.Redirect("frmAssetMovementList.aspx")

    End Sub