数据库系统之1.使用gridview动态增加行的实现

现在在实习，项目经理要求做个简单的数据库系统，实现简单的创建数据库，删除数据库，编辑字段等功能

今天简单做了一些，首先是使用gridview动态增加行的实现

 后台实现代码：

protected void Page_Load(object sender, EventArgs e)        {            if (!IsPostBack)            {                BindTestData();                           }        }                protected void BindTestData()        {            //模拟出一些原始数据绑定DataGrid            DataTable dt1 = new DataTable("Table1");            dt1.Columns.Add("ID");            dt1.Columns.Add("字段名称");            dt1.Columns.Add("字段长度");            dt1.Columns.Add("中文注释");            dt1.Columns.Add("默认值");            dt1.Columns.Add("字段类型");            dt1.Columns.Add("是否为空");            dt1.Columns.Add("是否自增");            dt1.Rows.Add(new object[] { 1, "Id", "4", "主键", "0","int","否","是" });            dt1.Rows.Add(new object[] { 2, "adder", "4", "添加人员", "0", "int", "否", "否" });            dt1.Rows.Add(new object[] { 3, "addtime", "", "添加时间", "getdate()", "datetime", "否", "否" });            dt1.Rows.Add(new object[] { 4, "moder", "4", "修改人员", "0", "int", "否", "否" });            dt1.Rows.Add(new object[] { 5, "modtime", "", "修改时间", "getdate()", "datetime", "否", "否" });            dt1.Rows.Add(new object[] { 6, "delstatus", "1", "删除标识", "0", "tinyint", "否", "否" });            dt1.AcceptChanges();            this.GridView1.DataSource = dt1;            this.GridView1.DataBind();        }        protected DataTable GetDataFromGrid()        {            DataTable dt1 = new DataTable("Table1");            dt1.Columns.Add("ID");            dt1.Columns.Add("字段名称");            dt1.Columns.Add("字段长度");            dt1.Columns.Add("中文注释");            dt1.Columns.Add("默认值");            dt1.Columns.Add("字段类型");            dt1.Columns.Add("是否为空");            dt1.Columns.Add("是否自增");            for (int i = 0; i < GridView1.Rows.Count; i++)            {                GridViewRow gRow = GridView1.Rows[i];                DataRow newRow = dt1.NewRow();                newRow[0] = GridView1.DataKeys[i].Value;                newRow[1] = ((TextBox)gRow.FindControl("TextBox1")).Text;                newRow[2] = ((TextBox)gRow.FindControl("TextBox2")).Text;                newRow[3] = ((TextBox)gRow.FindControl("TextBox3")).Text;                newRow[4] = ((TextBox)gRow.FindControl("TextBox4")).Text;                newRow[5] = ((DropDownList)gRow.FindControl("DropDownList1")).SelectedValue;                newRow[6] = ((DropDownList)gRow.FindControl("DropDownList2")).SelectedValue;                newRow[7] = ((DropDownList)gRow.FindControl("DropDownList3")).SelectedValue;                dt1.Rows.Add(newRow);            }            dt1.AcceptChanges();            return dt1;        }            protected void btn_addfile_Click(object sender, EventArgs e)        {            DataTable dt = this.GetDataFromGrid();            DataRow newRow = dt.NewRow();            newRow["字段类型"] = "int";            newRow["是否为空"] = "否";            newRow["是否自增"] = "否";            newRow["默认值"] = "";            newRow["中文注释"] = "";            dt.Rows.Add(newRow);            this.GridView1.DataSource = dt;            this.GridView1.DataBind();        }

 

 

前台页面代码：

     
                      需要创建的数据库表名：                
                      
      主键名称：                
                      
      
      
                
                          
                               
                                    
                                         
                                      
                                 
                                
                                    
                                         
                                      
                                 
                                
                                    
                                         
                                      
                                 
                                
                                    
                                         
                                      
                                 
                                
                                    
                                         
                                      
                                 
                                
                                    
                                         
           
                                          
           
            
             
            
                                      
                                 
                                
                                    
                                         
           
           
            否
            
           
            是
            
                                      
                                 
                                
                                    
                                         
           
           
            否
            
           
            是
            
                                      
                                 
                            
                       
                      
      
                
                      
                      
                  
     

 原文出自艾新草电脑论坛

数据库系统之1.使用gridview动态增加行的实现