Answer Posted / bhagwat prasad sharma

Steps: SqlConnection with vb.net code
'' Code

imports system.data.sqlclients
Public Class Form1 Inherits System.Windows.Forms.Form
'' createconnection with database

dim con as new sqlconnection("server=bps; database=company; user id=sa; password=admin")

private sub button1_click()

dim str as string="insert into employee (roll_no,name,class) values(@roll_no,@name,@class)"

dim cmd as new sqlcommand =(str,con)

if con.state=connectionstate.closed than
con.open()
'' parameter passing

cmd.parameters.add("@roll_no",type.int)
cmd.parameters.add("@name",type.varchar)
cmd.parameters.add("@class",type.varchar)

cmd.parameters("@roll_no").value= txtroll.text
cmd.parameters("@name").value=txtname.text
cmd.parameters("@class").value= txtclass.text

dim i as integer
i=cmd.executeNonquery

if i>o
msgbox("addition successful")
else
msgbox("sum mistakes into add")
end if
' end of connection
con.close()
end sub
end class

what are configuration files?

1026

---

What language does asp.net use?

983

---

What is a server cookie?

985

---

How to find last error which occurred?

1018

---

How will you maintain versioning in asp.net 2.0?

1012

---

How do you declare delegates and are delegates and events one and the same and explain how do you declare delegates and invoke them ?

4194

---

Why do you use the app_code folder in asp.net?

1072

---

Define tracing.

1100

---

How many types of session state management options available in asp.net?

1026

---

Explain the main function of razor in asp.net? : asp.net mvc

1063

---

Do you know about caching with the datasource controls?

880

---

How would ASP and ASP.NET applications run at the same time on the same server?

2482

---

What is ispostback method in asp.net?

1012

---

How can you register a custom server control to a web page?

976

---

What is asp.net mvc5? : Asp.Net MVC

1012

---