Create GlobalVariable and use it in another button click event

Question

0.00/5 (No votes)

See more:

Dear All i want how to Create GlobalVariable and save my database name in this variable for use reference anywhere in page.
My code are as below in this code every thing is perfect but not define GlobalVariable if you people know pls help me it is very urgent

C#

protected void Button3_Click(object sender, EventArgs e)
    {
        string str = string.Empty;
        DataSet ds = new DataSet();
        string db = "";

        foreach (ListItem li in CheckBoxList1.Items)
        {
            if (li.Selected)
            {
                if (CheckBoxList1.SelectedIndex != 0)
                {
                    if (CheckBoxList1.SelectedItem.Value == "arjun")
                    {
                        db = "arjun";

                    }
                    if (CheckBoxList1.SelectedItem.Value == "bsales")
                    {
                        db = "bsales";
                    }
                    if (CheckBoxList1.SelectedItem.Value == "hr")
                    {
                        db = "hr";
                    }
                    if (CheckBoxList1.SelectedItem.Value == "information_schema")
                    {
                        db = "information_schema";
                    }
                    if (CheckBoxList1.SelectedItem.Value == "intall")
                    {
                        db = "intall";
                    }
                    if (CheckBoxList1.SelectedItem.Value == "messages")
                    {
                        db = "messages";
                    }
                    if(CheckBoxList1.SelectedItem.Value=="mysql")
                    {
                        db = "mysql";
                    }
                    if (CheckBoxList1.SelectedItem.Value == "sales")
                    {
                        db = "sales";
                    }
                
                }
                string abc = "Data Source=localhost;Initial Catalog=" + db + ";user id=root;password=root";
               
                MySqlConnection myconn = new MySqlConnection(abc);
                myconn.Open();
                str = li.ToString();
                string query = "show tables from " + str + "";
                MySqlDataAdapter mydata = new MySqlDataAdapter(query, myconn);             
                mydata.Fill(ds, str);              
                myconn.Close();
                
                
            }

            int k = 0;
            foreach (DataTable dt in ds.Tables)
            {
                if (k == 0)
                {
                    CheckBoxList2.DataSource = ds.Tables[0];
                    CheckBoxList2.DataTextField = "tables_in_" + ds.Tables[0].TableName + "";
                    CheckBoxList2.DataValueField = "tables_in_" + ds.Tables[0].TableName + "";
                    CheckBoxList2.DataBind();
                }
                if (k == 1)
                {
                    CheckBoxList3.DataSource = ds.Tables[1];
                    CheckBoxList3.DataTextField = "tables_in_" + ds.Tables[1].TableName + "";
                    CheckBoxList3.DataValueField = "tables_in_" + ds.Tables[1].TableName + "";
                    CheckBoxList3.DataBind();
                }
                k++;
            }
        }   
    }

Posted 23-Jan-14 0:36am

Arjunwalmiki

Updated 23-Jan-14 0:59am

v2

Add a Solution

Comments

BillWoodruff 23-Jan-14 11:30am

Your code puzzles me: If there can only be one string stored in the 'db variable, why are you even using a CheckedListBox which ... even if SelectionMode is set to 'One ... allows multiple CheckBoxes to be checked ?

If SelectionMode is 'One, then SelectedIndex will always have a value of one of the CheckedListBox Items, unless there's no selection, in which case its value is -1.

Why are you iterating over CheckedListBox1, and testing every Item, when to get the SelectedIndex you only need to write: CheckBoxList1.SelectedIndex ?

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Answer 1 · 2014-01-23T00:49:00

try thiss. :)

HTML

If you create a variable inside the event of the session_start() method, it will only be available inside that method.

If you store a value in application or session state, those are accessible throughout your whole application. For example:

C#

string myAppTitle = (string)Application["appTitle"]'

reference.. :)

Application Variables[^]

Salman622 · Answer 2 · 2014-01-23T00:56:00

Solution 2

C#

public partial class ClassName : System.Web.UI.Page
{
  string str="";//global  You can assign a value to this variable anywhere on the page

  //other Events.....
}

Posted 23-Jan-14 0:56am

Salman622

Comments

Arjunwalmiki 23-Jan-14 7:06am

Salman can you seen my code how can i do batter way please let me know

Salman622 23-Jan-14 7:10am

do you want to retrive that value on the same page or some other page

Salman622 23-Jan-14 7:14am

below karthik has given a nice solution
to use class

Arjunwalmiki 24-Jan-14 0:51am

yes salman thank you i am follow the karthik

Karthik_Mahalingam · Answer 3 · 2014-01-23T00:58:00

Solution 3

Create a class and have a static Read only property like

C#

public class GlobalClass
{    public static string ConnectionString { get { return "Your connection string" // you can read form config also..
 } }
}

