Datatable objects not binded to combobox and textbox

Question

public void SendRoomIDtoCheckINNew(int RID) { try { object[] ParamArray = new object[] { { @RoomID RID } }; DataSet ds = new DataSet(); ds = DB.ExecuteQuery_SP(SelectRoomDetailsForGridByID ParamArray); if (ds.Tables.Count > 0) { cmbroomcat.DataSource = ds.Tables[0]; cmbroomcat.Text = ds.Tables[0].Rows[0][RoomCategoryName].ToString(); cmbroomno.DataSource = ds.Tables[0]; cmbroomno.DisplayMember = ds.Tables[0].Rows[0][RoomNo].ToString(); cmbroomno.Text = ds.Tables[0].Rows[0][RoomNo].ToString(); //cmbroomno.ValueMember = ds.Tables[0].Rows[0][RoomID].ToString(); txtCapacity.Text= ds.Tables[0].Rows[0][RoomCapacity].ToString(); } } catch (Exception ex) { ex.ToString(); } } above is my code but when i try to bind dt object to respective combo box and textbox it is not binding what is the reason behing it i am still confussing

mohammed shamsheer · Answer

Problem on page load : I by mistake add code on pageload mentioned below it created problems cmbroomcat1.SelectedIndex = -1; cmbroomcat1.SelectedValue = -1; cmbroomno.SelectedIndex = -1;

Arunava Bhattacharjee · Answer

Well Table is a property of type DataTableCollection in DataSet Class public DataTableCollection Tables { get; }

mohammed shamsheer · Answer

diff between dataset and datasetcollection

Munesh Sharma · Answer

go here http://dotnet-munesh.blogspot.in/2014/04/link-combobox-with-database-in-window.html

Arunava Bhattacharjee · Answer

See change the ds.Tables to List and the bind it to the DataSource. Check this post in c-sharp corner : http://www.c-sharpcorner.com/UploadFile/0f68f2/programmatically-binding-datasource-to-combobox-in-multiple/ Your problem is table returns a DataSetCollection where DataSource expects an Enumerable. So its a type mismatch. Also try to bind the parameter to CommandParameter search in Google about SQL Injection. If this post helps you then please mark the answer as accepted.