CIS407 Final

Need your ASSIGNMENT done? Use our essay writing service to score better and meet your deadline.

Order a Similar Paper Order a Different Paper


Question 3515 pts

(TCO 5, 6, 9) Discuss the importance of implementing transactions in web applications. Describe the COMMIT, and ROLLBACK command. In the following SaveEmployee function below, add code to insert the first name, last name, and pay rate into the tblEmployee table. In the database the column names are: FirstName, LastName, PayRate. Also, write the code to commit the transaction.
public static bool SaveEmployee(string Database, string FirstName, string LastName, string PayRate)
bool recordSaved;
OleDbTransaction myTransaction = null;
OleDbConnection conn = new OleDbConnection(“PROVIDER=Microsoft.ACE.OLEDB.12.0;” +”Data Source=” +Database);
OleDbCommand command = conn.CreateCommand();
string strSQL;

myTransaction = conn.BeginTransaction();
command.Transaction = myTransaction;

// Write the code below to insert the first name, last name, and pay rate into the tblEmployee table

// Add your comments here
command.CommandType = CommandType.Text;
command.CommandText = strSQL;

// Add your comments here

// Write the code below to commit the transaction

// Add your comments here

recordSaved = true;
catch (Exception ex)

recordSaved = false;

return recordSaved;


HTML EditorKeyboard Shortcuts




Question 3615 pts

(TCO 8, 9) Explain Secure Sockets Layer, authentication, and authorization. Discuss advantages of using validation controls and discuss the RequiredFieldValidator and the RegularExpressionValidator in particular.