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.
- <!-- This is method for show data on the Repeater1 -->
- 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();
- }
- }
- }
- <!-- This is method for bind data from Repeater1 to Modal-->
- 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