Click here to Skip to main content
15,904,500 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: How to end the Excel process after finishing in code Pin
The ANZAC20-Feb-07 19:33
The ANZAC20-Feb-07 19:33 
GeneralRe: How to end the Excel process after finishing in code Pin
Marcus J. Smith21-Feb-07 1:59
professionalMarcus J. Smith21-Feb-07 1:59 
GeneralRe: How to end the Excel process after finishing in code Pin
The ANZAC22-Feb-07 18:06
The ANZAC22-Feb-07 18:06 
Questionone form at a time Pin
charchabil0320-Feb-07 10:15
charchabil0320-Feb-07 10:15 
AnswerRe: one form at a time Pin
Dave Kreskowiak20-Feb-07 11:18
mveDave Kreskowiak20-Feb-07 11:18 
GeneralRe: one form at a time Pin
charchabil0320-Feb-07 11:24
charchabil0320-Feb-07 11:24 
QuestionSql Update/insert Pin
charchabil0320-Feb-07 10:07
charchabil0320-Feb-07 10:07 
AnswerRe: Sql Update/insert Pin
JUNEYT20-Feb-07 11:14
JUNEYT20-Feb-07 11:14 
Good question Smile | :) Actually SQL server waits for each connection session to to be done for database and then it updates the database with the change. However, when you deal with ADO to access a database to perform any action such as DELETE, UPDATE, etc., you should consider in opening the database with pesimistic or optimistic locking methods. I have given a sample below.

If Response.IsClientConnected = True Then

Set ObjectRecord = Server.CreateObject ("ADODB.Recordset")
ObjectRecord.CursorLocation = adUseServer
ObjectRecord.CursorType = adOpenkeyset
ObjectRecord.LockType = adLockOptimistic
ObjectRecord.Open GetTableName, ObjectConnection,,,adCmdTable

'adcmdtext for SQL Query

End If

I hope that helps WTF | :WTF:

Journey
QuestionMS Visual Studio 2005 can't open any project ??? Pin
kindman_nb20-Feb-07 9:22
kindman_nb20-Feb-07 9:22 
AnswerRe: MS Visual Studio 2005 can't open any project ??? Pin
sathesh pandian20-Feb-07 18:57
sathesh pandian20-Feb-07 18:57 
GeneralRe: MS Visual Studio 2005 can't open any project ??? Pin
kindman_nb21-Feb-07 6:59
kindman_nb21-Feb-07 6:59 
NewsProgramming Project Pin
csalim20-Feb-07 8:49
csalim20-Feb-07 8:49 
GeneralRe: Programming Project Pin
sathesh pandian20-Feb-07 21:43
sathesh pandian20-Feb-07 21:43 
QuestionCreating an Excel file - Microsoft.Office.Tools.Excel or Microsoft Excel 11.0 Object Library Pin
Marcus J. Smith20-Feb-07 7:09
professionalMarcus J. Smith20-Feb-07 7:09 
AnswerRe: Creating an Excel file - Microsoft.Office.Tools.Excel or Microsoft Excel 11.0 Object Library Pin
Krish - KP20-Feb-07 17:39
Krish - KP20-Feb-07 17:39 
QuestionHow can I play movie through window media player if I am getting port number and IP address Pin
onrivman20-Feb-07 6:26
onrivman20-Feb-07 6:26 
AnswerRe: How can I play movie through window media player if I am getting port number and IP address Pin
Dave Kreskowiak20-Feb-07 6:59
mveDave Kreskowiak20-Feb-07 6:59 
QuestionHow to play movie through vb.net Pin
onrivman20-Feb-07 5:56
onrivman20-Feb-07 5:56 
AnswerRe: How to play movie through vb.net Pin
Dave Kreskowiak20-Feb-07 7:00
mveDave Kreskowiak20-Feb-07 7:00 
QuestionPassing Arraylists of Objects to Child Form Pin
Geoff_300120-Feb-07 5:33
Geoff_300120-Feb-07 5:33 
AnswerRe: Passing Arraylists of Objects to Child Form Pin
Dave Kreskowiak20-Feb-07 6:30
mveDave Kreskowiak20-Feb-07 6:30 
GeneralRe: Passing Arraylists of Objects to Child Form Pin
Geoff_300120-Feb-07 7:16
Geoff_300120-Feb-07 7:16 
GeneralRe: Passing Arraylists of Objects to Child Form [modified] Pin
TwoFaced20-Feb-07 18:44
TwoFaced20-Feb-07 18:44 
GeneralRe: Passing Arraylists of Objects to Child Form Pin
Geoff_300120-Feb-07 21:01
Geoff_300120-Feb-07 21:01 
Questiondateandtimepicker in vb.net 2003 Pin
kendo1720-Feb-07 5:00
kendo1720-Feb-07 5:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.