C#

 private void ConnectOracleDB()
        {
            string sqlstring = string.Empty;
            Logger myLogger = new Logger();
            

            string myConnectionString = GenerateConnectionString();
            OracleConnection myConnection = new OracleConnection();
            myConnection.ConnectionString = myConnectionString;

            try
            {
                myLogger.AddtoLogFile("Trying to connect Oracle DB", "Page Load");
                myConnection.Open();                
            }
            catch (Exception ex)
            {
                myLogger.AddtoLogFile(ex.Message, "Connecting to Oracle DB");
            }

            //execute queries
            myConnection.Close();

        }

private string GenerateConnectionString()
        {
            return "Data Source=( DESCRIPTION = ( ADDRESS_LIST = ( ADDRESS = ( PROTOCOL = TCP )( HOST = {server ip} )( PORT = 1521 ) ) )( CONNECT_DATA = ( SERVER = DEDICATED )( SERVICE_NAME = {db name}) ) ); User Id= abcd; Password = 1234;";
        }

CRobert456 wrote:

- the number of questions on the actual exam, does the number vary between exams?

CRobert456 wrote:

- duration of the exam, i.e. max time allowed

CRobert456 wrote:

- the format of the answers: all are multiple choice (A,B,C,D)? Some sources claim that selected answers are fill-in, or drag-drop, is it true?

SELECT ResourceName FROM [SP2010_EDCStaffing_AppDB].[dbo].[Tempname] where not exists
(select Resourcename from Stafftracking  where StaffTracking.id = Tempname.id);

using System;
using System.Configuration;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

namespace StaffingWebParts.VisualWebPart1
{
    public partial class VisualWebPart1UserControl : UserControl
    {
       public SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLStaffingConn"].ConnectionString);
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("Name");
                
                SqlDataReader myReader = null;
                SqlCommand cmd = new SqlCommand("select Name FROM [SP2010_EDCStaffing_AppDB].[dbo].[Tempname] where not exists (select * FROM [SP2010_EDCStaffing_AppDB].[dbo].StaffTracking WHERE tempname.Name = Stafftracking.ResourceName)");            
                         
                cmd.Connection = conn;
                conn.Open();
                myReader = cmd.ExecuteReader();
                while (myReader.Read())
                {
                    DataRow dr = dt.NewRow();
                    dr[0] = myReader["Name"].ToString();
                                                 
                    dt.Rows.Add(dr);
                }
                          
                GridView1.DataSource = dt;
                GridView1.DataBind();
                conn.Close();
            }
        }
       
      }
    }

DataTable dt = new DataTable();

string line = null;

int i = 0;

 

using (StreamReader sr = File.OpenText(@"c:\temp\table1.csv"))

{   

      while ((line = sr.ReadLine()) != null)

      {

            string[] data = line.Split(',');

            if (data.Length > 0)

            {

                  if (i == 0)

                  {

                  foreach (var item in data)

                  {

                        dt.Columns.Add(new DataColumn());

                  }

                  i++;

             }

             DataRow row = dt.NewRow();

             row.ItemArray = data;

             dt.Rows.Add(row);

             }

      }

}

using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConsoleApplication3.Properties.Settings.daasConnectionString"].ConnectionString))

{

      cn.Open();

      using (SqlBulkCopy copy = new SqlBulkCopy(cn))

      {

            copy.ColumnMappings.Add(0, 0);

            copy.ColumnMappings.Add(1, 1);

            copy.ColumnMappings.Add(2, 2);

            copy.ColumnMappings.Add(3, 3);

            copy.ColumnMappings.Add(4, 4);

            copy.DestinationTableName = "Censis";

            copy.WriteToServer(dt);

      }

}  

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Globalization;
using System.IO;
using System.Windows.Forms;

private static char[] Colon = new char[] { ',' };
private DataTable QueryStaff()
{
    const int nameColumnIndex = 1;
    const int hoursColumnIndex = 2;

    using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConsoleApplication3.Properties.Settings.daasConnectionString"].ConnectionString))
    using (var cmd = new SqlCommand("", conn))
    using (var dataAdapter = new SqlDataAdapter(cmd))
    using (var cmdBuilder = new SqlCommandBuilder(dataAdapter))
    {
        // create temporary table in database
        cmd.CommandText = "CREATE TABLE #TempTable(Name nvarchar(100) NOT NULL, Hours decimal(6, 2) NOT NULL);";
        cmd.ExecuteNonQuery();

        // create a DataTable and let the DataAdapter create appropriate columns for it
        DataTable dataTable = new DataTable();
        cmd.CommandText = "SELECT * FROM #TempTable;";
        dataAdapter.Fill(dataTable);

        // read the CSV-records into the DataTable
        dataTable.BeginLoadData();
        using (StreamReader reader = File.OpenText(@"c:\temp\table1.csv"))
        {
            string line;
            if (reader.ReadLine() != null) // skip first line (headers)
            {
                while ((line = reader.ReadLine()) != null)
                {
                    string[] columns = line.Split(Colon, StringSplitOptions.None);

                    DataRow row = dataTable.NewRow();
                    row["Name"] = columns[nameColumnIndex];
                    row["Hours"] = Decimal.Parse(columns[hoursColumnIndex], NumberFormatInfo.InvariantInfo);
                    dataTable.Rows.Add(row);
                }
            }
        }
        dataTable.EndLoadData();

        // insert the records from the DataTable into the temporary table
        dataAdapter.Update(dataTable);

        // load the result of the "main purpose" query into the DataTable
        dataTable.Clear();
        cmd.CommandText = "SELECT Tmp.Name, SUM(Tmp.Hours) FROM #TempTable AS Tmp WHERE NOT EXISTS (SELECT * FROM Stafftracking AS ST WHERE Tmp.Name = ST.Name) GROUP BY Tmp.Name;";
        dataAdapter.Fill(dataTable);

        return dataTable;
    }
}

// and then somewhere:
GridView1.DataSource = QueryStaff();
GridView1.DataBind();