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