Re: web.config - ASP.NET Discussion Boards

Re: web.config

BasharatAli11-Nov-07 23:56

BasharatAli

11-Nov-07 23:56

thx john
but i want to add aur modify connection string at runtime.

BasharatAli

Internee
METESYS Lahore
Pakistan

Re: web.config

John-ph12-Nov-07 0:05

John-ph

12-Nov-07 0:05

Do you mean you want to programmatically add/modify the connection string stored in the web.config file?

Regards
- J O H N -

Re: web.config

BasharatAli12-Nov-07 0:07

BasharatAli

12-Nov-07 0:07

yes
i want to programmatically add/modify the connection string stored in the web.config file

BasharatAli

Internee
METESYS Lahore
Pakistan

Re: web.config

John-ph12-Nov-07 0:12

John-ph

12-Nov-07 0:12

Create a XMLDocument Object and Load the XMLFile (web.config) into it, then Navigate through the Nodes and find the attribute of the corressponding Connection string Node in the config file and modify the inner XML of the attribute.

Regards
- J O H N -

Re: web.config

Paddy Boyd12-Nov-07 0:35

Paddy Boyd

12-Nov-07 0:35

Note that changing the web.config will force your app domain to restart.

Re: web.config

BasharatAli12-Nov-07 0:58

BasharatAli

12-Nov-07 0:58

then how can i resolve this issue

BasharatAli

Internee
METESYS Lahore
Pakistan

Re: web.config

Paddy Boyd12-Nov-07 1:02

Paddy Boyd

12-Nov-07 1:02

If you must be able to change connection string programatically, then i would recommend storing them in a separate config file and writing your own code to access them.

Re: web.config

Guffa12-Nov-07 1:47

Guffa

12-Nov-07 1:47

Perhaps you should ask about what you are trying to accomplish, rather than how to implement it the way that you think that it should be implemented...

Experience is the sum of all the mistakes you have done.

Re: web.config

BasharatAli12-Nov-07 1:56

BasharatAli

12-Nov-07 1:56

i use this code for adding pr modifing connection string.

  Dim mydoc As System.Xml.XmlDocument = New System.Xml.XmlDocument<br />
        mydoc.Load(Application.StartupPath & "\..\..\app.config")<br />
        Dim node As System.Xml.XmlNode = mydoc.SelectSingleNode("configuration/connectionStrings/add")<br />
        Dim attribute As System.Xml.XmlAttributeCollection = node.Attributes<br />
        attribute(1).Value = ConnectionString<br />
mydoc.Save(Application.StartupPath & "\..\..\app.config")<br />

but Paddy Boyd said above
Note that changing the web.config will force your app domain to restart.

so i want to resolve this issue

BasharatAli

Internee
METESYS Lahore
Pakistan

Re: web.config

John-ph12-Nov-07 2:38

John-ph

12-Nov-07 2:38

BasharatAli wrote:
so i want to resolve this issue

First of all that is not a issue. That is one of the property of the .NET Framework that if you make any changes to the Configuration file, your webapplication will automatically restart since all the application level setting resides in the web.config file. By the way why you are programmatically modifying the web.config file. You can have multiple Connection strings in the Web.config file and access it in your code whichever you want.

Regards
- J O H N -

Re: web.config

Guffa12-Nov-07 5:19

Guffa

12-Nov-07 5:19

This is still just a question about how you implement the specific solution that you have chosen for your problem. Noone knows what is it that you are trying to accomplish really.

Experience is the sum of all the mistakes you have done.

Re: web.config

BasharatAli12-Nov-07 17:18

BasharatAli

12-Nov-07 17:18

i'm trying to generate connection string dynamicaly.

BasharatAli

Internee
METESYS Lahore
Pakistan

Re: web.config

BasharatAli12-Nov-07 17:20

BasharatAli

12-Nov-07 17:20

i'm trying to generate connection string dynamicaly mean every time new server name and DB.

BasharatAli

Internee
METESYS Lahore
Pakistan

Re: web.config

Guffa12-Nov-07 22:02

Guffa

12-Nov-07 22:02

Ok, why do you want to save the connection string in web.config? Why not just create a connection string settings object and use it?

