SUM QTY FROM DATATABLE VB.NET

Dim DTGakGeser, DTGeser As New DataTable

DTGakGeser.Columns.Add("COGAKGESER", GetType(String))

DTGakGeser.Columns.Add("QTYGAKGESER", GetType(Decimal))

DTGeser.Columns.Add("COGESER", GetType(String))

DTGeser.Columns.Add("QTYGESER", GetType(Decimal))

Dim tmpSUMGakGeser, tmpSUMGeser

If DTGakGeser.Rows.Count > 0 Then

'SUM DATATABLE

tmpSUMGakGeser = Convert.ToInt32(DTGakGeser.Compute("SUM(QTYGAKGESER)", String.Empty))

End If

If DTGeser.Rows.Count > 0 Then

'SUM DATATABLE

tmpSUMGeser = Convert.ToInt32(DTGeser.Compute("SUM(QTYGESER)", String.Empty))

End If

Comments

VS2015 using Bootstrap

this is how you gonna do that.. yes it is sometimes learning using tutorial book makes us boring.. so this tutorial is how to make it simple but very useful in understanding Tutorial To Download

CheckBox dalam DataGridView VB.Net

Pada saat membuat aplikasi (VB.Net) untuk materi skripsi, terbesit bagaimana cara baru untuk memberikan hak akses user secara dinamis pada sistem. setelah dicoba dengan tanya-tanya. akhirnya bisa mendapatkan cara itu... wah sesuatu banget dah.... inti dari posting ini hanya pada barisan kode berikut : Private Sub BtnSIMPAN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSIMPAN.Click Dim Y As String = Mid(CmbUSER.Text, 1, 7) Dim iROW As Integer Dim AKSES As String For iROW = 0 To DGVSample.Rows.Count - 1 'AksesBox = Nama CheckBox yang ada di DatagridView If DGVSample.Rows(iROW).Cells("AksesBox").Value Then ...

Create Comment As .xls In Farpoint Spread

Private Sub TAGS_PARENTING() Dim DTPopUp As New DataTable With DTPopUp .Columns.Add("SEQ", GetType(String)) .Columns.Add("QTY", GetType(String)) .Columns.Add("ETD", GetType(String)) .Columns.Add("ETA", GetType(String)) DTPopUp = MePostab_Control.Cari_TAG_PARENTING End With With FPPOSTAB For GG As Integer = 0 To .ActiveSheet.RowCount - 1 ...

OPRAG-OPREG

Search This Blog