Hi experts,
I have written some line of codes for a web page to update the data into sql database. There is no any error display.The only problem is that details are not updating in the database. This code works fine in vb.net.

Public Sub savedata(ByVal job_code As String, ByVal year As String, ByVal month As String, ByVal system As String)
Dim i As Integer
Dim cu As SqlCommandBuilder
cu = New SqlCommandBuilder(da)
da = New SqlDataAdapter("select * from DTS_DETAILS", sqlcon)
ds = New DataSet
da.Fill(ds, "DTS_DETAILS")
i = MsgBox("Are you sure to save the details", MsgBoxStyle.YesNoCancel, "Save ?")
If i = 6 Then
Dim dr As DataRow
dr = ds.Tables("DTS_DETAILS").NewRow()
dr.Item(0) = job_code
da.InsertCommand = (New SqlCommandBuilder(da)).GetInsertCommand()
da.Update(ds, "DTS_DETAILS")
MsgBox("Data updated successfully")
sqlcon.Close()
End If
End Sub