Yurii Medvedev

SELECT t.*,
       @sum := @sum + effect
FROM (
	SELECT *
	FROM `table`
	ORDER BY effect DESC
      ) AS t
      JOIN (SELECT @sum := 0) var
WHERE @sum < 100;

ServiceMetadataBehavior behavior = new ServiceMetadataBehavior();
behavior.HttpGetEnabled = true;
serviceHost.Description.Behaviors.Add(behavior);
serviceHost.AddServiceEndpoint(typeof(IMetadataExchange), MetadataExchangeBindings.CreateMexHttpBinding(), "mex");

int index = this.editingDataGridView.Columns.IndexOf(comboBoxColumn);

int index = comboBoxColumn.Index;

(this.editingDataGridView.Rows[i].Cells[index] as DataGridViewComboBoxCell).Value = tables.FirstOrDefault(c =>c.Table_ID == columns[i].Table_ID);