How to check the end of the record in Datareader?
Answer Posted / anitha
Dim cmdstr As String
Dim cmdsql As New SqlClient.SqlCommand
Dim consql As SqlConnection = New
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
cmdstr = "select top 1 columnName from tbl_Sample order by
ColumnName desc "
cmdsql = New SqlCommand(cmdstr, consql)
If consql.State = ConnectionState.Closed Then
consql.Open()
Dim drsql As SqlDataReader
drsql = cmdsql.ExecuteReader()
Do While drsql.Read
any Control value= drsql.Item(0)
Loop
drsql.Close()
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
i want the asp.net technical questions and answeres
Define dll hell?
How does a content page different from a master page?
Why would anyone need to implement their own hashtable or linked list?
What is %20 in a url?
Describe how to implement globalization and localization in the use interface in .net.
Which object is used to encapsulate the state of the client and the browser in ASP.NET?
What are the modes of updation in an updatepanel? What are triggers of an updatepanel?
Define resource files.
How you can manage the state of application at the server side in ASP.NET?
Where sessions are stored?
What is masterpage?
What is the asp.net mvc folder conventions? : asp.net mvc
Explain global assembly cache.
What is autopostback in asp net?