C#

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();

Norris Chappell wrote:

I was going to be working on this all weekend.

Norris Chappell wrote:

and let you know how it comes out

Norris Chappell wrote:

I am going to ask my Manager to send me to some C# classes.

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



namespace StaffingWebParts.VisualWebPart1
{
    public partial class VisualWebPart1UserControl : UserControl
    {
        private static char[] Colon = new char[] { ',' };
        private DataTable QueryStaff()
        {
            const int nameColumnIndex = 1;
            const int hoursColumnIndex = 2;

            using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLStaffingConn"].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:\Users\pzd74f\Downloads\FinalLabor2015.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);

             //   gvNewResource.DataSource = dt;
             //   gvNewResource.DataBind();
                return dataTable;
            }
            
        }

    }
}