Solved

Store Sessions variables from SQL Query in Code.

Posted on 2014-03-27
2
664 Views
Last Modified: 2014-03-27
I want to pass an ID to a sql query.

The results of the query I want to put in session variables.

I'd like to do this all in the vb code.

So, to summerise, I want to execute a SQL qury when I click on a button or a gridview selected change event.   That then feeds an ID into a SQL query and the returned results are all stored in session variables.   All in the code.  

Thanks
0
Comment
Question by:edjones1
  • 2
2 Comments
 

Accepted Solution

by:
edjones1 earned 0 total points
ID: 39959358
So I've worked out how to put the results into a gridview but what I really want is to add the results to session variables display in a gridview.

 Dim strConnString As String = ConfigurationManager.ConnectionStrings("CFLoanQuoteConnectionString").ConnectionString

            Dim sqlConnection1 As New SqlConnection(strConnString)

            Dim query As String
            Dim SqlCommand As SqlCommand
            Dim reader As SqlDataReader

            Dim adapter As New SqlDataAdapter()
            'Open the connection to db
            sqlConnection1.Open()

            'Generating the query to fetch the contact details
            query = "SELECT * FROM All"

            SqlCommand = New SqlCommand(query, sqlConnection1)
            adapter.SelectCommand = New SqlCommand(query, sqlConnection1)
            'execute the query
            reader = SqlCommand.ExecuteReader()
            'Assign the results 
            GridView1.DataSource = reader

            'Bind the data
            GridView1.DataBind()

Open in new window

0
 

Author Closing Comment

by:edjones1
ID: 39960390
worked it out myself
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now