I am using Microsoft Visual Basic .NET.
   I am trying to match the numeric Value of Column "Number" from user input. The column number is Primary Key, auto Generated, type Single.
When I debug I get this error code
Error"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll"

Problem is the construction of Select Statement. I know my syntex is wrong but dont know the correct syntex. I do not have any problem when I use a sting to match a string vlaue. Every resource I consulted only has syntex for string Value
"What is the correct syntex for a numeric Value ?"

my code
  Dim SearchEquip As Single
  Dim SearchString As String

        SearchEquip = CSng(txtEquipID.Text)
        SearchString = "Select * from TblInven
        where Number ='txtEquipID.Text';"
        Dstest1.Clear()
        daTest.SelectCommand.CommandText = SearchString
        daTest.Fill(Dstest1)
        With Dstest1
            lst1.Items.Add(.tblInven(0).Title)
        End With
Dat




yvk

__________________
yvk

hi there...

SearchString = "Select * from TblInven where Number = "& txtEquipID.Text

do exactly like you do with textboxes... ;)




HTH

Gonzalo

Special Thanks to Mr. Bianchi.
Yasho

yvk

You do need to use the val('string') to convert the value entered into the textbox to numeric one.

Dear Yasho....

Maybe you can try my code :)

Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
  Dim ds As DataSet
  Dim da As SqlDataAdapter
  Dim scnn As SqlConnection
  Dim cm As SqlCommand


  Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    scnn = New SqlConnection("Data Source=server;Initial Catalog=Northwind;User ID=d;Password=d")
    cm = New SqlCommand("Select * From Orders Where EmployeeID = '" & CInt(TextBox1.Text) & "'", scnn)
    da = New SqlDataAdapter(cm)
    ds = New DataSet("Orders")
    da.Fill(ds)
    Me.DataGrid1.DataSource = ds

  End Sub
End Class

ARIES

admin23383

I appreciate for all the suggestions and help i got. They all work.
 But what if the querry is not in string format say if the statement is as under.

Suppose we substitute date with a field which is a number then what will be the formate.

Dim mySearchString As String

 mySearchString = "Select LastName,MI, Address,State, ZipCode, Phone from tblCustomerInfo where FirstName=' " & txtFirstName.Text " ' "&" And Sdate beteween formateDateTime(txtstartdate.text) and formateDateTime(txtenddate.text)
            DsCust1.Clear()
            daCust.SelectCommand.CommandText = mySearchString

                dgrCustomers.Refresh()
                daCust.Fill(DsCust1)

    End Sub

I will also like you learned people to guide me to a good book which covers these sql command requirements



yvk

Assuming the date value that you pass is going to be in the right format you can always compare it the way you do for comparing a number.

_________________________
- Vijay G
Strive for Perfection