private void OleDb_ReadDataFinished(object sender, ReadDataEventArgs args) { if (!string.IsNullOrEmpty(txtRowName.Text)) { int row = int.Parse(txtRowName.Text); for (var i = 0; i < args.Data.Columns.Count; i++) { try { args.Data.Columns[i].ColumnName = args.Data.Rows[row].ItemArray[i].ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); args.Data.Columns[i].ColumnName = $"{args.Data.Rows[row].ItemArray[i]}{i}"; } } for (var i = 0; i <= row; i++) { args.Data.Rows[i].Delete(); } } excel.Data = args.Data; foreach (DataColumn col in args.Data.Columns) { excel.ColumnsNameList += $"{col.ColumnName};"; } excel.State = ExcelFile.Status.ReadCompleted; }
public void OnReadDataHandler(object sender, ReadDataEventArgs e) { StringBuilder sb = new StringBuilder(); sb.Append("R: "); byte[] data = e.Data; if (cmbLogDataType.SelectedIndex == 0) { return; // show i2c received data in "send" route //data = GetRecI2CData(e.Data); } else if (cmbLogDataType.SelectedIndex == 1) // command data { data = GetRecCommandData(e.Data); } else if (cmbLogDataType.SelectedIndex == 2) // api data { data = e.Data; } if (data != null) { for (int i = 0; i < data.Length; i++) { if (cmbShowFormat.SelectedIndex == 0) //hex { sb.Append(string.Format("{0:X2} ", data[i])); } else { sb.Append(string.Format("{0} ", data[i])); } } } if (data != null) { LogText(sb.ToString()); } }