Click here to Skip to main content
14,826,253 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
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
mvePete 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
mvePete 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
mveRichard 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
mveRichard 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
mveRichard 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
mveRichard 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
mveRichard 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
mveRichard 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
mvePete O'Hanlon12-Dec-17 23:13 
GeneralRe: need tutor online for .net core and sql server with msbi and azure deployment Pin
vinothsrivi12-Dec-17 23:55
Membervinothsrivi12-Dec-17 23:55 
GeneralRe: need tutor online for .net core and sql server with msbi and azure deployment Pin
Dave Kreskowiak13-Dec-17 2:12
mveDave Kreskowiak13-Dec-17 2:12 
AnswerRe: need tutor online for .net core and sql server with msbi and azure deployment Pin
Dave Kreskowiak13-Dec-17 2:14
mveDave Kreskowiak13-Dec-17 2:14 

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.