In VS 2008, for example I have sql command like
SELECT * FROM STUDENTS WHERE STUDENTID = @STUDENTID
Then I append value into it, for example 15
How to I catch this sql command
SELECT * FROM STUDENTS WHERE STUDENTID = 15
Thx in advance
Hello maybe this will help
I used this on VB 2005 to information for a crystal report
Dim strConnection As String = "Server=...\SQLEXPRESS; Database=db;uid=admin;Password=password" Dim Connection As New SqlConnection(strConnection) Dim norden As String norden = TextBox1.Text.ToString Dim strSQL As String = " (SELECT * FROM or_compra WHERE(or_compra.orden = " & norden & "))SELECT oc_desc.orden , oc_desc.cantidad, oc_desc.descripcion, oc_desc.importe FROM oc_desc INNER JOIN or_compra ON oc_desc.orden = or_compra.orden WHERE(oc_desc.orden =" & norden & ") " Dim DA As New SqlDataAdapter(strSQL, Connection) Dim DS As New DataSet Dim strReportName As String
As you can see the string "norden" i used it as a variable to search for an especific number and integrated it to the SQL Query you can see this in this section of the sql query
(SELECT * FROM or_compra WHERE(or_compra.orden = " & norden & "))
You can add a TextBox to the SQL Query if you need it not just a number.
is there someone that can help me about the syntactic form of the file XML for the italian "FATTURA PA"?
From 2017/01/01 is changed the file's form (rel 1.2), and the file created by my procedure is not accepted from the SDI system (outcome: "error 0200 - file not ...
I am currently creating a simulation of a pizza ordering system in object oriented program. I have some question. the instruction and guideline is long but I will try and cut it down a lot. the instruction is to create a program that simulate a pizza restaurant using ...
hi i am using vb.net multidimensional arrays and i am getting the nearest or closest number i just want to ask if my code was correct or not ? for example i have an input of 13000 and nearest number should be on col 6 can you please help me ...