Populate Some Data into textbox ASP.NET Web Form

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" />

@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" />
<%--add this Triggers make btnAddCariAnggota to fired, if not use Triggers btnAddCariAnggota when click not fired--%>
"btnAddCariAnggota" />

3 Replies

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

Sachin Singh5y ago
Accepted 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();
}
}

}
}
}
+1
Tri Setia5y ago
@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" />


<%--add 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 Singh5y ago
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() + "'"
+1