DropDownList的GridView编辑、删除的实现代码
本文导语: gridview编辑、删除完整代码如下。 代码示例: --%> /// /// 绑定数据到GridView /// private void GridViewBind() { 检索数据库 string strSql = "SELECT * FROM DB1"; 得到数据集 this.GridView1.DataSource=conn.GetDs(strSql).Table...
gridview编辑、删除完整代码如下。
--%>
///
/// 绑定数据到GridView
///
private void GridViewBind()
{
检索数据库
string strSql = "SELECT * FROM DB1";
得到数据集
this.GridView1.DataSource=conn.GetDs(strSql).Tables[0].DefaultView;
this.GridView1.DataBind();
}
///
/// 编辑当前行
///
///
///
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
//当前编辑行背景色高亮
this.GridView1.EditRowStyle.BackColor = Color.FromName("#F7CE90");
GridViewBind();
}
///
/// 取消编辑状态
///
///
///
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
GridViewBind();
}
///
/// 删除记录过程
///
///
///
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//得到单位编号
string rowToDelete = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
//转换为整数
//int >//从数据库中删除
string str = "DELETE FROM DB1 where DB1_1=" "'" rowToDelete "'" "";
try
{
conn.RunSql(str);
//重新绑定数据
GridViewBind();
}
catch (Exception ex)
{
Response.Write("数据库错误，错误原因：" ex.Message);
Response.End();
}
}
///
/// 更新记录过程
///
///
///
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string >string DB1_1 = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text;
//string DB1_2 = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text;
string DB1_2 = (((DropDownList))GridView1.Rows[e.RowIndex].FindControl("ddlXL")).SelectedItem.Text;
//判断表单项是否有空并给出提示信息
if (DB1_1 == "" || DB1_2 == "")
{
conn.Alert("请输入完整信息！", Page);
return;
}
try
{
conn.BuilderEdit("select * from DB1 where DB1_1 ='" ID "'");
conn.dr["DB1_1"] = DB1_1;
conn.dr["DB1_2"] = DB1_2;
conn.BuilderEditClose();
}
catch (OracleException err)
{
if (err.Code.ToString() == "1")
conn.Alert("错误：已存在具有相同主键的记录", Page);
else
conn.Alert("错误：未能添加记录", Page);
}
Response.Write("alert('数据已被保存!');");
//返回浏览状态
GridView1.EditIndex = -1;
GridViewBind();
}
///
/// 分页事件
///
///
///
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridViewBind();
}
///
/// 加入鼠标效果及为DropDownList绑定值
///
///
///
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
//为DropDownList绑定值
if (((DropDownList)e.Row.FindControl("ddlXL")) != null)
{
DropDownList ddlXL = (DropDownList)e.Row.FindControl("ddlXL");
ddlXL.Items.Clear();
ddlXL.Items.Add(new ListItem("博士", "1"));
ddlXL.Items.Add(new ListItem("硕士", "2"));
ddlXL.Items.Add(new ListItem("学士", "3"));
}
//加入鼠标滑过的高亮效果
if (e.Row.RowType == DataControlRowType.DataRow)//判定当前的行是否属于datarow类型的行
{
//当鼠标放上去的时候 先保存当前行的背景颜色 并给附一颜色
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='yellow',this.style.fontWeight='';");
//当鼠标离开的时候 将背景颜色还原的以前的颜色
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';");
}
//单击行改变行背景颜色
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onclick", "this.style.backgroundColor='#99cc00'; this.style.color='buttontext';this.style.cursor='default';");
}
}
您可能感兴趣的文章:
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。