How to pass a variable to a SQL command

[Quarantine]

I am still a noob at the whole .NET, but I have a question and hope
someone can help me out. I am taking user input, then want to query
a database and return the results to either a datagrid, or a
dynamically created table. I want to be able to pass a variable to
the SQL command that I have created, but I don't know how to get the
format right. Here is a snippet of my code I know that the format
of my SQL command is totally wrong after the WHERE portion. If
anybody could help me, I would appreciate it a lot!

Dim conn As OleDbConnection
Dim texthold as String
conn = New OleDbConnection
txtUserInput.te xt = Cstr(texthold)
conn.Connection String = _
System.Configur ation.Configura tionSettings.Ap pSettings.Get _
("ConnectionStr ing")
conn.Open()
Dim querydb As New OleDbCommand("S ELECT * FROM tapeinfo
WHERE LIKE texthold", conn)
Dim results As OleDbDataReader
Dim i As Integer
results = querydb.Execute Reader(CommandB ehavior.CloseCo nnection)
Bryant

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

[MattB]

I'm also pretty new to this, but I think I've stubbled over this one
already.
Build your query as a string and concatenate it together with your variables
like this:

dim myQuery as string
....
myQuery = "SELECT * FROM tapeinfo WHERE LIKE " & texthold
....
Dim querydb As New OleDbCommand(my Query, conn)
Good luck!

Matt

Quarantine wrote:

I am still a noob at the whole .NET, but I have a question and hope
someone can help me out. I am taking user input, then want to query
a database and return the results to either a datagrid, or a
dynamically created table. I want to be able to pass a variable to
the SQL command that I have created, but I don't know how to get the
format right. Here is a snippet of my code I know that the format
of my SQL command is totally wrong after the WHERE portion. If
anybody could help me, I would appreciate it a lot!

Dim conn As OleDbConnection
Dim texthold as String
conn = New OleDbConnection
txtUserInput.te xt = Cstr(texthold)
conn.Connection String = _
System.Configur ation.Configura tionSettings.Ap pSettings.Get _
("ConnectionStr ing")
conn.Open()
Dim querydb As New OleDbCommand("S ELECT * FROM tapeinfo
WHERE LIKE texthold", conn)
Dim results As OleDbDataReader
Dim i As Integer
results = querydb.Execute Reader(CommandB ehavior.CloseCo nnection)
Bryant

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==---- http://www.newsfeed.com The #1 Newsgroup Service in the
World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized
Servers - Total Privacy via Encryption =---

[noone]

Dim conn As System.Data.Sql Client.SqlConne ction

Dim cmd As System.Data.Sql Client.SqlComma nd = conn.CreateComm and

cmd.CommandType = CommandType.Sto redProcedure

cmd.CommandText = "YourProcedureN ame"

cmd.Parameters. Add("@yourParam ", yourValue)

Dim reader As System.Data.Sql Client.SqlDataR eader

reader = cmd.ExecuteRead er

This is for SQL server, it is about the same for OleDbConnection

you create a command that is associated to your connection, add parmaers to
pass on to your stored procedures, execute the reader. this scheme is read
once, forward only. You can do what you want with the results, put them in a
dataset, just plug it into controls or whatever. If your using Visual Studio
it is a little easier just to drop things on the designer, then bind your
controls to the results. You can add parameters in the designer and even
generate Select, Delete Etc staments as procedures(Best Faster) or SQL
statements.
"Quarantine " <br************ *@comcast-dot-net.no-spam.invalid> wrote in
message news:40******** @127.0.0.1...

I am still a noob at the whole .NET, but I have a question and hope
someone can help me out. I am taking user input, then want to query
a database and return the results to either a datagrid, or a
dynamically created table. I want to be able to pass a variable to
the SQL command that I have created, but I don't know how to get the
format right. Here is a snippet of my code I know that the format
of my SQL command is totally wrong after the WHERE portion. If
anybody could help me, I would appreciate it a lot!

Dim conn As OleDbConnection
Dim texthold as String
conn = New OleDbConnection
txtUserInput.te xt = Cstr(texthold)
conn.Connection String = _
System.Configur ation.Configura tionSettings.Ap pSettings.Get _
("ConnectionStr ing")
conn.Open()
Dim querydb As New OleDbCommand("S ELECT * FROM tapeinfo
WHERE LIKE texthold", conn)
Dim results As OleDbDataReader
Dim i As Integer
results = querydb.Execute Reader(CommandB ehavior.CloseCo nnection)
Bryant

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption

=---

x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 800 Gigs/Day - $8.95/Month
x-- UNLIMITED DOWNLOAD