Re: update app.config file at runtime - C# Discussion Boards

Re: update app.config file at runtime

steve_rm25-Sep-06 1:22

steve_rm

25-Sep-06 1:22

Re: update app.config file at runtime

Ed.Poore25-Sep-06 1:31

Ed.Poore

25-Sep-06 1:31

steve_rm wrote:
I am using vb.net 2005

Then ask in the appropriate forum[^].

Just Google it.
Failing that try phoning Green Alien | [Alien]

Re: update app.config file at runtime

steve_rm25-Sep-06 4:47

steve_rm

25-Sep-06 4:47

Hello

I am using my.settings to create a application scope connection string.

The customer would like to change this if they want to connect to another database, and this should update the app.config file with the updated connection string.

My problem I have into the setting and create a connection string (easy). But I don't know and can't find out to update and save the new connection string.

My.Settings.cnnString = "This is example connection" 'Error read-only property

Can anyone help,

I got this code and it seem it would work. However, there is a problem with the code. I get a "Object reference not set to an instance of an object."

Here my code.
[code]
Dim config As Configuration.Configuration = Configuration.ConfigurationManager.OpenExeConfiguration(Configuration.ConfigurationUserLevel.None)
config.ConnectionStrings.ConnectionStrings("ServiceMasterConnectionString").ConnectionString = "This is new connection " 'Error -
config.Save()
[/code]

Thanks in advance,

Steve

Re: update app.config file at runtime

Ed.Poore25-Sep-06 5:25

Ed.Poore

25-Sep-06 5:25

As I said there's not much point in asking here since we're C# developers and I for one have developed in VB.NET but not recently so don't know about My.Settings, people in the VB.NET forum should know. Roll eyes | :rolleyes:

Just Google it.
Failing that try phoning Green Alien | [Alien]

Re: update app.config file at runtime

steve_rm25-Sep-06 4:48

steve_rm

25-Sep-06 4:48

<br />
Dim config As Configuration.Configuration = Configuration.ConfigurationManager.OpenExeConfiguration(Configuration.ConfigurationUserLevel.None)<br />
        config.ConnectionStrings.ConnectionStrings("ServiceMasterConnectionString").ConnectionString = "This is new connection " 'Error - <br />
        config.Save()<br />

Thanks in advance,

Steve

Re: update app.config file at runtime

S. Senthil Kumar25-Sep-06 5:20

S. Senthil Kumar

25-Sep-06 5:20

Christian Graus wrote:
the file you need is under a folder called 'profile' and you actually access it from Profile.Settings.Default.Propname,

Oh, so you got it to work finally?

