一直很想写一个Gridview内实现单选功能,但是一直没有太多时间,近段时间多个网友问及此功能,只好抽出些少时间来实现,下面为实现过程。
效果如下,把选择的值使用javascript Alert:
数据源,在可用的数据库内创建一个表[Member] 并插入三笔测试记录:
View Code SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF OBJECT_ID ('[dbo].[Member]') IS NOT NULL
DROP TABLE [dbo].[Member]
GO
CREATE TABLE [dbo].[Member](
[MemberId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[Email] [nvarchar](100) NULL,
CONSTRAINT [PK__Member__0CF04B187F60ED59] PRIMARY KEY CLUSTERED
(
[MemberId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT INTO [dbo].[Member] ([Name],[Email]) VALUES ('John','john@it.com')
INSERT INTO [dbo].[Member] ([Name],[Email]) VALUES ('Jeny','Jeny@it.com')
INSERT INTO [dbo].[Member] ([Name],[Email]) VALUES ('Mike','Mike@it.com')
存过程:
View Code SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF OBJECT_ID ('[dbo].[usp_GetMember]') IS NOT NULL
DROP PROCEDURE [dbo].[usp_GetMember]
GO
CREATE PROCEDURE [dbo].[usp_GetMember]
AS
SELECT [MemberId],[Name],[Email] FROM [dbo].[Member]
GO
Member.cs 类别:
View Code sing System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
/// <summary>
/// Summary description for Member
/// </summary>
namespace Insus.NET
{
public class Member
{
BusinessBase objBusinessBase = new BusinessBase();
public Member()
{
//
// TODO: Add constructor logic here
//
}
public DataTable GetMember()
{
return objBusinessBase.GetDataToDataSet("usp_GetMember").Tables[0];
}
}
}
GridviewSingleSelection.aspx:
View Code <%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridviewSingleSelection.aspx.cs"
Inherits="GridviewSingleSelection" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div>
<asp:Button ID="ButtonSingleSelect" runat="server" Text="GetGridViewRasioSelectedValue" OnClick="ButtonSingleSelect_Click" />
<p />
<!--Insus.NET:GridView有一个事件OnRowDataBound -->
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowDataBound="GridView1_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="选择">
<HeaderStyle BorderWidth="1" BorderColor="#c0c0c0" />
<ItemStyle BorderWidth="1" BorderColor="#c0c0c0" />
<ItemTemplate>
<!--Insus.NET:这里是重点部分,使用Literal控件装载HtmlInputRadioButton -->
<asp:Literal ID="Literal1" runat="server"></asp:Literal>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ID">
<HeaderStyle BorderWidth="1" BorderColor="#c0c0c0" />
<ItemStyle BorderWidth="1" BorderColor="#c0c0c0" />
<ItemTemplate>
<%# Eval("MemberId") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<HeaderStyle BorderWidth="1" BorderColor="#c0c0c0" />
<ItemStyle BorderWidth="1" BorderColor="#c0c0c0" />
<ItemTemplate>
<%# Eval("Name") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Email">
<HeaderStyle BorderWidth="1" BorderColor="#c0c0c0" />
<ItemStyle BorderWidth="1" BorderColor="#c0c0c0" />
<ItemTemplate>
<%# Eval("Email") %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</form>
</body>
</html>
GridviewSingleSelection.aspx.cs:
View Code using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Insus.NET; //Insus.NET:要引用名称空间
public partial class GridviewSingleSelection : System.Web.UI.Page
{
//Insus.NET: new Member一个实例
Member objMember = new Member();
protected void Page_Load(object sender, EventArgs e)
{
Data_Binding();
}
private void Data_Binding()
{
this.GridView1.DataSource = objMember.GetMember();
this.GridView1.DataBind();
}
protected void ButtonSingleSelect_Click(object sender, EventArgs e)
{
//Insus.NET: 判断用户是否有选择,如果没有选择return
if (Request.Form["InsusRadio1"] == null) return;
//Insus.NET: 把选择的值存到ViewState,你可以把它存任何可以保留的变量中,呵呵
ViewState["SelectedValue"]= Request.Form["InsusRadio1"].ToString();
//Insus.NET: 下面类别,你可以从Insus.NET博客中下载
InsusJsUtility objJs = new InsusJsUtility();
objJs.JsAlert(ViewState["SelectedValue"].ToString());
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//Insus.NET: 判断Literal控件是否存在,如果没有写此判断,程式有可能在找不到时抛出异常
if (e.Row.FindControl("Literal1") != null)
{
//Insus.NET:找到了,把对象转为控件。
Literal literal = (Literal)e.Row.FindControl("Literal1");
//Insus.NET: 下面这个是把表主键的值赋给变量value。如果你想取GridView的索引,可以使用e.Row.RowIndex.ToString()
string value = DataBinder.Eval(e.Row.DataItem, "MemberId").ToString(); //e.Row.RowIndex.ToString();
//Insus.NET: 把HtmlInputRadioButton绑定至Literal控件上。
literal.Text = "<input id=\"InsusRadio1\" type=\"radio\" name=\"InsusRadio1\" value=\"" + value + "\" />";
}
}
}
}
好了,时间问题不再作过多讲解,如还有问题,请联系Insus.NET,程序重点部分有详细的注解。