导出CSV
private void btnInsert_Click(object sender, RoutedEventArgs e)
{
radGridView1.ToCsv();
string extension = "csv";
SaveFileDialog dialog = new SaveFileDialog()
{
DefaultExt = extension,
Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, "CSV"),
FilterIndex = 1
};
if (dialog.ShowDialog() == true)
{
using (Stream stream = dialog.OpenFile())
{
radGridView1.Export(stream,
new GridViewExportOptions()
{
Format = ExportFormat.Csv,
ShowColumnHeaders = true,
ShowColumnFooters = true,
ShowGroupFooters = false,
});
}
}
}
读取CSV
private void btnInsert_Click_1(object sender, RoutedEventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog()
{
Filter = "Csv Files (*.csv)|*.csv|All Files (*.*)|*.*",
};
if (true == dlg.ShowDialog())
{
//myList.DataContext = dlg.Files;
FileInfo fi= dlg.File;
if (fi != null)
{
using (Stream stream = fi.OpenRead())
{
List<ClientMetricNodeIcon> metricNodeIcons=new List<ClientMetricNodeIcon>();
StreamReader fileReader = new StreamReader(stream);
string strLine = "";
string[] tempString=new string[4];
while (strLine != null)
{
strLine = fileReader.ReadLine();
if (strLine != null && strLine.Length > 0)
{
//ls.Add(strLine.Split(','));
ClientMetricNodeIcon metricNode=new ClientMetricNodeIcon();
tempString=strLine.Split(',');
metricNode.UserName = tempString[0];
metricNode.Regex = tempString[1];
try
{
metricNode.Type= Convert.ToInt16(tempString[2]);
}
catch(Exception err)
{
metricNode.Type = 0;
}
try
{
byte[] byteArry = new byte[0];
byteArry = System.Text.Encoding.UTF8.GetBytes(tempString[3]);
//string str = System.Text.Encoding.UTF8.GetString(byteArry);
metricNode.Icon = byteArry;
}
catch (Exception err)
{
}
metricNodeIcons.Add(metricNode);
}
}
fileReader.Close();
radGridView1.ItemsSource = metricNodeIcons;
stream.Close();
}
}
}
}