Office Automation - Powerpoint in VB.Net

Hi

I tried to do the Powerpoint presentation using VB.Net 2.0. I got error while creating the object of the Powerpoint.Application

Unable to cast COM object of type 'PowerPoint.ApplicationClass' to interface type 'PowerPoint._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{91493442-5A91-11CF-8700-00AA0060263B}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).

Can any one tell me the solution for this error.?

Ganesh.

Hi Ganesh,

The error indicates that the PowerPoint.ApplicationClass was not registered on the running machine properly. A COM class needs to be registered in the registery to make it identified. The register process is done at the installation phase of Office.

So you can try to repair the installation of PowerPoint or make sure it is installed properly.

Further more, in an ASP.NET application, server side automation is not supported. Here is a KB article about this.

http://support.microsoft.com/kb/257757/en-us

Hope this helps.

official alternative to ajax

Hi

I have asked this on the official asp.net forums but no luck so
thought I'd try here

Assume you have a page with a filter control and a grid view and many
other controls on it. When the filter changes you want the gridview to
change but nothing else. In particular all you would like to happen is
for an ajax call to occur and a new grid view to be returned.

Similarily you might have a treeview working asynchronously, you might
have an n'tiered arrangment and if the database disappears you would
want a different control on the page to indicate this, but the treeview
can't be connected to other controls in this manner (can it?)

That kind of situation is possible with Raw html and Ajax. Obviously
ajax calls are easy enough (especially using something like AjaxPro)
and to get the a table back you could just create it and return it.
Similiarly for the treeview example you could return an li/ul structure
normally plus a different control to indicate the error.

So, my question. What is the official way to do things like this. I
suspect the answer is use a postback

ta

(sig: findbyfoldface)I see a lot of people trying to avoid postback, as they feel painting the
page over again is somehow inferior to doing some voodoo in the back with
Ajax. And, in some cases, they are correct. In others, they are creating two
data transports that they have to maintain, simply to avoid a repaint. I do
not see this as a wise use of Ajax, but everyone has their own opinion.

You can talk to controls all day long on the client side and even wire them
to Ajax calls. If you like, you can code your own via the XMLHTTP and with
SOAP even make true web service calls from the client. As long as you emit
the client script from your code beside (behind?) page, you can get the name
of the control, no matter where it is placed, and you can then have one
control pounding on another without a complete postback.

The question is whether you want to maintain this architecture.

PROS
1. It does not completely repaint the page

CONS
1. Harder to debug a mix of client and server script
2. Less maintainable

The main benefit of Ajax (yes, I realize there are many other reasons to use
it ;->) is user accessibility. For example, the google toolbar approach
where a drop down is created on the fly or the ability to change states
based on a country, or fill in a list of cities based on a postal code.
These are very valid reasons to use an asyncrhronous transport. I do not, in
general, believe that gathering a full spreadsheet of data is the best use
for asynch (although there are certainly some specific examples when it
would be wise).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
*************************************************
Think outside of the box!
*************************************************
<codefragment@.googlemail.comwrote in message
news:1159878333.734722.257200@.e3g2000cwe.googlegro ups.com...

Quote:

Originally Posted by

Hi
>
I have asked this on the official asp.net forums but no luck so
thought I'd try here
>
Assume you have a page with a filter control and a grid view and many
other controls on it. When the filter changes you want the gridview to
change but nothing else. In particular all you would like to happen is
for an ajax call to occur and a new grid view to be returned.
>
Similarily you might have a treeview working asynchronously, you might
have an n'tiered arrangment and if the database disappears you would
want a different control on the page to indicate this, but the treeview
can't be connected to other controls in this manner (can it?)
>
That kind of situation is possible with Raw html and Ajax. Obviously
ajax calls are easy enough (especially using something like AjaxPro)
and to get the a table back you could just create it and return it.
Similiarly for the treeview example you could return an li/ul structure
normally plus a different control to indicate the error.
>
So, my question. What is the official way to do things like this. I
suspect the answer is use a postback
>
ta
>
(sig: findbyfoldface)
>

official alternative to ajax

