Solved

Pass Session Variables to SQL Query to GridView

Posted on 2011-09-07
4
468 Views
Last Modified: 2012-05-12
Experts,

Having some difficulties with this. I am passing session variables from 3 dropdownlists on one page to another page. On the 2nd page, I am grabbing the variables  and trying to use them in a SQL Query to return results to a GridView. Could really use some help on this.


public partial class results : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["MyConnect"].ConnectionString);
        protected void Page_Load(object sender, EventArgs e)
        {
            
                string ssState = (string)(Session["ssState"]);
                string ssCity = (string)(Session["ssCity"]);                
                string ssType = (string)(Session["ssType"]);

                con.Open();
                SqlCommand com = new SqlCommand("SELECT * FROM dbo.tbl_Property WHERE Prop_State=@ssState AND Prop_City=@ssCity AND Prop_Type=@ssType", con);
                com.Parameters.AddWithValue("@ssState", ssState);
                com.Parameters.AddWithValue("@ssCity", ssCity);                
                com.Parameters.AddWithValue("@ssType", ssType);

                SqlDataAdapter myAdapter = new SqlDataAdapter(com);
                DataSet dSet = new DataSet();
                myAdapter.Fill(dSet);   

                
                
                myGrid.DataSource = dSet;
                myGrid.DataBind();

                con.Close();
            
        }
    }

Open in new window

0
Comment
Question by:Shaggy1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
strickdd earned 500 total points
ID: 36496504
Are you sure you have values in the session variables when you get to this section of code? Debug and step through it to be sure. If you do, take those values and put them in your SQL string and execute that string directly against the SQL server to make sure that you are getting rows back.
0
 

Author Comment

by:Shaggy1
ID: 36496547
Thanks for the help. It seems as though I am getting the values. To test it, i used a label to make sure i was getting the values. I had seen that programmers have been placing the values in the SQL string, but wasn't sure if that was the safest way to do it.
Thanks again!
0
 
LVL 28

Expert Comment

by:strickdd
ID: 36496985
The way you have the SQL - parameterized - is perfect. I'm just suggesting to manaully add the values to the SQL so you can run it in management studio and make sure results are returned. Don't shy away from parameterization!
0
 

Author Closing Comment

by:Shaggy1
ID: 36497259
Well, looks like it was one of the variables...i just removed one of them, and the Grid filled up.
Thanks for the help!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question