C#

<br />
System.ArgumentException: The row doesn't belong to the same DataSet as this relation.<br />
	at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)<br />
	at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos)<br />
	at System.Data.DataTable.AddRow(DataRow row, Int32 proposedID)<br />
	at System.Data.DataTable.AddRow(DataRow row) .. blah blah blah<br />

<br />
var dataSet = new MyDataSet();<br />
var parentTable = dataSet.Parent;<br />
var childTable = dataSet.Child;<br />
<br />
var relationshipName = "myrelationshipname";<br />
var oldRelationship = dataSet.Relations[relationshipName];<br />
<br />
dataSet.Relations.Remove(oldRelationship);<br />
<br />
//have to create these columns again because a column can't be a part of two different relationships ... :/<br />
var parentColumns = new List<DataColumn>();<br />
var childColumns = new List<DataColumn>();<br />
<br />
parentColumns.Add(parentTable.Columns["Column1"]);<br />
parentColumns.Add(parentTable.Columns["Column2"]);<br />
<br />
childColumns.Add(childTable.Columns["Column1"]);<br />
childColumns.Add(childTable.Columns["Column2"]);<br />
<br />
dataSet.Relations.Add(relationshipName, parentColumns.ToArray(), childColumns.ToArray(), false);<br />
<br />
this.FunctionToFillDataSet(dataSet, query);<br />

private void button2_Click(object sender, EventArgs e)
{
    if (txtAddRegistration.Text != "")
    {
        if (comboAircraft.Text != "")
        {
            if (comboAirline.Text != "")
            {
                if (comboLocation.Text != "")
                {
                    int picyesorno;
                    string picloc;
                    if (txtAddPicLoc.Text == "")
                    {
                        picyesorno = 0;
                        picloc = "";
                    }
                    else
                    {
                        picyesorno = 1;
                        picloc = txtAddPicLoc.Text;
                    }
                    string InsertRegCommand = "INSERT INTO SPOTTINGLOG (registration, aircraft, airline, location, date, pictured, picloc, comments) values('" + txtAddRegistration.Text + "','" + comboAircraft.Text + "','" + comboAirline.Text + "','" + comboLocation.Text + "'," + dateTimePicker1.Value.ToShortDateString() + "," + picyesorno + ",'" + picloc + "','" + txtAddComments.Text + "')";
                    string database = @"D:\Daniel\Documents\Visual Studio 2008\Projects\AviationSpottingLog\AviationSpottingLog\SpotData.sdf";
                    try
                    {
                        SqlCeConnection conn = new SqlCeConnection("Data Source=" + database);
                        conn.Open();
                        SqlCeCommand command = new SqlCeCommand();
                        command.Connection = conn;
                        command.CommandText = InsertRegCommand;
                        command.ExecuteNonQuery();
                        conn.Close();
                    }
                    catch
                    {

                    }
                    try
                    {
                        this.searchAfterAdd(txtAddRegistration.Text);
                    }
                    catch
                    {
                        MessageBox.Show("Search didnt work");
                    }
                    txtAddComments.Clear();
                    txtAddPicLoc.Clear();
                    txtAddRegistration.Clear();
                    comboAircraft.Text = "";
                    comboAirline.Text = "";
                    txtLabelAdded.Text = "Added";
                    AddStatus.Start();
                }
                else
                {
                    MessageBox.Show("You must enter a location.", "Insert Record", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                MessageBox.Show("You must enter an airline.", "Insert Record", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        else
        {
            MessageBox.Show("You must enter an aircraft type.", "Insert Record", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
    }
    else
    {
        MessageBox.Show("You must enter a registration.", "Insert Record", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }


}

private void searchAfterAdd(string param)
{
    this.spottingLogTableAdapter.Fill(this.spotSearchReg.SpottingLog, param);
}

private void btnSearch_Click(object sender, EventArgs e)
{
    if (txtSearchReg.Text != "")
    {
        this.spottingLogTableAdapter.Fill(this.spotSearchReg.SpottingLog, txtSearchReg.Text);
    }
    else
    {
        MessageBox.Show("Please enter a registration to search for.\n\nIf you would like to view records for specific Airports, Airlines and Aircraft, go to 'Browse Data Lists' on the top menu.", "Enter Search Criteria", MessageBoxButtons.OK, MessageBoxIcon.Error);

    }
}

private UdpClient myClient;
        private void button1_Click(object sender, EventArgs e)
        {
            myClient = new UdpClient(7777);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            myClient.Close();
        }