Hi
I have asked this on the official asp.net forums but no luck so
thought I'd try here
Assume you have a page with a filter control and a grid view and many
other controls on it. When the filter changes you want the gridview to
change but nothing else. In particular all you would like to happen is
for an ajax call to occur and a new grid view to be returned.
Similarily you might have a treeview working asynchronously, you might
have an n'tiered arrangment and if the database disappears you would
want a different control on the page to indicate this, but the treeview
can't be connected to other controls in this manner (can it?)
That kind of situation is possible with Raw html and Ajax. Obviously
ajax calls are easy enough (especially using something like AjaxPro)
and to get the a table back you could just create it and return it.
Similiarly for the treeview example you could return an li/ul structure
normally plus a different control to indicate the error.
So, my question. What is the official way to do things like this. I
suspect the answer is use a postback
ta
(sig: findbyfoldface)I see a lot of people trying to avoid postback, as they feel painting the
page over again is somehow inferior to doing some voodoo in the back with
Ajax. And, in some cases, they are correct. In others, they are creating two
data transports that they have to maintain, simply to avoid a repaint. I do
not see this as a wise use of Ajax, but everyone has their own opinion.
You can talk to controls all day long on the client side and even wire them
to Ajax calls. If you like, you can code your own via the XMLHTTP and with
SOAP even make true web service calls from the client. As long as you emit
the client script from your code beside (behind?) page, you can get the name
of the control, no matter where it is placed, and you can then have one
control pounding on another without a complete postback.
The question is whether you want to maintain this architecture.
PROS
1. It does not completely repaint the page
CONS
1. Harder to debug a mix of client and server script
2. Less maintainable
The main benefit of Ajax (yes, I realize there are many other reasons to use
it ;-> ) is user accessibility. For example, the google toolbar approach
where a drop down is created on the fly or the ability to change states
based on a country, or fill in a list of cities based on a postal code.
These are very valid reasons to use an asyncrhronous transport. I do not, in
general, believe that gathering a full spreadsheet of data is the best use
for asynch (although there are certainly some specific examples when it
would be wise).
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
****************************************
*********
Think outside of the box!
****************************************
*********
<codefragment@.googlemail.com> wrote in message
news:1159878333.734722.257200@.e3g2000cwe.googlegroups.com...
> Hi
> I have asked this on the official asp.net forums but no luck so
> thought I'd try here
> Assume you have a page with a filter control and a grid view and many
> other controls on it. When the filter changes you want the gridview to
> change but nothing else. In particular all you would like to happen is
> for an ajax call to occur and a new grid view to be returned.
> Similarily you might have a treeview working asynchronously, you might
> have an n'tiered arrangment and if the database disappears you would
> want a different control on the page to indicate this, but the treeview
> can't be connected to other controls in this manner (can it?)
> That kind of situation is possible with Raw html and Ajax. Obviously
> ajax calls are easy enough (especially using something like AjaxPro)
> and to get the a table back you could just create it and return it.
> Similiarly for the treeview example you could return an li/ul structure
> normally plus a different control to indicate the error.
> So, my question. What is the official way to do things like this. I
> suspect the answer is use a postback
> ta
> (sig: findbyfoldface)
>

OFFLINE with Online Conectivity (IMP)

hi

i have a website like

www.mysite.com

which is on USA machine both webhosting and database when i open my site huge reports open fastly because both are on same machine.

But on other side when i have offline asp.net pages with 1.1 and connecting with Online USA server like (64.6.5.121 etc) then the speed is v slow because database on other machine and pages on my machine.

what is solution for improvement????

i have also fast DSL...

Please??????

Hi,

Put your database server on the same ASP.NET is the best idea!

If you must run your db in different location, you can caching your database connections or usingConnection Pooling
and you can even cache your data from db like this:

http://www.2enetworx.com/dev/articles/caching6.asp

There is other tips that you can try, check the Network Bandwith and Database issue section of

http://www.15seconds.com/issue/000106.htm

for more details!

hope it helps!

OleDbConnection is not defined.

Hi!
I get the following error when connecting to my database. What am I missing? Please help, its driving me crazy!

