Popup open but data not showing

Bhavesh Vankar

SqlConnection con = new SqlConnection(this.con);
            SqlCommand selectcmd = new SqlCommand("SELECT NAME, ADDRESS FROM RESTICTIED_PERSON WHERE NAME ='" + TextBox1.Text + "'",con);
            SqlDataAdapter sda = new SqlDataAdapter(selectcmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            if (dt.Rows.Count > 0)
            {
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "showModal();", true);
                lbluname.Text = dt.Rows[0]["NAME"].ToString();
                lbluaddress.Text = dt.Rows[0]["ADDRESS"].ToString();

            }

i have used below code to open modal popup using bootstrap 4.5 issue is modal is open when i type text and lost focus from textbox but record not showing in lable kindly support me to solve this what to do and what issue can be in program...?

6 Replies

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

Bhavesh Vankar5y ago
i have added one extra textbox in my main project.
when i try to open by that textbox popup not open but when i click on modal button popup open and data also show...
but when i use this same code in main textbox txtlname.text its not show anything after open popup modal.
modal open by txtlname.text but record not show...
Bhavesh Vankar5y ago
what is issue sir ?
i can't understand...
i have copy paste this code but still not working...
its working in my other practicle program but when i implement in my main project it working stop....
what to do ?
Sachin Singh5y ago
if you have not closed it explicitly anywhere then it is fine to not open it because the Fill() method takes care of opening and closing the connection, so yes, it does not matter.
ok, I got the issue.
just copy-paste the below code, it will work for 100 %.
SqlConnection con = new SqlConnection(this.con);
            SqlCommand selectcmd = new SqlCommand("SELECT NAME, ADDRESS FROM RESTICTIED_PERSON WHERE NAME ='" + TextBox1.Text + "'",con);
            SqlDataAdapter sda = new SqlDataAdapter(selectcmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            if (dt.Rows.Count > 0)
            {
lbluname.Text = dt.Rows[0]["NAME"].ToString();
                lbluaddress.Text = dt.Rows[0]["ADDRESS"].ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "showModal();", true);


            }
Bhavesh Vankar5y ago
but when i use this code in my practicle its working fine and when i implement in my main project its working stop...
Why would that be?
Bhavesh Vankar5y ago
yes i have not used open and close connection
Sachin Singh5y ago
Are you sure you have opened the connection? and getting rows from database, because i can not see the open statement.
it should be
DataTable dt = new DataTable();
con.Open();
sda.Fill(dt);