string syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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");
 
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 said:
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");
Click to expand...

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;DataSource=", 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;DataSource={0};Jet
OLEDB:Engine Type=5", mdbTemp);

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


Roland
 
Back
Top