Get ASP.Net GridView selected record using jQuery

makumbi

SOLVED CLOSED ACTIVE ANSWERED
User: makumbi
Posted: on Nov 04, 2022 11:22 PM
Forum: Data Controls
Answer: 1
Views: 990
Sample Code: Download

When i click on the name of the person i wanted it to the sound to have the room number as well but in my case it does not happen please help

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="CallPatient.aspx.vb" Inherits="SulaSignar.CallPatient" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css" />
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<asp:Button ID="Button1" runat="server" Text="Back Menu" />
<asp:GridView ID="gvProduct" runat="server" AutoGenerateColumns="False" Width="583px">
    <Columns>
        <asp:BoundField DataField="account" HeaderText="Account" />
        <asp:TemplateField HeaderText="Name">
            <ItemTemplate>
                <div>
                    <asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
                    <asp:LinkButton ID="lblVoice" runat="server"  CssClass="voice"><i class="fa fa-volume-down"></i></asp:LinkButton>
                </div>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Room No">
            <EditItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("acnos") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="RoomNo" runat="server" Text='<%# Bind("acnos") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>
    <script type = "text/javascript">
        function GetSelectedRow(UserLink) {
            var row = UserLink.parentNode.parentNode;
            var rowIndex = row.rowIndex - 1;
            var Userid = row.cells[0].innerHTML;
            alert("RowIndex: " + rowIndex + " Userid : " + Userid +"" );
            return false;
        }
    </script>
<script type="text/javascript">
    $(function () {
        if (!('speechSynthesis' in window)) {
            alert("You don't have speechSynthesis");
        }
        $('[id*=lblVoice]').on('click', function () {
            var term = $(this).closest('div').find('[id*=lblName]').html();
           var termroom = $(this).closest('div').find('[id*=RoomNo]').html();
        
            var termroomd ="Please Come to Room Number" 
            var voices = window.speechSynthesis.getVoices();
            var speech = new SpeechSynthesisUtterance();
            speech.voice = voices[2];
            speech.rate = 1;
            speech.pitch = 1;
            alert(term);
            speech.text = term + ' ' + termroomd + ' ' + termroom;
            speechSynthesis.speak(speech);
            return false;
        });
    });
</script>
    </form>
</body>
</html>

Imports System.Data
Imports System.Web.Services
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.Threading
Public Class CallPatient
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not Me.IsPostBack Then
            Dim conString As String = ConfigurationManager.ConnectionStrings("TRIALSIGNARConnectionString").ConnectionString
            Using con As SqlConnection = New SqlConnection(conString)
                Using cmd As SqlCommand = New SqlCommand("SELECT Account,Name,age,Phone,sex,stdtype,Category,acnos,	RANK () OVER (ORDER BY dates) Slot FROM Student WHERE CAST(Dates AS DATE) = CAST(GETDATE() AS DATE) AND ISNULL(rStatus,'') = ''", con)
                    Using sda As SqlDataAdapter = New SqlDataAdapter(cmd)
                        Using dt As DataTable = New DataTable()
                            sda.Fill(dt)
                            gvProduct.DataSource = dt
                            gvProduct.DataBind()
                        End Using
                    End Using
                End Using
            End Using
        End If
    End Sub

i would want to get this value contenated so that it can also be part of the sound

 var termroom = $(this).closest('div').find('[id*=RoomNo]').html();

Account	Name	Room No
05-00009	NASSANGA FLAVIA	1
05-00012	KILUNGI CHRISTINE	2
05-00010	AKATURINDA MACKLINE	NONE

Download FREE API for Word, Excel and PDF in ASP.Net

PrinceG

0 2

Reply
ANSWER
User: PrinceG
Replied: on Nov 05, 2022 01:01 AM
Report

Hi makumbi,

You need find for closest tr not div.

Please refer below sample.

SQL

CREATE TABLE [TextToSpeech]
(
	[Account] VARCHAR(20),
	[Name]  VARCHAR(20),
	[RoomNo] VARCHAR(20)
)

INSERT INTO [TextToSpeech] VALUES('05-00009','NASSANGA FLAVIA',1)
INSERT INTO [TextToSpeech] VALUES('05-000012','KILUNGI CHRISTINE',2)
INSERT INTO [TextToSpeech] VALUES('05-000010','AKATURINDA MACKLINE','None')

SELECT * FROM [TextToSpeech]
DROP TABLE [TextToSpeech]

HTML

<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css" />
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<asp:GridView ID="gvDetails" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Account" HeaderText="Account" />
        <asp:TemplateField HeaderText="Name">
            <ItemTemplate>
                <asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
                <asp:LinkButton ID="lblVoice" runat="server" CssClass="voice"><i class="fa fa-volume-down"></i></asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="RoomNo">
            <ItemTemplate>
                <asp:Label ID="lblRoomNo" runat="server" Text='<%# Eval("RoomNo") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>
<script type="text/javascript">
    $(function () {
        if (!('speechSynthesis' in window)) {
            alert("You don't have speechSynthesis");
        }
        $('[id*=gvDetails]').on('click', function () {
            debugger;
            var term = $(this).closest('tr').find('[id*=lblName]').html();
            var termroom = $(this).closest('tr').find('[id*=lblRoomNo]').html();
            var message = "Name:" + term;
            message += "\nRoom No:" + termroom;
            var voices = window.speechSynthesis.getVoices();
            var speech = new SpeechSynthesisUtterance();
            speech.voice = voices[0];
            speech.rate = 1;
            speech.pitch = 1;
            alert(message);
            speech.text = message;
            speechSynthesis.speak(speech);
            return false;
        });
    });
</script>

Namespaces

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

VB.Net

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindGrid();
    }
}

private void BindGrid()
{
    string constring = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM TextToSpeech", con))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    gvDetails.DataSource = dt;
                    gvDetails.DataBind();
                }
            }
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Me.BindGrid()
    End If
End Sub

Private Sub BindGrid()
    Dim constring As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constring)
        Using cmd As SqlCommand = New SqlCommand("SELECT * FROM TextToSpeech", con)
            Using sda As SqlDataAdapter = New SqlDataAdapter(cmd)
                Using dt As DataTable = New DataTable()
                    sda.Fill(dt)
                    gvDetails.DataSource = dt
                    gvDetails.DataBind()
                End Using
            End Using
        End Using
    End Using
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Get ASP.Net GridView selected record using jQuery

Company

Explore

Follow us

Contact Us