How to Access Drop down list value into a GridView select query

Question

0.00/5 (No votes)

See more:

I have a Drop down list given below

ASP.NET

<asp:DropDownList ID="ddlExamId" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlExamId_SelectedIndexChanged">
</asp:DropDownList>

it have some value like "1","2" etc. I also use a Grid View to show my database value. Under the Grid View SelectCommand I want to select those data that have examId=ddlExamId.Text. Here is my SelectCommend.

ASP.NET

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BBAConnectionString1 %>" 
             SelectCommand="SELECT [Id], [tchId], [stdId], [dept], [subject], [courseCode], [quizNum], [examId], [examDate], [gainMark] FROM [quizResult] where examId= 
"<%# this.ddlExamId.Text;%>" />

But this provide me an Error like this
Parser Error Message: The server tag is not well formed.
what should I do. Please help me. I am new in ASP and my English is also week.

Posted 19-Aug-13 1:50am

sazzad37

Updated 19-Aug-13 2:20am

Thanks7872

v2

Add a Solution

Comments

Thanks7872 19-Aug-13 8:19am

One way is to remove this DataSource and bind your GridView in code. If you want so or comfortable with,let me know.

3 solutions

Solution 1

try using this

ASP.NET

<asp:SqlDataSource ID="Programs_DropdownList" runat="server" ConnectionString="<%$ ConnectionStrings:admConnectionString %>" ProviderName="<%$ ConnectionStrings:admConnectionString.ProviderName %>" 
SelectCommand="SELECT PROGRAM_ID, PROGRAM_NAME FROM PROGRAMS WHERE DEGREE_ID = @DEGREE_ID"><SelectParameters>
<asp:ControlParameter Name="DEGREE_ID" ControlID="Degree_DList" PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>

in the place of degree id replace your parameter

Posted 19-Aug-13 1:57am

Member 9762654

Updated 19-Aug-13 2:17am

v4

Comments

sazzad37 19-Aug-13 7:58am

I was try but not work.

sazzad37 19-Aug-13 8:02am

My main problem is, I can not access ddlExamId by this code "<%# this.ddlExamId.Text;%>" . what should I do?

Solution 2

Enclose "<%# this.ddlExamId.Text;%>" with single quotation marks as mentioned below :

HTML

'<%# this.ddlExamId.Text;%>'

Posted 19-Aug-13 2:18am

CodeBlack

Comments

sazzad37 19-Aug-13 8:36am

No error but can not access ddlExamId value.

CodeBlack 19-Aug-13 8:53am

instead of this.ddlExamId.Text use this.ddlExamId.SelectedItem.Text and still it doesnt work than check whether query results data or not ?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

sazzad37 · Accepted Answer · 2013-08-27T23:34:00

I have solve this in different way.

C#

protected void FillDdlSession()
{
    SqlCommand cmd = new SqlCommand("SELECT DISTINCT session FROM quizResult ORDER BY session ASC", vcon);
    SqlDataAdapter adp = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    adp.Fill(dt);
    ddlSession.DataSource = dt;
    ddlSession.DataTextField = "session";
    ddlSession.DataValueField = "session";
    ddlSession.DataBind();
    ddlSession.Items.Insert(0, "Choose Session");
}

How to Access Drop down list value into a GridView select query

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us