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();
                }
            }
        }
    }
}