Compiler Error Message:BC30002: Type 'OleDbConnection' is not defined.
Source Error:

Line 10: Dim objConnection As OleDbConnection

This is my code:
<%@dotnet.itags.org. Page Language="VB" %>
<%@dotnet.itags.org. import Namespace="System" %>
<%@dotnet.itags.org. import Namespace="System.Data" %>
<%@dotnet.itags.org. import Namespace="Sysyem.Data.OleDb" %>
<script runat="server">

    Sub Page_Load(Source As Object, E As EventArgs)
        Dim objConnection As OleDbConnection = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=C:\..\foods.mdb")
        objConnection.Open()
        ...

Add this to the top of you code behind page...

Imports System.Data.OleDb

Oopps, just looked closer at your code... nevermind.
You must not be using VS.Net.
You have it imported and it should work.

Zath

Nope, no VS.NET for me! I'm using webmatrix. I thought it should work, is there something I could be leaving out - like setting it up through ODBC administrator?
Crab

Crab wrote:

This is my code:
<%@. Page Language="VB" %>
<%@. import Namespace="System" %>
<%@. import Namespace="System.Data" %>
<%@. import Namespace="Sysyem.Data.OleDb" %>

You've misspelled the namespace. Try

System.Data.OleDb

Good catch. I didn't even notice that.....
Doh! I can't believe how many times I read over that and didn't see it. Thanks!
Doh! I can't believe how many times I read over that and didn't see it. Thanks!
Now I have a problem with my datareader! any more help?
Compiler Error Message:BC30201: Expression expected.
Source Error:

Line 22: & "</b></td><td>" & objDataReader("Weight") & "</td><td>" _Line 23: & objDataReader("Price") & "</td></tr>" & _Line 24: & "<tr><td colspan='3'>" & objDatareader("Description") _Line 25: & "</td></tr>"Line 26: Loop

Did you check whether you have null values into your Description column? Another way is allowing null values against that column

There are no null values in any of the columns used. I can't work it out.

Can we see more of your code? I am curious why you are outputting your data in that manner.

S'ok, it was an extra & at the end of line 23. I'm doing an exercise from as asp.net book that was using the datarepeater to display the datasource.
Thanks for your help!

Oledbparameters

Hi

I am having touble determining the correct syntax for my SQL query using
the OleDbCommand parameters and the 'like' operator with the 'where' clause
.. I would like to use the wildcard % at either end of my parameter, but no
matter what I try, nothing seems to work, on the surface the query couldn't
be simpler and works perfectly with text outside of this context. Can
anyone please advise?

Note: txtFirstname.Text refers to the text entered into a textbox

void btn_click(Object sender , EventArgs e)

