Skip to main content

Posts

Showing posts from 2019

Pop Up message Visual Studio "The operation could not be completed. The process cannot access the file because it is being used by another process"

Run your Visual Studio as Administrator account

Parent Child Data VB.Net

                                Dim DS_ParentChild As New DataSet()                 DS_ParentChild.Tables.Add(DTMaterial)                 DS_ParentChild.Tables.Add(DTChild)                 'Relation                 DS_ParentChild.Relations.Add("MODEL",                                              DTMaterial.Columns("CODE"),                                              DTChild.Columns("CHILD")                                              )                 .DataSource = DS_ParentChild                 .ActiveSheet.Columns(0).DataField = "CODE"

Skip Rows In Uploading .xls Files

Private Sub DATA_TOBE_SAVE()         OfdBUKAFILE.Filter = "*.xlsx|*.xlsx|All files(*.*)|*.*"         If OfdBUKAFILE.ShowDialog = Windows.Forms.DialogResult.OK Then             Try                 Conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" & _                      "Data Source='" & OfdBUKAFILE.FileName & "';Extended Properties=Excel 12.0;")                 DA = New OleDbDataAdapter("SELECT * FROM [FIXED_ORDER_MONTHLY$]", Conn)                 DTTemp = New DataTable                 Conn.Open()                 DA.Fill(DTTemp)                 'Skip Datatable Rows.. ini skip 2 baris...                 Dim BarisBaru As IEnumerable(Of DataRow) = DTTemp.AsEnumerable().Skip(2)                 Dim DT As DataTable = BarisBaru.CopyToDataTable()                 'Skip Datatable Rows.. ini skip 2 baris...                 Dim DT_Check_Upload As New DataTable                 For Each t

Membuat PictureBox Menjadi BULAT

 Private Sub FOTOBULAT()         Dim theGambar As System.Drawing.Drawing2D.GraphicsPath = New System.Drawing.Drawing2D.GraphicsPath()         theGambar.AddEllipse(0, 0, ImgPHOTO.Width - 3, ImgPHOTO.Height - 3)         Dim theRegion As Region = New Region(theGambar)         ImgPHOTO.Region = theRegion     End Sub

C# OOP 2019

DOWNLOAD FILE C# OOP TUTORIAL silahkan download for free..