How to store the result of SQL query in Session Variable using ASP.NET C# to use it later

Question

I am new to ASP.NET C#, I am working to develop web forms to send and receive messages (SQL Server as database) like emails. I want to store the result of SQL query in Session Variable and use it later in another page.

Kindly help me how can I do that, please correct if any things goes wrong.

Here is my code:

SqlConnection con = new SqlConnection("Data Source=AZEEM\\SQLEXPRESS; Initial Catalog=kics;User ID=sa;Password=123");
con.Open();

String query = "select username as sender,subject,message from emailtable where receiver='" + Session["username"] + "'";

    enter code here

//this is the query for which I want to store the result in variable myvar, how can I store the result of following query in variable myvar and use it later, when  I execute it, string is shown instead of result of string.
String myvar = "select receiver from emailtable where username='" + Session["username"] + "'";
SqlDataReader reader = null;

SqlCommand cmd = new SqlCommand(query, con);
SqlCommand cmd2 = new SqlCommand(myvar, con);

DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
reader = cmd2.ExecuteReader();

GridView1.DataSource = dt;
GridView1.DataBind();
DataSet ds = new DataSet();

ds = myvar;

actually I want to store the result of the following query in variable myvar,String myvar = "select receiver from emailtable where username='" + Session["username"] + "'"; I dont know how to do it, when i check the result of this query, it gives me query string but i want result of query. — Muhammad Ibrar
– Muhammad Ibrar, Commented Mar 26, 2016 at 10:19

INDIA IT TECH · Accepted Answer · 2016-03-26 10:42:39Z

1

Try below,

SqlConnection con = new SqlConnection("Data Source=AZEEM\\SQLEXPRESS; Initial Catalog=kics;User ID=sa;Password=123");
con.Open();

String query = "select username as sender,subject,message from emailtable where receiver='" + Session["username"] + "'";

    enter code here

//this is the query for which I want to store the result in variable myvar, how can I store the result of following query in variable myvar and use it later, when  I execute it, string is shown instead of result of string.
String myvar = "select receiver from emailtable where username='" + Session["username"] + "'";
SqlDataReader reader = null;

SqlCommand cmd = new SqlCommand(query, con);
SqlCommand cmd2 = new SqlCommand(myvar, con);

DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
reader = cmd2.ExecuteReader();

GridView1.DataSource = dt;
GridView1.DataBind();

session["dt"] = dt;

When you retrieve,

if (session["dt"] != null) {
    DataTable dt = (DataTable)session["dt"];
}

edited Mar 26, 2016 at 10:42

answered Mar 26, 2016 at 10:22

INDIA IT TECH

1,8984 gold badges15 silver badges25 bronze badges

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

6 Comments

Tummala Krishna Kishore Over a year ago

OP problem is different . actually I want to store the result of the following query in variable myvar,String myvar = "select receiver from emailtable where username='" + Session["username"] + "'"; I dont know how to do it, when i check the result of this query, it gives me query string but i want result of query , so i dont think this is what OP is asking

INDIA IT TECH Over a year ago

You mean, you just want to store string in session, please see my updated answer.

Tummala Krishna Kishore Over a year ago

two points i will clarify you, I'm not the OP , 2. you are understanding the Problem in a wrong way

INDIA IT TECH Over a year ago

Well, first I understand that you want to store result of your query, so definitely that will be in datatable. So I saved whole datatable in session. But as per your recent comment, you told that you want to store your variable. So I saved it within session. If you are looking something different, please let me know.

Tummala Krishna Kishore Over a year ago

i am not the original Poster (OP ) of this Question

|

Tummala Krishna Kishore · Accepted Answer · 2016-03-26 10:44:21Z

You Need to Pass that Query to this Method which will return you the result Set and then try to assign it to the Session

    String myvar = "select receiver from emailtable where username='" +  Session["username"] + "'";
    Session["myvar"] = GetData(myvar);

Method for GetData as Follows

   private static DataTable GetData(string query)
        {
            DataTable dt = new DataTable();
            string constr = "Data Source=AZEEM\\SQLEXPRESS; Initial Catalog=kics;User ID=sa;Password=123";
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    using (SqlDataAdapter sda = new SqlDataAdapter())
                    {
                        cmd.CommandType = CommandType.Text;
                        cmd.Connection = con;
                        sda.SelectCommand = cmd;
                        sda.Fill(dt);

                    }
                }
                return dt;
            }
        }

Collectives™ on Stack Overflow

How to store the result of SQL query in Session Variable using ASP.NET C# to use it later

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related