MCQs>Database Management>ADO.NET>You want to return '1' as new ID, if there exists no record in the database. Otherwise, the return value should be the maximum bill number plus one. What should follow in line 4, if you want to check for Null values as well?
ADO.NET MCQs
You have written a function to generate a unique bill number for every new bill:1 Public Function getNewBillNo() As Integer 2 Dim cm As New SqlCommand("select max(billno) from bill", con) 3 con.Open() 4 5 6 End Function
You want to return "1" as new ID, if there exists no record in the database. Otherwise, the return value should be the maximum bill number plus one. What should follow in line 4, if you want to check for Null values as well?
Answer
Correct Answer:
Explanation:
Note: This Question is unanswered, help us to find answer for this one