C#

private void btnSave_Click(object sender, EventArgs e)
      {
          update.PerformClick();
          SqlCeConnection connection = new SqlCeConnection();
          connection.ConnectionString = @"Data Source=C:\Users\Dell\Desktop\DataGridView\PMinfo.sdf";
          SqlCeCommand myCommand = new SqlCeCommand();
          myCommand.Connection = connection;

          connection.Open();
          //Clearing data table
          myCommand.CommandText = "DELETE FROM PMinfo";
          connection.Close();

          myCommand.CommandText = @"INSERT into [PMinfo] (Number, CostCenter, pType, ServiceType, Receiver, WorkCenter, Start, [End], Remaining, Status, ReceiveDate) values(@Number, @CostCenter, @pType, @ServiceType, @Receiver, @WorkCenter, @Start, @End, @Remaining, @Status, @ReceiveDate)";
          connection.Open();
          for (int i = 0; i < dataGridView1.Rows.Count; i++)
          {
              myCommand.Parameters.AddWithValue("@Number", dataGridView1.Rows[i].Cells[0].Value);
              myCommand.Parameters.AddWithValue("@CostCenter", dataGridView1.Rows[i].Cells[1].Value);
              myCommand.Parameters.AddWithValue("@pType", dataGridView1.Rows[i].Cells[2].Value);
              myCommand.Parameters.AddWithValue("@ServiceType", dataGridView1.Rows[i].Cells[3].Value);
              myCommand.Parameters.AddWithValue("@Receiver", dataGridView1.Rows[i].Cells[4].Value);
              myCommand.Parameters.AddWithValue("@WorkCenter", dataGridView1.Rows[i].Cells[5].Value);
              myCommand.Parameters.AddWithValue("@Start", dataGridView1.Rows[i].Cells[6].Value);
              myCommand.Parameters.AddWithValue("@End", dataGridView1.Rows[i].Cells[7].Value);
              myCommand.Parameters.AddWithValue("@Remaining", dataGridView1.Rows[i].Cells[8].Value);
              myCommand.Parameters.AddWithValue("@Status", dataGridView1.Rows[i].Cells[9].Value);
              myCommand.Parameters.AddWithValue("@ReceiveDate", dataGridView1.Rows[i].Cells[10].Value);


              myCommand.ExecuteNonQuery();
          }
          connection.Close();
      }

System.ArgumentException: 'The SqlCeParameter with this name is already contained by this SqlCeParameterCollection.'

Alex Dunlop wrote:

I reviewed the loop but I couldn't find out the reason

<pre lang="c#">myCommand.Parametes.Clear();

private void btnSave_Click(object sender, EventArgs e)
        {
            update.PerformClick();
            SqlCeConnection connection = new SqlCeConnection();
            connection.ConnectionString = @"Data Source=C:\Users\Dell\Desktop\DataGridView\PMinfo.sdf";
            SqlCeCommand myCommand = new SqlCeCommand();
            myCommand.Connection = connection;

            connection.Open();
            myCommand.CommandText = "Delete From PMinfo";
            myCommand.ExecuteNonQuery();
            connection.Close();

           myCommand.CommandText = @"INSERT into [PMinfo] (Number, CostCenter, pType, ServiceType, Receiver, WorkCenter, Start, [End], Remaining, Status, ReceiveDate) values(@Number, @CostCenter, @pType, @ServiceType, @Receiver, @WorkCenter, @Start, @End, @Remaining, @Status, @ReceiveDate)";
            connection.Open();
            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                myCommand.Parameters.Clear();
                myCommand.Parameters.AddWithValue("@Number", dataGridView1.Rows[i].Cells[0].Value);
                myCommand.Parameters.AddWithValue("@CostCenter", dataGridView1.Rows[i].Cells[1].Value);
                myCommand.Parameters.AddWithValue("@pType", dataGridView1.Rows[i].Cells[2].Value);
                myCommand.Parameters.AddWithValue("@ServiceType", dataGridView1.Rows[i].Cells[3].Value);
                myCommand.Parameters.AddWithValue("@Receiver", dataGridView1.Rows[i].Cells[4].Value);
                myCommand.Parameters.AddWithValue("@WorkCenter", dataGridView1.Rows[i].Cells[5].Value);
                myCommand.Parameters.AddWithValue("@Start", dataGridView1.Rows[i].Cells[6].Value);
                myCommand.Parameters.AddWithValue("@End", dataGridView1.Rows[i].Cells[7].Value);
                myCommand.Parameters.AddWithValue("@Remaining", dataGridView1.Rows[i].Cells[8].Value);
                myCommand.Parameters.AddWithValue("@Status", dataGridView1.Rows[i].Cells[9].Value);
                myCommand.Parameters.AddWithValue("@ReceiveDate", dataGridView1.Rows[i].Cells[10].Value);


                myCommand.ExecuteNonQuery();
            }
           
            connection.Close();
        }

