ASP.NET

Vuyiswa Maseko wrote:

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

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

/*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);
    }
}

protected void Page_Load(object sender, EventArgs e)
  {

      Session["ActiveDatabase"] = "Mafutha";

      UpdateConfig();

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


  }

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");
        }

}

if(System.IO.File.Exists(strPath))
{
System.IO.File.Delete(strPath);
}
else
{ 
  //Save................................
}