OleDbCommand command = new OleDbCommand();
command.Connection = conn;
command.CommandText = "Update tablename set Imeprezime=?, EMB=?, Adresa=?, RegBr=?, GarBr=?, ZapBr=?, DataKaz=?, DataDosp=?, OdzDok=?, Platil=?, DataPlak=?, Kontrolor=? where Rbr=?"; command.Parameters.AddWithValue("@imeprez", txtImePrez.Text); command.Parameters.AddWithValue("@EMB", txtEmb.Text); command.Parameters.AddWithValue("@adresa", txtAdresa.Text); command.Parameters.AddWithValue("@RegBr", txtReg.Text); command.Parameters.AddWithValue("@GarBr", Convert.ToInt32(txtGbr.Text)); command.Parameters.AddWithValue("@ZapBr", txtZap.Text); command.Parameters.AddWithValue("@DataKaz", dateTimePicker1.Value.Date);
string dateInString = Convert.ToString(dateTimePicker1.Value);
DateTime startDate = DateTime.Parse(dateInString);
if (Convert.ToString(startDate.DayOfWeek) == "Friday") { startDate = startDate.AddDays(3); } else if (Convert.ToString(startDate.DayOfWeek) == "Saturday") { startDate = startDate.AddDays(2); } else if (Convert.ToString(startDate.DayOfWeek) == "Sunday") { startDate = startDate.AddDays(1); }
DateTime expiryDate = startDate.AddDays(10); dateTimePicker2.Value = expiryDate;
command.Parameters.AddWithValue("@DataDosp", dateTimePicker2.Value); command.Parameters.AddWithValue("@OdzDok", txtDok.Text); command.Parameters.AddWithValue("@Platil", checkBox1.Checked); command.Parameters.AddWithValue("@DataPlak", dateTimePicker3.Value.Date); command.Parameters.AddWithValue("@Kontr", txtKontr.Text); command.Parameters.AddWithValue("@rbr", comboBox1.SelectedIndex); conn.Open(); command.ExecuteNonQuery(); conn.Close();
try { conn.Open(); _dataSet.Clear(); OleDbDataAdapter oleDBDataAdapter1 = new OleDbDataAdapter(new OleDbCommand("Select * from Kazneni order by Imeprezime asc", conn)); command.ExecuteNonQuery(); oleDBDataAdapter1.Fill(_dataSet, "Kazneni"); }
finally { conn.Close();
}