Regards
Senthil [MVP - Visual C#]
_____________________________
My Blog | My Articles | My Flickr | WinMacro

Re: update app.config file at runtime

steve_rm25-Sep-06 6:42

steve_rm

25-Sep-06 6:42

Hello,

The code I posted did not work, there was an error.

S. Senthil Kumar wrote:
the file you need is under a folder called 'profile' and you actually access it from Profile.Settings.Default.Propname,

I am sure what this Profile.Settings.Default.Propname is, can someone possibly give me an example.

Many thanks,

Steve

Re: update app.config file at runtime

Christian Graus25-Sep-06 10:16

Christian Graus

25-Sep-06 10:16

I realised there was a folder called Profile with a settings file in it. I hadn't seen it, I'd followed the instructions on the MS site and created a new settings file, which the IDE did, but which then was not mapped to the Profile.Settings stuff. It's all stupid IMO, but I can see now how to make it work. In the meantime, I wrote my own code to serialise a struct with all my settings in it to XML, and to expose those properties via a static class.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Get Decimal value from an sql 2000 Database

i-p-g-i24-Sep-06 23:49

i-p-g-i

24-Sep-06 23:49

Hello,
thats my problem:

Decimal _ContentDistributionResolution = 0;
....
....
_ContentDistributionResolution = myReader.GetDecimal(12);
...
...

In the Database ist the ContentDistributionResolution column from Datatype Decimal (accuracy: 5)...
The System.Converte methode dosent work...

Re: Get Decimal value from an sql 2000 Database

Christian Graus24-Sep-06 23:54

Christian Graus

24-Sep-06 23:54

Define 'doesn't work', Have you tried this :

object o = myReader.GetDecimal(12);

in the debugger to see what object is being returned ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Get Decimal value from an sql 2000 Database

i-p-g-i24-Sep-06 23:58

i-p-g-i

24-Sep-06 23:58

ahhh...I am stupid!!! I have used the false Index GetDecimal(13) is the right!!!
Sorry Roll eyes | :rolleyes:

How to Use __LINE__ & __FUNCTION__ in C#

asishpatnaik24-Sep-06 22:58

asishpatnaik

24-Sep-06 22:58

In C# how to get the line number and file name from which an exception is raised.

In C++ we have the macro __LINE__ to do that. Want to know the substitute in C#. or Is it possible to use the macro __LINE__ in C#. if YES , let me know how is it possible.

Ashish

Re: How to Use __LINE__ & __FUNCTION__ in C#

Nader Elshehabi24-Sep-06 23:14

Nader Elshehabi

24-Sep-06 23:14

Hello

You will find that in the SystemException.Message property. You might also want to check the SystemException.Data for useful information.

About the __FUNCTION__ macro, you can use Environment.StackTrace to get the name of the current function at anytime.

And no!! You can't call C++ macros in C#.

Regards

Re: How to Use __LINE__ & __FUNCTION__ in C#

asishpatnaik25-Sep-06 1:01

asishpatnaik

25-Sep-06 1:01

Thanx a lot for the response.

I have checked SystemException it does not gives the line no throwing exception.

and the Environment.StackTrace gives result in the debug build but doesnt work for the release build.

Is there any other way ?? plz let me know

NOthignhere

Re: How to Use __LINE__ & __FUNCTION__ in C#

Nader Elshehabi25-Sep-06 1:25

Nader Elshehabi

25-Sep-06 1:25

Environment.StackTrace works fine in release mode. What makes it doesn't work for you? Another alternative is to use Trace class to make your own trace calls.

Regards

How do you read the end of an XML file in C#?

bigove24-Sep-06 22:55

bigove

24-Sep-06 22:55

I have a program that cycles through an XML file and outputs to another file every 1000 records. Thyis works fine until the end of the XML file is reached, when it fails saying my 'root' tag is not closed - although it does for the previous files. It seems to be having issues with recognising the end of the XML file, so can someone please confirm how this is done? Currently I have a while loop to do this, with a for loop inside to cycle through the records, ie:

while (XmlReader.Read())
{
...

for (int i = 1; i <= 100; i++)
{
while (reads in a node here)
{
does the work
}
}

Close the XmlReader and XmlWriter
}

This works fine for the beginning, until the end of the file is reached; is my way of reading the XML file correct (I have also tried XmlReader != null), or is there a better way?

Many thanks.

Re: How do you read the end of an XML file in C#?

Ed.Poore24-Sep-06 23:04

Ed.Poore

24-Sep-06 23:04

Judging by your description of the error have you made sure that you close all the tags you open with XmlWriter?

<br />
<br />
xw.WriteStartDocument

must be closed by xw.WriteEndDocument<code>
xw.WriteStartElement must be closed by xw.WriteEndElement (even for the root node)

Just Google it.
Failing that try phoning Green Alien | [Alien]

Re: How do you read the end of an XML file in C#?

bigove24-Sep-06 23:52

bigove

24-Sep-06 23:52

Thanks for the reply.

I do ensure I have a 'closing' tag for every 'opening' one. This works fine for all files (say, 10 files of 100 records each), but on the last file, where the end of the original file is found, it fails. I believe my method to read it is fine, yet it fails (somehow!) when reading the end of the file. So I am really puzzled!

Oh, and I've googled lots to no joy!!!

Re: How do you read the end of an XML file in C#?

Ed.Poore25-Sep-06 0:36

Ed.Poore

25-Sep-06 0:36

When you hit the end-of-file do you make sure that all the nodes are closed in the output stream?

It'd be a help if you could copy & paste the details of the exception thrown as well, so that we can see if it's a reading or writing problem.

Just Google it.
Failing that try phoning Green Alien | [Alien]

Re: How do you read the end of an XML file in C#?

bigove25-Sep-06 1:58

bigove

25-Sep-06 1:58

I do ensure all nodes are closed when the end of file is found - at least I think so, but I am sure it is something in that area that is causing the problem.

As for the exception, there isn't one; the program doesn't complete. The XML file's are created, but in the last one towards the end of the file, in the middle of a record is the message:

"XML page cannot be displayed

The following tags were not closed: message."

Where message is my root node. Yet it closes them in the other files (when the original XML file still has more records to read)...

Re: How do you read the end of an XML file in C#?

Ed.Poore25-Sep-06 2:08

Ed.Poore

25-Sep-06 2:08

Can you show the bits of code which are executed when the end-of file is reached?

Just Google it.
Failing that try phoning Green Alien | [Alien]

Re: How do you read the end of an XML file in C#?

bigove25-Sep-06 2:55

bigove

25-Sep-06 2:55

Here is my code:

while (XmlReader.Read() && nodeCounter <= 1000)

{

// Create a file to write to

XmlTextWriter XmlWriter = new XmlTextWriter(directory + "\\Output" + x + " CIS_KASN.xml", null);

XmlWriter.Formatting = Formatting.Indented;

// Write the header details to the new file

XmlWriter.WriteProcessingInstruction("xml", "version='1.0' encoding='ISO-8859-1'");

XmlWriter.WriteComment("This XML message contains CIS Key Accounts and Special Needs records for inserting/updating in the IAR");

XmlWriter.WriteStartElement("message");

XmlWriter.WriteAttributeString("xmlns", "xsi", null, "http://www.w3.org/2001/XMLSchema-instance");

XmlWriter.WriteAttributeString("xsi", "noNamespaceSchemaLocation", null, "CISKASN.xsd");

// Write each row to the file, until 1000 records have been written

for (int i = 1; i <= 1000; i++)

{

while (XmlReader.Name != "CISKASNRecord")

{

XmlReader.Read();

}

XmlWriter.WriteNode(XmlReader, true);

XmlWriter.Flush();

}

// Tidy up and close the file so that a new one can be opened

XmlWriter.Flush();

XmlWriter.Close();

nodeCounter++;

x++;

}

The program runs fine if I reduce my for-loop to 10 (thus not reading the end of file). At 1000 I get an XML error saying the 'message' tag is not closed and the program doesn't complete...

Re: How do you read the end of an XML file in C#?

Ed.Poore25-Sep-06 4:54

Ed.Poore

25-Sep-06 4:54

bigove wrote:
for (int i = 1; i <= 1000; i++)

You need a condition here to test for the EOF me thinks. You're loop statements look a bit dodgy, might I suggest something like this:

private void Process(XmlReader xr)
{
    int recordCount = 0;                        // Counter to count how many records are in current file.
    int fileCount = 0;                          // Counter for file index
    XmlTextWriter xtw = OpenFile(fileCount++);  // XmlTextWriter for output file
    // Loop until EOF
    while (xr.Read())
    {
         // Skip over records which are not to be output
<font face="Courier New">         </font><font face="Courier New">while xr != "CISKASNRecord")
            xr.Read();
         // Write the element to output
        xtw.WriteNode(xr, true);</font>
<font face="Courier New">        xtw.Flush();</font>
        // Increment node counter
         recordCount++;

         // Check to see if 1000 records have been written
         if (recordCount == 1000)
         {
                // Close the output stream
                xtw.Close();
                xtw.Flush();
		xtw = null;		// Set to null to check to see if stream is open at the end of the loops
		// Open a new stream
		xtw = OpenFile(fileCount++);
         }
    }
    // Close the stream if not done already
    if (xtw != null)
    {
	xtw.Close();
	xtw.Dispose();
	xtw = null;
    }
}
private XmlTextWriter OpenFile(int index)
{
    XmlTextWriter xtw = new XmlTextWriter(Path.Combine(directory, string.Format("Output{0}CIS_KASN.xml", index)), null);
    xtw.Formatting = Formatting.Indented;
    // Write header details
   <font face="Courier New"> xtw.WriteProcessingInstruction("xml", "version='1.0' encoding='ISO-8859-1'");
    xtw.WriteComment("This XML message contains CIS Key Accounts and Special Needs records for inserting/updating in the IAR");
    xtw.WriteStartElement("message");
    xtw.WriteAttributeString("xmlns", "xsi", null, "http://www.w3.org/2001/XMLSchema-instance");
    xtw.WriteAttributeString("xsi", "noNamespaceSchemaLocation", null, "CISKASN.xsd");
    // Return the object
    return xtw;</font>
}

The benefit of this solution is there is only one place where you check for the end-of-file condition and similarly one place where you check for the end-of-batch condition.

Just Google it.
Failing that try phoning Green Alien | [Alien]

Re: How do you read the end of an XML file in C#?

bigove25-Sep-06 5:24

bigove

25-Sep-06 5:24

Thank you for the help.

Trying that code, the 'Dispose' method is inaccessible. But commetning that out, the code compiles...but nothing is output. Am I missing something obvious?!

Re: How do you read the end of an XML file in C#?

Ed.Poore25-Sep-06 6:13

Ed.Poore

25-Sep-06 6:13

bigove wrote:
'Dispose' method is inaccessible

Oops, my memory must be getting full Sigh | :sigh:

bigove wrote:
Am I missing something obvious?!

No I probably am.

Give me a few minutes to check over the code.

Just Google it.
Failing that try phoning Green Alien | [Alien]

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