data source

[freddy]

I went to save an access db in the bin folder so I do not have to hard code
it like this:
string sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=E:\\\\Freddy\\Projects\\vb.net\\Project Track It\\bin\\Project.mdb";

[Dmytro Lapshyn [MVP]]

Hi Freddy,

I assume it is an ASP .NET app, where you can probably use Server.MapPath to
obtain the physical path of the virtual folder where your ASP .NET
application resides:

string sConnString =
string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da taSource={0}\\bin\\Project.mdb",
Server.MapPath("/MyWebApp");

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"freddy" <fr****@discussions.microsoft.com> wrote in message
news:C7**********************************@microsof t.com...

I went to save an access db in the bin folder so I do not have to hard code
it like this:
string sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=E:\\\\Freddy\\Projects\\vb.net\\Project Track
It\\bin\\Project.mdb";

[freddy]

this is for a winform

"Dmytro Lapshyn [MVP]" wrote:

Hi Freddy,

I assume it is an ASP .NET app, where you can probably use Server.MapPath to
obtain the physical path of the virtual folder where your ASP .NET
application resides:

string sConnString =
string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da taSource={0}\\bin\\Project.mdb",
Server.MapPath("/MyWebApp");

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"freddy" <fr****@discussions.microsoft.com> wrote in message
news:C7**********************************@microsof t.com...

I went to save an access db in the bin folder so I do not have to hard code
it like this:
string sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=E:\\\\Freddy\\Projects\\vb.net\\Project Track
It\\bin\\Project.mdb";

[Dmytro Lapshyn [MVP]]

Then, use Application.StartupPath instead of Server.MapPath.

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"freddy" <fr****@discussions.microsoft.com> wrote in message
news:69**********************************@microsof t.com...

this is for a winform

"Dmytro Lapshyn [MVP]" wrote:

Hi Freddy,

I assume it is an ASP .NET app, where you can probably use Server.MapPath
to
obtain the physical path of the virtual folder where your ASP .NET
application resides:

string sConnString =
string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da taSource={0}\\bin\\Project.mdb",
Server.MapPath("/MyWebApp");

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"freddy" <fr****@discussions.microsoft.com> wrote in message
news:C7**********************************@microsof t.com...

>I went to save an access db in the bin folder so I do not have to hard
>code
> it like this:
> string sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=E:\\\\Freddy\\Projects\\vb.net\\Project Track
> It\\bin\\Project.mdb";