how to store session data table into a data tabale?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

, +

hi am using dynamic in my web application..
am using user control(BidTree)
i want to save this user controls values from session to sql table can any one suggest me how to give code to save into sql table.

thanks.

Posted 7-Jun-12 23:13pm

ythisbug

Updated 23-Oct-17 6:36am

Add a Solution

Comments

Herman<T>.Instance 21-Aug-14 6:06am

what have you tried? You can read values from session, set them as SqlParameter and fire a query with thee parameters to your database table? What part is to hard to handle for you?

3 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)

codeBegin · Answer 1 · 2012-06-07T23:26:00

Adding DataTable into Session:

C#

DataTable Tissues = new DataTable();

Tissues = dal.returnTissues("TestID", "TestValue");// returnTissues("","") sample     function for adding values

Session.Add("Tissues", Tissues);

Retrive that datatable from session:

C#

DataTable Tissues = Session["Tissues"] as DataTable

Or

C#

DataTable Tissues = (DataTable)Session["Tissues"];

Ref:Storing and retrieving datatable from session[^]

Rahul Rajat Singh · Answer 2 · 2012-06-07T23:54:00

Lets say you have a datatable ad you want to save it, say Dt.

C#

Session["myTable"] = Dt;

Now on the page where you need to access it:

C#

DataTable table = Session["myTable"] as DataTable;

if(table != null)
{
 //read table and push in Sqlserver
}
else
{
 //session either expired or invalid page being accessed.
}

I hope it helps. let me know if you need more.

Ankit Choure · Answer 3 · 2014-08-21T02:12:00

Adding DataTable into Session Veriable:

Set into Session variable as

Session["MyDataTableSessionName"]= "MyDataTable"

i.e. DataTable myDataTable=new DataTable();

Session["MyDataTable"]= myDataTable;

Retrive that DataTable from Session:

DataTable myDataTable =(DataTable)Session["MyDataTable"];

how to store session data table into a data tabale?

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0