一些基础问题。
!、页面弹出对话框
在页面的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();
}