Comments by Hashain Fernando (Top 4 by date)

Thanks for your help.

Below exception occured.

System.InvalidOperationException: The connection was not closed. The connection's current state is open.
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at AutoSpa_Xpress.Brands.cmbbName_SelectedIndexChanged(Object sender, EventArgs e) in C:\Users\hashainf\documents\visual studio 2010\Projects\AutoSpa Xpress\AutoSpa Xpress\Brands.cs:line 211

cannot, because when i am calling cmbbCode_SelectedIndexChanged method (it calls when i select a value from brand code combo box), cmbbName_SelectedIndexChanged method also calling.

And there is an exception. (connection is not closed).