Re: Update Connection String - ASP.NET Discussion Boards

Vimalsoft(Pty) Ltd2-Mar-09 1:53

2-Mar-09 1:53

Good Afternoon

My Application is Structured in a Way that before you login you must First Select a Database. Now i have one page that i want to change the Connection String Database name.

I have this function that get called on page load

/*This Function will change the Connection string in the web.congif file based on the Database that exists on the
 * session Variable. If there is nulll then set odirect3 as a current Database name.
 */
public void UpdateConfig()
{
    CommonFunctions obj = new CommonFunctions();



    String strKey = "NEWDT";

    String StrDatabase;

    if (Session["ActiveDatabase"] != null)
    {
        StrDatabase = Convert.ToString(Session["ActiveDatabase"]);
    }
    else
    {
        StrDatabase = "oDirectv3";
    }

    String strValue = @"User id=sa;Password=abacus;Server=LOUWTJIE\SQLEXPRESSDatabase="+StrDatabase;

    Configuration objConfig = WebConfigurationManager.OpenWebConfiguration("~");

    AppSettingsSection objAppsettings = (AppSettingsSection)objConfig.GetSection("appSettings");

    if (objAppsettings != null)
    {
        objAppsettings.Settings[strKey].Value = strValue;

        objConfig.Save();
    }
}

On the Development site it works well. But while still debugging the code, checking if its doing what i want, There is a point where it has to save the changes

objConfig.Save();

The Part will execute and message box will appear asking me if i really want to save the changes made, i will save yes and everything will be fine. But if i don debug it , it gives an Error that says

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

How can i do this and Suppress this dialogs

Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

Re: Update Connection String

J4amieC2-Mar-09 2:12

J4amieC

2-Mar-09 2:12

You're going about this all wrong. You cant possible update the web.config for every different session - the reason it works in development is because you are the only session. Once this goes into a multi-user environment I cant see how it would operate sucessfully.

I have a similar issue in an app I am writing, and I configure using separate connection strings in the web config and make a decision which one to use at run-time based on the user's settings.

Re: Update Connection String

Greg Chelstowski2-Mar-09 2:13

Greg Chelstowski

2-Mar-09 2:13

Man, you beat me to the punch by seconds Wink | ;)

var question = (_2b || !(_2b));

Re: Update Connection String

Vimalsoft(Pty) Ltd2-Mar-09 2:23

Vimalsoft(Pty) Ltd

2-Mar-09 2:23

Good Afternoon J4amieC

I have Created a Connection String for this. Now the Connection String Difference is only on the Database part. So i need to change the Database name Before doing anything.

Please Advice on the Best way of doing this

Re: Update Connection String

Greg Chelstowski2-Mar-09 2:12

Greg Chelstowski

2-Mar-09 2:12

Well I wouldn't go about changing web.config, for one thing...
Because if another user starts up the same website, they're gonna change the web.config again, aren't they?
Or, if they're picking a database on page_load, have as many connection strings in the web.config as you need, and use that one ( a simple switch-case statement will define which one you want).
But changing the connection string in the web.config through your application seems very insecure to me.

You have to remember web.config is the whole application's configuration, not its one instance.

var question = (_2b || !(_2b));

Re: Update Connection String

Vimalsoft(Pty) Ltd2-Mar-09 2:31

Vimalsoft(Pty) Ltd

2-Mar-09 2:31

Greg Wrote:
Well I wouldn't go about changing web.config, for one thing...
Because if another user starts up the same website, they're gonna change the web.config again, aren't they?

yes

Please Give advice on how to do it

Thank you

Re: Update Connection String

Greg Chelstowski2-Mar-09 2:41

Greg Chelstowski

2-Mar-09 2:41

