C# Console app error --> The parameter data type of UInt16 is invalid

------------------------- C# CODE -------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Management;
using System.Data.SqlClient;
 
namespace CollectEPData
{
    class Program
    {
        public string wkstn;
        public string Wkstn
        {
            get { return wkstn; }
            set { wkstn = value; }
        }
 
        static void Main()
        {
            string filename = @"C:\CollectEPData.txt";
            StreamWriter sw = new StreamWriter(filename, false);
 
            // Create WrkstnList collection using List Class
            List<Program> WrkstnList = new List<Program>();
 
            SqlConnection conn = new SqlConnection(SettingsManager.ConnectionString2);
            try
            {
                conn.Open();
 
                string sqlStr = "SELECT Name FROM dbo.Nodes";
                SqlCommand sqlCmd = new SqlCommand(sqlStr, conn);
                sqlCmd.CommandType = System.Data.CommandType.Text;
 
                SqlDataReader rdr = null;
                rdr = sqlCmd.ExecuteReader();
 
                // Let's check to make sure data
                // is in the database "main" table
                if (rdr.HasRows)
                {
                    while (rdr.Read())
                    {
                        Program client = new Program();
                        client.Wkstn = rdr.GetString(0);
                        WrkstnList.Add(client);                       
                    }
 
                    rdr.Close();
                }
 
                conn.Close();
 
                if (WrkstnList.Count > 0 )
                {
 
                    // For each client in the WrkstnList collection,
                    // lets connect to it and retrieve WMI data, and then
                    // store in parameters list to send and update DB.
                    foreach (Program client in WrkstnList)
                    {
                        // authentication settings needed for WMI Connection
                        // Impersonate - uses the credentials of the caller.
                        // Packet - packet level COM authentication
                        ConnectionOptions mgmtOptions = new ConnectionOptions();
                        mgmtOptions.Impersonation = ImpersonationLevel.Impersonate;
                        mgmtOptions.Authentication = AuthenticationLevel.Packet;
                        mgmtOptions.EnablePrivileges = true;
                        mgmtOptions.Username = "Domain\Username";
                        mgmtOptions.Password = "password";
 
                        /* computer path and connection authentication
                         * options passed to th ManagementScope object
                         * named "scope" which then uses the connect
                         * method to pass in parameters and connect to
                         * the computers WMI Scope.
                         */
                        ManagementScope scope = new ManagementScope("\\\\" + client.Wkstn + "\\root\\cimV2", mgmtOptions);
                        scope.Connect();
 
                        // Management WMI Query to return the specific Hardware data 
                        // using Win32 API Calls.
                      ObjectQuery queryCS = new ObjectQuery("SELECT * FROM Win32_ComputerSystem");
                      ObjectQuery queryNA = new ObjectQuery("SELECT * FROM Win32_NetworkAdapter WHERE DeviceID = 1");
 
                        // ManagementObjectSearcher - retrieves a collection of management objects
                        // based on the specified query.
                        ManagementObjectSearcher csObjSearcher = new ManagementObjectSearcher(scope, queryCS);
                        ManagementObjectSearcher naObjSearcher = new ManagementObjectSearcher(scope, queryNA);
 
                        SqlConnection conn2 = new SqlConnection(SettingsManager.ConnectionString1);
                        SqlCommand sqlCmd2 = new SqlCommand("usp_InsertToPCDATA", conn2);
                        sqlCmd2.CommandType = System.Data.CommandType.StoredProcedure;
 
                            // Invokes the specificed WMI Query and returns the resulting
                            // collection. ManagementObject - represents a WMI 
                            // "Win32_ComputerSystem" Instance
                            foreach (ManagementObject csObjQueried in csObjSearcher.Get())
                            {
                                try
                                {
                                    sqlCmd2.Parameters.AddWithValue("WorkstationName", csObjQueried["Name"]);
                                    sqlCmd2.Parameters.AddWithValue("UserName", csObjQueried["UserName"]);
                                    sqlCmd2.Parameters.AddWithValue("Domain", csObjQueried["Domain"]);
                                    sqlCmd2.Parameters.AddWithValue("WakeUpType", csObjQueried["WakeUpType"]);
                                    sqlCmd2.Parameters.AddWithValue("Status", csObjQueried["Status"]);
                                }
                                catch (Exception ex)
                                {
                                    sw.WriteLine("No Win32_ComputerSystem WMI Data returned for " + client.Wkstn + ".\nError is " +
                                            ex.Message);
                                    sw.Flush();
                                }
                            }
 
                            // Invokes the specificed WMI Query and returns the resulting
                            // collection. ManagementObject - represents a WMI 
                            // "Win32_NetworkAdapter" Instance
                            foreach (ManagementObject naObjQueried in naObjSearcher.Get())
                            {
                                try
                                {
                                    sqlCmd2.Parameters.AddWithValue("MAC Address: {0}", naObjQueried["MACAddress"]);
                                }
                                catch (Exception ex)
                                {
                                    sw.WriteLine("No Win32_NetworkAdapter WMI Data returned for " + client.Wkstn + ".\nError is " +
                                            ex.Message);
                                    sw.Flush();
                                }
                            }
 
                            //Open a DB connection...send the data and close it
                            try
                            {
                                conn2.Open();
                                sqlCmd2.ExecuteNonQuery();
                            }
                            catch (Exception ex)
                            {
                                sw.WriteLine("Couldn't open connection to update\n WMI information to the Database.\nError message: "
                                                + ex.Message);
                                sw.Flush();
                            }
                            finally
                            {
                                conn.Close();
                            }
                    }
                }
            }
            catch
            {
                Console.WriteLine("Database connection failed.");
            }
            sw.Close();
            Console.ReadLine();
        }
    }
}
------------------------------- STORED PROCEDURE --------------------------------------
USE [PCDATA]
GO
 
/****** Object:  StoredProcedure [dbo].[usp_InsertToPCDATA]    Script Date: 04/14/2009 09:25:46 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
-- =============================================
-- Author:		Wally Davis
-- Create date: April 13, 2009
-- Description:	
-- =============================================
 
CREATE PROCEDURE [dbo].[usp_InsertToPCDATA]
	-- Add the parameters for the stored procedure here
	--@ID int OUTPUT,
	@WorkstationName varchar(15),
	@UserName varchar(15),
	@Domain varchar(50),
	@WakeUpType tinyint = NULL,
	@MacAddress varchar(17),
	@WkstnStatus varchar(10) = NULL
AS
If @WorkstationName is not null
BEGIN
	INSERT INTO Main(WorkstationName, UserName, Domain, WakeUpType, MacAdress, WkstnStatus)
	Values (@WorkstationName, @UserName, @Domain, @WakeUpType, @MacAddress, @WkstnStatus)
	--SET @ID = SCOPE_IDENTITY()
END
ELSE
BEGIN
	UPDATE Main 
		SET WorkstationName = @WorkstationName, 
			UserName = @UserName,
			Domain = @Domain, 
			WakeUpType = @WakeUpType,
			MacAdress = @MacAddress, 
			WkstnStatus = @WkstnStatus
	--WHERE PcDataID = @ID
END
 
GO

Select allOpen in new window