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.