Add parameter SQL

SqlConnection connection = new SqlConnection(Program.C); connection.Open(); string cmdText = "Update table1 set rate=@rate,qty=@qty,total=@total where id=@id"; SqlCommand command = new SqlCommand(cmdText, connection); command.Parameters.AddWithValue("rate", rate); command.Parameters.AddWithValue("qty", qty); command.Parameters.AddWithValue("total", total); command.Parameters.AddWithValue("id", id); command.ExecuteNonQuery(); connection.Clos...

Read More

Connection my sql

Imports MySql.Data.MySqlClient Public Class clsConnecetion     Public ConMy As MySqlConnection = New MySqlConnection     'Dim Hostname As String = "172.00.00.000"     'Dim DBName As String = "XXX"     'Dim SID As String = "admin"     'Dim Password As String = "1234567890"     Public Sub ConnectOpen()         ConMy.Close()         Try             With ConMy                 If...

Read More