Hi,
Why does the update statement not working..
Dim strConn As String
strConn = ConfigurationManager.ConnectionStrings("CCMSConnectionString").ConnectionString
Dim conn As New SqlConnection(strConn)
Dim nextconn As New SqlConnection(strConn)
conn.Open()
Dim strSql As String
strSql = "INSERT INTO dbo.TblTechDetails (RefNo, ChangeDesc, Regression, TestDesc, Comment) VALUES (@RefNo, @ChangeDesc, @Regression, @TestDesc, @Comment)"
Dim cmd As New SqlCommand(strSql, conn)
With cmd.Parameters
.AddWithValue("@RefNo", txtref.Text)
.AddWithValue("@ChangeDesc", txtchng.Text)
.AddWithValue("@Regression", txtreg.Text)
.AddWithValue("@TestDesc", txttest.Text)
.AddWithValue("@Comment", txtcomm.Text)
End With
cmd.ExecuteNonQuery()
Dim query As String
Dim cmdC As New SqlCo ...
Go to the complete details ...