using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Admin_CreateTable : System.Web.UI.Page
{
    LYS.UserData1 myud = new  LYS.UserData1();
    protected void Page_Load(object sender, EventArgs e)
    {


    }
    protected void Button1_Click(object sender, EventArgs e)
    {  //Create TABLE [表名]([字段名1] MEMO NOT NULL, [字段名2] MEMO, [字段名3] COUNTER NOT NULL, [字段名4] DATETIME, [字段名5] TEXT(200), [字段名6] TEXT(200))
        myud.RunCreateSQL(TextBox1.Text);
    }
    protected void Button3_Click(object sender, EventArgs e)
    {//
        string SQL = "select ID,教师姓名,count(distinct  教师姓名) from TKJL GROUP BY ID,教师姓名 order by 教师姓名";
        Literal1.Text = myud.DispLineData(SQL).ToString();
    }
}