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);}