If I have 4 Connection Strings In Web.Config And Switch Betweeen Them In Code Behind as per check in checkboxList?

Question

0.00/5 (No votes)

See more:

SQL

i am face one problem hope you help me
I am 4 connection string in Web.Config And Switch Betweeen Them In Code Behind as per check selected in checkboxList?

please let me know how can i use it 
Web.Config

C#

<connectionStrings>
 <add name="mysql" connectionString="Server=localhost;database=arjun;user id=root;password=root;" />
    <add name="mysql1" connectionString="Server=localhost;database=bsales;user id=root;password=root;" />
    <add name="mysql2" connectionString="Server=localhost;database=hr;user id=root;password=root;" />
</connectionStrings>
 

protected void CheckBoxList3_SelectedIndexChanged(object sender, EventArgs e)
    {
 
        foreach (ConnectionStringSettings c in System.Configuration.ConfigurationManager.ConnectionStrings)
        {
            string Name = c.Name;
            string connString = c.ConnectionString;
            string provider = c.ProviderName;
        
        }
        MySqlConnection myconn = new MySqlConnection(strmysqlcon2);
        MySqlConnection myconn1 = new MySqlConnection(strmysqlcon8);
        string str = string.Empty;
        DataSet ds2 = new DataSet();
       
        foreach (ListItem li in CheckBoxList2.Items)
        {
            if (li.Selected)
            {
                myconn.Open();
                str = li.ToString();
                string query = "show COLUMNS from " + str + "";
                MySqlDataAdapter mydata = new MySqlDataAdapter(query, myconn);
 
                mydata.Fill(ds2, str);
                myconn.Close();
            }
            int p = 0;
            foreach (DataTable dt in ds2.Tables)
            {
                if (p == 0)
                {
                    TableCheckBoxList3.DataSource = ds2.Tables[0];
                    TableCheckBoxList3.DataTextField = "Field";
                    TableCheckBoxList3.DataValueField = "Field";
                    TableCheckBoxList3.DataBind();
 
                }
                if (p == 1)
                {
 
                    CheckFromTable3.DataSource = ds2.Tables[1];
                    CheckFromTable3.DataTextField = "Field";
                    CheckFromTable3.DataValueField = "Field";
                    CheckFromTable3.DataBind();
                }
                p++;
 
            }
 
        }
    }

ASP.NET

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DropDownList.aspx.cs" Inherits="DropDownList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head  runat="server">
    <title></title>
</head>
<body>
    <form id="form1"  runat="server">
    <div>
        <asp:DropDownList ID="DropDownList3" runat="server" OnSelectedIndexChanged="DropDownList3_SelectedIndexChanged"
            AutoPostBack="True">
            <asp:ListItem Selected="True">FoxPro
            <asp:ListItem>MySQL
            <asp:ListItem>Data3

    </div>
    <div>
        <asp:CheckBoxList ID="CheckBoxList1" runat="server" DataTextField="" DataValueField=""
            OnSelectedIndexChanged="CheckBoxList1_SelectedIndexChanged">

    </div>
    <div>
        <table>
            <tr>
                <td>
                    <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
                    <asp:Button ID="Button2" runat="server" Text="Button" OnClick="Button2_Click" />
                    <asp:Button ID="Button3" runat="server" Text="Button" OnClick="Button3_Click" />
                </td>

            </tr>
        </table>
    </div>
    <div>
        <table>
            <tr>
            <td>
                    <asp:CheckBoxList ID="CheckBoxList2" runat="server" AutoPostBack="True" OnSelectedIndexChanged="CheckBoxList2_SelectedIndexChanged">

                </td>
                <td>
                    <asp:CheckBoxList ID="CheckBoxList3" runat="server"
                        onselectedindexchanged="CheckBoxList3_SelectedIndexChanged"
                        AutoPostBack="True">

                </td>
                </tr>
                <tr>
                <td>
                    <asp:CheckBoxList ID="TableCheckBoxList" runat="server">

                </td>
                <td><asp:CheckBoxList ID="CheckFromTable" runat="server">
                        </td>
                        <td><asp:CheckBoxList ID="TableCheckBoxList3" runat="server">
                        </td>
                        <td><asp:CheckBoxList ID="CheckFromTable3" runat="server">
                        </td>
            </tr>
            <tr>
                <td>
                    <asp:DropDownList ID="Dropdownlist1" runat="server">

                    </td>

            </tr>
        </table>
    </div>
    </form>
