How i insert a string from DataBase into a ListBox

Question

 string SQL = "SELECT * FROM Email ";
 string myConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
              "Data Source=" + textBox1.Text;
 OleDbConnection myConnection = new OleDbConnection(myConnString);
 OleDbCommand myCommand = new OleDbCommand(SQL, myConnection);
 myConnection.Open();
 OleDbDataReader myReader = myCommand.ExecuteReader();
 if (myReader.Read())
 {
    View.Items.Add(myReader.Read());
 }
 myConnection.Close();

The output is False .The output should be israel.nahum(from the DB)

James Hill · Accepted Answer · 2011-08-01 13:25:35Z

2

You need to specify which column you want to retrieve the text from:

string SQL = "SELECT * FROM Email ";
    string myConnString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + textBox1.Text;
    OleDbConnection myConnection = new OleDbConnection(myConnString);
    OleDbCommand myCommand = new OleDbCommand(SQL, myConnection);
    myConnection.Open();
    OleDbDataReader myReader = myCommand.ExecuteReader();

    //Changed if(myReader.Read()) to while(myReader.Read())
    while(myReader.Read())
    {
        View.Items.Add(myReader["NameOfColumnGoesHere"]);
    }



    myConnection.Close();

Take a look at the documentation for the OleDbDataReader Class.

edited Aug 1, 2011 at 13:25

answered Aug 1, 2011 at 13:04

James Hill

62.2k22 gold badges150 silver badges166 bronze badges

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

1 Comment

James Hill Over a year ago

@Israel, See above edit. Calling myReader.Read() advances to the first record. You want to read until all the records have been read, so you need to use while(myReader.Read()).

Erre Efe · Accepted Answer · 2011-08-01 13:09:17Z

1

Read get you access to the iterator (put the next item of the results in it) use

if (myReader.Read())
{
    View.Items.Add(myReader["COLUMN_NAME"]);
}

And so then, if the reader returns something then it'll put in on your item.

edited Aug 1, 2011 at 13:09

answered Aug 1, 2011 at 13:03

Erre Efe

15.6k10 gold badges47 silver badges80 bronze badges

2 Comments

Israel Over a year ago

View.Items.Add(myReader["EMAIL"]);

Erre Efe Over a year ago

I suggest to study first about what you're are trying to do. If you use if(myReader.Read()) then that code will evaluate just ONE time, for the first record. If you want it to perform for EACH record, then use WHILE

Davide Piras · Accepted Answer · 2011-08-01 13:04:13Z

0

Please look in MSDN documentation how to use the DataReader object. the Read is reading a row and returning true if there is any row available, you should use other methods to get the values from the current row.

also, notice that you do not need to do a SELECT * FROM... if you only need one column, just do SELECT Email FROM ... for example...

answered Aug 1, 2011 at 13:04

Davide Piras

44.7k10 gold badges103 silver badges150 bronze badges

Collectives™ on Stack Overflow

How i insert a string from DataBase into a ListBox

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related