GridView实现单选(Single Selection)

一直很想写一个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 />
                
                <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>
                               
                                <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，程序重点部分有详细的注解。

posted @ 2011-04-26 15:28 Insus.NET 阅读(3260) 评论(2) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

Insus.NET

放下一切乘云去，坐起云端观落日。

GridView实现单选(Single Selection)

公告