and in the all pages you can access like this

C#

string conn = GlobalClass.ConnectionString;

updated based on comments:

C#

public class GlobalClass
{

    public static Dictionary<string, string> ConnectionString
    {
        get
        { 
            Dictionary<string, string> dict = new Dictionary<string, string>();
            dict.Add("Con1", "Your connection string 1");
            dict.Add("Con2", "Your connection string 2");
            dict.Add("Con3", "Your connection string 3");
            dict.Add("Con4", "Your connection string 4");
            return dict;
        }
    }
}

and you can access it as

C#

string con1 = GlobalClass.ConnectionString["Con1"];
       string con2 = GlobalClass.ConnectionString["Con2"];
       string con3 = GlobalClass.ConnectionString["Con3"];
       string con4 = GlobalClass.ConnectionString["Con4"];

Posted 23-Jan-14 0:58am

Karthik_Mahalingam

Updated 23-Jan-14 2:10am

v2

Comments

Arjunwalmiki 23-Jan-14 7:20am

public class GlobalClass
{ public static string ConnectionString { get
{ return "Data Source=localhost;Initial Catalog=arjun;user id=root;password=root";
"Data Source=localhost;Initial Catalog=hr;user id=root;password=root";
"Data Source=localhost;Initial Catalog=bsales;user id=root;password=root";
} }
}

Karthik it is working fine but if i am using 5 database how can handle it

Karthik_Mahalingam 23-Jan-14 8:04am

you can use list or dictionary then...

Karthik_Mahalingam 23-Jan-14 8:10am

check my updated solution..

Arjunwalmiki 24-Jan-14 0:48am

Hi Karthik gm

This is my code :-

protected void Button1_Click(object sender, EventArgs e)
{
string str = string.Empty;
DataSet ds1 = new DataSet();
string con1 = GlobalClass.ConnectionString["Con1"];
string con2 = GlobalClass.ConnectionString["Con2"];
string con3 = GlobalClass.ConnectionString["Con3"];
string con4 = GlobalClass.ConnectionString["Con4"];
foreach (ListItem li in CheckBoxList2.Items)
{
if (li.Selected)
{
MySqlConnection myconn3 = new MySqlConnection(con1);

myconn3.Open();
str = li.ToString();
string query = "show COLUMNS from " + str + "";
MySqlDataAdapter mydata = new MySqlDataAdapter(query, myconn3);
mydata.Fill(ds1,str);
myconn3.Close();
}
int a = 0;
foreach (DataTable dt in ds1.Tables)
{
if (a == 0)
{
TableCheckBoxList.DataSource = ds1.Tables[0];
TableCheckBoxList.DataTextField = "Field" ;
TableCheckBoxList.DataValueField = "Field";
TableCheckBoxList.DataBind();
}
if (a == 1)
{

CheckFromTable.DataSource = ds1.Tables[1];
CheckFromTable.DataTextField = "Field";
CheckFromTable.DataValueField = "Field";
CheckFromTable.DataBind();
}
a++;
}

}
}
my code only get one database table i want both database table in new checkboxlist

Karthik_Mahalingam 24-Jan-14 1:01am

you want to merge it ?

Arjunwalmiki 24-Jan-14 2:09am

foreach (ListItem li in CheckBoxList2.Items) { if (li.Selected) in this foreach i am found table name so i want to use connection string as per table selected for e.g table came arjun and batabase in string Con2 so how can get it as per table than my query fire select * from DbName.Table name

Karthik_Mahalingam 24-Jan-14 3:22am

map it accordingly.

Arjunwalmiki 24-Jan-14 3:50am

Karthik that way i need to mydata.Fill(ds, str); store ds in globale variable than i can use it any where in the same page

Karthik_Mahalingam 24-Jan-14 3:57am

Hi Arjun
Pls dont mix the topics,
if this isssue is resolved, pls close this post and
post a new question . Its confusing...
moreover its not clear only..

Arjunwalmiki 24-Jan-14 4:32am

Dear Karthik i am not mix any thing i am using multiple checkboList in our project 1) Checkboxlist bind from MYServer(in ist list iam able to seen all batabase list in checkboxlist)

if use select 2 database from the same so new 2 checkboxlist bind with each batabase table.

know use check one table from checkboxlist and query fire select * from databaseName.TableName;

so my question how can handle it you must create globaleVariable and must be save database in side it and second table name also want to save in globalevariable than you able to fire select * from globlevaribaledatabaseName.globlevaribaleTableName; that is my logic if i am wron correct me and pls help me i am stuck

Karthik_Mahalingam 24-Jan-14 4:36am

at a time you will use single Database and Single Table only ??
if so, then use Radio button list instead of checkbox list ....

Create GlobalVariable and use it in another button click event

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Create GlobalVariable and use it in another button click event

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us