List Boxes

[abugslife]

hey guys!

anyone have any ideas of how I can represent my data inside a listbox?

i'm currently using sql to connect my database to the program.

ive got this code

SQLiteConnection^ selectConnection = gcnew SQLiteConnection("Data Source=shoesDatabase.db3;");
int i = listBox1->SelectedIndex + 1;
SQLiteCommand^ selectCommand = gcnew SQLiteCommand("SELECT * FROM Shoes WHERE ShoesID=" +i,selectConnection);
selectCommand->CommandType = CommandType::Text;
SQLiteDataAdapter^ selectDataAdapter = gcnew SQLiteDataAdapter(selectCommand);
selectDataAdapter->Fill(dataSet, "Shoes");
listBox1->DataSource = dataSet->Tables["Shoes"];
listBox1->DataBindings->Clear();
listBox1->DataBindings->Add("Text",dataSet->Tables["Shoes"], "Name");

But it does not work :(

Thanks!