Re: Call to MS Access parametrized query from ADO .NET

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



michaelvar wrote:
> Hi.
> I wrote a query with parameter in MS Access. When i try to call it
> from .NET(C#)
> i recieved errors.
> Can everybody send my working code.
>
> Thanks
>
There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-savvy person here who can
answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet or
microsoft.public.dotnet.framework.adonet

Having said that. I do need to point out that the online help that comes
with Visual Studio contains several examples of using an OleDbCommand object
to pass parameters to stored procedures. If you don't have Visual Studio,
the same documentation can be found at msdn.microsoft.com/library. You can
even download and install the (massive) SDK so you don't have to visit the
website to read the documentation.

Finally, Google will reveal many examples of doing this. Just search for
OleDbCommand examples.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.



Relevant Pages

  • Re: Common Library .NET and CF.NET
    ... > SolidBrush implements Dispose but does not seem to implement IDisposable. ... >> in your libraries, too. ... >> as a Class Library project (always assuming you will use Visual Studio). ... >> documentation of the .NETCF. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: VBScript help needed: how do I split a string?
    ... Split breaks a string based on a specified character, ... Viatcheslav gave you a good example of splitting while ignoring word-breaks. ... You mentioned that you did not have the documentation. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: No explicit directions.
    ... That documentation did NOT say how to build it so I was ... > Setting environment for using Microsoft Visual Studio .NET 2003 tools. ...
    (microsoft.public.vc.language)
  • RE: Updating the MSDN Library
    ... If I have to re-install the "Visual Studio.Net" documentation, ... Just reinstall product documentation from the Visual Studio .Net DVD? ... > Specifying a Preferred Help Collection ... > Using the Combined Help Collection Manager ...
    (microsoft.public.vsnet.setup)
  • Re: String Search with SQL
    ... > I was trying to write an SQL statment that will do a string search in ... > an Access 2000 database. ... According to the documentation, all searches are case-insensitive. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)