C#

<br />
                System.Windows.Forms.ListView.ColumnHeaderCollection coloane = listView1.Columns;<br />
                foreach (ColumnHeader header in coloane)<br />
                {<br />
                   listView1.Columns.Add(header.Text);<br />
                   <br />
                }<br />
                listView1.Clear();

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
        }

    }
}