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

In which module you have worked in your .net project explain?

1 Answers   TechSolution,

---

What is boxing and unboxing ?

7 Answers   Accenture, Infosys, MedTek,

---

What is the difference between typeof() vs gettype()?

0 Answers  

---

What is a 401 redirect?

0 Answers  

---

What are asynchronous callbacks ?

6 Answers   Accenture, BirlaSoft,

---

I am trying to implement sorting facility from client side code in GridView Control. So how can I fill up an Array inside client side code (using JavaScript), i want to assign my DataSet object declared and filled up on Server side(in code behind) to the array (on client side)

0 Answers   HCL,

---

Caching techniques in .NET?

2 Answers   Microsoft,

---

Where viewstate value is stored in asp.net?

0 Answers  

---

Explain how server control validation controls works?

2 Answers   CMS, Syntax Softtech,

---

What layout mode is the default when a new Web Form is created? a) GridBagLayout b) GridLayout c) FlowLayout d) FormLayout

2 Answers   Syntax Softtech,

---

How Clustered Index and Non clustered index stored on SQL server?

2 Answers   TCS,

---

What is the syntax for datagrid and specifying columns ?

2 Answers   Microsoft,

---