CREATE PROC TEST1
AS
  SET NOCOUNT ON
   -- bla bla bla
 
  SELECT COL1, COL2 FROM #TempTable
  RETURN  0 

Public DataSet LoadDataSet()
{

string connectionString = "bla bla bla"
System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection(connectionString);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("TEST1", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;

System.Data.DataSet ds = new System.Data.DataSet();
try
{
	cnn.Open();
	System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);
	da.Fill(ds);
	ds.Tables[ 0 ].TableName = "myTempTable"
}
catch (System.Exception e)
{
	throw e;
}
finally
{
	cnn.Close();
}
return ds;
}