Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I know this is an old post but it did help me. I have done some edits to make it work with silverlight 4, converts and excel. I wanted the fast export so I first use CSV then open it with excel. This code works silverlight web and oob elevated trust. In Web will not open in excel.</p> <pre><code> private static void OpenExcelFile(string Path) { dynamic excelApp; excelApp = AutomationFactory.CreateObject("Excel.Application"); dynamic workbook = excelApp.workbooks; object oMissing = Missing.Value; workbook = excelApp.Workbooks.Open(Path, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing); dynamic sheet = excelApp.ActiveSheet; // open the existing sheet sheet.Cells.EntireColumn.AutoFit(); excelApp.Visible = true; } private static string FormatCSVField(string data) { return String.Format("\"{0}\"", data.Replace("\"", "\"\"\"") .Replace("\n", "") .Replace("\r", "") ); } public static string ExportDataGrid(DataGrid grid,string SaveFileName,bool AutoOpen) { string colPath; System.Reflection.PropertyInfo propInfo; System.Windows.Data.Binding binding; System.Text.StringBuilder strBuilder = new System.Text.StringBuilder(); var source = grid.ItemsSource; if (source == null) return ""; List&lt;string&gt; headers = new List&lt;string&gt;(); grid.Columns.ToList().ForEach(col =&gt; { if (col is DataGridBoundColumn) { headers.Add(FormatCSVField(col.Header.ToString())); } }); strBuilder .Append(String.Join(",", headers.ToArray())) .Append("\r\n"); foreach (var data in source) { List&lt;string&gt; csvRow = new List&lt;string&gt;(); foreach (DataGridColumn col in grid.Columns) { if (col is DataGridBoundColumn) { binding = (col as DataGridBoundColumn).Binding; colPath = binding.Path.Path; propInfo = data.GetType().GetProperty(colPath); if (propInfo != null) { string valueConverted = ""; if (binding.Converter.GetType().ToString() != "System.Windows.Controls.DataGridValueConverter") valueConverted = binding.Converter.Convert(propInfo.GetValue(data, null), typeof(System.String), binding.ConverterParameter, System.Globalization.CultureInfo.CurrentCulture).ToString(); else valueConverted = FormatCSVField(propInfo.GetValue(data, null) == null ? "" : propInfo.GetValue(data, null).ToString()); csvRow.Add(valueConverted.ToString()); } } } strBuilder .Append(String.Join(",", csvRow.ToArray())) .Append("\r\n"); } if (AutomationFactory.IsAvailable) { var sampleFile = "\\" + SaveFileName; var path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); path += "\\Pement"; if (!System.IO.Directory.Exists(path)) { System.IO.Directory.CreateDirectory(path); } else { var files = System.IO.Directory.EnumerateFiles(path); foreach (var item in files) { try { System.IO.File.Delete(item); } catch { } } } StreamWriter sw = File.CreateText(path + sampleFile); sw.WriteLine(strBuilder.ToString()); sw.Close(); if (AutoOpen) OpenExcelFile(path + sampleFile, true, true); } else { SaveFileDialog sfd = new SaveFileDialog() { DefaultExt = "csv", Filter = "CSV Files (*.csv)|*.csv|All files (*.*)|*.*", FilterIndex = 1 }; if (sfd.ShowDialog() == true) { using (Stream stream = sfd.OpenFile()) { using (StreamWriter writer = new StreamWriter(stream)) { writer.Write(strBuilder.ToString()); writer.Close(); } stream.Close(); } } } return strBuilder.ToString(); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POSilverlight DataGrid: Export to excel or csv
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAndrew
    1. USAndrew
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks looks good going to give it a try. Please remove your add, see here http://stackoverflow.com/faq#signatures
      singulars
      1. PO
      1. USDavid Perlman
    2. COJust a note to say that controlling Excel via interop in this way requires the user to be running out-of-browser (OOB). You must also build your app such that it requests elevated permissions (via the project's property pages.)
      singulars
      1. PO
      1. USDrew Noakes
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload