protected void btnPromeni_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConfigurationManager.ConnectionStrings["Konekcija"].ConnectionString; SqlCommand komanda = new SqlCommand(); komanda.Connection = connection; komanda.CommandText += @" INSERT INTO KorisnikNivo (Naziv) VALUES ('" + tbNaziv.Text + "') ; "; try { connection.Open(); komanda.ExecuteNonQuery(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Корисничкото ниво е додадено!');", true); } finally { connection.Close(); } DS_Korisnici.DataBind(); GridView1.DataBind(); }
protected void btnPromeni_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConfigurationManager.ConnectionStrings["Konekcija"].ConnectionString; SqlCommand komanda = new SqlCommand(); komanda.Connection = connection; komanda.CommandText += @" INSERT INTO Korisnik (KorisnickoIme, Lozinka, KorisnikNivo_Id) VALUES ('" + tbKorisnickoIme.Text + "', '" + tbLozinkata.Text + "', " + ddlNivo.SelectedValue + ") ; "; try { connection.Open(); komanda.ExecuteNonQuery(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Корисникот е додаден!');", true); } finally { connection.Close(); } DS_Korisnici.DataBind(); GridView1.DataBind(); }