button! The Values of the textboxes should wrote

> Hello,
>
> I'm new in programming with ASP.NET 2.0 and I have a problem with the
> updating of the Grid View!
> I have one GridView with a connection to a database, three textboxes and a
> button! The Values of the textboxes should wrote
> down to the database, after clicking the button! That's worked, but the
> GridView don't show the Values after that! When I click
> the button the second time, then the GridView shows the Values, but he had
> then two records in the database of that value!
>
> Here is my Code:
>
> protected void Page_Load(object sender, EventArgs e)
> {
> string ConnectionString =
> "server=buero3;Trusted_Connection=yes;database=Personal";
> SqlConnection conn = new SqlConnection(ConnectionString);
>
> conn.Open();
>
> string Sql = "SELECT * FROM Mitarbeiter";
>
> SqlCommand cmd = new SqlCommand(Sql, conn);
> SqlDataReader reader = cmd.ExecuteReader();
>
> myGridView.DataSource = reader;
>
> DataBind();
>
> myGridView.GridLines = GridLines.Both;
>
> conn.Close();
>
> lblDatum.Text = DateTime.Now.ToString();
>
> txtName.Focus();
>
> }
> protected void btnAnmelden_Click(object sender, EventArgs e)
> {
> string ConnectionString =
> "server=buero3;Trusted_Connection=yes;database=Personal";
> SqlConnection conn = new SqlConnection(ConnectionString);
> SqlCommand cmd = new SqlCommand();
> cmd.Connection = conn;
> cmd.CommandText = "INSERT INTO Mitarbeiter (Name, Vorname,
> Abteilung) VALUES (@valName, @valVorname, @valAbteilung)";
> cmd.Parameters.Add("@valName", SqlDbType.VarChar, 50).Value =
> txtName.Text;
> cmd.Parameters.Add("@valVorname", SqlDbType.VarChar, 50).Value =
> txtVorname.Text;
> cmd.Parameters.Add("@valAbteilung", SqlDbType.VarChar, 50).Value =
> txtAbteilung.Text;
> conn.Open();
> cmd.ExecuteNonQuery();
> conn.Close();
>
>
> Regards,
> Sebastian
>
> P.S. Sry for my bad English! *g
>