textbox validation is not successful

See more:

C#

ASP.NET

SQL-Server

, +

hi,
in Page_Load Event some information store in textboxes.in fact he see his profile information for editing.when i change some textboxes information for example i change jack to alex and click save changes button jack were save in DataBase.i do not know what is wrong.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Drawing;
 
namespace Sanjesh_begin_8_farvardin
{
    public partial class EditProfile : System.Web.UI.Page
    {
        public string constring = "server=localhost;database=SanjeshOrganizationDB;Trusted_Connection=true";
        protected void Page_Load(object sender, EventArgs e)
        {
            
            SqlConnection con0 = new SqlConnection(constring);
            con0.Open();
            SqlCommand com0 = new SqlCommand("select * from Profile_Information where Username='"+Session["Username"].ToString()+"'",con0);
            SqlDataReader rdr = com0.ExecuteReader();
            rdr.Read();
            TextBox1.Text = rdr["Username"].ToString();
            TextBox2.Text = rdr["FName"].ToString();
            TextBox3.Text = rdr["LName"].ToString();
            DropDownList1.SelectedItem.Value = "1391";
            DropDownList2.SelectedItem.Value = "01";
            DropDownList3.SelectedItem.Value = "01";
            TextBox4.Text = rdr["LiveLocation"].ToString();
            TextBox5.Text = rdr["Email_Address"].ToString();
            TextBox6.Text = rdr["Reason_For_Registering"].ToString();
            TextBox7.Text = rdr["Liking_Field"].ToString();
            TextBox8.Text = rdr["Optional_Comment"].ToString();
            con0.Close();
        }
 
        protected void Button1_Click(object sender, EventArgs e)//Save changes
        {   
            SqlConnection con0 = new SqlConnection(constring);
            con0.Open();
            SqlCommand com0 = new SqlCommand("Update Profile_Information Set FName='" + TextBox2.Text + "',LName='" + TextBox3.Text + "',BirthDate='"+DropDownList1.SelectedItem+"-"+DropDownList2.SelectedItem+"-"+DropDownList3.SelectedItem+"',LiveLocation='"+TextBox4.Text+"',Email_Address='"+TextBox5.Text+"',Reason_For_Registering='"+TextBox6.Text+"',Liking_Field='"+TextBox7.Text+"',Optional_Comment='"+TextBox8.Text+"' where Username='" + TextBox1.Text + "'", con0);
            try
            {
                com0.ExecuteNonQuery();
                Label12.Visible = true;
                Label12.Text = "Successfull";
                Label12.ForeColor = Color.Green;
            }
            catch
            {
                Label12.Visible = true;
                Label12.Text = "Error";
                Label12.ForeColor = Color.Red;
            }
        }
    }
}