Shared Tutorials

Tutorials Shared by the Internet Community
Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Basic Detail

Executing Transact-SQL UPDATE statement

In this example, we will edit some records from a database.
http://www.dotnetindex.com/articles/53_Executing_Transact_SQL_UPDATE_statement.asp

Description:

In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database

dim strConnection
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/our_db.mdb")
'strConnection = "Provider=SQLOLEDB;Server=ASP;User ID=sa;Password=;Database=MY_DB;"

Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.open strCon
objConn.execute("Update myTable Set field1 = '"& some_value &"' Where id = "& ID &"")

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.85%  54
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.07%  14
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.51%  16
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 10.79%  15
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.78%  40

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.





Advertisements
Advertisements