SqlConnection myConnection = new SqlConnection(con.ConStr);

               

            try
            {

                myConnection.Open();

                for (int i =  1 ; i < Grid1.RowCount; i++)
                {
                    string DateSql = Convert.ToString(Grid1.Rows[i].Cells[ 0 ].Value) + " " + Convert.ToString(Grid1.Rows[i].Cells[ 135 ].Value);

                    DateTime dateSQL;


                    dateSQL = Convert.ToDateTime(DateSql);

                    SqlCommand myCommandUpdateValues = new SqlCommand(" DECLARE @ID_LOG int 
 DECLARE @ID_PAR int
  SELECT @ID_LOG = Id_logfile FROM  dbo.logfile WHERE name_file = @NAME_FILE  
SELECT @ID_PAR = Id_param FROM  dbo.conform WHERE Id_conform = @ID_J  
UPDATE dbo.msrs  SET msr_value = @MSR_VALUE  WHERE id_param = @ID_PAR AND Id_logfile=@ID_LOG AND msr_time = @TIME", myConnection);



                    myCommandUpdateValues.Parameters.Add("@TIME", SqlDbType.DateTime);
                    myCommandUpdateValues.Parameters["@TIME"].Value = dateSQL;
                    myCommandUpdateValues.Parameters.Add("@NAME_FILE", SqlDbType.Char);
                    myCommandUpdateValues.Parameters["@NAME_FILE"].Value = label1.Text;



                    for (int j =  1 ; j < Grid1.ColumnCount -  7 ; j++)
                    {




                        myCommandUpdateValues.Parameters.Add("@ID_J", SqlDbType.Int);
                        myCommandUpdateValues.Parameters["@ID_J"].Value = j;

                        myCommandUpdateValues.Parameters.Add("@MSR_VALUE", SqlDbType.VarChar);
                        myCommandUpdateValues.Parameters["@MSR_VALUE"].Value = Convert.ToString(Grid1.Rows[i].Cells[j].Value);




                        myCommandUpdateValues.ExecuteNonQuery();

                    }

                }
                
             
            }

            catch (Exception ex)
            {
                MessageBox.Show("Failed");
            }
                  finally
                  {
                      myConnection.Close();
                  }