DataGrid 完全攻略之六（使用RadioButton）

最新推荐文章于 2024-11-21 10:39:02 发布

转载最新推荐文章于 2024-11-21 10:39:02 发布 · 307 阅读

文章标签：

#ui #c# #javascript #ViewUI

该博客展示了DataGrid使用的前后台代码。前台代码采用HTML，涉及C#和JavaScript；后台代码为C#，包含数据绑定、页面初始化、编辑、删除、更新等功能，通过SQL语句与数据库交互，实现学生信息的管理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前台代码：html

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

<!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="2" AutoGenerateColumns="False" AllowPaging="True">

<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:RadioButton id=RadioButton2 runat="server" Enabled="False" Checked='<%# DataBinder.Eval(Container, "DataItem.Sex") %>' Text="男">

</asp:RadioButton>

<asp:RadioButton id=RadioButton1 runat="server" Enabled="False" Checked='<%# !(bool)DataBinder.Eval(Container, "DataItem.Sex") %>' Text="女">

</asp:RadioButton>

</ItemTemplate>

<asp:RadioButton id=cbSex runat="server" Checked='<%# DataBinder.Eval(Container, "DataItem.Sex") %>' Text="男" GroupName="Sex">

</asp:RadioButton>

<asp:RadioButton id=RadioButton4 runat="server" Checked='<%# !(bool)DataBinder.Eval(Container, "DataItem.Sex") %>' Text="女" GroupName="Sex">

</asp:RadioButton>

</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>

<asp:HyperLinkColumn Text="点击查看" DataNavigateUrlField="StudentID" DataNavigateUrlFormatString="Show.aspx?ID={0}" DataTextField="StudentName" HeaderText="详细信息"></asp:HyperLinkColumn>

</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 WebForm1 : 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();

}

Web Form Designer generated code#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。

InitializeComponent();

base.OnInit(e);

}

/**//// <summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

{

this.dgShow.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgShow_PageIndexChanged);

this.dgShow.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_CancelCommand);

this.dgShow.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_EditCommand);

this.dgShow.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_UpdateCommand);

this.dgShow.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_DeleteCommand);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

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 = ((CheckBox)(e.Item.Cells[3].FindControl("cbSex"))).Checked?"1":"0";

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();

}