I click on edit some times the modal popup brings wrong information.
currently when the page has just loaded the edit selection works well but after implementing search of the record it brings a different record.
please help
<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Forms/Site1.Master" CodeBehind="Student.aspx.vb" Inherits="UNIFORMSWEBAPP.Student" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<table class="auto-style4">
<tr>
<td class="auto-style3"> </td>
<td> </td>
</tr>
<tr>
<td class="auto-style3">
<div>
</div>
<div class="container">
<div class="table-responsive">
<asp:GridView ID="GridView1" AutoGenerateColumns="False" runat="server"
CssClass="table table-bordered table-hover table-striped thead-dark GridCustomers" Height="148px" style="font-size: small" Width="1050px">
<Columns>
<asp:BoundField DataField="admno" HeaderText="admno" />
<asp:BoundField DataField="Name" HeaderText="Name" />
<asp:BoundField DataField="Class" HeaderText="Class" />
<asp:BoundField DataField="Stream" HeaderText="Stream" />
<asp:BoundField DataField="House" HeaderText="House" />
<asp:BoundField DataField="Sex" HeaderText="Sex" />
<asp:BoundField DataField="Status" HeaderText="Status" />
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" href="#" data-target="#MyPopup" data-toggle="modal"
runat="server">Edit</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</div>
<div id="MyPopup" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
×</button>
<h4 class="modal-title">
Update Payments
</h4>
</div>
<div class="modal-body">
<table class="table table-bordered table-hover table-striped thead-dark">
<tr>
<td>
admno
</td>
<td>
<asp:TextBox runat="server" ID="admno" CssClass="form-control" />
</td>
</tr>
<tr>
<td>
Name
</td>
<td>
<asp:TextBox runat="server" ID="txtName" CssClass="form-control" />
</td>
</tr>
<tr>
<td>
Class
</td>
<td>
<asp:TextBox runat="server" ID="txtCountry" CssClass="form-control" />
</td>
</tr>
<tr>
<td>
Stream
</td>
<td>
<asp:DropDownList ID="Streamddl" runat="server" DataSourceID="SqlDataSource2" DataTextField="stream" DataValueField="stream"
CssClass="dropdown" AutoPostBack="true" OnSelectedIndexChanged="OnUpdate2000" >
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:UNIFORMConnectionString %>"
SelectCommand="SELECT * FROM [streamdata]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td>
Date
</td>
<td>
<asp:TextBox runat="server" ID="Date" CssClass="form-control" />
</td>
</tr>
<tr>
<td>
Cash
</td>
<td>
<asp:TextBox runat="server" ID="Pay" CssClass="form-control" />
</td>
</tr>
<tr>
<td>
Term
</td>
<td>
<asp:DropDownList ID="Termdll" runat="server" CssClass="form-control">
<asp:ListItem>NONE</asp:ListItem>
<asp:ListItem>TERMI</asp:ListItem>
<asp:ListItem>TERMII</asp:ListItem>
<asp:ListItem>TERMIII</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
Category
</td>
<td>
<asp:DropDownList ID="Categoryddl" runat="server" CssClass="form-control">
<asp:ListItem>NONE</asp:ListItem>
<asp:ListItem>SATURDAY</asp:ListItem>
<asp:ListItem>CLUBS</asp:ListItem>
<asp:ListItem>TRIPS</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
</table>
</div>
<div class="modal-footer">
<asp:Button ID="btnUpdate" Text="Update" runat="server" CssClass="btn btn-primary"
OnClick="OnUpdate" />
<input type="button" value="Close" class="btn btn-danger" data-dismiss="modal" />
</div>
</div>
</div>
</div>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css" />
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script type="text/javascript" src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/js/bootstrap.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<link href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.css" rel="stylesheet"
type="text/css" />
<script type="text/javascript">
$(function () {
$(".GridCustomers").DataTable({
bLengthChange: true,
lengthMenu: [[10, 15, -1], [10, 15, "All"]],
bFilter: true,
bSort: true,
bPaginate: true
});
$("[id*=lnkEdit]").click(function () {
$('[id*=admno]').val($(this).closest('tr').find('td').eq(0).html());
$('[id*=txtName]').val($(this).closest('tr').find('td').eq(1).html());
$('[id*=txtCountry]').val($(this).closest('tr').find('td').eq(2).html());
$('[id*=Streamddl]').val($(this).closest('tr').find('td').eq(3).html());
$('#MyPopup').modal('show');
return false;
});
});
</script>
</td>
</tr>
<tr>
<td class="auto-style3">
</td>
<td> </td>
</tr>
</table>
</asp:Content>
Imports System.Data.SqlClient
Imports System.Data
Public Class Student
Inherits System.Web.UI.Page
Dim constr As String = ConfigurationManager.ConnectionStrings("UNIFORMConnectionString").ConnectionString
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim constr As String = ConfigurationManager.ConnectionStrings("UNIFORMConnectionString").ConnectionString
Using con As New SqlConnection(constr)
Using cmd As New SqlCommand("SELECT*FROM Student", con)
Using sda As New SqlDataAdapter(cmd)
cmd.CommandType = CommandType.Text
Dim dt As New DataTable()
sda.Fill(dt)
GridView1.DataSource = dt
GridView1.DataBind()
GridView1.UseAccessibleHeader = True
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader
End Using
End Using
End Using
[Date].Text = Convert.ToDateTime(DateAndTime.Now).ToString("dd/MM/yyyy")
' Dim name As String = Streamddl.SelectedItem.Text
End If
End Sub
Protected Sub OnUpdate(ByVal sender As Object, ByVal e As EventArgs)
' Code to update the record.
Dim id As String = Request.Form("txtId")
Dim name As String = Request.Form("txtName")
Dim country As String = Request.Form("txtCountry")
Dim categoryad As String = Request.Form("admno")
' Categorym.Text = Request.Form("Categoryddl")
' Names.Text = name
' Countrys.Text = country
Streamddl.SelectedItem.Value = Request.Form("Streamddl")
Using Cont As New SqlConnection(constr)
Cont.Open()
Using cmd As New SqlCommand
cmd.Connection = Cont
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "Pushpay"
cmd.Parameters.Add("@a", SqlDbType.NVarChar).Value = admno.Text
cmd.Parameters.Add("@n", SqlDbType.NVarChar).Value = txtName.Text
cmd.Parameters.Add("@c", SqlDbType.NVarChar).Value = txtCountry.Text
cmd.Parameters.Add("@s", SqlDbType.NVarChar).Value = Streamddl.SelectedItem.Text
cmd.Parameters.Add("@d", SqlDbType.DateTime).Value = [Date].Text
cmd.Parameters.Add("@cs", SqlDbType.NVarChar).Value = Pay.Text
cmd.Parameters.Add("@t", SqlDbType.NVarChar).Value = Termdll.SelectedItem.Text
cmd.Parameters.Add("@ct", SqlDbType.NVarChar).Value = Categoryddl.SelectedItem.Text
cmd.ExecuteReader()
Cont.Close()
End Using
End Using
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), "showalert", "alert('Record Saved Successfully');window.location ='" + Request.Url.AbsoluteUri + "';", True)
GridView1.UseAccessibleHeader = True
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader
End Sub
Protected Sub OnUpdate2000(ByVal sender As Object, ByVal e As EventArgs) Handles Streamddl.SelectedIndexChanged
' Code to update the record.
Dim id As String = admno.Text
Dim name As String = Streamddl.SelectedItem.Text
Dim country As String = Request.Form("txtCountry")
Dim categoryad As String = Request.Form("admno")
End Sub
End Class
