OPRAG-OPREG

Select multiple rows data then show in one row this is how to do that : select DATA=stuff(( select top 2 '/' + supplierpicname from TABELSUPPLIERCONTACT where supplierid = 'SUP006' for XML path('')),1,1,'') select DATA=stuff(( select  top 2  ' / ' + supplierpicname from TABELSUPPLIERCONTACT where supplierid = 'SUP006' for XML path('')),1,3,'')

  Private Sub CmbPERIODYEARSTART_KeyPress(sender As Object, e As KeyPressEventArgs) Handles CmbPERIODYEARSTART.KeyPress         If Not Char.IsDigit(e.KeyChar) Then             e.Handled = True         End If     End Sub

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             ...

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