Populate Some Data into textbox ASP.NET Web Form

Question

hi guys.. l'm try to popupate some data from database but always fail. I want if the btnAddCariAnggota click will show just nama_anggota not show all row in database. Any help could be appriaciate. this is the tbl_anggota CREATE TABLE [dbo].[tbl_anggota]( [id_anggota] [ varchar ](50) NOT NULL , [nama_anggota] [ varchar ](50) NULL , [alamat] [ varchar ](350) NULL , [no_telpon] [ varchar ](50) NULL , [saldo] [ bigint ] NULL , CONSTRAINT [PK_tbl_anggota] PRIMARY KEY CLUSTERED ( [id_anggota] ASC ) WITH (PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [ PRIMARY ] ) ON [ PRIMARY ] this is .aspx class = "col-md-6" > class = "form-group" > for = "id_anggota" > ID Anggota class = "input-group" > "txtid_anggota" runat= "server" CssClass= "form-control" placeholder= "Enter ID Anggota" > class = "input-group-append" > "UpdatePanel1" runat= "server" > "btnAddCariAnggota" CssClass= "btn btn-warning" runat= "server" Text= "Cari Data Anggota" OnClick= "btnAddCariAnggota_Click" /> class = "col-md-6" > class = "form-group" > for = "nama_anggota" > Nama Anggota "txtnama_anggota" runat= "server" CssClass= "form-control" placeholder= "Enter Nama Anggota" ReadOnly= "true" > this code bihind protected void btnCariAnggota_Click( object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(koneksi)) { using (SqlCommand sqlcmd = new SqlCommand( "Select * from tbl_anggota where id_anggota='" + txtid_anggota.Text.Trim() + "'" ,con)) { con.Open(); sqlcmd.Connection = con; using (SqlDataReader rdr = sqlcmd.ExecuteReader()) { while (rdr.Read()) { txtnama_anggota.Text = rdr[ "nama_anggota" ].ToString(); } } con.Close(); } } }

Sachin Singh · Answer

test this protected void btnCariAnggota_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(koneksi)) { using (SqlCommand sqlcmd = new SqlCommand( "Select nama_anggota from tbl_anggota where id_anggota=@Id" ,con)) { sqlcmd.Parameters.AddWithValue( "@Id" ,txtid_anggota.Text.Trim()); con.Open(); using (SqlDataReader rdr = sqlcmd.ExecuteReader()) { while (rdr.Read()) { txtnama_anggota.Text = rdr[ "nama_anggota" ].ToString(); } } } } }

Tri Setia · Answer

@Sachin Singh @Satendra Singh thanks so much for the answer sir,, the problem solved use this code. protected void btnAddCariAnggota_Click( object sender, EventArgs e) { string id_anggota = txtid_anggota.Text.Trim(); using (SqlConnection con = new SqlConnection(koneksi)) { using (SqlCommand sqlcmd = new SqlCommand( "spCariNamaAnggota" )) { con.Open(); sqlcmd.Connection = con; sqlcmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(sqlcmd); SqlParameter param = new SqlParameter( "@id_anggota" , id_anggota); sqlcmd.Parameters.Add(param); using (SqlDataReader rdr = sqlcmd.ExecuteReader()) { while (rdr.Read()) { txtnama_anggota.Text = rdr[ "nama_anggota" ].ToString(); } } con.Close(); } } } the store prosedure USE [db_koperasi] GO /****** Object: StoredProcedure [dbo].[spCariNamaAnggota] Script Date : 29/05/2021 23.48.03 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[spCariNamaAnggota] @id_anggota varchar (50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; -- Insert statements for procedure here SELECT nama_anggota From dbo.tbl_anggota where id_anggota=@id_anggota END and add trigger on updatePanel class = "col-md-6" > class = "form-group" > for = "id_anggota" > ID Anggota class = "input-group" > "txtid_anggota" runat= "server" CssClass= "form-control" placeholder= "Enter ID Anggota" > class = "input-group-append" > "UpdatePanel1" runat= "server" > "btnAddCariAnggota" CssClass= "btn btn-warning" runat= "server" Text= "Cari Data Anggota" OnClick= "btnAddCariAnggota_Click" /> this Triggers make btnAddCariAnggota to fired, if not use Triggers btnAddCariAnggota when click not fired--%> "btnAddCariAnggota" /> class = "col-md-6" > class = "form-group" > for = "nama_anggota" > Nama Anggota "txtnama_anggota" runat= "server" CssClass= "form-control" placeholder= "Enter Nama Anggota" ReadOnly= "true" >

Satendra Singh · Answer

however your code should work but if it is failing try to change your SQL query as below. "Select nama_anggota from tbl_anggota where id_anggota='" + txtid_anggota.Text.Trim() + "'"