unable to search Text only Integers

[ae]

I have the following in ASP, and it works fine unless I change the SELECT ID
field to something else that isn't an integer. In other words, if I change
ID to city it doesn't work, and the only connection I can make is that my
bind only accepts integers, can someone help me?

Dim dstProducts As DataSet
Dim dadProducts As SqlDataAdapter
Label1.Visible = False

dstProducts = New DataSet()

Dim conPubs as SqlConnection

conPubs = New
SqlConnection("Server=LENVSQL;uid=itam;pwd=agenda; database=Discovery")

conPubs.Open()

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE ID = " & TextBox1.Text, conPubs)

Try

dadProducts.Fill( dstProducts, "Computer") 'the error occurs here
if ID is changed to City

dgEmployee.DataSource = dstProducts
dgEmployee.DataBind()
dgEmployee.Visible = True

[Eliyahu Goldin]

String field value should be enclosed with quotes.

Eliyahu

"ae" <[e-mail]> wrote in message
news:73**********************************@microsof t.com...

I have the following in ASP, and it works fine unless I change the SELECT ID field to something else that isn't an integer. In other words, if I change ID to city it doesn't work, and the only connection I can make is that my
bind only accepts integers, can someone help me?

Dim dstProducts As DataSet
Dim dadProducts As SqlDataAdapter
Label1.Visible = False

dstProducts = New DataSet()

Dim conPubs as SqlConnection

conPubs = New
SqlConnection("Server=LENVSQL;uid=itam;pwd=agenda; database=Discovery")

conPubs.Open()

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE ID = " & TextBox1.Text, conPubs)

Try

dadProducts.Fill( dstProducts, "Computer") 'the error occurs here
if ID is changed to City

dgEmployee.DataSource = dstProducts
dgEmployee.DataBind()
dgEmployee.Visible = True

[ae]

I tried the following, it still does not pick up the values.

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE 'IPAddress'=" & TextBox1.Text, conPubs)

And I have also tried:
dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE 'IPAddress'=" & TextBox1.Text.ToString(),
conPubs)

It still does not pull data, can you give me an example?
"Eliyahu Goldin" wrote:

String field value should be enclosed with quotes.

Eliyahu

"ae" <[e-mail]> wrote in message
news:73**********************************@microsof t.com...

I have the following in ASP, and it works fine unless I change the SELECT

ID

field to something else that isn't an integer. In other words, if I

change

ID to city it doesn't work, and the only connection I can make is that my
bind only accepts integers, can someone help me?

Dim dstProducts As DataSet
Dim dadProducts As SqlDataAdapter
Label1.Visible = False

dstProducts = New DataSet()

Dim conPubs as SqlConnection

conPubs = New
SqlConnection("Server=LENVSQL;uid=itam;pwd=agenda; database=Discovery")

conPubs.Open()

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE ID = " & TextBox1.Text, conPubs)

Try

dadProducts.Fill( dstProducts, "Computer") 'the error occurs here
if ID is changed to City

dgEmployee.DataSource = dstProducts
dgEmployee.DataBind()
dgEmployee.Visible = True

[Eliyahu Goldin]

WHERE IPAddress='" & TextBox1.Text & "'", conPubs)

Eliyahu

"ae" <[e-mail]> wrote in message
news:DC**********************************@microsof t.com...

I tried the following, it still does not pick up the values.

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE 'IPAddress'=" & TextBox1.Text, conPubs)

And I have also tried:
dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE 'IPAddress'=" & TextBox1.Text.ToString(),
conPubs)

It still does not pull data, can you give me an example?
"Eliyahu Goldin" wrote:

String field value should be enclosed with quotes.

Eliyahu

"ae" <[e-mail]> wrote in message
news:73**********************************@microsof t.com...

I have the following in ASP, and it works fine unless I change the SELECT

ID

field to something else that isn't an integer. In other words, if I

change

ID to city it doesn't work, and the only connection I can make is that

my bind only accepts integers, can someone help me?

Dim dstProducts As DataSet
Dim dadProducts As SqlDataAdapter
Label1.Visible = False

dstProducts = New DataSet()

Dim conPubs as SqlConnection

conPubs = New
SqlConnection("Server=LENVSQL;uid=itam;pwd=agenda; database=Discovery")

conPubs.Open()

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE ID = " & TextBox1.Text, conPubs)

Try

dadProducts.Fill( dstProducts, "Computer") 'the error occurs here if ID is changed to City

dgEmployee.DataSource = dstProducts
dgEmployee.DataBind()
dgEmployee.Visible = True

[ae]

the following takes care of it.

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE IPAddress =" & "'" & TextBox1.Text & "'",
conPubs)

"ae" wrote:

I tried the following, it still does not pick up the values.

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE 'IPAddress'=" & TextBox1.Text, conPubs)

And I have also tried:
dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE 'IPAddress'=" & TextBox1.Text.ToString(),
conPubs)

It still does not pull data, can you give me an example?
"Eliyahu Goldin" wrote:

String field value should be enclosed with quotes.

Eliyahu

"ae" <[e-mail]> wrote in message
news:73**********************************@microsof t.com...

I have the following in ASP, and it works fine unless I change the SELECT

ID

field to something else that isn't an integer. In other words, if I

change

ID to city it doesn't work, and the only connection I can make is that my
bind only accepts integers, can someone help me?

Dim dstProducts As DataSet
Dim dadProducts As SqlDataAdapter
Label1.Visible = False

dstProducts = New DataSet()

Dim conPubs as SqlConnection

conPubs = New
SqlConnection("Server=LENVSQL;uid=itam;pwd=agenda; database=Discovery")

conPubs.Open()

dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress,
SerialNo FROM Computer WHERE ID = " & TextBox1.Text, conPubs)

Try

dadProducts.Fill( dstProducts, "Computer") 'the error occurs here
if ID is changed to City

dgEmployee.DataSource = dstProducts
dgEmployee.DataBind()
dgEmployee.Visible = True