Bind multiple Combobox in windows forms aspx

See more:

ASP.NET

WinForms

combobox

, +

Issue in binding multiple combobox and datagrid at a time. It just binds the last comobox/datagrid.

SetConnection(); 
			sql_con.Open();

			sql_cmd = sql_con.CreateCommand();
            string CommandText = "SELECT MediaArticle.id, MediaArticle.Title,MediaArticle.Author,MediaArticle.Volume,MediaArticle.Location, Category.Category, MediaType.Title as 'Media Type', MediaArticle.Comments, MediaArticle.UpdateDate as 'Add Date', Admin.Username as 'Added By' FROM MediaArticle INNER JOIN Admin ON MediaArticle.ById = Admin.id INNER JOIN MediaType ON MediaArticle.MediaType = MediaType.id INNER JOIN Category ON MediaArticle.Category = Category.id";
			DB = new SQLiteDataAdapter(CommandText,sql_con);
            DS.Reset();
			DB.Fill(DS);
			DT= DS.Tables[0];
			Grid.DataSource = DT;
            ex.ExportDetails(DT, Export.ExportFormat.CSV, "MediaArticles");
			sql_con.Close();


 SetConnection();
            sql_con.Open();
            sql_cmd = sql_con.CreateCommand();
            string CommandText1 = "SELECT * from MediaType";
            DB = new SQLiteDataAdapter(CommandText1, sql_con);
            DS.Reset();
            DB.Fill(DS);
            DT1 = DS.Tables[0];
            dlMediatype.DataSource = DT1;
            dlMediatype.DisplayMember = "Title";
            dlMediatype.ValueMember = "id";
            dlSearchMediaType.DataSource = DT1;
            dlSearchMediaType.DisplayMember = "Title";
            dlSearchMediaType.ValueMember = "id";
            sql_con.Close();

from above code when placed under Form load it binds '

dlMediatype

' & '

dlSearchMediaType

' BUT not binding '

Grid

' when debugged it gives its result in datatable but not found on form. Whichever is placed as last Datatable, is binding the data/working while previous not..