"jez123456" wrote:
Hi I'm attempting to pass a string into another string but I get an error
This code work ok
jro.CompactData base(@"Provider =Microsoft.Jet. OLEDB.4.0;Data
Source=C:\Compa ct.mdb", @"Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=C:\tempd b.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.CompactData base(@"Provider =Microsoft.Jet. OLEDB.4.0;Data
Source=C:\Compa ct.mdb", @"Provider=Micr osoft.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=Micr osoft.Jet.OLEDB .4.0;DataSource =" + mdbTemp +
@";Jet OLEDB:Engine Type=5"
OR
string target =
string.Concat(@ "Provider=Micro soft.Jet.OLEDB. 4.0;DataSource= ", mdbTemp,
@";Jet OLEDB:Engine Type=5"
jro.CompactData base(@"Provider =Microsoft.Jet. OLEDB.4.0;Data
Source=C:\Compa ct.mdb", target);
2) Formatting
string mdbTemp = @"C:\tempdb.mdb ";
string target =
string.Format(@ "Provider=Micro soft.Jet.OLEDB. 4.0;DataSource= {0};Jet
OLEDB:Engine Type=5", mdbTemp);
jro.CompactData base(@"Provider =Microsoft.Jet. OLEDB.4.0;Data
Source=C:\Compa ct.mdb", target);
Roland