Comments by DPaul1994 (Top 27 by date)

Hmm something's wrong, it replace the value of rows with each id one by one, but on first selection, it doesn't get out of the while until it selects all rows..and that's wrong. it should select every row one by one but only when button is clicked. Don't know if it matters, but select() is also called at form Load, as initializing first value. Then, each time when button is pressed, it should called again select() function for next row

1, it means it reads first row. but it doesn't continue with next rows

I have 2 records with id 1 and 2 :)

Aaaa you're right, sorry. Well, I did that and I saw the problem. So, select() function is called by a button. Each time when button is pressed, select should select from table next row. And if I click again, it doesn't step into while, is jumping over while, but I don't know why..

Everything seems to be ok..

Of course, I check this now

Aaa sorry, I have a previous error. I don't receive any error messages, is just, it selects only first row

Is just a var that I will have to use it later in program. Still got this problem...interesting

I receive "Specified cast is not valid" and I don't understand why. `id` is an integer in table and `rows` is an int initialized with 0

If I remove LIMIT 1, nothing changes

I want all rows, one by one

Exactly!

Omg Smile | :) ) It worked. I will try to learn and understand this way to update with DataTable. Thank you for your patience and wish you the best!

What you did there is just an example of how I could do it, right? Cause is not what I have to do. First I have to collect and compare, then I have to update, you get that, right? No, I don't close them..connection is always opened. I try that now

I don't know if it matters, but I have another function which select some data and is called on load form. (using SQLiteDataReader)

Well, is not about I give up, I'm sick of this update :)) I tried to change the code in so many ways, but without success. This is my last try. I get the same error. I tried to close and reopen connection, than close is again, but with no succees. I tried with DataAdapter, with DataReader but it didn't work. I don't know to else to try. And I have to change only a value from a single row, don't understand why to use foreach loop..
<pre lang="c#">
private void UpdateTotalSim()
{
using (SQLiteCommand cmd = new SQLiteCommand(@"update accounts set totalsim=totalsim+1 where username='" + SimulatorManager.Utilizator + "'", Conexiune.getConnection()))
{
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}

private void button4_Click(object sender, EventArgs e)
{
if (check1.Checked == true) result1 = 1;
else result1 = 0;
if (check2.Checked == true) result2 = 1;
else result2 = 0;
if (check3.Checked == true) result3 = 1;
else result3 = 0;
string collect = "Select option1,option2,option3 from questions where `question`='" + SimulatorManager.Intrebare + "'";
SQLiteCommand comp = new SQLiteCommand(collect, Conexiune.getConnection());
comp.CommandType = CommandType.Text;
SQLiteDataReader read = comp.ExecuteReader(CommandBehavior.CloseConnection);
try
{
while (read.Read())
{
int op1 = (int)read["option1"];
int op2 = (int)read["option2"];
int op3 = (int)read["option3"];
if (check1.Checked == false && check2.Checked == false && check3.Checked == false)
MessageBox.Show("Selectati minim o optiune");
else
{
if ((result1 == op1) && (result2 == op2) && (result3 == op3))
{
corect++;
label4.Text = corect.ToString();
check1.Checked = false;
check2.Checked = false;
check3.Checked = false;
select();
}
else
{
incorect++;
label6.Text = incorect.ToString();
check1.Checked = false;
check2.Checked = false;
check3.Checked = false;
select();
}
if (corect + incorect == 1)
{
MessageBox.Show("Test terminat!");
if (corect == 1)
{
UpdateTotalSim(); // HERE I CALL THE UPDATE FUNCTION
MessageBox.Show("Bravo!");
}
else
{
MessageBox.Show("Bleah");
}
this.Close();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
</pre>

I didn't succeed to fix it. If you can write the code so I can see exactly what are you talking about, it's ok, else that's it. Thank you anyway for your time :)

Ok, I'll try this :)

So, using SQLiteCommand, inside this - using SQLiteDataReader - using SQLiteDataAdapter and here is the table?

Well this may be a silly answer, but that is the entire code :))) I don't really know how to use datatable..yeah :))

OMG! =)))) Yeah, sorry for that. But database is still locked.

You mean like that?
using (SQLiteDataAdapter update = new SQLiteDataAdapter("update totalsim from accounts set totalsim=totalsim+1 where username = 'DPaul'", Conexiune.getConnection()))
{
DataTable updt = new DataTable();
update.Fill(updt);
}

Cause I tried this and I receive:
SQL logic error or missing database near 'from': syntax error