[Solved] ASP.Net Error: Incorrect syntax near )

I have an error with this code while trying to insert new record into database table, as shown below:

Incorrect syntax near ')' 

Code Behind:

public partial class NewTeamSignup : System.Web.UI.Page
{
    SqlCommand cmd = new SqlCommand();
    SqlDataAdapter sda = new SqlDataAdapter();
    DataSet ds = new DataSet();
    SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");

    protected void Button1_Click(object sender, EventArgs e)
    {
        string CreatedBy = GetCreatedBy(Convert.ToInt32(Request.QueryString["Uid"]));
        using (SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True"))
        {
            using (SqlCommand cmd = new SqlCommand("INSERT INTO Users VALUES(@email,@pass,@con_pass,@UserRole,@CreatedBy,@CreateDate)"))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.Parameters.AddWithValue("@email", mailtxtbx.Text.Trim());
                    cmd.Parameters.AddWithValue("@pass", pass.Text.Trim());
                    cmd.Parameters.AddWithValue("@con_pass", conpass.Text.Trim());
                    cmd.Parameters.AddWithValue("@UserRole", 'U');
                    cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy);
                    cmd.Parameters.AddWithValue("@CreateDate", DateTime.Now);
                    cmd.Connection = con;
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
        }
    }

    private string GetCreatedBy(int id)
    {
        string CreatedBy = "";
        using (SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True"))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT Uid FROM Users WHERE Uid = @Id)"))
            {
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.AddWithValue("@Id", id);
                cmd.Connection = con;
                con.Open();
                CreatedBy = Convert.ToString(cmd.ExecuteScalar());
                con.Close();
            }
        }

        return CreatedBy;
    }
}