hi,

i want to know how to implement this query in VB.NET

"Select max(Sno) from Student"

manisha

Are you asking how to setup database connectivity or are you asking if there is somethign special you need to do to execute that query??

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Actually in this code

sub button1_Click()

dim con as sqlconnection
dim cmd as sqlcommand
dim str as string

con=new sqlconnection("server=localhost;integrated security=true;database=pubs")
con.open

str="insert authors(au_id,au_name) values(@au_id,@au_name)"
cmd=new sqlcommand(str,con)
cmd.parameters.add("@au_id","1")

'How to get max au_id field value from table

cmd.parameters.add("@au_name",txtauname.text)
cmd.executenonquery()
con.close()

end sub

You need to execute the select statement that you provided in your initial post, however, you need to use ExecuteReader() instead of ExecuteNonQuery()

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

this code is working properly only i want to know,
If in a table there are 1-5 au_id then how to get 5(max) au_id

SELECT max(au_id) From [table]

Like i said, execute the command using ExecuteReader() (although, since you just want a number you would be better off using ExecuteScalar() )

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hellow Manisha,Try this code.
private sub Button1_click(......) Handles btninsert.click
Dim con As new SqlConnection
con.ConnectionString = "Data Source = ....; Database=dbname;Integrated
                       Security=ISPI"
Dim cmd as New SqlCommand
cmd.CommandText="Select max(sno) from Students"
cmd.CommandType=CommandType.Text
cmd.Connection = con
con.Open()
MsgBox(cmd.ExecuteScalar)
con.Close()
End Sub