Datatable objects not binded to combobox and textbox

mohammed shamsheer

12y1.5kWindows Forms

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

mohammed shamsheer12y ago
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;
0
Arunava Bhattacharjee12y ago
Well Table is a property of type DataTableCollection in DataSet Class

public DataTableCollection Tables { get; }
+1
mohammed shamsheer12y ago
diff between dataset and datasetcollection
0
Munesh Sharma12y ago
go here http://dotnet-munesh.blogspot.in/2014/04/link-combobox-with-database-in-window.html
0
Arunava Bhattacharjee12y ago
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.
0