Click here to Skip to main content
14,767,976 members
Home » Discussions » .NET (Core and Framework)
   

.NET (Core and 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
mvePete O'Hanlon15-Jan-18 23:40 
AnswerRe: Why does .Net have IL code? Pin
Gerry Schmitz17-Jan-18 10:19
mveGerry 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
mvePete 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
mvePete 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
mveRichard 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
mveRichard 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
mveDave 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
mveRichard 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
mveRichard 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
mveGerry 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
mveRichard 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
mveRichard 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
mvePete 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.