How to check the end of the record in Datareader?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bhagwat prasad sharma
{vb.net code for selection by data reader}
//\\Start......
imports system.data.sqlclients
public class
dim con as new sqlconnection("server=bps; database=college; user id=sa; password=admin")
private button1 ()
dim str as string="select
name from student where roll_no=1"
dim cmd as new sqlcommand(str,con)
if con.state=connectionstate.closed than
con.open()
cmd.parameters.add("@roll_no",type.int)
cmd.parameters("@roll_no").value=txtroll.text
dim dr as sqldatareader
dr=cmd.executereader
if dr.read than
txtname.text=dr(1)
else
msgbox("selection error ")
end if
con.close()
end sub
end class
Is This Answer Correct ? | 4 Yes | 4 No |
How do you manage session in ASP and ASP.NET ?
2 Answers Cap Gemini, Microsoft,
What is comparevalidator?
What is Hidden Fields in Asp.Net
Is global asax mandatory?
How do we make a poperty read only?
How to create a permanent cookie?
what is difference between const, static and readonly?
Mention few asp.net validators.
What is cookies cache and session?
What are the main requirements for caching?
What is the difference between session and viewstate in asp.net?
What is the difference between repeater over datalist and datagrid ?