[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 & ")"

[timeshifter]

Look at this INSERT statement pulled directly from one of my apps. Should be fairly easy to figure out why yours isn't working.

InsertCommand="INSERT INTO [tblNewArrivals] ([intGunID], [bitActive], [dtPosted], [strPostedBy]) VALUES (@intGunID, @bitActive, @dtPosted, @strPostedBy)"

[mendhak]

STR_VALUES = PRODUCT_ID.ToString() & "," & TRANS_TYPE.ToString() "," & "TRANS_STATUS"