How to use VB.NET for MSSQL (feedback) after the statement execution of news-CodePudding

In the process of database can use custom end KILL2 pid process, now want to get executed by VB.NET statements feedback message
So good judgment whether success,

Executing SQL statements are

Dim sql1 As String=the String. Format (" Use master ")
Dim sql2 As String=the String. Format (" kill2 '@ JC ")
Dim cmd1 As SqlCommand=New SqlCommand (sql1, conn.)
Dim cmd2 As SqlCommand=New SqlCommand (sql2, conn.)

Cmd2. The Parameters. The Add (" @ JC ", SqlDbType. Int). The Value=https://bbs.csdn.net/topics/Me.TextBox1.Text
'here's Me. TextBox1. Text is available to the end of the process,

Cmd1. ExecuteNonQuery ()
Cmd2. ExecuteNonQuery ()

But always not successful execution statement also don't succeed, don't know how to modify the

CodePudding user response:

Have a way to find a solution to perfect the

CodePudding user response:

Why do you want to by used to execute the kill?

It doesn't work?

 
Var process=
Process. GetProcessById (processId); 
Process. The Kill ();