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()

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

What is the name of the process the browser uses to find the address of a web server? a) DMZ b) DNS c) Active Directory d) Database lookup

1 Answers   Syntax Softtech,

---

What is web api config?

0 Answers  

---

Define repository pattern in asp.net mvc? : asp.net mvc

0 Answers  

---

Explain the differences between managed and unmanaged code?

0 Answers  

---

Explain the difference between asp and asp.net?

0 Answers  

---

How to display validation messages in one control?

0 Answers  

---

How can i explain my project during interview?many time i expalain my project but they did't accept? please explain me.

0 Answers   Honeywell, Wipro,

---

when the user control event occur in ASp page life cycle?

3 Answers   Microsoft,

---

Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?

3 Answers   HCL, NIIT,

---

is it possible to use web site without web server from remote place?

1 Answers   ABC, Mannar Company, Quadrant,

---

What are the 3 levels at which content pages can be attached to Master Page?

0 Answers   MCN Solutions,

---

What is the maximum amount of memory any single process on Windows can address? Is this different than the maximum virtual memory for the system? How would this affect a system design?

1 Answers   Infosys, KPIT,

---