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

Question

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

Jignesh Kumar · 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 Mohamed · Answer

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 **/