ConnectionStringSettings settings = new ConnectionStringSettings("name...", "connection string...", "System.Data.SqlClient");

Experience is the sum of all the mistakes you have done.

Re: web.config

BasharatAli12-Nov-07 22:10

BasharatAli

12-Nov-07 22:10

Accutaly i hve used dataset component which read connectionstring from config file and i want to change that connectionstring programticaly to specify different server, user id and password so that's why i'm trying to change it.
anyways i hve just done it by another technique. so thanks all of you for your time Smile | :)

BasharatAli

Internee
METESYS Lahore
Pakistan

Re: web.config

Guffa13-Nov-07 11:17

Guffa

13-Nov-07 11:17

BasharatAli wrote:
Accutaly i hve used dataset component which read connectionstring from config file

You could just set the connection string from code behind instead of specifying it in the markup code. You are trying to work around limitations that doesn't exist...

Experience is the sum of all the mistakes you have done.

RadioButton

ps.srinivasan11-Nov-07 23:18

ps.srinivasan

11-Nov-07 23:18

How to write the coding for RadioButton onclick event

Re: RadioButton

John-ph11-Nov-07 23:32

John-ph

11-Nov-07 23:32

ps.srinivasan wrote:
How to write the coding for RadioButton onclick event

server-side You can write the code on OnCheckedChanged event.
Clisent-side you bind a javascript function to the client onclick event.

Regards
- J O H N -

How to lock a record?

samerh11-Nov-07 23:01

samerh

11-Nov-07 23:01

Hi all,
Iam developing a .net 2.0 web application where i have dataentry pages to enter details for a case. Each case has a unique reference. I need to prevent users from enetering/editing/viewing this certain reference if another user is viewing/editing it. How can i do that?
N.B. i have tried a bit field in the database but iam not being able to maintain page closing/leave to release the page.

thanks

Re: How to lock a record?

Christian Graus11-Nov-07 23:05

Christian Graus

11-Nov-07 23:05

samerh wrote:
but iam not being able to maintain page closing/leave to release the page.

You can use AJAX to do this, but you'd still be best to impliment a timeout, because if someone turns off their PC, there's literally nothing you can do.

A bit field and a date/time for a timeout is the only way to do this. Storing the Id of the person who has the lock also makes sense ( replace the bit with an int, using 0 for no lock, or a user Id, for example )

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: How to lock a record?

samerh11-Nov-07 23:22

samerh

11-Nov-07 23:22

Thanks for ur reply.
Storing the id of the user is a good solution, however iam not being able to know when the user leaves the pages of that reference, taking into consideration that this reference has around 25 detail pages and i need to keep locking this reference as long as this user is in one of these pages. My issue is that i am facing timeouts and how can i know when a user eneters a second reference to release the first one and what if he wants to use them both!!!
May be as said there is no one way to do that. I will try to check the query string and if the refId is different i will release the reference. Still i didnt test it.

Re: How to lock a record?

Christian Graus11-Nov-07 23:51

Christian Graus

11-Nov-07 23:51

samerh wrote:
however iam not being able to know when the user leaves the pages of that reference

Corrent. You have to add a timeout because there is no way to be sure that the user has left the page.

how to run a html file when i run the dotnet application?

codeproject_buna11-Nov-07 22:59

codeproject_buna

11-Nov-07 22:59

hi,

I put a html file with in the tag of the table and i want to run this html file when i run my application. that means when i run the application i want the output of the html file with in a table cell.

I am using aspdotnet(using vb.net).
please send me some solution for that.

thanks and regards

bikash pattanayak

Re: how to run a html file when i run the dotnet application?

Christian Graus11-Nov-07 23:05

Christian Graus

11-Nov-07 23:05

You can use a frame to embedd a HTML page in your app. Or if it's an HTML snippet, you can put an asp:Literal in your page and assign the HTML to it.

how to use xml coment in vbdotnet 1.1

codeproject_buna11-Nov-07 22:52

codeproject_buna

11-Nov-07 22:52

hi,

i hv applied some xml documentation for c# using /// (three forword slashes) but how can i do the same in vbdotnet. now i am using vbdotnet 1.1

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