SqlCeConnection connection = new SqlCeConnection();
            connection.ConnectionString = @"Data Source=C:\Users\Dell\Desktop\DataGridView\PMinfo.sdf";

            SqlCeCommand myCommand = new SqlCeCommand(@"INSERT into [PMinfo] (Number, CostCenter, pType, ServiceType, Receiver, WorkCenter, Start, End, Remaining, Status, ReceiveDate) values(@Number, @CostCenter, @pType, @ServiceType, @Receiver, @WorkCenter, @Start, @End, @Remaining, @Status, @ReceiveDate)");

            myCommand.Connection = connection;

            //
            // You'll have to set the DB type of each parameter to what the database expects.
            //
            myCommand.Parameters.Add("@Number", SqlDbType.NVarChar);
            myCommand.Parameters.Add("@CostCenter", ...);
            myCommand.Parameters.Add("@pType", ...);
            myCommand.Parameters.Add("@ServiceType", ...);
            myCommand.Parameters.Add("@Receiver", ...);
            myCommand.Parameters.Add("@WorkCenter", ...);
            myCommand.Parameters.Add("@Start", ...);
            myCommand.Parameters.Add("@End", ...);
            myCommand.Parameters.Add("@Remaining", ...);
            myCommand.Parameters.Add("@Status", ...);
            myCommand.Parameters.Add("@ReceiveDate", ...);

            connection.Open();

            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                myCommand.Parameters["@Name"] = dataGridView1.Rows[i].Cells[0].Value.ToString();
                myCommand.Parameters["@CostCenter"] = ...
                ...

                myCommand.ExecuteNonQuery();
            }

            connection.Close();

class SortedSetDemo
{
    static void Main(string[] args)
    {
        var words = new string[]
            {"the", "quick", "brown", "fox", "jumps",
             "over", "the", "lazy", "dog"};

        // Create a sorted set.
        var wordSet2 = new SortedSet<KeyValuePair<int, string>>(new KVPKeyComparer<int, string>());
        int x = 0;
        foreach (string word in words)
        {
            x++;
            wordSet2.Add(new KeyValuePair<int, string>(x, word));
        }

        // List the members of the sorted set.
        Console.WriteLine("Set items in sorted order:");

        // Access an item at a specified index (position).
        for (int j = 0; j < wordSet2.Count; j++)
        {
            var item = wordSet2.ElementAt(j);
            Console.WriteLine(item);
        }
    }

    public class KVPKeyComparer<TKey, TValue> : IComparer<KeyValuePair<TKey, TValue>> where TKey : IComparable
    {
        public int Compare(KeyValuePair<TKey, TValue> x, KeyValuePair<TKey, TValue> y)
        {
            if(x.Key == null)
            {
                if(y.Key == null)
                    return 0;
                return -1;
            }

            if(y.Key == null)
                return 1;

            return x.Key.CompareTo(y.Key);
        }
    }
}

[1, the]
[2, quick]
[3, brown]
[4, fox]
[5, jumps]
[6, over]
[7, the]
[8, lazy]
[9, dog]

Quote:

fyi: I am using a custom IComparer<keyvaluepair<string, string="">> for sorting, but, that's working as expected.