/*****
* Purpose: Save textbox info as a record.
*
* Parameter list:
* object sender control that caused the event
* EventArgs e details about the sender
*
* Return value:
* void
******/
private void btnSave_Click(object sender, EventArgs e)
{
int status;
int flag;
int i;
string sqlCommand;
string[] colNames = new string[MAXCOLUMNS];
clsDB myDB = new clsDB(dbName);
myDB.GetColumnInfo(colNames, dbTableName);
if (chkStatus.Checked == true)
{
status = 1;
}
else
{
status = 0;
}
// Build INSERT command
sqlCommand = "INSERT INTO " + dbTableName + " (";
for (i = 1; i < colNames.Length; i++)
{
if (colNames[i] == null)
{
break;
}
sqlCommand += colNames[i] + ",";
}
i = sqlCommand.LastIndexOf(',');
sqlCommand = sqlCommand.Substring(0, i) + ") VALUES ('";
// Now add the values
sqlCommand += txtFirstName.Text + "','" +
txtMI.Text + "','" +
txtLastName.Text + "','" +
txtAddr1.Text + "','" +
txtAddr2.Text + "','" +
txtCity.Text + "','" +
txtState.Text + "','" +
txtZip.Text + "','" +
txtHome.Text + "','" +
txtCell.Text + "','" +
txtWork.Text + "','" +
txtEmail.Text + "','" +
txtBirthday.Text + "','" +
txtAnniversary.Text + "'," +
status.ToString() + ")";
flag = myDB.ProcessCommand(sqlCommand);
if (flag == 1)
{
MessageBox.Show("Record added successfully.");
}
else
{
MessageBox.Show("Failed to add data.", "Process Error");
}
}