In popup modal page record not showing

Bhavesh Vankar

string namestring = txtfname.Text + " " + txtmname.Text + " " + txtlname.Text;
//        string firstlastname = txtfname.Text + " " + txtlname.Text;

        if (txtfname.Text != "" && txtlname.Text != "")
        {
            SqlConnection con2 = new SqlConnection(this.con2);
            con2.Open();
            SqlCommand cmd = new SqlCommand("Select NAME,ADDRESS,CITYORVILLAGE,TALUKA,DISTRICT,CONTACTNO From Student_Records where NAME Like '" + namestring + "'", con2);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            sda.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "showModal();", true);
                lblName.Text = dt.Rows[0]["NAME"].ToString();
                lblAddress.Text = dt.Rows[0]["ADDRESS"].ToString();
                lblCityvillage.Text = dt.Rows[0]["CITYORVILLAGE"].ToString();
                lblTaluka.Text = dt.Rows[0]["TALUKA"].ToString();
                lblDistrict.Text = dt.Rows[0]["DISTRICT"].ToString();
                lblContactno.Text = dt.Rows[0]["CONTACTNO"].ToString();

            }

i have wriiten code as below. when the name is exist in table than modal should be open and display details related entered name in textbox. below code is working fine in my another practicle program but when i try to implement in my main project its not working modal open but record not showing. what to do in this case ?

where is i made mistake ?

their is also one more query i in table name stored in one column and i have split in textbox from table.

what to do if only split firstname and lastname from sql to textboxes....

i have split it like " string namestring = txtfname.Text + " " + txtmname.Text + " " + txtlname.Text;"

3 Replies

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

Bhavesh Vankar5y ago
then how to do this if user enter name in textbox and if student name is in block table than popup should be open and should be display details of blocked student like student image, name, address etc...

their is may query the student full name is stored in table in single column..

1) our requirment is if user enter the name in three part like firstname middlename and last in text three textboxes if name is match in block table than popup should be open with blocked student details.

2) Popup should be also open if user only enter first and last name in textbox

3) if user enter only first character of firstname middlename and surname in lastname than also should be open popup.

how to do this ?
Sachin Singh5y ago
!IsPostback means the code written inside that will only execute for the first request and not for any button click etc.
Sachin Singh5y ago
test this
string namestring = txtfname.Text + " " + txtmname.Text + " " + txtlname.Text;
//        string firstlastname = txtfname.Text + " " + txtlname.Text;

        if (txtfname.Text != "" && txtlname.Text != "")
        {
            SqlConnection con2 = new SqlConnection(this.con2);
            con2.Open();
            SqlCommand cmd = new SqlCommand("Select NAME,ADDRESS,CITYORVILLAGE,TALUKA,DISTRICT,CONTACTNO From Student_Records where NAME Like '" + namestring + "'", con2);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            sda.Fill(dt);
            if (dt.Rows.Count > 0)
            {

                lblName.Text = dt.Rows[0]["NAME"].ToString();
                lblAddress.Text = dt.Rows[0]["ADDRESS"].ToString();
                lblCityvillage.Text = dt.Rows[0]["CITYORVILLAGE"].ToString();
                lblTaluka.Text = dt.Rows[0]["TALUKA"].ToString();
                lblDistrict.Text = dt.Rows[0]["DISTRICT"].ToString();
                lblContactno.Text = dt.Rows[0]["CONTACTNO"].ToString();

            }
  ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "showModal();", true);