C#

DataTable GetDocs = new DataTable(Query);

public DataSet GetDocs

private DataSet Sds;
public DataSet GetDocs
{
get
{
return Sds;
}
set
{
Sds = value;
}

object GD = GetForm1.GetDocs;

private DataSet sds;
public DataSet GetDocs
{
get
{
    return sds;
}
set
{
    sds = value;
}

private DataSet sds;
public DataSet Sds
{
get
{
    return sds;
}
set
{
    sds = value;
}

string Query = ("SELECT * FROM [" + dataGridView1 + "]");
DataTable Sds = new DataTable(Query);
DataRow myNewRow;
myNewRow = Sds.NewRow();
Sds.Rows.Add(myNewRow);

private DataTable sds;
public DataTable Sds
        {
            get
            {
                return sds;
            }
            set
            {
                sds = value;
            }
        }

GetForm1 = new Form1();
object GD = GetForm1.Sds;
this.dataGridView1.DataSource = GD; 

SELECT * FROM [System.Windows.Forms.DataGridView]

bwood2020 wrote:

Right now I have it selecting all just to get the dgv on Form 2 to populate. Later the query will include a Select Distinct. Do you think this is a good way to do this or is there a more efficient method to code this?

string Query = ("SELECT * FROM [" + dataGridView1 + "]");
DataTable Sds = new DataTable(Query);
DataRow myNewRow;
myNewRow = Sds.NewRow();
Sds.Rows.Add(myNewRow);

string Query = ("SELECT * FROM [" + dataGridView1 + "]");
sds = new DataTable(Query);  <============= Here is the change, get rid of 'DataTable Sds' and replace it with just 'sds'
DataRow myNewRow;
myNewRow = Sds.NewRow();
Sds.Rows.Add(myNewRow);

sds = new DataTable(Query);

string Query = ("SELECT * FROM [" + dataGridView1 + "]");
DataTable Sds = new DataTable(Query);
DataRow myNewRow;
myNewRow = Sds.NewRow();
Sds.Rows.Add(myNewRow);

the code from the first link (modified for your tables)
sds = ReaderToDataTable(reader);

//create new dataTable and add new top row for new headers
                              DataTable newDataTable = new DataTable();

                              foreach (DataColumn col in dFill.Columns)
                              {
                                    try
                                    {
                                          newDataTable.Columns.Add(new DataColumn(col.ColumnName));

                                    }
                                    catch (Exception)
                                    {

                                    }
                              }
                              foreach (DataRow row in dFill.Rows)
                              {
                                    string[] rowarr = new string[dFill.Columns.Count];

                                    for (int k = 0; k < dFill.Columns.Count; k++)
                                    {
                                          rowarr[k] = row[k].ToString();
                                    }
                                    newDataTable.Rows.Add(rowarr);

                              }


                              DataRow NewRow;
                              NewRow = newDataTable.NewRow();
                              newDataTable.Rows.InsertAt(NewRow, 0);

// bindingSource1.DataSource = newDataTable;
bindingSource1.DataSource = dFill;

private Form2 docsForm = null;
private Form2 DocsForm
{
    get
    {
        if (this.docsForm == null)
        {
            this.docsForm = new Form2();
        }

        return docsForm;
    }
}

private void btnShowDocs_Click(object sender, EventArgs e)
{
                // ************************************
                // Only if there are to be many Form2s
                // ************************************
    Form2 DocsForm = new Form2();
                // ************************************

                DocsForm.DataKey = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
                DocsForm.Show();  // or .ShowDialog(), depends on whether need access to Form1 again before Form2 closes
}

public partial class Form2 : Form
{
    private bool dataDisplayed = false;

    public Form2()
    {
        InitializeComponent();
    }

    private void Form2_Load(object sender, EventArgs e)
    {
        this.LoadData();
    }

    private void LoadData()
    {
        // here will go the code to load the data into the datagrids

        this.dataDisplayed = true;
    }

    private string dataKey = string.Empty;
    public string DataKey
    {
        get
        {
            return this.dataKey;
        }

        set
        {
            if (this.dataKey != value)
            {
                this.dataKey = value;
                if (this.dataDisplayed)
                {
                    this.LoadData();
                }
            }
        }
    }
}

    private MappingsForm mappingsForm = null;
    private MappingsForm MappingsForm
    {
        get
        {
            if (this.mappingsForm == null)
            {
                this.mappingsForm = new MappingsForm();
            }

            return mappingsForm;
        }
    }

private void btnShowDocs_Click(object sender, EventArgs e)
{
        MappingsForm.DataKey = this.dataGridView1.Rows[0];
        MappingsForm.Show();
}

private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
    if (this.mappingsForm != null)
{
    this.mappingsForm.Dispose();
    this.mappingsForm = null;
}
}

public partial class MappingsForm : Form
{
    private bool dataDisplayed = false;

    public MappingsForm()
    {
        InitializeComponent();
    }

    private void MappingsForm_Load(object sender, EventArgs e)
    {
                if (this.dataKey != null)
                {
            this.LoadData();
                }
    }

    private void LoadData()
    {
        // this is part of your code, slightly modified
                for (int c = 0; c < this.dataKey.Columns.Count; c++)
                {
                    if(this.dataKey.Cells[c].Value.ToString() == "DocType")
                    {
                        //pass data to dgv1
                    }
                    else if (this.dataKey.Cells[c].Value.ToString() == "PurposeType") // else here to avoid unnecessary processing
                    {
                        //pass data to dgv2
                    }
                    else if (this.dataKey.Cells[c].Value.ToString() == "SomeOtherType") // else here to avoid unnecessary processing
                    {
                        // and so on
                    }

                    // This could also be written like this, so either have the ifs as above OR this
                    switch (this.dataKey.Cells[c].Value.ToString())
                    {
                        case "DocType":
                            //pass dataKey.Cells[c].Value to dgv1
                            break;
                        case "PurposeType":
                            //pass dataKey.Cells[c].Value to dgv2
                            break;
                        case "SomeOtherType":
                            // and so on
                            break;
                    }
                }
        this.dataDisplayed = true;
    }

    private DataGridViewRow dataKey = null;
    public DataGridViewRow DataKey
    {
        get
        {
            return this.dataKey;
        }

        set
        {
            if (this.dataKey != value)
        {
            this.dataKey = value;
            if (this.dataDisplayed)
            {
                this.LoadData();
            }
        }
        }
    }
}

SELECT * FROM TheThisTypeFile.csv
  WHERE DataType == "thisType"