C# Access database query

Question

I created database in ms access and it has GPA column. In listbox2 i need to list students which GPA is bigger than 2. how caN I do that?

command.CommandText = "SELECT * FROM Student WHERE GPA > 2";
while (reader.Read())
{
  listBox2.Items.Add............?
}

Help if you can.

What is wrong with the code that you have? Other than you never execute the command to get the reader.... — PhoenixReborn
– PhoenixReborn, Commented Dec 14, 2012 at 12:37
What keeps you from searching SO or Google to find one of the replies to simliar How do I display data from Access/Excel/SQL in a list view/list box/console/whatever questions? — Thorsten Dittmar
– Thorsten Dittmar, Commented Dec 14, 2012 at 12:54

Tim Schmelter · Accepted Answer · 2012-12-14 12:43:57Z

2

I don't know if that's just pseudo code you've posted. But if not, you are reading a DataReader which is either not initialized or is not using the correct Command-sql since you are setting the CommandText one line before.

command.CommandText = "SELECT * FROM Student WHERE GPA > 2";
using(var reader = command.ExecuteReader())
{
    while (reader.Read())
    {
        // assuming that there's a column with name: StudentName
        listBox2.Items.Add(reader.GetString(reader.GetOrdinal("StudentName")));
    }
}

answered Dec 14, 2012 at 12:43

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

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

Comments

Priyank Thakkar · Accepted Answer · 2012-12-14 12:46:46Z

0

string ConnectionString = "PUT YOU CONNECTION STRING HERE";

con = new SqlConnection(ConnectionString);
con.Open();
string CommandText = "SELECT * FROM Student WHERE GPA > 2";
cmd = new SqlCommand(CommandText);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
lbx.Items.Clear();
while (rdr.Read())
{    
     lbx.Items.Add......
}

answered Dec 14, 2012 at 12:46

Priyank Thakkar

4,87219 gold badges63 silver badges95 bronze badges

1 Comment

Priyank Thakkar Over a year ago

put this in a try catch and close the connection in finally block

Collectives™ on Stack Overflow

C# Access database query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related