一些基础问题。

 

！、页面弹出对话框

在页面的pageload中加入：

Button1.Attributes.Add("onclick", "return   confirm('此案卷真的要回退吗？是／否');");

2、从数据库中读入数据绑定到GridView中。

 

 //从数据库中获取数据
        public void getData()
        {
           
            SqlConnection cn = new SqlConnection("server=ZHOUWEN;database=DCM_data;user=DCM;password=DCM;");

 

            SqlCommand cd = new SqlCommand("select * from SysMessageR order by 发送时间 desc", cn); 

                //SysMessageR是数据表名
            SqlDataAdapter da = new SqlDataAdapter(cd);
            DataSet ds = new DataSet();
            da.Fill(ds, "SysMessageR");
           
            this.GridView1.DataSource = ds.Tables[0].DefaultView;
            this.DataBind();

        }

3、实现GridView的分页

  

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            this.GridView1.PageIndex = e.NewPageIndex;
            getData();
                 

       }

4、GridView中记录删除（记得要设置GridView的DataKeys）

 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string na = this.GridView1.DataKeys[e.RowIndex][0].ToString();
            deletepersonal(na);
            getData();

        }

 public void deletepersonal(string name)
        {
            SqlConnection cn = new SqlConnection("server=localhost;database=test1;user=grid;password=grid;");
            SqlCommand cmd = new SqlCommand("delete from personal  where name='" + name + "'", cn);
            cn.Open();
            cmd.ExecuteNonQuery();
            cn.Close();
       
        }
5、GridView中记录编辑

//开始编辑
       

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            this.GridView1.EditIndex = e.NewEditIndex;
             getData();

 

        }

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string na = this.GridView1.DataKeys[e.RowIndex][0].ToString();
            string id = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString();
            string sco = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString(); ;
           // Response.Write( na+"--"+id);
            updatepersonal(na,id,sco);
            this.GridView1.EditIndex = -1;
            getData();

        }

 

//更新所修改的

        public void updatepersonal(string name,string id ,string score)
        {
            SqlConnection cn = new SqlConnection("server=localhost;database=test1;user=grid;password=grid;");
            SqlCommand cmd = new SqlCommand("update personal set id= '"+id+"',score='"+score+"'where name='"+name+"'",   cn);
            cn.Open();
            cmd.ExecuteNonQuery();
            cn.Close();
        }

 

//取消编辑
        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {

            this.GridView1.EditIndex = -1;
            getData();
        }