{

OleDbConnection conAuthors = new OleDbConnection(
"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=D:\\Mydatabase\\Code\\
Latest28092004\\pg.MDB" );

conAuthors.Open();

string OleString = "Select Code, Description, Retail from Pricelist0804
where Description like '%?%'";

OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString, conAuthors );

cmdSelectAuthors.Parameters.Add ("?", txtFirstname.Text);

dgrdMenu.DataSource = cmdSelectAuthors.ExecuteReader();
dgrdMenu.DataBind();

conAuthors.Close();

--
Message posted via http://www.dotnetmonster.comChange it so that the "%" is in your parameter value, not in the original
sql.

-Brock
DevelopMentor
http://staff.develop.com/ballen

> Hi
> I am having touble determining the correct syntax for my SQL query
> using the OleDbCommand parameters and the 'like' operator with the
> 'where' clause . I would like to use the wildcard % at either end of
> my parameter, but no matter what I try, nothing seems to work, on the
> surface the query couldn't be simpler and works perfectly with text
> outside of this context. Can anyone please advise?
> Note: txtFirstname.Text refers to the text entered into a textbox
> void btn_click(Object sender , EventArgs e)
> {
> OleDbConnection conAuthors = new OleDbConnection(
> "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=D:\\Mydatabase\\Code\\
> Latest28092004\\pg.MDB" );
> conAuthors.Open();
> string OleString = "Select Code, Description, Retail from
> Pricelist0804 where Description like '%?%'";
> OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
> conAuthors );
> cmdSelectAuthors.Parameters.Add ("?", txtFirstname.Text);
> dgrdMenu.DataSource = cmdSelectAuthors.ExecuteReader();
> dgrdMenu.DataBind();
> conAuthors.Close();
Hi Paul,

AFAIK, in Access you should use wildcard * rather than % (I'm not sure what
is that in Access 2003).

HTH

Elton Wang
elton_wang@.hotmail.com

"Paul Gray via DotNetMonster.com" wrote:

> Hi
> I am having touble determining the correct syntax for my SQL query using
> the OleDbCommand parameters and the 'like' operator with the 'where' clause
> .. I would like to use the wildcard % at either end of my parameter, but no
> matter what I try, nothing seems to work, on the surface the query couldn't
> be simpler and works perfectly with text outside of this context. Can
> anyone please advise?
> Note: txtFirstname.Text refers to the text entered into a textbox
> void btn_click(Object sender , EventArgs e)
> {
>
> OleDbConnection conAuthors = new OleDbConnection(
> "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=D:\\Mydatabase\\Code\\
> Latest28092004\\pg.MDB" );
> conAuthors.Open();
> string OleString = "Select Code, Description, Retail from Pricelist0804
> where Description like '%?%'";
> OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString, conAuthors );
> cmdSelectAuthors.Parameters.Add ("?", txtFirstname.Text);
>
> dgrdMenu.DataSource = cmdSelectAuthors.ExecuteReader();
> dgrdMenu.DataBind();
> conAuthors.Close();
> --
> Message posted via http://www.dotnetmonster.com
Hi

Thank you, but I was wondering if you could tell me the exact sequence if
possible, as I have tried a number of variations without success, e.g

string OleString = "Select Code, Description, Retail from Pricelist0804
where Description like ' @.? ' ";

OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
conAuthors );

cmdSelectAuthors.Parameters.Add ("@.%?%", txtFirstname.Text);

--
Message posted via http://www.dotnetmonster.com
Thank you - I have tried this but there is something else amiss, e.g the
following doesn't work

----------

string OleString = "Select Code, Description, Retail from Pricelist0804
where Description like ' @.*?* ' ";

OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
conAuthors );

cmdSelectAuthors.Parameters.Add ("@.?", txtFirstname.Text);

----------

nor does the following and a number of other similar variations

-------------

string OleString = "Select Code, Description, Retail from Pricelist0804
where Description like '*@.?*' ";

OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
conAuthors );

cmdSelectAuthors.Parameters.Add ("@.?", txtFirstname.Text);
--------------

Any suggestions gratefully received

--
Message posted via http://www.dotnetmonster.com
Access 2003 with the OleDbConnection/OleDbCommand seems to be expecting the
SQL Server syntax using % as the wild card despite the documentation stating
that * is the wild card. To concatenate the parameter value you'd use the
following syntax. If your version of access requires the *, simply replace
the % signs in the query below and all should be fine.

OleDbCommand cmd = new OleDbComnand("SELECT Code, Description, Retail FROM
Pricelist0804 WHERE Description LIKE '%' + ? + '%'", conAuthors);
cmd.Parameters.Add(new OleDbParameter("p1", OleDbType.VarChar, 15)).Value =
txtFirstname.Text;

On a side note, Access 2003 and the OleDb classes seem to accept the SQL
Server syntax with named parameters (@.param). The following also worked...

OleDbCommand cmd = new OleDbComnand("SELECT Code, Description, Retail FROM
Pricelist0804 WHERE Description LIKE '%' + @.name + '%'", conAuthors);
cmd.Parameters.Add(new OleDbParameter("@.name", OleDbType.VarChar, 15)).Value
= txtFirstname.Text;

HTH
------
Dave Fancher
http://davefancher.blogspot.com

"Paul Gray via DotNetMonster.com" <forum@.DotNetMonster.com> wrote in message
news:5b695dc1a75849bcab4ece1a5e7a56af@.DotNetMonste r.com...
> Thank you - I have tried this but there is something else amiss, e.g the
> following doesn't work
> ----------
> string OleString = "Select Code, Description, Retail from Pricelist0804
> where Description like ' @.*?* ' ";
> OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
> conAuthors );
> cmdSelectAuthors.Parameters.Add ("@.?", txtFirstname.Text);
> ----------
> nor does the following and a number of other similar variations
> -------------
> string OleString = "Select Code, Description, Retail from Pricelist0804
> where Description like '*@.?*' ";
> OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
> conAuthors );
> cmdSelectAuthors.Parameters.Add ("@.?", txtFirstname.Text);
> --------------
> Any suggestions gratefully received
> --
> Message posted via http://www.dotnetmonster.com
Dave,

