Click here to Skip to main content
13,903,016 members

.NET Framework

 
QuestionWhy does .Net have IL code? Pin
nrnoble15-Jan-18 22:19
membernrnoble15-Jan-18 22:19 
AnswerRe: Why does .Net have IL code? Pin
Pete O'Hanlon15-Jan-18 22:40
protectorPete O'Hanlon15-Jan-18 22:40 
AnswerRe: Why does .Net have IL code? Pin
Gerry Schmitz17-Jan-18 9:19
mveGerry Schmitz17-Jan-18 9:19 
Question.NET 4.7.1 Pin
Member 1361680410-Jan-18 10:50
memberMember 1361680410-Jan-18 10:50 
AnswerRe: .NET 4.7.1 Pin
Pete O'Hanlon10-Jan-18 11:24
protectorPete O'Hanlon10-Jan-18 11:24 
GeneralRe: .NET 4.7.1 Pin
Member 1361680410-Jan-18 12:05
memberMember 1361680410-Jan-18 12:05 
GeneralRe: .NET 4.7.1 Pin
Pete O'Hanlon10-Jan-18 12:16
protectorPete O'Hanlon10-Jan-18 12:16 
QuestionHow to update all document number listed in datagridview using VB.net Pin
Fbanz121-Jan-18 14:48
memberFbanz121-Jan-18 14: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 MacCutchan1-Jan-18 23:04
protectorRichard MacCutchan1-Jan-18 23:04 
GeneralRe: How to update all document number listed in datagridview using VB.net Pin
Fbanz122-Jan-18 14:25
memberFbanz122-Jan-18 14:25 
GeneralRe: How to update all document number listed in datagridview using VB.net Pin
Richard MacCutchan2-Jan-18 23:29
protectorRichard MacCutchan2-Jan-18 23:29 
AnswerRe: How to update all document number listed in datagridview using VB.net Pin
Dave Kreskowiak2-Jan-18 3:05
mveDave Kreskowiak2-Jan-18 3:05 
QuestionLanguage independent shell32.GetDetailsOf (extended file system attributes) Pin
Member 798912227-Dec-17 1:31
memberMember 798912227-Dec-17 1:31 
AnswerRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Richard MacCutchan27-Dec-17 3:01
protectorRichard MacCutchan27-Dec-17 3:01 
GeneralRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Member 798912227-Dec-17 3:57
memberMember 798912227-Dec-17 3:57 
GeneralRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Richard MacCutchan27-Dec-17 4:07
protectorRichard MacCutchan27-Dec-17 4:07 
GeneralRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Member 798912227-Dec-17 4:46
memberMember 798912227-Dec-17 4:46 
AnswerRe: Language independent shell32.GetDetailsOf (extended file system attributes) Pin
Gerry Schmitz28-Dec-17 7:28
mveGerry Schmitz28-Dec-17 7:28 
QuestionHow Good is Doing Programming Inverview Practice Online? Pin
CodeFights12-Dec-17 20:27
professionalCodeFights12-Dec-17 20:27 
AnswerRe: How Good is Doing Programming Inverview Practice Online? Pin
Richard MacCutchan12-Dec-17 22:07
protectorRichard MacCutchan12-Dec-17 22:07 
GeneralRe: How Good is Doing Programming Inverview Practice Online? Pin
Anup Singh10-Jan-18 2:29
memberAnup Singh10-Jan-18 2:29 
AnswerRe: How Good is Doing Programming Inverview Practice Online? Pin
jschell14-Dec-17 8:38
memberjschell14-Dec-17 8:38 
Questionneed tutor online for .net core and sql server with msbi and azure deployment Pin
vinothsrivi12-Dec-17 15:51
membervinothsrivi12-Dec-17 15:51 
AnswerRe: need tutor online for .net core and sql server with msbi and azure deployment Pin
Richard MacCutchan12-Dec-17 22:06
protectorRichard MacCutchan12-Dec-17 22:06 
AnswerRe: need tutor online for .net core and sql server with msbi and azure deployment Pin
Pete O'Hanlon12-Dec-17 23:13
protectorPete O'Hanlon12-Dec-17 23: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
Web03 | 2.8.190306.1 | Last Updated 24 Mar 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid