SQL从C#中的数据库中选择 [英] SQL select from database in C#

问题描述

我在C#中具有以下代码:

I have the following code in C#:

string query = "SELECT * FROM Zboruri WHERE cod_aeroport = " + country;

using (var command = new SqlCommand(query, connection))
{
    var list = new ArrayList();
    var reader = command.ExecuteReader();

    if (reader.HasRows)
    {
         while (reader.Read())
         {
             string data1 = reader.GetString(1);
             string data2 = reader.GetString(2);
             list.Add(cod_aeroport);
             list.Add(data1);
             list.Add(data2);
         }
    }
    else
    {
        string raspuns = "nu este info";
        list.Add(raspuns);
    }

    reader.Close();
    connection.Close();
    return list;
 }

我的数据库表包含以下列:

My database table has these columns:

data1(numeric(18,0))
data2(numeric(18,0))
...........

它给了我错误:

索引超出了数组的范围.

在这行代码上:

string data2 = reader.GetString(2); 

如何解决错误?

推荐答案

索引从0开始，而不是1

index starts at 0, not 1

string data1 = reader.GetString(0);
string data2 = reader.GetString(1);

这篇关于SQL从C#中的数据库中选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！