How to populate data from Repeater to modal bootstrap in asp.net

Tri Setia

I will bind data from Repeater1 to modal. If user click LinkButton1 on Repeater1 I want the data populate to modal, but l’m din’t get the data although the modal is showing.

"Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
"Repeater1" runat="server">
"myTable" class="table table-hover table-responsive table-borderless">
class="table table-dark">
class="text-center">
Nomer ID
Tanggal Muat
Nama Driver
Nomer Lambung
Nomer DO
Jumlah Tonase Pengiriman
Tanggal Timbang Diport
Jumlah Tonase Penerimaan
Nomer CRF
Ngesub Ke Tambang
Selisih
Persentase
Pinalti
Keterangan
#
class="text-center">
"Label1" runat="server" Text='<%#Eval("no_id")%>'>
<%#Eval("tgl_muat", "{0: dd/MM/yyyy}")%>
<%#Eval("nama_driver")%>
<%#Eval("no_lambung")%>
<%#Eval("no_do")%>
<%#Eval("tonase_pengiriman")%>
<%#Eval("tgl_timbang_diport", "{0: dd/MM/yyyy}")%>
<%#Eval("tonase_penerimaan")%>
<%#Eval("no_crf")%>
<%#Eval("ngesub_ke_tambang")%>
<%#Eval("selisih")%>
<%#Eval("persentase") %>
<%#Eval("pinalti")%>
<%#Eval("keterangan")%>
"LinkButton1" OnClick="LinkButton1_Click" data-toggle="modal" data-target="#ModalDetilData" data-backdrop="static" class="fa fa-edit btn btn-warning btn-sm" runat="server"> Detail
"ModalDetilData" class="modal fade" data-keyboard="false" >
class="modal-dialog modal-lg">
class="modal-content">
class="modal-header bg bg-blue">
"center">
class="modal-title">Detail Data Coal

"button" class="close" data-dismiss="modal">

class="modal-body">

class="row">

class="col-md-12">

class="card">

class="card-body">

class="row">

class="col-md-6">

class="form-group">

for="NoID">

Nomer ID

"txtNoID" runat="server" CssClass="form-control"

placeholder="">

class="col-md-6">

class="form-group">

for="UserName">

Tanggal Muat

"txtDetailTanggalMuat" runat="server" CssClass="form-control"

placeholder=" Enter Tanggal Muat Dari Tambang">

class="col-md-6">

class="form-group">

for="Password">

Nama Driver

"txtDetilDataNamaDriver" runat="server" CssClass="form-control" placeholder="Enter Nama Driver">

class="col-md-6">

class="form-group">

for="UserName">

Nomer Lambung

"txtDetilDataNomerLambung" runat="server" CssClass="form-control" placeholder="Enter Nomer Lambung">

class="col-md-6">

class="form-group">

for="Password">

Nomer DO

"txtDetilDataNomerDO" runat="server" CssClass="form-control" placeholder="Enter Nomer DO">

class="col-md-6">

class="form-group">

for="UserName">

Jumlah Tonase Pengiriman

"txtDetilDataJumlahTonasePengiriman" runat="server" CssClass="form-control"

placeholder="Enter Jumlah Tonase Pengiriman">

class="col-md-6">

class="form-group">

for="Password">

Tanggal Timbang Diport

"txtDetailTanggalTimbangDiport" runat="server" CssClass="form-control"

placeholder="Enter Tanggal Timbang Diport">

class="col-md-6">

class="form-group">

for="UserName">

Jumlah Tonase Penerimaan

"txtDetilDataJumlahTonasePenerimaan" runat="server" CssClass="form-control"

placeholder="Enter Jumlah Tonase Penerimaan">

class="col-md-6">

class="form-group">

for="Password">

Nomer CRF

"txtDetilDataNomerCRF" runat="server" CssClass="form-control" placeholder="Enter Nomer CRF">

class="col-md-6">

class="form-group">

for="Password">

Ngesub Ke Tambang

"txtDetilDataNgesubKeTambang" runat="server" CssClass="form-control" placeholder="Enter Ngesub Ke Tambang">

class="col-md-6">

class="form-group">

for="UserName">

Selisih

"txtDetilDataSelisih" runat="server" CssClass="form-control" placeholder="Enter Selisih">

class="col-md-6">

class="form-group">

for="Password">

Persentase

"txtDetilDataPersentase" runat="server" CssClass="form-control" placeholder="Enter Persentase">

class="col-md-6">

class="form-group">

for="UserName">

Pinalti

"txtDetilDataPinalti" runat="server" CssClass="form-control" placeholder="Enter Pinalti">

class="col-md-12">

class="form-group">

for="Password">

Keterangan

"txtDetilDataKeterangan" TextMode="MultiLine" Height="150px" runat="server" CssClass="form-control" placeholder="Enter Keterangan">

class="col-md-6">

class="form-group">

"center">

"btnUpdateDataCoal" CssClass="btn btn-success btn-block" runat="server" Text="Update Data" OnClick="btnUpdateDataCoal_Click" />

class="col-md-6">

class="form-group">

"center">

"btnDeleteData" CssClass="btn btn-danger btn-block" runat="server" Text="Delete Data" OnClick="btnDeleteData_Click" />

