checkedListBox binding with DataReader.

[sea]

I’m writing ADO program connected to MS access with DataReader. Need to bind a checkedListBox to a table. This is what I wrote:

	public void BindCheckedListBox(CheckedListBox BooksCheckedListBox)
	{
		ArrayList books = new ArrayList();
		string sqlBindList = "SELECT BookName " +
			"FROM books "+
			"ORDER BY BookName ";

		OleDbCommand cmdShowStock = new OleDbCommand();
		cmdShowStock.Connection = cnShop;
		cmdShowStock.CommandType = CommandType.Text;
		cmdShowStock.CommandText = sqlBindList;
		cnShop.Open();
		OleDbDataReader reader = cmdShowStock.ExecuteReader();
		BooksCheckedListBox.DataSource = reader;
	}

When run it with debbuger I get an exception: “Complex DataBinding accepts as a data source either an IList or an IListSource”. Trying to figure out how to work with those interfaces I got nowhere :(. Please help me clear up this issue! TIA, sea#

[jdkulkarni]

Hi, You can only assign those objects as a datasource which implements ILIst or IListSource interface e.g. DataSet, Array. So you can not assign DataReader as a datasource to a listbox or combobox. Jayant Jayant D. Kulkarni Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET