private void submitButton_Click(object sender, EventArgs e)
{
String sailorID = SIDTextBox.Text;
String boatID = BIDTextBox.Text;
String date = dateTextBox.Text;
try
{
String insertStmt = "insert into Reserves values(" + "'" + sailorID + "'" + "," + "'" + boatID + "'" + "," + "'" + date + "'" + ")";
SqlCommand cmd = new SqlCommand(insertStmt, DataBaseInfo.con);
cmd.ExecuteNonQuery();
cmd.Dispose();
String message = "Reservation was successfully added to database";
MessageBox.Show(message, date, MessageBoxButtons.OK, MessageBoxIcon.Information);
SIDTextBox.Clear();
BIDTextBox.Clear();
dateTextBox.Clear();
}
catch (Exception ex) {
MessageBox.Show(ex.Message, "Error Adding Reservation", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void submitButton_Click(object sender, EventArgs e)
{
String sailorID = SIDTextBox.Text;
String sailorName = sNameTextBox.Text;
String sailorRating = sRatingTextBox.Text;
String sailorAge = sAgeTextBox.Text;
try
{
String insertStmt = "insert into Sailors values(" + "'" + sailorID + "'" + "," + "'" + sailorName + "'" + "," + "'" + sailorRating + "'" + "," + "'" + sailorAge + "'" + ")";
SqlCommand cmd = new SqlCommand(insertStmt, DataBaseInfo.con);
cmd.ExecuteNonQuery();
cmd.Dispose();
String message = "Sailor successfully added to database";
MessageBox.Show(message, sailorName, MessageBoxButtons.OK, MessageBoxIcon.Information);
SIDTextBox.Clear();
sNameTextBox.Clear();
sRatingTextBox.Clear();
sAgeTextBox.Clear();
}
catch (Exception ex) {
MessageBox.Show(ex.Message, "Error Adding Sailor", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
