DataGrid 完全攻略之五（使用DropDownList）

前台代码：html

<%@ Page language="c#" Codebehind="UseDropDown.aspx.cs" AutoEventWireup="false" Inherits="MsDataGrid.UseDropDown" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>DataGrid使用举例</title>

</HEAD>

<asp:DataGrid id="dgShow" style="Z-INDEX: 101; LEFT: 31px; POSITION: absolute; TOP: 93px" runat="server" Width="842px" Height="172px" BorderColor="Tan" BorderWidth="1px" BackColor="LightGoldenrodYellow" CellPadding="2" GridLines="None" ForeColor="Black" PageSize="1" AutoGenerateColumns="False">

<asp:BoundColumn DataField="StudentID" ReadOnly="True" HeaderText="学生ID"></asp:BoundColumn>

<asp:BoundColumn DataField="StudentName" HeaderText="学生姓名"></asp:BoundColumn>

<asp:BoundColumn DataField="StudentPass" HeaderText="密码"></asp:BoundColumn>

<asp:BoundColumn DataField="Sex" HeaderText="性别"></asp:BoundColumn>

<asp:BoundColumn DataField="Birthday" HeaderText="生日" DataFormatString="{0:yyyy-M-d}"></asp:BoundColumn>

<asp:BoundColumn DataField="Email" HeaderText="邮件地址"></asp:BoundColumn>

<asp:TemplateColumn HeaderText="性别模板列">

<asp:DropDownList id="ddlSexI" runat="server" Enabled="False">

<asp:ListItem Value="1">男</asp:ListItem>

<asp:ListItem Value="0">女</asp:ListItem>

</asp:DropDownList>

</ItemTemplate>

<asp:DropDownList id="ddlSexE" runat="server">

<asp:ListItem Value="1">男</asp:ListItem>

<asp:ListItem Value="0">女</asp:ListItem>

</asp:DropDownList>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:ButtonColumn Text="选择" HeaderText="选择" CommandName="Select"></asp:ButtonColumn>

<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" HeaderText="操作" CancelText="取消" EditText="编辑"></asp:EditCommandColumn>

<asp:ButtonColumn Text="删除" HeaderText="删除" CommandName="Delete"></asp:ButtonColumn>

</Columns>

</asp:DataGrid></FONT>

</form>

</body>

</HTML>

后台代码：cs

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

namespace MsDataGrid

{

/// <summary>

/// WebForm1 的摘要说明。

/// </summary>

public class UseDropDown : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DataGrid dgShow;

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

if(!IsPostBack)

BindData();

}

private void BindData()

{

string strCon = System.Configuration.ConfigurationSettings.AppSettings["DSN"];

SqlConnection con = new SqlConnection(strCon);

SqlDataAdapter da = new SqlDataAdapter("Select * from tbStudentinfo",con);

DataSet ds = new DataSet();

da.Fill(ds,"studentinfo");

dgShow.DataSource = ds.Tables["studentinfo"].DefaultView;

dgShow.DataBind();

foreach(DataGridItem dgi in dgShow.Items)

{

//以下绑定非编辑状态下拉列表

DropDownList ddI = (DropDownList)dgi.FindControl("ddlSexI");

if(ddI!=null)

{

bool bSex = (bool)ds.Tables["studentinfo"].Rows[dgi.ItemIndex]["Sex"];

if(bSex)

ddI.SelectedIndex = 0;

else

ddI.SelectedIndex = 1;

}

//以下绑定编辑状态下拉列表

DropDownList ddE = (DropDownList)dgi.FindControl("ddlSexE");

if(ddE!=null)

{

bool bSex = (bool)ds.Tables["studentinfo"].Rows[dgi.ItemIndex]["Sex"];

if(bSex)

ddE.SelectedIndex = 0;

else

ddE.SelectedIndex = 1;

}

Web Form Designer generated code

private void dgShow_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

dgShow.EditItemIndex = e.Item.ItemIndex;

BindData();

}

private void dgShow_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

dgShow.EditItemIndex = -1;

BindData();

}

private void dgShow_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)

{

dgShow.CurrentPageIndex = e.NewPageIndex;

BindData();

}

private void dgShow_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

if(dgShow.Items.Count==1)

{

if(dgShow.CurrentPageIndex!=0)

dgShow.CurrentPageIndex = dgShow.CurrentPageIndex-1;

}

string strSql = "delete from tbStudentinfo where studentid="+e.Item.Cells[0].Text+"";

ExecuteSql(strSql);

BindData();

}

////////////////////////////////////////////////////////////

//说明：执行制定SQL语句/////////////////////////////////////

///////////////////////////////////////////////////////////

private void ExecuteSql(string strSql)

{

try

{

string strconn = System.Configuration.ConfigurationSettings.AppSettings["DSN"];//从Web.config中读取

SqlConnection conn =new SqlConnection(strconn);

SqlCommand com = new SqlCommand(strSql,conn);

conn.Open();

com.ExecuteNonQuery();

conn.Close();

}

catch(Exception e)

{

Response.Write("<script language = 'javascript'>alert('"+e.Message+"');</script>") ;

}

private void dgShow_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

string strStudentID = e.Item.Cells[0].Text;//处于非编辑状态

string strName = ((TextBox)(e.Item.Cells[1].Controls[0])).Text;//处于编辑状态

string strPass =((TextBox)(e.Item.Cells[2].Controls[0])).Text;

string strSex = ((DropDownList)(e.Item.FindControl("ddlSexE"))).SelectedItem.Value;

string strBirthday =((TextBox)(e.Item.Cells[4].Controls[0])).Text;

string strEmail =((TextBox)(e.Item.Cells[5].Controls[0])).Text;

string strSql = "update tbStudentinfo set StudentName='"+strName+"',StudentPass='"+strPass+"'";

strSql +=",Sex="+strSex+",Birthday='"+strBirthday+"',Email='"+strEmail+"' where studentid="+strStudentID+"";

ExecuteSql(strSql);

dgShow.EditItemIndex = -1;

BindData();

}

posted on 2005-10-12 17:05 LDAR泄漏检测与修复阅读(598) 评论(0) 编辑收藏举报

刷新页面返回顶部

.NET技术支持者

公告