There's honestly a lot of ways you could it.
The cleanest would be to add all the connection strings into the webconfig (using

<connectionStrings>
<add name="string1" connectionString="datasource=.\SQLEXPRESS;User ID=sa;password=1235;Database=Database1" providername="System.Data.SqlClient" />

<add name="string2" connectionString="datasource=.\SQLEXPRESS;User ID=sa;password=1235;Database=Database2" providername="System.Data.SqlClient" />

</connectionStrings>

There is another, though. You can set up one connection string and then when you reference it in the code you do:

string connString = ConfigurationManager.ConnectionStrings["string1"].ConnectionString;
connString = connString.Replace("Database1", "YourDataBaseName");

var question = (_2b || !(_2b));

Re: Update Connection String

Vimalsoft(Pty) Ltd2-Mar-09 2:47

Vimalsoft(Pty) Ltd

2-Mar-09 2:47

Thanks for your Advice

Now the Second Option,can work for me. But i have a Question regarding the replace part.

The "YourDataBaseName" does it matter if it comes from a Session variable ?

Re: Update Connection String

Greg Chelstowski2-Mar-09 2:53

Greg Chelstowski

2-Mar-09 2:53

Vuyiswa Maseko wrote:
The "YourDataBaseName" does it matter if it comes from a Session variable ?

Nope.
As long as it's a string! Wink | ;)

var question = (_2b || !(_2b));

Re: Update Connection String

Vimalsoft(Pty) Ltd2-Mar-09 19:45

Vimalsoft(Pty) Ltd

2-Mar-09 19:45

hi Greg

i Done it this way

<connectionStrings>
    
<add name="string1" connectionString="datasource=VUYISWA_SERVER ;User ID=VA;password=MASEKO;Database=NEWDT" providerName="System.Data.SqlClient" />
 
</connectionStrings>

And the C# code is like this

/*This Function will change the Connection string in the web.congif file based on the Database that exists on the
 * session Variable. If there is null then set odirect3 as a current Database name.
 */
public void UpdateConfig()
{

    String StrDatabase; //This will be Comming from a Session

    if (Session["ActiveDatabase"] != null)
    {
        StrDatabase = Convert.ToString(Session["ActiveDatabase"]);
        string connString = ConfigurationManager.ConnectionStrings["string1"].ConnectionString;
        connString = connString.Replace("NEWDT", StrDatabase);
    }
    else
    {
        StrDatabase = "oDirectv3";
        string connString = ConfigurationManager.ConnectionStrings["string1"].ConnectionString;
        connString = connString.Replace("NEWDT", StrDatabase);
    }
}

And am Calling this Function like this from a page load

protected void Page_Load(object sender, EventArgs e)
  {

      Session["ActiveDatabase"] = "Mafutha";

      UpdateConfig();

      Response.Write("<script> alert('Wow i did it');</script>");


  }

Remember this is just a test to see if it will change the Database in the Connection String. After i run it i get the alert no Errors but the Connection String has not been changed to "Mafutha".

What could be the Problem ?

Re: Update Connection String

Greg Chelstowski2-Mar-09 20:50

Greg Chelstowski

2-Mar-09 20:50

OK, now look.
Obviously, your UpdateConfig() method is not going to physically alter the web.config.
The connection string you want to use is only going to work with just one session, and that's a good thing. Instead of keeping just the database name in your session variable, store the whole connection string.
If you do not want to, change your UpdateConfig() method (and change its name too, cos it's confusing) like so:

private string GetConnectionString(string DB) // where DB is your database name from the session
{

        string connString = ConfigurationManager.ConnectionStrings["string1"].ConnectionString;
        if (Session["ActiveDatabase"] != null)
        {
            return connString.Replace("NEWDT", DB);
        }
        else
        {
            return  connString.Replace("NEWDT", "oDirectv3");
        }

}

Anytime you want to use the connection string, just call this function to return it to you.

var question = (_2b || !(_2b));

Re: Update Connection String

Vimalsoft(Pty) Ltd4-Mar-09 1:27

Vimalsoft(Pty) Ltd

4-Mar-09 1:27

Good Day Greg

I would like to take this chance and thank you for what you have doe for me. Everything is Working Fine.

Thank you

Can i use my own User Registartion Information Class with ASP .NET Login controls

The One2-Mar-09 1:49

The One

2-Mar-09 1:49

Hi friends,

I got a question that
"Can i use my own SQl Databse Table named 'RegisteredUsers' to store the information about users who wants to register on my site. If i used my own class like such without using the ASPMembershipProvider then is there any drawback of using my method."

As i have this table "Registered Users" and its class that will handle all the information about the user.

Thanks in advance if any one can answer.

Cause i m confused about my using wether my own structures, Methods and classes OR just to use the ASPMembershipProvider for the user login and registration.

WTF | :WTF:

Re: Can i use my own User Registartion Information Class with ASP .NET Login controls

Abhishek Sur2-Mar-09 3:55

Abhishek Sur

2-Mar-09 3:55

Yes ... no problem with that ... We generally use own custom database for Registered user and dont use ASPMembershipProviders.

Rather it is better to create a Web Interface for login, probably you can use Web service for login if you want Rose | [Rose]

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Error occuring while developin with ASP.NET

VeeKeyBee2-Mar-09 1:46

VeeKeyBee

2-Mar-09 1:46

I got this error during debugging the code without using an IIS or webserver. I got two errors ,
1.
Line 105:<compilers>
Line 106:<compiler language="c#;cs;csharp" extension=".cs" warninglevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
Line 107:<provideroption name="CompilerVersion" value="v3.5">
Line 108:<provideroption name="WarnAsError" value="false">
Line 109:
--the bolded session will have the error.

2. child notes not allowed.

Help me please!

Re: Error occuring while developin with ASP.NET

Vimalsoft(Pty) Ltd2-Mar-09 1:54

Vimalsoft(Pty) Ltd

2-Mar-09 1:54

Really you have not Specified your Problem.

Tell us what were you trying to do before the Error occurred. and post us the Error the way it appears

Import data from Excel sheet to sql Database-asp.net 2.0

Member 46590012-Mar-09 1:26

Member 4659001

2-Mar-09 1:26

Currently I need to write a code To Import data from Excel sheet to sql Database-asp.net 2.0

I Have Written A function For It
Function Is Given Below ;
But as i execute it it gives Error Meaasge
"The Microsoft Jet database engine cannot open the file 'D:\'. It is already opened exclusively by another user, or you need permission to view its data."

I Have Order.xls File In D Drive

protected void btnUpload_Click1(object sender, EventArgs e)
{
string PathtoTextFile = ("D:\\");
Response.Write(PathtoTextFile);
System.Data.OleDb.OleDbConnection oCon = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\;Extended Properties= \"Excel 8.0;HDR=no;IMEX=1 \"");
System.Data.OleDb.OleDbDataAdapter oCmd = new System.Data.OleDb.OleDbDataAdapter("select * from Order.xls", oCon);

DataSet myDS = new DataSet();
oCmd.Fill(myDS);

oCon.Close();

}

Raghvendra

Re: Import data from Excel sheet to sql Database-asp.net 2.0

Greg Chelstowski2-Mar-09 1:34

Greg Chelstowski

2-Mar-09 1:34

You need to pass the filename in the data source, in the connection string, dude.
You're on the right path, though.
And then, the sql you wrote ("select * from Order.xls") should really be ("select * from Sheet1"), or whatever your Sheet is called in that excel spreadsheet.
The rest seems fine... Except I would use a DataTable, and not a DataSet.
Easier that way Wink | ;)