</body>
</html>

Posted 15-Jan-14 19:29pm

Arjunwalmiki

Updated 15-Jan-14 23:02pm

Karthik_Mahalingam

v2

Add a Solution

Comments

Rajkumar_Blr 16-Jan-14 1:33am

I think you should use *Radio Button*(single selection allowed) and not checkbox(multiple selection allowed)

Arjunwalmiki 16-Jan-14 1:41am

Rajkumar Thank you for reply
i want to select single connectionStrings when user check in checkboxlist.

Karthik_Mahalingam 16-Jan-14 2:04am

what issue you r facing >?

Arjunwalmiki 16-Jan-14 2:15am

Hi Karthik

i am not get right connection from connection String when user select database table from checkBoxList

Karthik_Mahalingam 16-Jan-14 3:17am

post your aspx code for checkbox list

Arjunwalmiki 16-Jan-14 3:28am

ASPX:-

<td>
<asp:CheckBoxList ID="CheckBoxList3" runat="server"
onselectedindexchanged="CheckBoxList3_SelectedIndexChanged"
AutoPostBack="True">

</td>

Karthik_Mahalingam 16-Jan-14 3:42am

what is CheckBoxList2
TableCheckBoxList3
CheckFromTable3 ??

Arjunwalmiki 16-Jan-14 4:46am

all are checkboxList Name

Arjunwalmiki 16-Jan-14 4:47am

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DropDownList.aspx.cs" Inherits="DropDownList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList3" runat="server" OnSelectedIndexChanged="DropDownList3_SelectedIndexChanged"
AutoPostBack="True">
<asp:ListItem Selected="True">FoxPro
<asp:ListItem>MySQL
<asp:ListItem>Data3

</div>
<div>
<asp:CheckBoxList ID="CheckBoxList1" runat="server" DataTextField="" DataValueField=""
OnSelectedIndexChanged="CheckBoxList1_SelectedIndexChanged">

</div>
<div>
<table>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="Button" OnClick="Button2_Click" />
<asp:Button ID="Button3" runat="server" Text="Button" OnClick="Button3_Click" />
</td>

</tr>
</table>
</div>
<div>
<table>
<tr>
<td>
<asp:CheckBoxList ID="CheckBoxList2" runat="server" AutoPostBack="True" OnSelectedIndexChanged="CheckBoxList2_SelectedIndexChanged">

</td>
<td>
<asp:CheckBoxList ID="CheckBoxList3" runat="server"
onselectedindexchanged="CheckBoxList3_SelectedIndexChanged"
AutoPostBack="True">

</td>
</tr>
<tr>
<td>
<asp:CheckBoxList ID="TableCheckBoxList" runat="server">

</td>
<td><asp:CheckBoxList ID="CheckFromTable" runat="server">
</td>
<td><asp:CheckBoxList ID="TableCheckBoxList3" runat="server">
</td>
<td><asp:CheckBoxList ID="CheckFromTable3" runat="server">
</td>
</tr>
<tr>
<td>
<asp:DropDownList ID="Dropdownlist1" runat="server">

</td>

</tr>
</table>
</div>
</form>
</body>
</html>
This is my aspx file

Karthik_Mahalingam 16-Jan-14 5:10am

y u have messed up your code...
can u pls give me your exact requirement , so that i can focus on that. its too messy..

Arjunwalmiki 16-Jan-14 5:26am

thanks for reply know my requirement if you have 1)i am bind CheckBoxList1 from all database from mysql server.My query know i want to check on CheckBoxList(CheckBoxList1)and want to bind new checkboxList as per check.But issue is when i am check on checkboxlist1 how can i get correct string name from web.config file as per selected item in checkboxList.

Karthik_Mahalingam 16-Jan-14 5:32am

y do u want to use checkbox list , u need to use 3 database at a time?/
you can use radio button list instead. so that only one db is selected..safe...

Arjunwalmiki 16-Jan-14 5:34am

y do u want to use checkbox list , u need to use 3 database at a time? y you right that is my query how can i use.

Arjunwalmiki 16-Jan-14 5:36am

i want to use 3 or 2 database as per check and want to bind new checkboxList.

D-Kishore 16-Jan-14 5:20am

