Hello guys, can someone tell me how can I get the values from the columns ?

My sql table is:

Table name: settbl
Table columns: id, first (int), second (int)

...and now, I want to get the values from "first" and "second", but I got the error message "Object reference no set to an instance of an object".

This is my code:

sqlIteCon = new SQLiteConnection("Data Source=set.db;Version=3;New=False;Compress=True;");
string SelectQuery = "SELECT * FROM settbl";
SQLiteCommand sqlCommand = new SQLiteCommand(SelectQuery, sqlIteCon);

                SQLiteDataReader sqlRead = sqlCommand.ExecuteReader();

                int a = sqlRead.GetInt32(sqlRead.GetOrdinal("first"));

                int b = sqlRead.GetInt32(sqlRead.GetOrdinal("second"));


Recommended Answers

All 2 Replies

Why not load it in to a DataTable ?

private void button9999_Click(object sender, EventArgs e)
      const string connStr = "Data Source=apex2006sql;Initial Catalog=Leather;Integrated Security=True;";
      const string query = "Select * From Invoice Where InvNumber = @InvNumber";
      using (SqlConnection conn = new SqlConnection(connStr))
        using (SqlCommand cmd = new SqlCommand(query, conn))
          cmd.Parameters.Add(new SqlParameter("@InvNumber", 1100));
          using (SqlDataReader dr = cmd.ExecuteReader())
            using (DataTable dt = new DataTable())
              for (int i1 = 0; i1 < dt.Rows.Count; i1++)
                DataRow row = dt.Rows[i1];
                string custName = Convert.ToString(row["CustName"]);
                string email = Convert.ToString(row["Email"]);

Sknake, thanks for your help/example, but I solved mu problem with the SQLiteDataReader Class

public void ReadMyData(string myConnString)
 string mySelectQuery = "SELECT DeptNo, DName FROM Dept";
 SQLiteConnection sqConnection = new SQLiteConnection(myConnString);
 SQLiteCommand sqCommand = new SQLiteCommand(mySelectQuery,sqConnection);
   SQLiteDataReader sqReader = sqCommand.ExecuteReader();
   while (sqReader.Read())
     Console.WriteLine(sqReader.GetInt32(0) + ", " + sqReader.GetString(sqReader.GetOrdinal("DName")));
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.