public void makeIndividualOnlineQuizTracker()
{
try
{
userName = UserInformation.getUserName();
QuizNo = UserInformation.getQuizNo();
// step 1: Create a connection
var result = Path.GetFullPath("InformationDatabase.mdf");
string strConnection = "Data Source=.\\sqlexpress;AttachDbFilename=" + result + ";User Instance=true; Integrated Security=True;Pooling=False;MultipleActiveResultSets=true";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
string strCommand = "insert into IndividualOnlineQuizTracker values( @QN , @UN )";
SqlCommand objCommand = new SqlCommand(strCommand, objConnection);
objCommand.Parameters.Add(new SqlParameter("@QN", QuizNo));
objCommand.Parameters.Add(new SqlParameter("@UN", userName));
objCommand.ExecuteNonQuery();
objConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
