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
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the importance of Global.asax in ASP.NET?
How u refer webservices?
What is the concepts of globalization and localization in .net?
What is css in asp.net?
what is meant by sitemapnode ?
How to disable validator control by client side JavaScript?
What is a postback in asp net?
What is custom events? How to create it?
What is a url string?
In What Order Do The Events Of An Aspx Page Execute. As A Developer Is It Important To Undertsand These Events?
What are the Types of chaching. How to implement caching
Differentiate between a hyperlink control and a linkbutton control.
Do gac'ed assemblies have fulltrust?
how to elimainte the similar data from the different tables
How does a web application session work?
