Display Query results into a Textbox
Posted on 2009-05-12
I have a SelectedIndexChanged procedure in which I have an SQL statement. I need the results from the SQL statement to be displayed in a text box.
The SQL statement is given below
SQL = "select max(TotalPayable) - max(TotalPaid) from Payments Group by StudentId having StudentId = '" & Trim(cboStudentId.SelectedItem.Value) & "'"
I have a textbox OpeningBalance in which I want the results from the above SQL statement to be displayed. How do I do it?