how to pass parameters in command properties in visual basic.. urgent plss help?

Question

i have specified the sql query to connect to table..

SELECT propertydata.*, environdata.* FROM propertydata, environdata WHERE propertydata.farmerId = environdata.farmerid AND (propertydata.farmerId = ?)

how to give the parameter value (?)...

Answer 1

There are several ways, I'll assume propertydata.farmerId is an integer, you could do:

SELECT propertydata.*, environdata.* FROM propertydata, environdata WHERE propertydata.farmerId = environdata.farmerid AND (propertydata.farmerId = " & farmerID & ")"

And if you're using .net you can setup command parameters:

command.CommandText = "SELECT propertydata.*, environdata.* FROM propertydata, environdata WHERE propertydata.farmerId = environdata.farmerid AND (propertydata.farmerId = @FarmerID)"
command.Parameters.Add( "@FarmerID", SqlDbType.Int)
command.Parameters( "@FarmerID").Value = farmerID

Answer 2

It is very simple using SqlCommand class on vb
ex:
Dim SqlCmd As New SqlCommand("select * from employees where id = @ID", sqlconnection)
SqlCmd.Parameters.Add(New SqlParameter("@VAL", SqlDbType.NVarChar, (50), ParameterDirection.Input)).Value = TextBox1.Text