[2005] Update,Insert using SQLDataSource

[bomayed]

I know how to do a select statement using SQLDatasource.SelectedCommand

I tried to insert using the same code , but , I'm not getting any thing inserted to the database and I'm not getting an error message

This is the code I'm using

        Dim PRODUCT_ID, TRANS_TYPE, TRANS_STATUS As Integer
        
        PRODUCT_ID = Me.GridView1.Rows(0).Cells(0).Text
        TRANS_TYPE = 2
        TRANS_STATUS = 1

        Dim STR_FIELDS As String 
        Dim STR_VALUES As String

        STR_FIELDS = "[PRODUCT_ID], [TRANS_TYPE], [TRANS_STATUS]"
        STR_VALUES = "PRODUCT_ID, TRANS_TYPE, TRANS_STATUS"

        Me.SqlDataSource2.SelectCommand = "INSERT INTO [TRANSACTIONS] (" & STR_FIELDS & ") VALUES (" & STR_VALUES & ")"