Hi,
in the below code you are calling strmysqlcon2 and strmysqlcon8, I have a doubt where you declared these strings and assigning.
MySqlConnection myconn = new MySqlConnection(strmysqlcon2);
MySqlConnection myconn1 = new MySqlConnection(strmysqlcon8);

Arjunwalmiki 16-Jan-14 5:31am

Hello D-Kishore your right (but i have total 5 string just like this,Know my problem is how can i use it in code-behind as per checkboxlist selected)

D-Kishore 16-Jan-14 6:14am

What i understood here is your CheckBoxList3 contains with all 5 connections strings with checkboxes, here if you select first check box you want access first connection string or if you select 2nd check box you want access second connection string.

If i am right tell me one thing, are you allowing multi selection from CheckBoxList3.
If not check CheckBoxList3.selecteditem or index==0 fire 1st connection string if it is==1 fire 2nd connection string.

Arjunwalmiki 16-Jan-14 6:33am

Yes i am allowing multiple selection option from CheckBoxList1(all database list bind in CheckBoxList1)know you tell me how can handle.

1 solution

Add a Solution

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

Rajkumar_Blr · Answer 1 · 2014-01-15T19:48:00

Solution 1

you can use something like below code,

C#

            CheckBoxList1.Items.Add("mysql1");
            CheckBoxList1.Items.Add("mysql2");
            CheckBoxList1.Items.Add("mysql3");
            .....
            .....

            string conne=CheckBoxList1.SelectedItem.Text
 
            //Connect to database
            .....

           
Note: Here your CheckBoxList1 items name should match with your connectionstring name(mysql)

1,mysql2

Posted 15-Jan-14 19:48pm

Rajkumar_Blr

Updated 15-Jan-14 19:59pm

v3

Comments

Arjunwalmiki 16-Jan-14 2:05am

Hi Rajkumar thank you for prompt reply and you valuable time

I am already code inside the CheckBoxList3_SelectedIndexChanged and in the below code i am able to get correct data but my connection string is hard-coded but i want to handle dynamically.So pls let me know.
string strmysqlcon3 = ConfigurationManager.ConnectionStrings["mysql"].ConnectionString;
protected void CheckBoxList3_SelectedIndexChanged(object sender, EventArgs e)
{
MySqlConnection myconn = new MySqlConnection(strmysqlcon3);
string str = string.Empty;
DataSet ds1 = new DataSet();
foreach (ListItem li in CheckBoxList3.Items)
{
if (li.Selected)
{
myconn.Open();
str = li.ToString();
string query = "show COLUMNS from " + str + "";
MySqlDataAdapter mydata = new MySqlDataAdapter(query, myconn);

mydata.Fill(ds2,str);
myconn.Close();
}
int p = 0;
foreach (DataTable dt in ds2.Tables)
{
if (p == 0)
{TableCheckBoxList3.DataSource = ds2.Tables[0];
TableCheckBoxList3.DataTextField = "Field";
TableCheckBoxList3.DataValueField = "Field";
TableCheckBoxList3.DataBind();

}
if (p == 1)
{

CheckFromTable3.DataSource = ds2.Tables[1];
CheckFromTable3.DataTextField = "Field";
CheckFromTable3.DataValueField = "Field";
CheckFromTable3.DataBind();
}
p++;

}

}

}

Rajkumar_Blr 16-Jan-14 2:15am

The below is my understanding of the probelm,

strmysqlcon3 - is a connection string(You are already retrieving from the config section dynamically ) and
CheckBoxList3.Items contains list of table in the database.

So what are you expecting?

Arjunwalmiki 16-Jan-14 3:31am

if you seen in the code i am connecting with database name "arjun"(

Arjunwalmiki 16-Jan-14 3:37am

if you seen in the code i am connecting with database name "arjun"(<add name="mysql" connectionstring="Server=localhost;database=arjun;user id=root;) but is user select database name " bsales="(<add name=" mysql1=" connectionString=" server="localhost;database=bsales;user" id="root;)" or="" database="hr">

If I have 4 Connection Strings In Web.Config And Switch Betweeen Them In Code Behind as per check in checkboxList?

1 solution

Solution 1

Add your solution here

Preview 0

If I have 4 Connection Strings In Web.Config And Switch Betweeen Them In Code Behind as per check in checkboxList?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us