Many thanks - that did the trick

I am using Access 2000 and I checked to see if it would work with named
parameters as you indicated it did with 2003, and strangely enough despite
all indications to the contrary it did.

Anyway, appreciate the help, what should have been relatively
straightforward had become a bit of a headache.

Thanks again

P.S Site looks good - will have a closer peruse through it over the coming
days

--
Message posted via http://www.dotnetmonster.com

Oledbparameters

Hi
I am having touble determining the correct syntax for my SQL query using
the OleDbCommand parameters and the 'like' operator with the 'where' clause
. I would like to use the wildcard % at either end of my parameter, but no
matter what I try, nothing seems to work, on the surface the query couldn't
be simpler and works perfectly with text outside of this context. Can
anyone please advise?
Note: txtFirstname.Text refers to the text entered into a textbox
void btn_click(Object sender , EventArgs e)
{
OleDbConnection conAuthors = new OleDbConnection(
"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=D:\\Mydatabase\\Code\\
Latest28092004\\pg.MDB" );
conAuthors.Open();
string OleString = "Select Code, Description, Retail from Pricelist0804
where Description like '%?%'";
OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString, conAuthors );
cmdSelectAuthors.Parameters.Add ("?", txtFirstname.Text);
dgrdMenu.DataSource = cmdSelectAuthors.ExecuteReader();
dgrdMenu.DataBind();
conAuthors.Close();
Message posted via http://www.webservertalk.comChange it so that the "%" is in your parameter value, not in the original
sql.
-Brock
DevelopMentor
http://staff.develop.com/ballen

> Hi
> I am having touble determining the correct syntax for my SQL query
> using the OleDbCommand parameters and the 'like' operator with the
> 'where' clause . I would like to use the wildcard % at either end of
> my parameter, but no matter what I try, nothing seems to work, on the
> surface the query couldn't be simpler and works perfectly with text
> outside of this context. Can anyone please advise?
> Note: txtFirstname.Text refers to the text entered into a textbox
> void btn_click(Object sender , EventArgs e)
> {
> OleDbConnection conAuthors = new OleDbConnection(
> "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=D:\\Mydatabase\\Code\\
> Latest28092004\\pg.MDB" );
> conAuthors.Open();
> string OleString = "Select Code, Description, Retail from
> Pricelist0804 where Description like '%?%'";
> OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
> conAuthors );
> cmdSelectAuthors.Parameters.Add ("?", txtFirstname.Text);
> dgrdMenu.DataSource = cmdSelectAuthors.ExecuteReader();
> dgrdMenu.DataBind();
> conAuthors.Close();
>
Hi Paul,
AFAIK, in Access you should use wildcard * rather than % (I'm not sure what
is that in Access 2003).
HTH
Elton Wang
elton_wang@.hotmail.com
"Paul Gray via webservertalk.com" wrote:

> Hi
> I am having touble determining the correct syntax for my SQL query using
> the OleDbCommand parameters and the 'like' operator with the 'where' claus
e
> .. I would like to use the wildcard % at either end of my parameter, but n
o
> matter what I try, nothing seems to work, on the surface the query couldn'
t
> be simpler and works perfectly with text outside of this context. Can
> anyone please advise?
> Note: txtFirstname.Text refers to the text entered into a textbox
> void btn_click(Object sender , EventArgs e)
> {
>
> OleDbConnection conAuthors = new OleDbConnection(
> "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=D:\\Mydatabase\\Code\\
> Latest28092004\\pg.MDB" );
> conAuthors.Open();
> string OleString = "Select Code, Description, Retail from Pricelist0804
> where Description like '%?%'";
> OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString, conAuthors );
> cmdSelectAuthors.Parameters.Add ("?", txtFirstname.Text);
>
> dgrdMenu.DataSource = cmdSelectAuthors.ExecuteReader();
> dgrdMenu.DataBind();
> conAuthors.Close();
> --
> Message posted via http://www.webservertalk.com
>
Hi
Thank you, but I was wondering if you could tell me the exact sequence if
possible, as I have tried a number of variations without success, e.g
string OleString = "Select Code, Description, Retail from Pricelist0804
where Description like ' @.? ' ";
OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
conAuthors );
cmdSelectAuthors.Parameters.Add ("@.%?%", txtFirstname.Text);
Message posted via http://www.webservertalk.com
Thank you - I have tried this but there is something else amiss, e.g the
following doesn't work
string OleString = "Select Code, Description, Retail from Pricelist0804
where Description like ' @.*?* ' ";
OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
conAuthors );
cmdSelectAuthors.Parameters.Add ("@.?", txtFirstname.Text);
nor does the following and a number of other similar variations
---
string OleString = "Select Code, Description, Retail from Pricelist0804
where Description like '*@.?*' ";
OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
conAuthors );
cmdSelectAuthors.Parameters.Add ("@.?", txtFirstname.Text);
---
Any suggestions gratefully received
Message posted via http://www.webservertalk.com
Access 2003 with the OleDbConnection/OleDbCommand seems to be expecting the
SQL Server syntax using % as the wild card despite the documentation stating
that * is the wild card. To concatenate the parameter value you'd use the
following syntax. If your version of access requires the *, simply replace
the % signs in the query below and all should be fine.
OleDbCommand cmd = new OleDbComnand("SELECT Code, Description, Retail FROM
Pricelist0804 WHERE Description LIKE '%' + ? + '%'", conAuthors);
cmd.Parameters.Add(new OleDbParameter("p1", OleDbType.VarChar, 15)).Value =
txtFirstname.Text;
On a side note, Access 2003 and the OleDb classes seem to accept the SQL
Server syntax with named parameters (@.param). The following also worked...
OleDbCommand cmd = new OleDbComnand("SELECT Code, Description, Retail FROM
Pricelist0804 WHERE Description LIKE '%' + @.name + '%'", conAuthors);
cmd.Parameters.Add(new OleDbParameter("@.name", OleDbType.VarChar, 15)).Value
= txtFirstname.Text;
HTH
--
Dave Fancher
http://davefancher.blogspot.com
"Paul Gray via webservertalk.com" <forum@.webservertalk.com> wrote in message
news:5b695dc1a75849bcab4ece1a5e7a56af@.Do
webservertalk.com...
> Thank you - I have tried this but there is something else amiss, e.g the
> following doesn't work
> --
> string OleString = "Select Code, Description, Retail from Pricelist0804
> where Description like ' @.*?* ' ";
> OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
> conAuthors );
> cmdSelectAuthors.Parameters.Add ("@.?", txtFirstname.Text);
> --
> nor does the following and a number of other similar variations
> ---
> string OleString = "Select Code, Description, Retail from Pricelist0804
> where Description like '*@.?*' ";
> OleDbCommand cmdSelectAuthors = new OleDbCommand( OleString,
> conAuthors );
> cmdSelectAuthors.Parameters.Add ("@.?", txtFirstname.Text);
> ---
> Any suggestions gratefully received
> --
> Message posted via http://www.webservertalk.com
Dave,
Many thanks - that did the trick
I am using Access 2000 and I checked to see if it would work with named
parameters as you indicated it did with 2003, and strangely enough despite
all indications to the contrary it did.
Anyway, appreciate the help, what should have been relatively
straightforward had become a bit of a headache.
Thanks again
P.S Site looks good - will have a closer peruse through it over the coming
days
Message posted via http://www.webservertalk.com