var question = (_2b || !(_2b));

Re: Import data from Excel sheet to sql Database-asp.net 2.0

Member 46590012-Mar-09 18:09

Member 4659001

2-Mar-09 18:09

Thanks For Reply,
I did the same as u instructed ,
But Still Having Same Error

Raghvendra

Method?

Karthick_gc2-Mar-09 1:05

Karthick_gc

2-Mar-09 1:05

I declare a variable in one method and used it. Now i want to access the variable from another method. Can anyone say how to acheive this?

Re: Method?

Gaurav K Singh2-Mar-09 1:13

Gaurav K Singh

2-Mar-09 1:13

Variable within the method is private for that method. if you want to access one variable in more than one mthod, declase as private/public in the class.

The miracle is this--the more we share, the more we have.

Re: Method?

Karthick_gc2-Mar-09 1:23

Karthick_gc

2-Mar-09 1:23

Can u explain briefly?

Re: Method?

mr_muskurahat2-Mar-09 1:26

mr_muskurahat

2-Mar-09 1:26

public string abc;

public void function function1()
{

abc="anything";

}

public void function function2()
{

string def =abc;

}

function1();
function2();

or you can also pass it as a parameter...

umerumerumer

How to export data from datagrid to .mdb format

ballameharmurali2-Mar-09 0:21

ballameharmurali

2-Mar-09 0:21

Hi all,
Can anybody tell how to export data from datagrid to .mdb format(i.e into Access format).If possible please let me know the code.
thanks
Murali

Re: How to export data from datagrid to .mdb format

Greg Chelstowski2-Mar-09 0:48

Greg Chelstowski

2-Mar-09 0:48

Read up on the JET engine, please.
And stop posting the same question over and over again.
The JET engine will allow you to create a new ACCESS database (among other formats) and populate it with whatever you want. It is really easy to use, but:
you haven't posted a single line of code. Don't assume people are waiting to write stuff for you, look it up yourself! And even if they do, how can anybody assume, what you get will be comprehensible by you.
Good luck in your research.

var question = (_2b || !(_2b));

Last Visit: 31-Dec-99 18:00 Last Update: 28-Apr-24 13:55

Refresh

ᐊ Prev 1...2262 2263 2264 226522662267 2268 2269 2270 2271 Next ᐅ

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