how to insert textbox value i.e eid in the form of date format and also 5digit number into a database by using asp.net with c#

string str = ConfigurationManager.AppSettings["constring"];
       SqlConnection con = new SqlConnection(str);



       SqlCommand cmd = new SqlCommand("insert_register", con);
       cmd.CommandType = CommandType.StoredProcedure;
       SqlParameter p1 = new SqlParameter("@EID", SqlDbType.Int);
       p1.Direction = ParameterDirection.Output;

       SqlParameter p2 = new SqlParameter("@ENAME", SqlDbType.VarChar);
       p2.Value = TextBox1.Text;
       SqlParameter p3 = new SqlParameter("@EPASSWORD", SqlDbType.VarChar);
       p3.Value = TextBox2.Text;
       SqlParameter p4 = new SqlParameter("@EREPASSWORD", SqlDbType.VarChar);
       p4.Value = TextBox3.Text;
       SqlParameter p5 = new SqlParameter("@EMAILID", SqlDbType.VarChar);
       p5.Value = TextBox4.Text;
       SqlParameter P6 = new SqlParameter("@Status", SqlDbType.VarChar);
       P6.Value = Rdbtnstatus.Text;
       SqlParameter p7 = new SqlParameter("@Verify", SqlDbType.VarChar);
       p7.Value = Rdbtnverify.Text;

       cmd.Parameters.Add(p1).Value=Convert.ToInt32(TextBox5.Text);
       cmd.Parameters.Add(p2);
       cmd.Parameters.Add(p3);
       cmd.Parameters.Add(p4);
       cmd.Parameters.Add(p5);
       cmd.Parameters.Add(P6);
       cmd.Parameters.Add(p7);


       con.Open();
       //cmd.ExecuteNonQuery();
        SqlDataReader dr;

       dr = cmd.ExecuteReader();

       if (dr.HasRows==false)
       {
         dr.Close();
       if (cmd.ExecuteNonQuery() > 0)
       {
      Label1.Text = "inserted..!";
      }
      }
      else
      {


      while (dr.Read())
      {
      TextBox1.Text = dr[0].ToString();
      TextBox2.Text = dr[1].ToString();
      TextBox3.Text = dr[2].ToString();
      TextBox4.Text = dr[3].ToString();

       Rdbtnstatus.Text = dr[3].ToString();
      Rdbtnverify.Text = dr[4].ToString();

      Label1.Text = "already existed......";
      }

       }



       con.Close();
       dr.Close();
       Random r = new Random();
       Lblmsg.Text = r.Next(10000, 100000).ToString();
       string str1 = DateTime.Now.Year.ToString();
       string str2 = DateTime.Now.ToString();
       String[] a = str2.Split('/');
       StringBuilder sb = new StringBuilder();
       sb.Append(a[0]);
       sb.Append(a[1]);
       TextBox5.Text = sb+str1+ r.Next(10000,100000).ToString();

      // string s = TextBox5.Text;

      // string str3 = s(0, 12);//u get the first 4 digits

      // int number = Convert.ToInt32(s);
       }
       }