public static Column Create(DataRow dr)
{
var column = new Column();
column.CopyFromSchemaTableRow(dr);
return(column);
}
public static Column Create(DataRow dr)
{
var column = new Column();
column.CopyFromSchemaTableRow(dr);
return column;
}
private void RenderTable(TextWriter writer, IDataReader dr)
{
var schemaTable = dr.GetSchemaTable();
writer.WriteLine("<table border=\"1\" cellspacing=\"0\" style=\"border-collapse:collapse\">");
// header
writer.WriteLine("<tr>");
for (int i = 0; i < dr.FieldCount; i++)
{
var column = new Column();
column.CopyFromSchemaTableRow(schemaTable.Rows[i]);
writer.WriteLine("<td class=\"header\" nowrap>{0}<br />{1}</td>", column.Name, column.DataType.NameWithLength);
}
writer.WriteLine("</tr>");
// Rows
while (dr.Read())
{
writer.WriteLine("<tr>");
for (int i = 0; i < dr.FieldCount; i++)
{
writer.WriteLine("<td nowrap>{0}</td>", dr.GetValue(i).ToString());
}
writer.WriteLine("</tr>");
}
// Footer
writer.WriteLine("</table>");
}
