C# choosing database connection - C# Discussion Boards

Re: Call .Net 2005 DLL in .Net 2003

originSH23-Jul-07 12:06

23-Jul-07 12:06

Why would you want to use it in 1.1 when you could code it in 2.0 and have all the advantages of the extra features and better IDE?

You'll need to install the .Net 2.0 framework anyway so why not just use that?

Re: Call .Net 2005 DLL in .Net 2003

Bhavik Solanki23-Jul-07 12:20

Bhavik Solanki

23-Jul-07 12:20

I have some applications which is already developed in Framework 1.1 and as of now its not posible to move to Framework 2.0.

Re: Call .Net 2005 DLL in .Net 2003

Paul Conrad23-Jul-07 15:14

Paul Conrad

23-Jul-07 15:14

Bhavik Solanki wrote:
which is already developed in Framework 1.1 and as of now its not posible to move to Framework 2.0.

Have you tried running the solution from 1.1 through the converter to make it 2.0?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Call .Net 2005 DLL in .Net 2003

Scott Dorman23-Jul-07 14:17

Scott Dorman

23-Jul-07 14:17

The simple answer is you can't. C# 2.0 (from VS 2005) uses .NET 2.0 while VB.NET 2003 uses .NET 1.1. These are different runtimes and are not compatible with each other. Beyond that, you can't have one application that loads two different versions of the runtime.

-----------------------------
In just two days, tomorrow will be yesterday.

http://geekswithblogs.net/sdorman

Re: Call .Net 2005 DLL in .Net 2003

Bhavik Solanki23-Jul-07 14:39

Bhavik Solanki

23-Jul-07 14:39

Thanks for reply

Here is some more info on this topic : http://www.thescripts.com/forum/thread661371.html[^]

Thanks Again

Re: Call .Net 2005 DLL in .Net 2003

originSH23-Jul-07 22:18

originSH

23-Jul-07 22:18

As a hack you could load it as an out of process COM server, but it's bad and wrong, just upgrade the damn app already :P it'll be worth it in the long run. There were very few breaking changes between 1.1 and 2.0 so theres not much excuse for not upgrading.

Re: Call .Net 2005 DLL in .Net 2003

Bhavik Solanki24-Jul-07 12:22

Bhavik Solanki

24-Jul-07 12:22

Thanks to All of you.

