Loading

Select last row of column in table and show in textbox

mind controll

my windows form (form1) has textbox control (textbox1) , combobox control (combobox1) which all contain items (table1 - table2 - table3) and the sql database name (database1) and it has a tables (table1 - table2 - table3)which are identical each contains columns (itemcode - itemname - itemprice)

i want to show the last row of column(itemcode) according to table name i will choose from combobox1

3 Replies

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

mind controll11y ago
any help guys ?
0
mind controll11y ago
thanks raja but can u show me how to do put that command in code and in which event of the 2 controlls
0
Raja T11y ago
Hi Mind, Try like

1) Get Data from selected table in ComboBox like
SELECT MAX(ID) AS LastID FROM 'Selected Table'
2) Then select itemcode from selected table in ComboBox based on Last Id like

SELECT itemcode FROM 'Selected Table' WHERE = Last ID
+1