Inserting Data To SQL Global Temporary Table From ASP.NET C#

Jes Sie

Is it possible to insert data to a SQL global temporary table using C# in asp.net? After inserting, I want to retrieve that data and display it on the same page. To better explain it, please refer to the images below:

I want to insert the given values into the SQL temporary table. After inserting, I want to retrieve the inserted data and display it like the picture below:

Can someone show me or direct me to a reference on how to do this? thank you

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Accepted answer
Hi Hold on,

If you want to keep your data in storage then you can storein SQL table and after insert query you can bind data in table or gridview with select statement after insert statement.

If you want to keep it for some time then you can create dataset/datatable and bind same data in gridview.

Please find below links which will help you,

Temporary Storage using dataset :
https://www.aspsnippets.com/Articles/Using-DataTable-as-Temporary-storage-table-in-ASPNet.aspx

Permenent starage in SQL table
https://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx
Mounnad Mohamed6y ago
Hello ,
You can Connect to Global Temporary Tables with asp.net.
You need To Create Tables first and after that in your button of Insert, you call the Insert Query of SQL Server (I don't if Entity Framework supports working with temporary Tables),
public ActionResult Insert(Item item)
{
  //Do some operation to Costruct Your Insert Request

var sql = "Insert into ##tempTables Values (/*item Values*/)

//Execute the query here

}

/*  The same for  Read data **/