C# Discussion Boards - CodeProject

Problem with changing connection string that saved in app.config

hdv2128-Oct-09 6:13

8-Oct-09 6:13

Hi i want to change connection string that saved in app.config (which created in visual studio wizard dialog).
i changed some Settings.Designer.cs code which described in this thread[^] to make that editable. that's works good when i change it at runTime and load it again, but when i exit from my app and look at my saved properties, it's again backed to earlier settings (before my edit).
what's the problem and how to solve this ?
thanks

Re: Problem with changing connection string that saved in app.config

Md. Marufuzzaman8-Oct-09 6:37

Md. Marufuzzaman

8-Oct-09 6:37

Could you share the code snippets…So that we can get the actual scenario properly?

Thanks
Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Re: Problem with changing connection string that saved in app.config

hdv2128-Oct-09 7:25

hdv212

8-Oct-09 7:25

here is my Settings.Designer.cs code (my modification code is bold) :

[global::System.Configuration.UserScopedSettingAttribute()]
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
        //[global::System.Configuration.DefaultSettingValueAttribute("Data Source=.;Initial Catalog=mehr;Integrated Security=True")]
        public string mehrConnectionString {
            get {
                return ((string)(this["mehrConnectionString"]));
            }
            set
            {
                this["mehrConnectionString"] = value;
            }
        }

        [global::System.Configuration.UserScopedSettingAttribute()]
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
        //[global::System.Configuration.DefaultSettingValueAttribute("Data Source=.;Initial Catalog=mehr;Integrated Security=True")]
        public string mehrConnectionString1 {
            get {
                return ((string)(this["mehrConnectionString1"]));
            }
            set
            {
                this["mehrConnectionString1"] = value;
            }
        }

here is my code to save in app.config :

Properties.Settings.Default.serverName = this.txtServer.Text;
                    Properties.Settings.Default.userName = this.txtUser.Text;
                    Properties.Settings.Default.password = this.txtPass.Text;

                    if (this.radioLocal.Checked)
                    {
                        Properties.Settings.Default.network = false;
                        Properties.Settings.Default.mehrConnectionString = string.Format("Data Source={0};Initial Catalog=mehr;Integrated Security=True", this.txtServer.Text);
                        Properties.Settings.Default.mehrConnectionString1 = string.Format("Data Source={0};Initial Catalog=mehr;Integrated Security=True", this.txtServer.Text);
                    }
                    else
                    {
                        Properties.Settings.Default.network = true;
                        Properties.Settings.Default.mehrConnectionString = string.Format("Data Source={0};Initial Catalog=mehr;User Id={1};Password={2};", this.txtServer.Text, this.txtUser.Text, this.txtPass.Text);
                        Properties.Settings.Default.mehrConnectionString1 = string.Format("Data Source={0};Initial Catalog=mehr;User Id={1};Password={2};", this.txtServer.Text, this.txtUser.Text, this.txtPass.Text);
                    }
                    Properties.Settings.Default.Save();

regards

Re: Problem with changing connection string that saved in app.config

Md. Marufuzzaman8-Oct-09 7:44

Md. Marufuzzaman

8-Oct-09 7:44

Probably you are loading the app.config several times, why dont you use a Hashtable for managing multiple connectionstring
Example:

Hashtable ObjHashtable   = new Hashtable();

ObjHashtable.Add("Key1", "Data Source= source_1 ;Initial Catalog= DatabaseName_1;User ID=id;Password=pwd;");
ObjHashtable.Add("Key2", "Data Source= source_2 ;Initial Catalog= DatabaseName_2;User ID=id;Password=pwd;");

You just need to load the Hashtable only one time...........

public SqlDataReader Example(string strSql, string strKey)
{
   ObjSqlConnection = new SqlConnection(ObjHashtable[strKey].ToString());
   ...........
   .......
}

Thanks
Md. Marufuzzaman

Re: Problem with changing connection string that saved in app.config

hdv2128-Oct-09 8:03

hdv212

8-Oct-09 8:03

Thanks Md. Marufuzzaman
i want to save my connection string in app.config to save this state in future use. next time it must use the saved settings which user set.

Re: Problem with changing connection string that saved in app.config

Md. Marufuzzaman8-Oct-09 9:25

Md. Marufuzzaman

8-Oct-09 9:25

You are most welcome....... Smile | :)

Absolutely you save your connectionString in your app.config.

My point of view was:

1.     Read your config file
2.     Fill the HasTable
3.     Use the HasTable runtime so that you not need to invoke config file several times.

Thanks
Md. Marufuzzaman

Re: Problem with changing connection string that saved in app.config

hdv2128-Oct-09 10:43

hdv212

8-Oct-09 10:43

my problem is that i can't store my settings in app.config file. it's not persistence.

Re: Problem with changing connection string that saved in app.config

cjoki12-Oct-09 5:34

cjoki

12-Oct-09 5:34

I am looking into a simular issue and although, I am no expert, I think app.config is used in design time and [appname].exe.config is for release and where the changes need to be made... anyone, please correct me if I'm wrong on this.

All the best
cjoki

navigator in datagridview

hotthoughtguy8-Oct-09 5:03

hotthoughtguy

8-Oct-09 5:03

hi
how to use navigator in datagridview
can any one provide me link.
thanks

Re: navigator in datagridview

Luc Pattyn8-Oct-09 5:19

Luc Pattyn

8-Oct-09 5:19

sure[^], no problem.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

[Message Deleted]

hotthoughtguy8-Oct-09 4:53

hotthoughtguy

