string syntax

[jez123456]

Hi I'm attempting to pass a string into another string but I get an error

This code work ok

jro.CompactDatabase(@"Provider=Microsoft.Jet.OLEDB .4.0;Data
Source=C:\Compact.mdb", @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\tempdb.mdb;Jet OLEDB:Engine Type=5");

However when I declare a string and try to pass that I get an error

string mdbTemp = @"C:\tempdb.mdb";

jro.CompactDatabase(@"Provider=Microsoft.Jet.OLEDB .4.0;Data
Source=C:\Compact.mdb", @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=mdbTemp;Jet OLEDB:Engine Type=5");

[cody]

use the following:

jro.CompactDatabase
(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Compact.mdb",
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbTemp + @";Jet
OLEDB:Engine Type=5"
);

"jez123456" <je*******@discussions.microsoft.com> schrieb im Newsbeitrag
news:75**********************************@microsof t.com...

Hi I'm attempting to pass a string into another string but I get an error

This code work ok

jro.CompactDatabase(@"Provider=Microsoft.Jet.OLEDB .4.0;Data
Source=C:\Compact.mdb", @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\tempdb.mdb;Jet OLEDB:Engine Type=5");

However when I declare a string and try to pass that I get an error

string mdbTemp = @"C:\tempdb.mdb";

jro.CompactDatabase(@"Provider=Microsoft.Jet.OLEDB .4.0;Data
Source=C:\Compact.mdb", @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=mdbTemp;Jet OLEDB:Engine Type=5");

[Roland Polzer]

"jez123456" wrote:

Hi I'm attempting to pass a string into another string but I get an error

This code work ok

jro.CompactDatabase(@"Provider=Microsoft.Jet.OLEDB .4.0;Data
Source=C:\Compact.mdb", @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\tempdb.mdb;Jet OLEDB:Engine Type=5");

However when I declare a string and try to pass that I get an error

string mdbTemp = @"C:\tempdb.mdb";

jro.CompactDatabase(@"Provider=Microsoft.Jet.OLEDB .4.0;Data
Source=C:\Compact.mdb", @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=mdbTemp;Jet OLEDB:Engine Type=5");

Hi jez123456,

You can never pass a string in another string. One have to concat two string
or format a string!

1) Concatenation

string mdbTemp = @"C:\tempdb.mdb";

string target = @"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=" + mdbTemp +
@";Jet OLEDB:Engine Type=5"

OR

string target =
string.Concat(@"Provider=Microsoft.Jet.OLEDB.4.0;D ataSource=", mdbTemp,
@";Jet OLEDB:Engine Type=5"
jro.CompactDatabase(@"Provider=Microsoft.Jet.OLEDB .4.0;Data
Source=C:\Compact.mdb", target);

2) Formatting

string mdbTemp = @"C:\tempdb.mdb";

string target =
string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;D ataSource={0};Jet
OLEDB:Engine Type=5", mdbTemp);

jro.CompactDatabase(@"Provider=Microsoft.Jet.OLEDB .4.0;Data
Source=C:\Compact.mdb", target);
Roland