OPRAG-OPREG

DOWNLOAD FILE HERE ! ebook preview Main Menu Preview List Data Preview Action Preview for everyone who want to learn more about OOP implementation on programming tool using C#.Net in Visual Studio environment Enjoy the lesson, thanks for visit please leave your comment about this e-book

Follow Below Script : Private Sub ExportToExcelFromGridview()         Dim excel As Microsoft.Office.Interop.Excel._Application = New Microsoft.Office.Interop.Excel.Application()         Dim workbook As Microsoft.Office.Interop.Excel._Workbook = excel.Workbooks.Open(TemplatePathEmpty)         Dim worksheet As Microsoft.Office.Interop.Excel._Worksheet = Nothing         Try             worksheet = workbook.ActiveSheet             worksheet.Name = "SUPPLIER"             Dim cellRowIndex As Integer = 2             Dim cellColumnIndex As Integer = 1             ''Adding HeaderText From Datagridview             For Each column As DataGridViewColumn In DgvSUPPLIER.Columns                 worksheet.Cells(1, column.Index + 1) = column.HeaderText             Next             For i As Integer = 0 To DgvSUPPLIER.Rows.Count - 1                 For j As Integer = 0 To DgvSUPPLIER.Columns.Count - 1                     If cellRowIndex = 1 Then          

1st Pattern, Working on Manual Add Item and Datasource Item :  2nd Pattern, Only working on Manual Add Item

This is how to get TextValue in a ComboBox before and after a spesific symbol, please see how to do that After Symbol :        'Ambil Text Setelah Tanda (-)         Dim Z As String = CmbMATERIALGROUP.Text         Dim D = Z.Substring(Z.IndexOf("-")+1)         MsgBox("" & D & "") Before Symbol :         'Ambil Text Sebelum Tanda (-)         Dim Z As String = CmbMATERIALGROUP.Text         Dim D = Z.Substring(0, Z.IndexOf("-"))         MsgBox("" & D & "")

Make a display name of your combo box content list as you wish event different name but you still can assign to specifik field as you wish. just write below codes then see what happens :      With CmbCARIDATA             DTT = New DataTable             DTT.Columns.Add("Id")             DTT.Columns.Add("Name")             DTT.Rows.Add("ApplicationName.ApplicationID", "ID")             DTT.Rows.Add("ApplicationName.ApplicationName", "NAME")             DTT.Rows.Add("ApplicationName.SystemName", "SYSTEM NAME")             DTT.Rows.Add("ApplicationName.Remark", "REMARK")             CmbCARIDATA.DataSource = DTT             CmbCARIDATA.DisplayMember = "Name"             CmbCARIDATA.ValueMember = "Id"         End With

This is how to check email address validation in VB.Net add below inheritance on your textcode : (CONTROL) Imports System.Text.RegularExpressions (BOUNDARY) Add a button and write below codes :