Why is my tuple only writing 1 record and failing on a second iteration

Instead of adding parameters each time through the loop with a value, add the parameters without values outside of the loop, and then inside the loop, update the value of the parameters.

Can you please give me a one line example outside and inside the loop.

I seam to be having syntax errors

Thanks

Olukay

The code should be similar to:

Outside of your foreach loop:
NpgsqlParameter schoolname = new NpgsqlParameter("schoolnamex", NpgsqlTypes.NpgsqlDbType.Varchar) { Direction = ParameterDirection.Input};
command.Parameters.Add(schoolname);

Inside your foreach loop:
schoolname = GridVariables.GridColumn02;

Tried but got this error

Cannot implicitly covert type 'string' to 'NpgsqlParameter'

I have tried to use ToString, ToChar  without luck

The variable is defined as a string so i dont understand the error

See attached

[embed=file 1420174]

Select allOpen in new window

Olukay
Conversion-issues.png

Got the syntax right but only 1 of 2 records is still written  (see code below)

   

public void CreateEducationForm(List<Tuple<string, string, string, string, string>> newTuples)
        {
            //Place  to process tuples into the database
            //  Save Button Click
            using (NpgsqlConnection conn = new NpgsqlConnection(pgrstring))
            {
                // public.speducation_insert
                using (var command = new NpgsqlCommand("public.speducation_writemasterdetail", conn))
                  //using (var command = new NpgsqlCommand("public.speducation_insert", conn))
              {

                    conn.Open();
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.Add(value: new NpgsqlParameter("staffnox", NpgsqlTypes.NpgsqlDbType.Varchar) { Direction = ParameterDirection.Input, Value = GridVariables.GridColumn01 });
                    command.Parameters.Add(new NpgsqlParameter("companycodex", NpgsqlTypes.NpgsqlDbType.Varchar) { Direction = ParameterDirection.Input, Value = GridVariables.GridColumn07 });
                    command.Parameters.Add(new NpgsqlParameter("empidx", NpgsqlTypes.NpgsqlDbType.Integer) { Direction = ParameterDirection.Input, Value = ((int)GridVariables.GridColumn08) });
                    command.Parameters.Add(new NpgsqlParameter("empeduidx", NpgsqlTypes.NpgsqlDbType.Integer) { Direction = ParameterDirection.InputOutput, Value = ((int)GridVariables.GridColumn09) });

                    NpgsqlParameter schoolname = new NpgsqlParameter("schoolnamex", NpgsqlTypes.NpgsqlDbType.Varchar) { Direction = ParameterDirection.Input };
                    command.Parameters.Add(schoolname);
                    NpgsqlParameter startdate = new NpgsqlParameter("startdatex", NpgsqlTypes.NpgsqlDbType.Date) { Direction = ParameterDirection.Input };
                    command.Parameters.Add(startdate);
                    NpgsqlParameter enddate = new NpgsqlParameter("enddatex", NpgsqlTypes.NpgsqlDbType.Date) { Direction = ParameterDirection.Input };
                    command.Parameters.Add(enddate);
                    NpgsqlParameter yearsexp = new NpgsqlParameter("yearsexpx", NpgsqlTypes.NpgsqlDbType.Integer) { Direction = ParameterDirection.Input };
                    command.Parameters.Add(yearsexp);
                    NpgsqlParameter degreecode = new NpgsqlParameter("degreecodex", NpgsqlTypes.NpgsqlDbType.Varchar) { Direction = ParameterDirection.Input };
                    command.Parameters.Add(degreecode);

                  //  foreach (Tuple<string, string, string, string, string> tuple in newTuples)
                    foreach (DataGridViewRow row in dgvDetailsTable.Rows)
                    {
                        schoolname.Value = GridVariables.GridColumn02;
                        startdate.Value = Convert.ToDateTime(GridVariables.GridColumn03);
                        enddate.Value = Convert.ToDateTime(GridVariables.GridColumn04);
                        yearsexp.Value = Convert.ToInt32(GridVariables.GridColumn05);
                        degreecode.Value = GridVariables.GridColumn06;

                        int newvar = 0;
                        //  int newid = Convert.ToInt32(command.ExecuteNonQuery());
                        int newid = Convert.ToInt32(command.ExecuteScalar());
                        newvar = newid;
                    }
                    
                }
            }
        }

Select allOpen in new window

When i used  foreach  tuple in Tuples  I only got the last  record written (This is most likely wrong)

When I tried foreach row in dgvDetailsTable.Rows  i got a syntax error because  the  code is not in the same scope with the grid

Is there a way for me  to reference the grid in a method not directly accessible to it

See  the attachments



Regards

Olukay

At this stage I think the best thing will be to close this thread and

restart another from where we stopped

Thanks for the effort

Olukay

Thanks.

Will close thread now and reopen a new thread to

continue with the current issue

Efforts very much appreciated