I've a query
cmdmax = New SqlCommand("select max(Q_ID) as maxid from Question", conPubs)
Now i want to collect the returened number,in which i can store
this No. ,so that i can use this further.

abhinavjain

__________________
abhinavjain

cmdmax.ExecuteScalar() returns a single integer value. Use that method to return to an integer value.

Brian

Hi,
I write following code

Dim max as integer
cmdmax = New SqlCommand("select max(Q_ID) from Titles", conPubs)
max = cmdmax.ExecuteScalar
TextBox2.Text = max

But it is not working ,what's the problem

abhinavjain

try this...

--------------------------------------------
Mehdi.:)

Hey,

If you have Option Strict On, you have to CType the value. Otherwise, the problem is with your query.

What is the specific error that you are getting?

Brian

There is no error msg,but actully i want that i get maximun ID from table
and then add 1 to that number
ie max1=max+1

abhinavjain

Yeah OK, use ExecuteScalar()