public void ShowData()
{
using (SqlConnection con = new SqlConnection(koneksi))
{
using (SqlCommand sqlcmd = new SqlCommand())
{
con.Open();
sqlcmd.Connection = con;
sqlcmd.CommandType = CommandType.Text;
sqlcmd.CommandText = "Select * From dbo.tbl_coal";
SqlDataAdapter adp = new SqlDataAdapter(sqlcmd);
DataTable dt = new DataTable();
adp.Fill(dt);
Repeater1.DataSource = dt;
Repeater1.DataBind();
con.Close();
}
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int Id = Convert.ToInt32((item.FindControl("Label1") as System.Web.UI.WebControls.Label).Text);
using (SqlConnection con = new SqlConnection(koneksi))
{
using (SqlCommand sqlcmd = new SqlCommand("SPGetByID"))
{
con.Open();
sqlcmd.Connection = con;
sqlcmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adp = new SqlDataAdapter(sqlcmd);
SqlParameter param = new SqlParameter("@no_id", Id);
sqlcmd.Parameters.Add(param);
using (SqlDataReader rdr = sqlcmd.ExecuteReader())
{
while (rdr.Read())
{
txtNoID.Text = rdr["no_id"].ToString();
txtDetailTanggalMuat.Text = rdr["tgl_muat"].ToString();
txtDetilDataNamaDriver.Text = rdr["nama_driver"].ToString();
txtDetilDataNomerLambung.Text = rdr["no_lambung"].ToString();
txtDetilDataNomerDO.Text = rdr["no_do"].ToString();
txtDetilDataJumlahTonasePengiriman.Text = rdr["tonase_pengiriman"].ToString();
txtDetailTanggalTimbangDiport.Text = rdr["tgl_timbang_diport"].ToString();
txtDetilDataJumlahTonasePenerimaan.Text = rdr["tonase_penerimaan"].ToString();
txtDetilDataNomerCRF.Text = rdr["no_crf"].ToString();
txtDetilDataNgesubKeTambang.Text = rdr["ngesub_ke_tambang"].ToString();
txtDetilDataSelisih.Text = rdr["selisih"].ToString();
txtDetilDataPersentase.Text = rdr["persentase"].ToString();
txtDetilDataPinalti.Text = rdr["pinalti"].ToString();
txtDetilDataKeterangan.Text = rdr["keterangan"].ToString();
}
}
con.Close();
}
}
}

Any help could be appreciated

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
i can't guess what is wrong in your stored procedure, considering the SP is correct, modify the code as
using (SqlConnection con = new SqlConnection(koneksi))
    {
        using (SqlCommand cmd = new SqlCommand("SPGetByID", con))
        {


            cmd.CommandType = CommandType.StoredProcedure;
           cmd.Parameters.Addwithvalue("@no_id',Id);
          con.Open();



            using (SqlDataReader rdr = cmd.ExecuteReader())
            {
                while (rdr.Read())
                {
                    txtNoID.Text =Convert.ToString(rdr["no_id"]);
             ..........other ....
   }
}
Sachin Singh5y ago
replace the client script with this
ClientScript.RegisterStartupScript(this.GetType(),"pupup","openModal()",true);
there was an unnecessary semicolon and 'this' keyword caused the error.
Sachin Singh5y ago
step 1. Remove data-toggle from your link button
"LinkButton1" OnClick="LinkButton1_Click"  class="fa fa-edit btn btn-warning btn-sm" runat="server"> Detail

step 2. Add this script to aspx page
"text/javascript">
function openModal() {
$('#ModalDetilData').modal('show');
}
step 3. Modify your linkbutton event to open model as
protected void LinkButton1_Click(object sender, EventArgs e)
{
    RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
    int Id = Convert.ToInt32((item.FindControl("Label1") as System.Web.UI.WebControls.Label).Text);
    using (SqlConnection con = new SqlConnection(koneksi))
    {
        using (SqlCommand sqlcmd = new SqlCommand("SPGetByID"))
        {
            con.Open();
            sqlcmd.Connection = con;
            sqlcmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter adp = new SqlDataAdapter(sqlcmd);
            SqlParameter param = new SqlParameter("@no_id", Id);
            sqlcmd.Parameters.Add(param);
            using (SqlDataReader rdr = sqlcmd.ExecuteReader())
            {
                while (rdr.Read())
                {
                    txtNoID.Text = rdr["no_id"].ToString();
                    txtDetailTanggalMuat.Text = rdr["tgl_muat"].ToString();
                    txtDetilDataNamaDriver.Text = rdr["nama_driver"].ToString();
                    txtDetilDataNomerLambung.Text = rdr["no_lambung"].ToString();
                    txtDetilDataNomerDO.Text = rdr["no_do"].ToString();
                    txtDetilDataJumlahTonasePengiriman.Text = rdr["tonase_pengiriman"].ToString();
                    txtDetailTanggalTimbangDiport.Text = rdr["tgl_timbang_diport"].ToString();
                    txtDetilDataJumlahTonasePenerimaan.Text = rdr["tonase_penerimaan"].ToString();
                    txtDetilDataNomerCRF.Text = rdr["no_crf"].ToString();
                    txtDetilDataNgesubKeTambang.Text = rdr["ngesub_ke_tambang"].ToString();
                    txtDetilDataSelisih.Text = rdr["selisih"].ToString();
                    txtDetilDataPersentase.Text = rdr["persentase"].ToString();
                    txtDetilDataPinalti.Text = rdr["pinalti"].ToString();
                    txtDetilDataKeterangan.Text = rdr["keterangan"].ToString();
                }
            }
            con.Close();
        }
    }
ptManager.RegisterStartupScript(this,this.GetType(),"Pop", "openModal();", true);
}