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

When Garbage Collector runs in an Application? 1)Application is running form more than 30 min. 2)On every 1/4th milisecond 3) Randomly 4) Application is running on low of memory

2 Answers   PCS,

---

14. What are your Future Plans for Swatz Oils GROUP U.K?

0 Answers   CSC, Swatz Oils, TCS,

---

6. Tell us about a time when you failed to meet a deadline. What were the repercussions?

0 Answers   AlKhaleej, Swatz Oils,

---

How to implement caching?

2 Answers   Infosys, Microsoft,

---

Derive WSDL?

6 Answers   Siebel,

---

What is the namespace used to store the information about the user?s locale?

1 Answers   NeoSoft, Siebel,

---

how can create login from create and written conde in asp.net

0 Answers  

---

What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?

4 Answers  

---

Types of state management techniques ?

6 Answers   Digital GlobalSoft,

---

Explain how cookies work. Give an example of cookie abuse.

0 Answers  

---

what is Versioning in asp.net and how it maintain in any web application

1 Answers   TCS,

---

What is the < machinekey > element and what two ASP.NET technologies is it used for ?

1 Answers  

---