C#

Member 11484624 wrote:

first of all u can tell me nicely not like that because i ve said aouch whe i read ur replay to me .

When adding a Video or Serial name, replace "’" with "'" - they are visually similar, but do not match for searching (Database integrity update required to fix existing examples). An "update application" has been created to do this correction in existing examples - ask for DBIntegrityUpdater.EXE

// 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";