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