I have some simple code below and I would like to get some ADO.NET code to update a temporary table. Hopefully using Datasets / data tables.
SqlConnection myConn = new SqlConnection("Data Source=localhost\\SQLEXPRESS;Initial Catalog=CarDB;Integrated Security=True;database=CarDB");
string str = "create table #temp1 (col1 int, col2 int);";
// Code to do a dataset to insert some records.
SqlCommand myCommand = new SqlCommand(str, myConn);
myCommand.CommandText = "drop table #temp1;";