Re: Queries to an Access db from vs2005

Tech-Archive recommends: Speed Up your PC by fixing your registry


Anybody can help?

Thanks.
Max

"max" <max@xxxxxxx> ha scritto nel messaggio
news:ARpth.18500$bH4.6269@xxxxxxxxxxxxxxxxxxxxxxxx


If I do that:
SELECT * FROM table WHERE name LIKE name + '*'

I get an error when starting compiling application:
"Too many arguments for "Public Overridable Overloads Function
FillByName(dataTable As demoDataSet.myTableDataTable) As Integer".
It reminds in a VB line:
"Me.MyTableTableAdapter.FillByName(Me.demoDataSet.myTable,
NameToolStripTextBox.Text)",
in which the error is underlined on "NameToolStripTextBox.Text". This is
the textbox where I digit the items to search for in my db.

Help would be appreciated.
Thanks.


"Shkedy" <shkedy@xxxxxxxxxxxxxxxxx> ha scritto nel messaggio
news:Og9IhOoPHHA.1248@xxxxxxxxxxxxxxxxxxxxxxx

The wildcard character in Jet-SQL (Access) is * and not %
That should do it

Sagi Shkedy
http://Blog.shkedy.com
"Max" <nobody@xxxxxxxxxxxxxxxxxxx> wrote in message
news:45b54784$0$7735$5fc30a8@xxxxxxxxxxxxxxxxxx
Hello,
I just have a form in which there's a textbox for queries. I need to use
the SQL statements for an Access db, like this, which works fine in a
SQL db:
SELECT * FROM table WHERE name LIKE @name + '%'
I just need to query the db to find names that start with letters I
digit in the textbox.
This query comes from dataset designer. If I use it in my Access db I
get a syntax error from framework. Which is the Access equivalent?
Thanks.
Max












.

Relevant Pages

  • Re: Queries to an Access db from vs2005
    ... I just have a form in which there's a textbox for queries. ... the SQL statements for an Access db, like this, which works fine in a SQL ... I just need to query the db to find names that start with letters I digit ... This query comes from dataset designer. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Queries to an Access db from vs2005
    ... I have an access db; in my form I have a textbox; on it, ... menu, added a new query, gave it a name and put it in query text: ... Do you know a place where I can learn more about SQL statements for Access ... is the textbox where I digit the items to search for in my db. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Queries to an Access db from vs2005
    ... I have an access db; in my form I have a textbox; on it, ... menu, added a new query, gave it a name and put it in query text: ... Do you know a place where I can learn more about SQL statements for Access ... is the textbox where I digit the items to search for in my db. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Queries to an Access db from vs2005
    ... I have an access db; in my form I have a textbox; on it, click on data menu, ... added a new query, gave it a name and put it in query text: ... the textbox where I digit the items to search for in my db. ... use the SQL statements for an Access db, like this, which works fine in ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Queries to an Access db from vs2005
    ... menu, added a new query, gave it a name and put it in query text: ... My target is to write a partial text in the textbox, ... the textbox where I digit the items to search for in my db. ... use the SQL statements for an Access db, like this, which works fine ...
    (microsoft.public.dotnet.framework.adonet)