数据库

c#中对access数据表中增加表,增加字段、删除字段

2010-11-02

protected void btnjb_Click(object sender, EventArgs e)
    {
        string aa = txtname.Text.Trim();
        string str = "create table "+aa.ToString()+"(id autoincrement,uname text,email text,times datetime)";
        执行

    }

//ID是自动编码字段


    protected void btnadd_Click(object sender, EventArgs e)
    {
        string aa = txtlie1.Text.Trim();
        string str = "alter table baolei add column " + aa.ToString() + " int";
        执行

    }
    protected void btndel_Click(object sender, EventArgs e)
    {
        string aa = txtlie2.Text.Trim();
        string str = "alter table baolei drop column " + aa.ToString();
        执行

    }