直接用C#在内存中建立表

//C#中创建表
    public void bindData()
    {
        DataTable dt = new DataTable("blog");
        DataColumn dc = new DataColumn("id", typeof(int));
        dc.AutoIncrement = true;//id自动增加
        dt.Columns.Add(dc);
        dc = new DataColumn("bname", typeof(string));
        dt.Columns.Add(dc);
        dc = new DataColumn("burl", typeof(string));
        dt.Columns.Add(dc);
        dc = new DataColumn("busername", typeof(string));
        dt.Columns.Add(dc);
        //在新建的表中添加数据
        DataRow dr = dt.NewRow();
        dr["bname"] = "Tom's blog";
        dr["burl"] = "http://jaylong1302-163-com.iteye.com/";
        dr["busername"] = "Tom";
        dt.Rows.Add(dr);

        dr = dt.NewRow();
        dr["bname"] = "mike's blog";
        dr["burl"] = "http://mike.iteye.com/";
        dr["busername"] = "mike";
        dt.Rows.Add(dr);