ITPub博客

首页 > IT职业 > IT图书 > GridView实现单选(Single Selection)

GridView实现单选(Single Selection)

IT图书 作者:tomorrowcome 时间:2021-09-09 09:45:02 0 删除 编辑

一直很想写一个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 description for Member
/// 

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     Inherits="GridviewSingleSelection" %>

html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


    


    

    
    

    
        
            

                
                


                <!--Insus.NET:GridView有一个事件OnRowDataBound -->
                
                    
                        
                            
                            
                            
                               <!--Insus.NET:这里是重点部分,使用Literal控件装载HtmlInputRadioButton -->
                                
                            

                        

                        
                            
                            
                            
                                
                            

                        

                        
                            
                            
                            
                                
                            

                        

                        
                            
                            
                            
                                
                            

                        

                    

                

            

        

    

    


 

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 = "";
            }
        }
    }
}

 

好了,时间问题不再作过多讲解,如还有问题,请联系Insus.NET,程序重点部分有详细的注解。

 

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/875/viewspace-2806875/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2019-08-19

  • 博文量
    122
  • 访问量
    927