After doing lot of R&D and Spending lot of time on it, finally I come to the decision that I will upgrade existing applications to Framework 2.0. Frown | :(

Thanks Again.

C# choosing database connection

lino_i23-Jul-07 8:47

lino_i

23-Jul-07 8:47

I have a GUI utility and it connects to a sql server 2005 database. All of the connection code has been generated by the IDE.

I have 2 databases one for produciton and one for development. How can I switch the connection string? I am currently doing it in the Settings.Designer.cs file and checking for

#if DEBUG
//use the dev server
#else
//use the prod server
#endif

however everytime i alter the settings.settings file the IDE rewrites the Settings.Designer.cs file.

this is how the code currently works:

currently when i start my application the connection string is initialized like this:
this is called:
internal System.Data.SqlClient.SqlConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
which calls this:
private void InitConnection() {
this._connection = new System.Data.SqlClient.SqlConnection();
this._connection.ConnectionString = global::DGView2.Properties.Settings.Default.ProdConnectionString;
}
which calls this:
public string ProdConnectionString {
get {
return ((string)(this["ProdConnectionString "]));
}
}

app.config file:

<connectionStrings>
<add name="DGView2.Properties.Settings.ProdConnectionString"
connectionString="Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=True"
providerName="System.Data.SqlClient"
<add name="DGView2.Properties.Settings.DevConnectionString" connectionString="Data Source=localhost\DEV;Initial Catalog=MyDatabase;Integrated Security=True" />

</connectionStrings>

I guess part of the problem is that this line of code:

this._connection.ConnectionString = global::DGView2.Properties.Settings.Default.ProdConnectionString;

is always calling: public string ProdConnectionString

so in my Settings.Designer.cs file I have set it up this way:

public string ProdConnectionString {
#if DEBUG
get { return ((string)(this["DevConnectionString"]));}
#else
get { return ((string)(this["ProdConnectionString"]));}
#endif
}

I am not convinced that this is the best way to do it. The ideal situation I think would be to use the desired property based on DEBUG or RELEASE in the call to the connection string:

#if DEBUG
this._connection.ConnectionString = global::DGView2.Properties.Settings.Default.DevConnectionString;
#else
this._connection.ConnectionString = global::DGView2.Properties.Settings.Default.ProdConnectionString;

#endif

however there are just to many instances of this therefore making it less efficient.

any suggestions?

thx

Re: C# choosing database connection

Paul Conrad23-Jul-07 8:51

Paul Conrad

23-Jul-07 8:51

You may need to look in the App.Config file...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: C# choosing database connection

lino_i23-Jul-07 9:09

lino_i

23-Jul-07 9:09

i am looking in the app.config file that's where the settings are stored...that's not the problem

thx for your help tho

Re: C# choosing database connection

Pete O'Hanlon23-Jul-07 9:29

Pete O'Hanlon

23-Jul-07 9:29

The normal way of doing this is to just use one setting. You change the config file, so that you have a debug version and a release version.

Deja View - the feeling that you've seen this post before.

Re: C# choosing database connection

Vikram A Punathambekar23-Jul-07 17:10

Vikram A Punathambekar

23-Jul-07 17:10

I second what Pete said - use one setting, called ConnectionString and edit the file depending on whether you want it to work on Dev or Prod.

Cheers,
Vıkram.

After all is said and done, much is said and little is done.

Re: C# choosing database connection

lino_i24-Jul-07 1:49

lino_i

24-Jul-07 1:49

thanks to all for the replies...i will stick with one connection string

Simple forums question

Raymond_P*23-Jul-07 7:43

Raymond_P*

23-Jul-07 7:43

Heres a simple one im making a startup forum which asks for a password when the user clicks on the trey icon , if the password is accpted the value Authenticated is set to true and the trey icon menu is enabled

the problem being the whole multi form thing i cant change the value of Authenticated in the native form , Can anyone tell me how to get this working ?

//Native form
private bool Authenticated;

private void TreyIcon_Click(object sender, EventArgs e)
{
Authenticated = false;
if (Authenticated == true)
{
this.TreyIcon.ContextMenuStrip = this.TreyMenu;
}
else
{
Authentication form = new Authentication();
form.ShowDialog();
}
}

//remote form
private bool Authenticated;

private void Authenticate(object sender, EventArgs e)
{
if (Password1.Text == "pass")
{
MessageBox.Show("Password accpted", "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
Authenticated = true;
}
else {
Application.Exit();
}
}

Re: Simple forums question

Paul Conrad23-Jul-07 8:31

Paul Conrad

23-Jul-07 8:31

Raymond_P* wrote:
i cant change the value of Authenticated in the native form , Can anyone tell me how to get this working ?

Not sure, but as an observation, I wouldn't have the password out in plaintext when you have your program go live Smile | :)

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Simple forums question

Raymond_P*23-Jul-07 8:51

Raymond_P*

23-Jul-07 8:51

well its just some basic protection the app has my ftp credentals it updates a flash websites xml files . Its manly to detur anyone who uses my laptop like family. I wont be giving it to anyone else

im sure its simple ive dine this before but ive forgoton how

Re: Simple forums question

Paul Conrad23-Jul-07 17:56

Paul Conrad

23-Jul-07 17:56

Raymond_P* wrote:
Its manly to detur anyone who uses my laptop like family. I wont be giving it to anyone else

Okay, simple enough Smile | :)

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Get FTP Root/Home directory

Muhammad Nauman Yousuf23-Jul-07 7:38

Muhammad Nauman Yousuf

23-Jul-07 7:38

Dear All,

Need help to get the root/home directory of an FTP site configured on IIS 6.

Now so far i have been able to get each and every information such allowed via the WMI provider but am still unable to find any information to get home/root directory for ftp site.

Thank you!
M. Nauman Yousuf

IIS 7.0

kibromg23-Jul-07 6:32

kibromg

23-Jul-07 6:32

Hi all?

Can IIS 7.0 be installed on windows vista?

Is there an option called Windows authentication on IIS 7.0?

Regards

Re: IIS 7.0

Paul Conrad23-Jul-07 7:51

Paul Conrad

23-Jul-07 7:51

Google search: IIS 7.0 on Windows Vista[^] should be of help. As long as you have Vista Business or Ultimate.

BTW, do you have a C# question? You are in the wrong forum...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Bad user!

leckey23-Jul-07 8:24

leckey

23-Jul-07 8:24

Seems like you have cross-posted before and not gotten the message. I am virtually hitting your nose with my rolled up TechNet magazine. Now go to the corner and read the forum guidelines.

_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!

Re: Bad user!

Paul Conrad23-Jul-07 8:29

Paul Conrad

23-Jul-07 8:29

leckey wrote:
I am virtually hitting your nose with my rolled up TechNet magazine

Too bad I couldn't tie a rock or brick to my message I ~~posted~~ hurled earlier Laugh | :laugh:

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Module handling.....

Arish rivlin23-Jul-07 5:59

Arish rivlin

23-Jul-07 5:59

How can i kill a module without terminating its process?....

Re: Module handling.....

Luc Pattyn23-Jul-07 6:13

Luc Pattyn

23-Jul-07 6:13

what do you mean by module here ?

you can abort or kill a thread (not a very good idea).
you cant unload a class or assembly, but you can create a new AppDomain, load it, then
remove it (with everything thats in it).

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Module handling.....

Arish rivlin23-Jul-07 6:20

Arish rivlin

23-Jul-07 6:20

Then how can I know if a thread belongs to a cirtain dll/module. Its very important to me since a dll that I activate causes a crash at shotdown.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.