Click here to Skip to main content
15,914,221 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Visual Studio 2010 Pin
The Man from U.N.C.L.E.25-Feb-10 22:39
The Man from U.N.C.L.E.25-Feb-10 22:39 
QuestionBlank Mail ASP Pin
for120625-Feb-10 1:25
for120625-Feb-10 1:25 
AnswerRe: Blank Mail ASP Pin
TheComputerMan25-Feb-10 1:33
TheComputerMan25-Feb-10 1:33 
QuestionSilverlight for Windows Application Forms...? VB.Net 2008 Pin
Paramu197324-Feb-10 23:15
Paramu197324-Feb-10 23:15 
AnswerRe: Silverlight for Windows Application Forms...? VB.Net 2008 Pin
Dave Kreskowiak25-Feb-10 1:52
mveDave Kreskowiak25-Feb-10 1:52 
QuestionWorking mdb access with vb.net - won't update [modified] - RESOLVED Pin
C#Coudou24-Feb-10 20:12
C#Coudou24-Feb-10 20:12 
AnswerRe: Working mdb access with vb.net - won't update Pin
Wayne Gaylard24-Feb-10 21:23
professionalWayne Gaylard24-Feb-10 21:23 
GeneralRe: Working mdb access with vb.net - won't update Pin
C#Coudou24-Feb-10 21:43
C#Coudou24-Feb-10 21:43 
Actually theres no error in my code. Anyway, heres my code snippet.

Private Sub btnUpdate_Click(ByVal sender As System.Object, _
       ByVal e As System.EventArgs) Handles btnUpdate.Click

   sb = New StringBuilder
       sb.Append("UPDATE [T_Analysis] SET ")
       sb.Append(" [OrderDate]= '" & Me.txtDate.Text & "'")
       sb.Append(",[OrderName]= '" & Me.txtOrderName.Text & "'")
       sb.Append(" WHERE [OrderNo]= " & Me.txtOrder.Text & "")
   ADOExecute(sb.ToString)

   End Sub

[Module]
 Public Sub ADOExecute(ByVal ssql As String)
        Dim sqlexec As Integer
        Dim adocmd As ADODB.Command
        Dim adocon As New ADODB.Connection
        Try
            adocon = New ADODB.Connection
            adocon.ConnectionString = adoconstr
            adocon.CursorLocation = ADODB.CursorLocationEnum.adUseClient
            adocon.Open()

            adocmd = New ADODB.Command
            adocmd.ActiveConnection = adocon
            adocmd.CommandText = ssql
            adocmd.Execute(sqlexec)
            rowsAffected = sqlexec

        Catch ex As Exception
            log.Debug(ex.ToString)
            Throw (ex)
        Finally
            If adocon.State <> ConnectionState.Closed Then
                adocon.Close()
                adocon = Nothing
                adocmd = Nothing
            End If
        End Try
    End Sub
C# コードMicrosoft End User
2000-2008




「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」


AnswerRe: Working mdb access with vb.net - won't update Pin
Dave Kreskowiak25-Feb-10 1:49
mveDave Kreskowiak25-Feb-10 1:49 
GeneralRe: Working mdb access with vb.net - won't update Pin
C#Coudou25-Feb-10 12:54
C#Coudou25-Feb-10 12:54 
GeneralRe: Working mdb access with vb.net - won't update Pin
Dave Kreskowiak25-Feb-10 13:52
mveDave Kreskowiak25-Feb-10 13:52 
GeneralRe: Working mdb access with vb.net - won't update Pin
C#Coudou25-Feb-10 14:59
C#Coudou25-Feb-10 14:59 
GeneralRe: Working mdb access with vb.net - won't update Pin
TheComputerMan25-Feb-10 23:00
TheComputerMan25-Feb-10 23:00 
GeneralRe: Working mdb access with vb.net - won't update Pin
Thomas Krojer1-Mar-10 19:33
Thomas Krojer1-Mar-10 19:33 
QuestionPrint RichTextBox Content Pin
Anubhava Dimri24-Feb-10 19:51
Anubhava Dimri24-Feb-10 19:51 
AnswerRe: Print RichTextBox Content Pin
Wayne Gaylard24-Feb-10 21:20
professionalWayne Gaylard24-Feb-10 21:20 
GeneralRe: Print RichTextBox Content Pin
Anubhava Dimri24-Feb-10 22:12
Anubhava Dimri24-Feb-10 22:12 
AnswerRe: Print RichTextBox Content Pin
Nuri Ismail24-Feb-10 21:25
Nuri Ismail24-Feb-10 21:25 
AnswerRe: Print RichTextBox Content Pin
Smithers-Jones25-Feb-10 0:50
Smithers-Jones25-Feb-10 0:50 
Questionhow to read message archieve ym in offline mode using vb6 code Pin
darni3324-Feb-10 18:26
darni3324-Feb-10 18:26 
AnswerRe: how to read message archieve ym in offline mode using vb6 code Pin
Dave Kreskowiak25-Feb-10 1:47
mveDave Kreskowiak25-Feb-10 1:47 
QuestionExternal input into application [modified] - solved Pin
chrispowell1234524-Feb-10 5:08
chrispowell1234524-Feb-10 5:08 
AnswerRe: External input into application Pin
nlarson1124-Feb-10 10:06
nlarson1124-Feb-10 10:06 
AnswerRe: External input into application Pin
Steven J Jowett25-Feb-10 5:52
Steven J Jowett25-Feb-10 5:52 
GeneralRe: External input into application Pin
chrispowell1234528-Feb-10 21:55
chrispowell1234528-Feb-10 21:55 

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.