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

Explain what the contents of cookie?

1011

---

What are the various types of validation controls provided by asp.net?

942

---

What are different types of api?

968

---

What are the features that make asp.net more used framework? : asp.net mvc

963

---

How many types of session in ASP.NET

1041

---

What do you mean by marshalbyref?

1040

---

Explain the asp.net session state modes.

1031

---

Is asp.net and .net same?

935

---

How does the service stream content?

978

---

What is the difference between mechine.config and web.config?

1180

---

What is state management techniques in asp.net?

983

---

what is command line compiler.what are the steps and how it is related to debugging.

1831

---

What are query strings used for?

896

---

What is an asp.net web form?

1039

---

What are strong names?

980

---