protected void Button1_Click(object sender, EventArgs e)
{
PlaceHolder1.Controls.Clear();
object sqlRes;
try
{
sqlRes = DSSwitch.sql().ProcessSql(SessionData.SessionsSystem_Get(Session), TextBox_Sql.Text);
}
catch (Exception ex)
{
sqlRes = ex.Exceptio2Table();
}
if ((sqlRes != null) && (sqlRes.GetType() == typeof(System.Data.DataTable)))
{
System.Data.DataTable r1 = (System.Data.DataTable)sqlRes;
WebControlsTableResult r2 = r1.DataTable2WebControlsTable(20);
PlaceHolder1.Controls.Add(r2.Label);
PlaceHolder1.Controls.Add(r2.Table);
}
else if ((sqlRes != null) && (sqlRes.GetType() == typeof(Table)))
{
PlaceHolder1.Controls.Clear();
Table sqlTable = (Table)sqlRes;
PlaceHolder1.Controls.Add(sqlTable);
}
}
public static WebControlsTableResult DataTable2WebControlsTable(this System.Data.DataTable dt, int maxText)
{
string unitString = dt.Columns.Count == 0 ? "" : (100 / dt.Columns.Count).ToString() + "%";
WebControlsTableResult ret = new WebControlsTableResult();
ret.Table = new System.Web.UI.WebControls.Table();
ret.Table.BorderWidth = 1;
ret.Table.GridLines = System.Web.UI.WebControls.GridLines.Both;
System.Web.UI.WebControls.TableRow row = null;
//Add the Headers
row = new System.Web.UI.WebControls.TableRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
System.Web.UI.WebControls.TableHeaderCell headerCell = new System.Web.UI.WebControls.TableHeaderCell();
headerCell.Text = dt.Columns[j].ColumnName;
row.Cells.Add(headerCell);
}
ret.Table.Rows.Add(row);
//Add the Column values
for (int i = 0; i < dt.Rows.Count; i++)
{
row = new System.Web.UI.WebControls.TableRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
System.Web.UI.WebControls.TableCell cell = new System.Web.UI.WebControls.TableCell();
cell.Text = dt.Rows[i][j].ToString().LimitText(maxText);
cell.Width = new System.Web.UI.WebControls.Unit(unitString);
row.Cells.Add(cell);
}
// Add the TableRow to the Table
ret.Table.Rows.Add(row);
}
ret.Label = new System.Web.UI.WebControls.Label();
ret.Label.Text = "C:" + dt.Columns.Count.ToString() + " R:" + dt.Rows.Count.ToString();
return(ret);
}
