private void button3_Click(object sender, EventArgs e)
{
Data123 p = new Data123();
p.Username = textBox1.Text;
p.Password = textBox2.Text;
p.FirstName = textBox3.Text;
p.LastName = textBox4.Text;
p.Position = textBox5.Text;
p.Lastaction = textBox6.Text;
b.Update(p);
}
// UPDATE
public void Update(Data123 p)
{
try
{
command.CommandText = "UPDATE Employee SET Username='******'" + p.FirstName + "," + " LastName=" + "'" + p.LastName + "," + " Position=" + "'" + p.Position + "," + " Lastaction=" + "'" + p.Lastaction + "'" + " WHERE Username="******"UPDATE Employee SET Username = WHERE id = ?";
command.CommandType = CommandType.Text;
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception)
{
//throw;
MessageBox.Show("Некоректни данни! Моля въведете отново!");
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
public void Insert(Data123 p)
{
try
{
command.CommandText = "INSERT INTO Employee([Username], [Password], [FirstName], [LastName], [Position], [Lastaction]) VALUES ("
//"'1','2', '1', '1','1', '1')";
+ "'" + p.Username + "', '" + p.Password + "' , '" + p.FirstName + "', '" + p.LastName + "', '" + p.Position + "', '" + p.Lastaction + "')";
command.CommandType = CommandType.Text;
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception)
{
//throw;
MessageBox.Show("Некоректни данни! Моля въведете отново!");
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}