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();
}
