public string Serialize(IQueryResult queryResult)
{
var columns = queryResult.GetColumnNames();
var xml = string.Empty;
while (queryResult.Read())
{
var row = string.Empty;
foreach (var column in columns)
{
row = string.Format("{0}\n<{1}>{2}</{1}>", row, column, queryResult.GetValue(column));
}
xml = string.Format("{0}\n<Row>{1}</Row>", xml, row.Substring(1));
}
return(string.Format("<Data>{0}</Data>", xml));
}
public string Serialize(IQueryResult queryResult)
{
var columns = queryResult.GetColumnNames();
var csv = string.Join(",", columns);
while (queryResult.Read())
{
var row = string.Empty;
foreach (var column in columns)
{
row = string.Format("{0},{1}", row, queryResult.GetValue(column));
}
csv = string.Format("{0}\n{1}", csv, row.Substring(1));
}
return(csv);
}
private void PrintResultData(IQueryResult result)
{
resultdataView.Rows.Clear();
resultdataView.Columns.Clear();
//tabetGridView.ColumnCount = previewList[0].Count;
resultdataView.ColumnHeadersVisible = true;
// Set the column header style.
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
columnHeaderStyle.BackColor = Color.Beige;
columnHeaderStyle.Font = new Font("Verdana", 10, FontStyle.Bold);
resultdataView.ColumnHeadersDefaultCellStyle = columnHeaderStyle;
resultdataView.AllowUserToAddRows = false;
var columns = result.GetColumnNames();
foreach (var col in columns)
{
DataGridViewColumn c = new DataGridViewColumn();
c.Name = col;
DataGridViewCell cell = new DataGridViewTextBoxCell();
// cell.Style.BackColor = Color.Wheat;
c.CellTemplate = cell;
resultdataView.Columns.Add(c);
}
string[] row = new string[columns.Length];
int contor;
while (result.Read())
{
contor = 0;
foreach (var column in columns)
{
row[contor++] = result.GetValue(column).ToString();
}
resultdataView.Rows.Add(row);
}
}
private static void PrintResultData(IQueryResult result)
{
var columns = result.GetColumnNames();
foreach (var column in columns)
{
System.Console.Write(string.Format("|{0}|", column));
}
System.Console.WriteLine();
while (result.Read())
{
foreach (var column in columns)
{
System.Console.Write(string.Format("|{0}|", result.GetValue(column)));
}
System.Console.WriteLine();
}
}