System.IndexOutOfRangeException during SELECT output

Question

I have this code in Visual Studio:

sqlite.Open();  //Initiate connection to the db

string stmEP = "select a.portata,a.quantita,b.QUANTITA_ATTUALE,a.COSTO_UNITARIO,a.SPESA_PORTATA from ORDINI a join QUANTITA_LIMITATE b on a.PORTATA = b.PORTATA WHERE a.CASSA = '" + MyGlobals.NOME_CASSA + "' ORDER BY a.ID,a.PORTATA;";

using var cmdEP = new SQLiteCommand(stmEP, sqlite);
using SQLiteDataReader rdrEP = cmdEP.ExecuteReader();

while (rdrEP.Read())
{
    string OUT_PORTATA = (string)rdrEP["a.portata"];
    Int64 OUT_QTA = (Int64)rdrEP["a.quantita"];
    Int64 OUT_QTA_ATT = (Int64)rdrEP["b.QUANTITA_ATTUALE"];
    MessageBox.Show(OUT_PORTATA);
}

sqlite.Close();

The error occurs on this line:

string OUT_PORTATA = (string)rdrEP["a.portata"];

Error:

System.IndexOutOfRangeException: Index was outside the bounds of the array

I don't understand why.

I'd like to extract all items in ORDINI that are also in QUANTITA_LIMITATE.

jmcilhinney · Accepted Answer · 2025-03-15 16:31:22Z

1

When you qualify a column name in a SELECT statement, that's only to specify the source. the output just has the column name. That means that your column is named "portata", not "a.portata". You should have seen this for yourself because you should have actually looked at the data to see what the column names were.

answered Mar 15 at 16:31

jmcilhinney

54.9k5 gold badges30 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gianluca Bendinelli Mar 16 at 7:35

Thank's work fine now!!!

jmcilhinney Mar 16 at 14:49

@GianlucaBendinelli, if an answer solves your problem then don't forget to accept it. As well as rewarding the person who answered, it shows up in the question list lets everyone know that you don't need any further help without their having to open the question and read a comment on an answer.

Collectives™ on Stack Overflow

System.IndexOutOfRangeException during SELECT output

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related