C#

// Since you're only reading a single record, you should only select a single record.
// Also, avoid "SELECT *"; explicitly specify the columns you need.
const string citireLastChapter = "SELECT articol_ramas, data FROM cursuri WHERE capitol = @capitol LIMIT 1";

// Wrap disposable objects in a "using" block:
using (SQLiteCommand cmd = new SQLiteCommand(citireLastChapter, Conexiune.getConnection()))
{
    cmd.CommandType = CommandType.Text;
    cmd.Parameters.AddWithValue("@capitol", SimulatorManager.CursuriCapitol);

    // Wrap disposable objects in a "using" block:
    using (SQLiteDataReader read = cmd.ExecuteReader())
    {
        // No need for a loop to read a single record:
        if (read.Read())
        {
            SimulatorManager.ArticolRamasCursuri = (int)read["articol_ramas"];
            data = read["data"].ToString();
        }
    }
}

// No need for ".ToString()" on a string:
richTextBox1.Text = data;

int row = SimulatorManager.ArticolRamasCursuri;
if (row >= 0 && richTextBox1.Lines.Length > row)
{
    int startLineIndex = richTextBox1.GetFirstCharIndexFromLine(row);
    int lineLength = richTextBox1.Lines[row].Length;

    int col = 33;
    if (lineLength > col)
    {
        startLineIndex += col;
        lineLength -= col;
    }

    richTextBox1.Select(startLineIndex, lineLength);
    richTextBox1.ScrollToCaret();
}

Additional information: database schema has changed

near "1": syntax error

using (SQLiteDataReader read = cmd.ExecuteReader())

const string citireLastChapter = "SELECT articol_ramas, data FROM cursuri WHERE capitol = @capitol LIMIT 1";

public interface IPersist<T>
{
  void LoadLayout(T instance);
  void SaveLayout(T instance);
}

public class MyModel
{
  public string Name { get; set; }
  public string FriendlyName { get; set; }
  public DateTime LastLogin { get; set; }
}

public class MyModelPersistence : IPersist<MyModel>
{
  public void LoadLayout(MyModel instance)
  {
    // Work directly with items such as item.Name
  }

  public void SaveLayout(MyModel instance)
  {
    // Work directly with items such as item.Name
  }
}

Pete O'Hanlon wrote:

... once I really got into SOLID as a discipline