8-Oct-09 4:53

[Message Deleted]

Re: hi

AndyInUK8-Oct-09 4:56

AndyInUK

8-Oct-09 4:56

Mr. Hot Thought -

Can you provide a correct subject.

Passing a Form's control to a routine in another class as a variable

yogi_bear_798-Oct-09 4:39

yogi_bear_79

8-Oct-09 4:39

I have a simple program. It has one Form called frmMain, and another Class called Poker. I have the following snippit routine below. The name 'Color' does not exist in this context. What do I need to do to make this work?

public void Results(Label lbl_1)
{
frmMain Form1 = new frmMain();

lbl_1.ForeColor = Color.Yellow;
Form1.lblWinnings.Text = "100";
}

Re: Passing a Form's control to a routine in another class as a variable

Richard MacCutchan8-Oct-09 4:51

Richard MacCutchan

8-Oct-09 4:51

yogi_bear_79 wrote:
The name 'Color' does not exist in this context.

Include using System.Drawing; at the top of your source module.

Re: Passing a Form's control to a routine in another class as a variable

yogi_bear_798-Oct-09 4:54

yogi_bear_79

8-Oct-09 4:54

So easy... Thanks!!!

Re: Passing a Form's control to a routine in another class as a variable

Henry Minute8-Oct-09 4:58

Henry Minute

8-Oct-09 4:58

When you get this error if you hover your mouse over the offending item, you should see a rectangle appear under the rightmost letter of the word. Moving the pointer over this rectangle changes it to a drop-down, offering solutions. Simply select the 'using System.Drawing' one and bob's-your-uncle. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Passing a Form's control to a routine in another class as a variable

PIEBALDconsult8-Oct-09 5:32

PIEBALDconsult

8-Oct-09 5:32

Fully qualify the name.

Suggestions for general networking solution on WAN and LAN

lvq6848-Oct-09 4:24

lvq684

8-Oct-09 4:24

Hi.

I am about to program a piece of software which contains a single server, and about 20-40 clients.
All parts can be spread out on a lan, or on a wan.
The server shall be able to broadcast/multicast to the clients in some way, and the clients should be able to fetch information from the server.
There are about 30 kinds of information which has to be fetched/broadcasted.

Question is, how to solve this general problem in the most elegant way?
I would be happy if i could avoid switches in the client/server end to check what kind of information i received, or make my own kind of application layer protocol to check it.
I had a look at remoting, like RMI in java, but that seems to be a very bad idea over WAN because of firewalls and such.

Do you have any insight in possible solutions for this?

Thanks alot Smile | :)

Re: Suggestions for general networking solution on WAN and LAN

Mirko19808-Oct-09 4:40

Mirko1980

8-Oct-09 4:40

If you have to communicate through WAN, your best option is using Windows Communication Foundation, using one of the HTTP bindings.

[C#.NET 2008] Screen-scraping a HTML Page

Dimitri Backaert8-Oct-09 3:47

Dimitri Backaert

8-Oct-09 3:47

Hi,

I'm trying to process the HTML source code from a certain web page.
This web page has security enabled, using a Username & a password.

I'm using the following method to try to access the page:

public static string GetHtmlPageSource(string url, string username, string password)
{

	WebClient wc = new WebClient();

	wc.Credentials = new NetworkCredential(username, password);
	
	try
	{
		using (Stream stream = wc.OpenRead(new Uri(url)))
		{
			using (StreamReader reader = new StreamReader(stream))
			{
				return reader.ReadToEnd();
			}
		}
	}
	catch (WebException e)
	{
		//Error handeling 
		return e.ToString();
	} 
}

This doesn't work however, I seem to be stuck at the logon page. I'm not able to pass the user security.
Anyone has an idea?

Re: [C#.NET 2008] Screen-scraping a HTML Page

Henry Minute8-Oct-09 4:20

Henry Minute

8-Oct-09 4:20

Do you not think that the site owners put the security there for a reason?

Re: [C#.NET 2008] Screen-scraping a HTML Page

Dimitri Backaert8-Oct-09 4:58

Dimitri Backaert

8-Oct-09 4:58

Yes I do, it's to prevent unauthorised access to the page... Laugh | :laugh:

However, this is a Web page that exists on the intranet of our company network.
It displays certain measures which we want to display on a Dashboard application.

The idea is to have an overview of these values at the blink of an eye (the dashboard will be projected on a whiteboard).

Normally, we would use a read account on the database for this, but (since the database is being managed by the Netherlands and I am a Belgian employee) the Netherlands are refusing to give us a read account.
So this is the only way how we can succeed in building the dashboard.

Re: [C#.NET 2008] Screen-scraping a HTML Page

Richard MacCutchan8-Oct-09 5:10

Richard MacCutchan

8-Oct-09 5:10

Dimitri Backaert wrote:
Normally, we would use a read account on the database for this, but (since the database is being managed by the Netherlands and I am a Belgian employee) the Netherlands are refusing to give us a read account.

Does the chairman of the company think this is a good thing?

Re: [C#.NET 2008] Screen-scraping a HTML Page

Henry Minute8-Oct-09 5:24

Henry Minute

8-Oct-09 5:24

Doncha just luuuv office politics? Laugh | :laugh:

Re: [C#.NET 2008] Screen-scraping a HTML Page

Richard MacCutchan8-Oct-09 6:05

Richard MacCutchan

8-Oct-09 6:05

Henry Minute wrote:
Doncha just luuuv office politics?

I just wonder why the Dutch don't trust the Belgians? Laugh | :laugh:

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