Bind a gridview by passing session in where clause

Question

0.00/5 (No votes)

See more:

C#

Session["que"] = lb.Text;
            Response.Redirect("DisplayAnswer.aspx");

and in DisplayAnswer.aspx file...

XML

<asp:GridView ID="GridView1" runat="server" OnDataBound="GridView1_DataBound">
        </asp:GridView>

and DisplayAnswer.aspx.cs file...

C#

protected void Page_Load(object sender, EventArgs e)
   {
<pre lang="cs">String conn = "Data Source=localhost;Database= forum;User ID=root;Password=rachana;Allow User Variables=True";

       MySqlConnection con = new MySqlConnection(conn);
       try
       {
           con.Open();
           MySqlCommand md = new MySqlCommand("select answer,userid,date from thread where forumid='"+Session["idq"].ToString()+"' ", con);
            MySqlDataAdapter ada = new MySqlDataAdapter(md);
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            ada.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
<pre lang="cs">}
        catch (Exception ex)
        { }

    }

.............
here i have tried to get Session value of que from lable and redirected to DisplayAnswer.aspx page...on this page i want to select only data where question is Session["que"] which i have added to where clause in select command..it is not giving me any error but also not binding the gridview. it displays nothing..how to bind gridview using session values in where clause??
please explain...
thanx...

Posted 21-Apr-13 11:46am

Member 9586157

Updated 21-Apr-13 13:56pm

Dave Kreskowiak

v2

Add a Solution

Comments

[no name] 21-Apr-13 19:09pm

Session["idq"].ToString()...where question is Session["que"]... typo?

2 solutions

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)

_Amy · Answer 1 · 2013-04-21T16:56:00

This means that query is executing successfully in database but not returning any rows. Your session value might be giving Empty String. Put a breakpoint and check for the session value. Try Like this:

C#

if(Session["idq"]!= "")
{
    con.Open();
    MySqlCommand md = new MySqlCommand("select answer,userid,date from thread where forumid='"+Session["idq"].ToString()+"' ", con);
    MySqlDataAdapter ada = new MySqlDataAdapter(md);
    DataSet ds = new DataSet();
    DataTable dt = new DataTable();
    ada.Fill(dt);
    GridView1.DataSource = dt;
    GridView1.DataBind();
}
else
{
    //Your session is empty. Show the message here.
}

Before using the session value you should always check for its existence. Check whether Session["idq"] is null or not before using it.

--Amit

RelicV · Answer 2 · 2013-04-21T20:37:00

Solution 2

Hi Member 9586157,

Also, if the column 'forumid' in your DB is an integer type, then the single quotes in the query

SQL

forumid='"+Session["idq"].ToString()+"'

is not required.

Just set it as

SQL

forumid="+Session["idq"].ToString()+"

Thank you,
Vamsi

Posted 21-Apr-13 20:37pm

RelicV

Comments

Chanthol Khom 10-Nov-13 20:48pm

hello, i am a new to asp.net. i want to know,
how can i store a whole gridview in session?