Click here to Skip to main content
13,768,911 members

.NET Framework

 
QuestionWhy does .Net have IL code? Pin
nrnoble15-Jan-18 23:19
membernrnoble15-Jan-18 23:19 
AnswerRe: Why does .Net have IL code? Pin
Pete O'Hanlon15-Jan-18 23:40
protectorPete O'Hanlon15-Jan-18 23:40 
AnswerRe: Why does .Net have IL code? Pin
Gerry Schmitz17-Jan-18 10:19
memberGerry Schmitz17-Jan-18 10:19 
Question.NET 4.7.1 Pin
Member 1361680410-Jan-18 11:50
memberMember 1361680410-Jan-18 11:50 
AnswerRe: .NET 4.7.1 Pin
Pete O'Hanlon10-Jan-18 12:24
protectorPete O'Hanlon10-Jan-18 12:24 
GeneralRe: .NET 4.7.1 Pin
Member 1361680410-Jan-18 13:05
memberMember 1361680410-Jan-18 13:05 
GeneralRe: .NET 4.7.1 Pin
Pete O'Hanlon10-Jan-18 13:16
protectorPete O'Hanlon10-Jan-18 13:16 
QuestionHow to update all document number listed in datagridview using VB.net Pin
Fbanz121-Jan-18 15:48
memberFbanz121-Jan-18 15:48 
Hi Masters,

I have a payment form, in this form, I have a datagridview which listed all the invoices of a certain customer. when I press okay to pay, all of the listed invoices should be updated with close. Here is the code i used and its not working.



Private Sub updateinvoicepaymentstat()
       conn.ConnectionString = "Server = '" & Servername & "';  " _
                                    & "Database = '" & DBName & "'; " _
                                    & "user id = '" & sqlUName & "'; " _
                                    & "password = '" & sqlPwd & "'"

       conn.Open()
       For x As Integer = 0 To dgvinvoicedetails.Rows.Count - 1
           Dim sqlcommand As String = "UPDATE purchaseinvoice SET partialpay=@bal where docentry ='" & dgvinvoicedetails.Rows(x).Cells(0).Value & "'"
           Dim command As New SqlCommand(sqlcommand, conn)
           command.Parameters.AddWithValue("@bal", txtoutbal.Text)
           command.ExecuteNonQuery()
           command.Parameters.Clear()
       Next x
       conn.Close()
       clear()

   End Sub





Your help is much appreciated..


Thanks

Fbanz12
SuggestionRe: How to update all document number listed in datagridview using VB.net Pin
Richard MacCutchan2-Jan-18 0:04
protectorRichard MacCutchan2-Jan-18 0:04 
GeneralRe: How to update all document number listed in datagridview using VB.net Pin
Fbanz122-Jan-18 15:25
memberFbanz122-Jan-18 15:25 
GeneralRe: How to update all document number listed in datagridview using VB.net Pin
Richard MacCutchan3-Jan-18 0:29
protectorRichard MacCutchan3-Jan-18 0:29 
AnswerRe: How to update all document number listed in datagridview using VB.net Pin
Dave Kreskowiak2-Jan-18 4:05
mvpDave Kreskowiak2-Jan-18 4:05 
QuestionLanguage independent shell32.GetDetailsOf (extended file system attributes) Pin
Member 798912227-Dec-17 2:31
memberMember 798912227-Dec-17 2:31 
AnswerRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Richard MacCutchan27-Dec-17 4:01
protectorRichard MacCutchan27-Dec-17 4:01 
GeneralRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Member 798912227-Dec-17 4:57
memberMember 798912227-Dec-17 4:57 
GeneralRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Richard MacCutchan27-Dec-17 5:07
protectorRichard MacCutchan27-Dec-17 5:07 
GeneralRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Member 798912227-Dec-17 5:46
memberMember 798912227-Dec-17 5:46 
AnswerRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Gerry Schmitz28-Dec-17 8:28
memberGerry Schmitz28-Dec-17 8:28 
QuestionHow Good is Doing Programming Inverview Practice Online? Pin
CodeFights12-Dec-17 21:27
professionalCodeFights12-Dec-17 21:27 
AnswerRe: How Good is Doing Programming Inverview Practice Online? Pin
Richard MacCutchan12-Dec-17 23:07
protectorRichard MacCutchan12-Dec-17 23:07 
GeneralRe: How Good is Doing Programming Inverview Practice Online? Pin
Anup Singh10-Jan-18 3:29
memberAnup Singh10-Jan-18 3:29 
AnswerRe: How Good is Doing Programming Inverview Practice Online? Pin
jschell14-Dec-17 9:38
memberjschell14-Dec-17 9:38 
Questionneed tutor online for .net core and sql server with msbi and azure deployment Pin
vinothsrivi12-Dec-17 16:51
membervinothsrivi12-Dec-17 16:51 
AnswerRe: need tutor online for .net core and sql server with msbi and azure deployment Pin
Richard MacCutchan12-Dec-17 23:06
protectorRichard MacCutchan12-Dec-17 23:06 
AnswerRe: need tutor online for .net core and sql server with msbi and azure deployment Pin
Pete O'Hanlon13-Dec-17 0:13
protectorPete O'Hanlon13-Dec-17 0:13 

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.


Advertise | Privacy | Cookies | Terms of Service
Web01-2016 | 2.8.181117.1 | Last Updated 16 Nov 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid