C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private SqlConnection OpenConnection()
        {
            SqlConnection myConnection = null;
            string connectionString = "Integrated Security=SSPI;" + "Initial Catalog=Sales;" + "Data Source=PC-HERE\\SQLEXPRESS;";
             
            try
            {
                myConnection = new SqlConnection(connectionString);
                myConnection.Open();
                //MessageBox.Show("Connection OK!");
                return myConnection;   
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error in connection: " + ex.Message);
                myConnection = null;
                return myConnection;
            }
        }
        
        public void AddRow(SqlConnection myConnection, long memNum)
        {
            //FUNCTION SUMMARY
            //----------------
            //Adds a new row to the Members Table in the database
            //Only for new members
            //END SUMMARY
            
            //--------- UPDATE THE 3 BELOW TO LOOP ----------//
            //Update Database Table - Members
            DataSet mySet = new DataSet();
            string selectString = "INSERT INTO Members ([Member Number]) VALUES (" + memNum + ")";
            SqlCommand myCommand = myConnection.CreateCommand();
            myCommand.CommandText = selectString;
            SqlDataAdapter myAdapter = new SqlDataAdapter();
            myAdapter.SelectCommand = myCommand;
            myAdapter.Fill(mySet, "Members");

            //Update Database Table - Sales
            mySet = new DataSet();
            selectString = "INSERT INTO Sales ([Member Number]) VALUES (" + memNum + ")";
            myCommand = myConnection.CreateCommand();
            myCommand.CommandText = selectString;
            myAdapter = new SqlDataAdapter();
            myAdapter.SelectCommand = myCommand;
            myAdapter.Fill(mySet, "Sales");

            //Update Database Table - Location
            mySet = new DataSet();
            selectString = "INSERT INTO Location ([Member Number]) VALUES (" + memNum + ")";
            myCommand = myConnection.CreateCommand();
            myCommand.CommandText = selectString;
            myAdapter = new SqlDataAdapter();
            myAdapter.SelectCommand = myCommand;
            myAdapter.Fill(mySet, "Location");
            //--------END LOOP-------//
            myConnection.Close();

            int hi = 0; // For breakpoint
        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {

        }

        private void AddTruck_Click(object sender, EventArgs e)
        {
            long memNum = long.Parse(txtMemNum.Text);
            SqlConnection myConnection = new SqlConnection();
            myConnection = OpenConnection();
            AddRow(myConnection, memNum);
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void txtMemNum_TextChanged(object sender, EventArgs e)
        {
            // THIS MODULE UPDATES THE DATAGRIDVIEW UPON TYPING
            long memNum = long.Parse(txtMemNum.Text);
            SqlConnection myConnection = new SqlConnection();
            
            DataSet tableSet = new DataSet();
            string selectString = "SELECT * FROM Members WHERE [Member Number] LIKE '" + memNum + "%'";
            myConnection = OpenConnection(); 
            SqlCommand myCommand = myConnection.CreateCommand();
            myCommand.CommandText = selectString;
            SqlDataAdapter myAdapter = new SqlDataAdapter();
            myAdapter.SelectCommand = myCommand;
            
            //Do I need to set tableSet to something before running the next line?
            DataTable myTable = tableSet.Tables["Members"];
            
            int hi = 0; // For Breakpoint
        }

    }
}

<br />
string TargetMachine = textBox2.Text;<br />
<br />
<br />
System.Management.ManagementScope oMs = new<br />
<br />
System.Management.ManagementScope("\\\\" + TargetMachine + "\\root\\microsoftdfs");<br />
oMs.Connect();<br />
<br />
System.Management.ObjectQuery oQuery = new System.Management.ObjectQuery("SELECT * FROM DfsrReplicatedFolderInfo"); //WHERE ReplicationGroupName='" + comboBox6.Text + "'");<br />
<br />
ManagementObjectSearcher oSearcher = new<br />
<br />
ManagementObjectSearcher(oMs, oQuery);<br />
<br />
ManagementObjectCollection MgmtObject = oSearcher.Get();<br />
<br />
<br />
foreach (ManagementObject item in MgmtObject)<br />
{<br />
<br />
    //Get an input parameters object for this method<br />
    //ManagementBaseObject inParams = item.GetMethodParameters("GetVersionVector");<br />
<br />
    //Fill in input parameter values<br />
    //inParams["CommandLine"] = "calc.exe";<br />
<br />
    //Execute the method<br />
    ManagementObject outParams = (ManagementObject)item.InvokeMethod("GetVersionVector", null);<br />
<br />
    //Display results<br />
    //Note: The return code of the method is provided in the "returnValue" property of the outParams object<br />
    MessageBox.Show(outParams.ToString());<br />
}<br />