DropDownList with Two SqlDataSources

Question

I have a single dropdownlist with EnableAutoPostBack and two SqlDataSources.

What I am trying to do is if user chooses radiobuttonRed then the DDLType will use SqlDataSourceRed and display data into a gridview depending on DDLTYpe item selected.

If the user chooses radiobuttonBlue then the DDLType will use SqlDataSourceBlue and display the data into a gridview depending on DDLTYpe item selected.

How can I achieve this?

Cameron Tinker · Accepted Answer · 2013-06-21 18:13:40Z

2

You would need two SqlConnection objects with connection strings to each database:

SqlConnection connRed = new SqlConnection();
SqlConnection connBlue = new SqlConnection();
DataTable dt = null;
SqlDataAdapter da = null;

if(radioButtonRed.Checked)
{
    dt = new DataTable();
    da = new SqlDataAdapter("select command", connRed);   
}
else
{    
    dt = new DataTable();
    da = new SqlDataAdapter("select command", connBlue);
}

da.Fill(dt);
dgv.DataSource = dt;
dgv.DataBind();

edited Jun 21, 2013 at 18:13

answered Jun 21, 2013 at 17:54

Cameron Tinker

9,83710 gold badges49 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Apollo Over a year ago

The problem here is that you are using two Gridviews. I want to use one gridview, is it possible?

Cameron Tinker Over a year ago

I've updated my answer to use one DataGridView and Fill the DataTable appropriately.

Apollo Over a year ago

DataTable dt = null; SqlDataAdapter da = null; should i do this is giving an error since they are not used

nocturns2 Over a year ago

you might want to finish it off with: dgv.databind

Cameron Tinker Over a year ago

@nocturns2 Thanks for pointing that out. I had forgotten to call DataBind() since I forgot this was ASP.NET and not Windows Forms. In Windows Forms, it's not explicitly needed to call DataBind().

|

Collectives™ on Stack Overflow

DropDownList with Two SqlDataSources

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related