Re: create a select query with a parameters.

Hi Amos,

It not so much the database you're using but the provider. With Access you
are working with the OleDb data provider. With this data provider, names
don't matter, but parameter order does. SqlClient data provider uses named
parameters, so names must be specified correctly.

Cheers,
Bob Beauchemin
http://www.SQLskills.com/bobb/blogs



"amos hchmon" <amoshchmon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E200534D-1DC4-42B4-8CB8-D48033A407ED@xxxxxxxxxxxxxxxx
>I working in .net with c# .if I working with sql sever I need to add @
>before
> the variable for query with parameters. my database set on access I want
> to
> know which character I need to add before the variable .can you give me a
> reference with example that execute the select query with parameters
> completely .
>
> Thanks for who refer to my question.
>


.

Relevant Pages

  • SQL Server 2005 Express connection error?
    ... getting an "Unable to find the requested .Net Framework Data Provider. ... //Obtain the database connection string ... //Obtain a database specific connection object ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: large SELECT with ORDER BY very slow (only in ado.net)
    ... I have 4 million rows in my database. ... So if I do it in DAO ... seconds to iterate through the recordset. ... using OLE DB data provider with Ms Access. ...
    (microsoft.public.dotnet.general)
  • Re: Writing ADO custom providers
    ... Is there an ODBC driver for this database? ... Odbc .NET Data Provider. ... > write an ADO data provider so that we can access this information using ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ODBC.NET
    ... does the Odbc.Net data provider implement it. ... Between now and Nov. 6th 2006 you can sign up for a substantial discount. ... Using an ODBC.NET connection how can I: ... Get a list of all tables in that database? ...
    (microsoft.public.dotnet.framework.adonet)
  • Merge Data
    ... I have a database which contains an ID field, Name Field, Percent Field, ... The ID field is not unique and contains records which all map ... Source: Data Provider ... Can anybody give me a few pointers. ...
    (microsoft.public.access.macros)
Loading