Placing Data from a Dataset table directly into SQL

 
try
{
   SqlConnection conn = new SqlConnection("Server=IELETT3KA05;database=Metrics;uid=webuser;pwd=userweb");

   if (conn.State != ConnectionState.Open) 
      conn.Open(); 
   
   DataSet tmpDs = new DataSet(); 
   SqlDataAdapter pDa = new SqlDataAdapter("Select * from ALAN_BusinessReports_EPIC", conn); 
 
   pDa.FillSchema(tmpDs, SchemaType.Source, pDs.Tables[0].TableName);
   pDa.Fill(tmpDs, 0, pDs.Tables[0].Rows.Count, pDs.Tables[0].TableName);

 
   SqlCommandBuilder pCbm = new SqlCommandBuilder(pDa);

 
   pDa.InsertCommand = pCbm.GetInsertCommand();
 
   pDa.Update(pDs, pDs.Tables[0].TableName);
 
   conn.Close();
}
 
catch (Exception ex2)
{
   Response.Write(ex2.Message);
}