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

using System;
using System.Collections.Generic;
using System.Text;

namespace sudoku
{
    class sudoku
    {
        private int[] values_right = new int[81];

        private int[] squareindex = new int[81] {0, 0, 0, 1, 1, 1, 2, 2, 2,
                                                 0, 0, 0, 1, 1, 1, 2, 2, 2,
                                                 0, 0, 0, 1, 1, 1, 2, 2, 2,
                                                 3, 3, 3, 4, 4, 4, 5, 5, 5,
                                                 3, 3, 3, 4, 4, 4, 5, 5, 5, 
                                                 3, 3, 3, 4, 4, 4, 5, 5, 5, 
                                                 6, 6, 6, 7, 7, 7, 8, 8, 8, 
                                                 6, 6, 6, 7, 7, 7, 8, 8, 8, 
                                                 6, 6, 6, 7, 7, 7, 8, 8, 8};

        private int[] posible_values = new int[9] { 1, 2, 3, 4, 5, 6, 7, 8, 9 };

        public sudoku()
        {
            this.generate();
        }

        public void generate()
        {
            /*
            int[] values = {8, 4, 6, 3, 5, 1, 7, 9, 2, 
                            5, 1, 3, 9, 2, 7, 4, 6, 8, 
                            7, 9, 2, 6, 8, 4, 1, 3, 5,
                            4, 3, 8, 5, 7, 9, 6, 2, 1, 
                            1, 7, 9, 2, 4, 6, 5, 8, 3, 
                            2, 6, 5, 8, 1, 3, 9, 7, 4, 
                            6, 8, 1, 7, 3, 5, 2, 4, 9, 
                            9, 2, 4, 1, 6, 8, 3, 5, 7, 
                            3, 5, 7, 4, 9, 2, 8, 1, 6};
            */


            Random rnd = new Random();
            int i;
           


            for (i = 0; i < 81; i++)
            {
                while (this.values_right[i] == 0)
                    this.values_right[i] = rnd.Next(1, 90) % 10;


                while (check_position(i) == 0)
                {
                    this.values_right[i] = (this.values_right[i] + 1) % 10;

                }
            }

        }

        public int[] get_values_right()
        {
            return values_right;
        }

        int check_position(int i)
        {
            if (this.values_right[i] == 0)
                return 0;

            Random rnd = new Random();
            int row = i - (i % 9);
            int col = i % 9;
            int position;

             for (position = row; position < row + 9; position++)
            {
                if (position == i)
                    continue;

                if (this.values_right[position] == this.values_right[i])
                    return 0;
            }

           /*for (position = col; position < 80; position += 9)
            {
                if (position == i)
                    continue;

                if (this.values_right[position] == this.values_right[i])
                    return 0;
            }*/


            return 1;
        }
    }
}