C#

string selectCommand = "SELECT COUNT..."; // ... for brevity
objDA = new OleDbDataAdapter( selectCommand, connection );
objDA.InsertCommand.CommandText = string.Format("Insert into tblProjects(SProjID, SProjName) Values('{0}', '{1}')", ProjID, ProjName);
objDA.InsertCommand.ExecuteNonQuery();

string selectCommand = "SELECT COUNT..."; // ... for brevity
objDA = new OleDbDataAdapter( selectCommand, connection );
objDA.InsertCommand = new OleDbCommand( "Insert into tblProjects(SProjID, SProjName) Values( ?, ?)", connection );
objDA.InsertCommand.Parameters.Add( "@SProjID", OleDbType.VarChar, 30, "SProjID" ).Value = ProjID;
objDA.InsertCommand.Parameters.Add( "@SProjName", OleDbType.VarChar, 30, "SProjName" ).Value = ProjName;
objDA.InsertCommand.ExecuteNonQuery();

For Each proc As Process In Process.GetProcesses()
    Try
        Debug.WriteLine(String.Format("{0} - {1}", proc.ProcessName, proc.MainModule.FileName))
    Catch ex As Exception
        Debug.WriteLine(String.Format("{0} - N/A", proc.ProcessName))
    End Try
Next

foreach (Process proc in Process.GetProcesses())
{ 
    try
    { 
        Debug.WriteLine(string.Format("{0} - {1}", proc.ProcessName, proc.MainModule.FileName)); 
    }
    catch (Exception ex)
    { 
        Debug.WriteLine(string.Format("{0} - N/A", proc.ProcessName)); 
    } 
}

ArrayList serverList = new ArrayList();
SQLDMO.Application dmo = new SQLDMO.Application();
SQLDMO.NameList nameList;
nameList=dmo.ListAvailableSQLServers();
foreach ( object svrName in nameList)
{
	string server = svrName.ToString();
	if (server == "(local)")
	{
		server = "localhost" ;
	}
	serverList.Add ( server ) ;
}

using System;
 
namespace MyClassNameDLL
{
    /// 
    /// Summary description for Class1.
    /// 
    public class MyClassName
    {
        public MyClassName()
        {
            //
            // TODO: Add constructor logic here
            //
        }
 
        public void Hi()
        {
            string szPassed = "Hi.";
        }
    }
}

MyClassName myClass = new MyClassName();
myClass.Hi();

ExpertComing wrote:

I am having no problem getting to the functions on the DLL, I have done what you stated above, but usually when you use a DLL you don't end up having to do things like MyClass.MyFunctions.

ExpertComing wrote:

Although I don't take offense to you saying I don't know how to code, I have to say you are wrong. I do my time in coding with ASP.NET applications

  NotifyIcon icon;<br />
<br />
        ...<br />
<br />
        private void Form1_Load(object sender, EventArgs e)<br />
        {<br />
            //initialize icon<br />
            icon = new NotifyIcon();<br />
            <br />
            // set the icon that will be seen in the system tray<br />
            icon.Icon = this.Icon;<br />
            <br />
            /// event handler for when user double clicks the icon<br />
            icon.DoubleClick += new                 System.EventHandler(this.notifyIcon1_DoubleClick);<br />
<br />
            //show the icon<br />
            icon.Visible = true;<br />
<br />
        }<br />
<br />
        private void button1_Click(object sender, EventArgs e)<br />
        {         <br />
            //hide the current form<br />
            this.Hide();   <br />
        }<br />
<br />
        private void notifyIcon1_DoubleClick(object sender, EventArgs e)<br />
        {<br />
            // show the form when the user double clicks the icon<br />
            this.Show();<br />
        }

// Hijack the windows message for minimizing the windowing so that
// you simply hide the window rather than close it. This gives the
// appearance of minimizing to the tray.
protected override void WndProc(ref System.Windows.Forms.Message m)
{
	if(m.Msg != 0x0010)
	{
		base.WndProc(ref m);
	}
	else
	{
		this.Hide();
	}
}