bind lowest value from table in a textbox

Question

hi,,i m a fresher,,,i have one form that generate the numbers in a series,,,,now i want to bind the lowest value of the number from the table in a textbox in a different form,,

suppose i generate numbers 500 to 520 ,,so i want to bind lowest number 500.

how can i do this plz help me

Nainil · Answer

Hi tausif, To do this you will have to grant access of the TextBox in other form to the current form. For example, if the DataTable containing numbers is located in Form1 and the TextBox is on Form2, you should make a public property on Form2 which returns the TextBox, or you can make the TextBox in Form2 public. I personally prefer to make a property in Form2 to get the TextBox. To bind the TextBox to the lowest number, you will have to first sort the DataTable. For sort ascending, you can use the DefaultView.Sort property and assign it "Column ASC" string, where "Column" is the column you want to sort and "ASC" stands for Ascending sorting. Then you can simply use the DataBinding.Add("Text", DataTable.DefaultView, "Column") to do the databindings. This should bind the TextBox with lowest value in the DataTable. I have attached a sample with your scenario for your reference. Hope this helps.

Sam Hobbs · Answer

Do you need to get the data from a table in another form or page or do you need to get the data from a table in the database?

bind lowest value from table in a textbox

Answers (2)