[Solved] Column value not updated in database Table using VB.Net

Akram.19
 
on Jun 29, 2022 07:43 AM
397 Views

I have a table in sql that contains a varchar() column called Transaction_Value.

I have a Button in form1 that must update that column with specific word but there are no any updates in table. 

Dim UpdateCmd1 As String = "UPDATE DATAGRID " & _
    "SET Transaction_Type ='" & "Loading" & "' " & _
    "WHERE tank_name ='" & ComboBox1.Text & "' AND material_name = '" & ComboBox2.Text & "'"
If SQL.Update(UpdateCmd1) = 0 Then
    MsgBox("")
    Exit Sub
End If
Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Jun 29, 2022 07:47 AM
Akram.19 says:
Dim UpdateCmd1 As String = "UPDATE DATAGRID " & _
                                      "SET Transaction_Type ='" & "Loading" & "' " & _
                                      "WHERE tank_name ='" & ComboBox1.Text & "' AND material_name = '" & ComboBox2.Text & "'"

In your update query you have specified Transaction_Type. You need to specify the Transaction_Value column with its value.

Use parameterized query instead of string concatenation.

Using Parameterized queries to prevent SQL Injection Attacks in SQL Server