protected void objectsExportButton_Click(object sender, EventArgs e)
{
// DataSet d = OSAESql.RunSQL("SELECT object_id, container_name, object_name, object_type, state_name, last_updated, address FROM osae_v_object order by container_name, object_name");
DataSet d = OSAESql.RunSQL("CALL osae_sp_object_export_all");
//MemoryStream s = new MemoryStream();
d.DataSetName = "Objects";
d.Tables[0].TableName = "Object";
// d.WriteXml(s);
foreach (DataTable tab in d.Tables)
{
foreach (DataRow drow in tab.Rows)
Response.Write(drow[0].ToString());
}
Response.ContentType = "text/sql";
Response.AddHeader("Content-Disposition", "attachment; filename=Objects.sql");
Response.End();
}