Select sqldasource query from dropdownlist

Question

I have a grid which has a dasource selected sqlDataSource2. I have not built any query in the datasource. I have a dropdownlist with two items and I would like to select the query from the dropdownlist and after selection of the query update the grid to show the result. This is what I have tried so far:

protected void Page_Load(object sender, EventArgs e)
{
    Query1();
}

 protected void Query1()
{
    //if (this.IsPostBack)
 {
   SqlConnection conn = new SqlConnection();
    conn.ConnectionString = ConfigurationManager.ConnectionStrings["PMIcommConnectionString"].ConnectionString;
    SqlDataSource2.SelectCommand = @"SELECT YEAR(custDecDate), SUM(valueXX), SUM(valueYY)
                                     FROM bids
                                    WHERE forBid ='"+ DropDownList3.SelectedValue +"'GROUP BY YEAR(custDecDate)'";
    SqlDataSource2.DataBind();
    RadGrid1.DataBind();
 }
}

This is my connection string:

<add name="PMIcommConnectionString" connectionString="Data
Source=WIN-72PL3253COR\SQLEXPRESS;Initial Catalog=PMIcomm;Integrated
Security=True" providerName="System.Data.SqlClient" />

I get an error "Connection string has not been initialized" on the last line. How can I make this working? Beside the error I am getting, I am not sure if this is the correct way to do this. Sorry for asking such simple thing, I am a selflearning beginner.

use var string = ConfigurationManager.ConnectionStrings["PMIcommConnectionString"].ConnectionString; — Neel
– Neel, Commented Apr 3, 2014 at 9:48
Can you show how you have specified your connectionstring in web.config? — RKS
– RKS, Commented Apr 3, 2014 at 9:50
@Nullbyte: You have specified this within <connectionString>. Just follow the answer provided by Neel. That is correct. — RKS
– RKS, Commented Apr 3, 2014 at 9:57

Neel · Accepted Answer · 2014-04-03 09:51:06Z

1

The connection string is not in AppSettings.

What you're looking for is in:

SqlConnection conn = new SqlConnection();

conn.ConnectionString = ConfigurationManager.ConnectionStrings["PMIcommConnectionString"].ConnectionStri‌ng;

answered Apr 3, 2014 at 9:51

Neel

11.7k3 gold badges46 silver badges63 bronze badges

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

3 Comments

Nullbyte Over a year ago

I have update my question with the code as it is now after your answer. But I still have the same problem.

Neel Over a year ago

what exact error you are getting and at which step after the change @Nullbyte

Neel Over a year ago

hey btw I have just given the example I mean I have just noticed you have placed exact code in your code..just make neccessory changes instead of putting exact code @Nullbyte

RGS · Accepted Answer · 2014-04-03 10:05:03Z

1

Web.config:

 <connectionStrings>
    <add name="PMIcommConnectionString" connectionString="Data
    Source=WIN-72PL3253COR\SQLEXPRESS;Initial Catalog=PMIcomm;Integrated
    Security=True"/>
 </connectionStrings>

Code Behind .cs:

using System.Configuration;
using System.Data.SqlClient;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PMIcommConnectionString"].ConnectionString);

answered Apr 3, 2014 at 10:05

RGS

5,2217 gold badges44 silver badges69 bronze badges

Collectives™ on Stack Overflow

Select sqldasource query from dropdownlist

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related