Пример #1
0
    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);
        }
    }