如何将会话数据表存储到数据tabale？ [英] how to store session data table into a data tabale?

问题描述

您好我在我的网络应用程序中使用动态..

我正在使用用户控件（BidTree）

i希望保存此用户控件值从session到sql表可以任意一个建议我如何将代码保存到sql表中。



谢谢。

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.

推荐答案

添加DataTable进入会话：

Adding DataTable into Session:

DataTable Tissues = new DataTable();

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

Session.Add("Tissues", Tissues);

从会话中检索数据表：

Retrive that datatable from session:

DataTable Tissues = Session["Tissues"] as DataTable

或

Or

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

参考：存储和检索数据表m session [ ^ ]

假设您有一个 datatable 广告要保存它，比如 Dt 。

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

Session["myTable"] = Dt;

现在在您需要访问它的页面上：

Now on the page where you need to access it:

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.

将DataTable添加到会话中可用：



设置为Session变量为



Session [MyDataTableSessionName] =MyDataTable



即DataTable myDataTable = new DataTable（）;



Session [MyDataTable] = myDataTable;



从会话中回复DataTable：



DataTable myDataTable =（DataTable）Session [MyDataTable];

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"];

这篇关于如何将会话数据表存储到数据tabale？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！