OPRAG-OPREG

 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  

   For Each row As DataGridViewRow In DgvDETECTIONTESTINPUT.Rows                     Dim CmbBoxSize As DataGridViewComboBoxCell = CType((row.Cells(0)), DataGridViewComboBoxCell)                     CmbBoxSize.Items.Add(MejaData(row.Index)(1))                     CmbBoxSize.Value = MejaData(row.Index)(1)                 Next

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 MVC5 & VB.Net Tutorial

VView (.vbhtml)               <div class="form-group">                      @Html.LabelFor(Function(model) model.Plant, "Plant",                          htmlAttributes:=New With {.class = "control-label col-md-2"})                      <div Class="col-md-10">                      @Html.DropDownList("MeSkill", New List(Of SelectListItem)() From                         {  ...

Run your Visual Studio as Administrator account

                                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"), ...

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

 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

 Dim _DateUsage As DateTime = DgvFODAILY.Item(4, DgvFODAILY.CurrentRow.Index).Value  Dim _DateUsageStr As String = _DateUsage.ToString("yyyy-MM-dd")

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

VB C # UBound () = yourArray . GetUpperBound ( 0 ) or yourArray . Length for one - dimesional arrays LBound () = yourArray . GetLowerBound ( 0 ) IsNothing () = Object . ReferenceEquals ( obj , null ) Chr () = Convert . ToChar () Len () = "string" . Length UCase () = "string" . ToUpper () LCase () = "string" . ToLower () Left () = "string" . Substring ( 0 , length ) Right () = "string" . Substring ( "string" . Length - desiredLength ) RTrim () = "string" . TrimEnd () LTrim () = "string" . TrimStart () Trim () = "string" . Trim () Mid () = "string" . Substring ( start , length ) Replace () = "string" . Replace () Split () = "string" . Split () Join () = String . Join () MsgBox () = MessageBox . Show () IIF () ...

VB.Net Dim_strNamaGrup As String = "blogger" Dim strNamaGrup As String = Mid(_strNamaGrup, 0, 3) C# string _strNamaGrup = "blogger"; string strNamaGrup = _strNamaGrup.Substring(0,3); result : blo

this is the source for doin that. https://stackoverflow.com/questions/31211506/how-stuff-and-for-xml-path-work-in-sql-server

If you meet this message : uncheck below marked :

Download File (.rar) Inside this tutorial : Main Menu Application SplitContainer Child Form

                                    Dim Cek_vRATIO As Double                                     If Double.TryParse(vRATIO, Cek_vRATIO) Then                                         .EstimateRatio = Cek_vRATIO                                     Else                                         .EstimateRatio = 0                                     End If

this query gonna tell you how to combine 2 field as 1 select in SQL : CONCAT(ENDBALANCE_TABLE.MONTHENDBALANCE, ENDBALANCE_TABLE.YEARENDBALANCE) as BULANTAHUN

TRIGGER INSERT : create trigger [dbo].[trigger name] on [dbo].[table name 1st] after INSERT as begin insert into [IP Address destination server].[2nd database name].[dbo].[table name 2nd] select [Material]       ,[MaterialDescr]       ,[MatlGroup]       ,[Createdby] from inserted end TRIGGER DELETE : create trigger [dbo].[trigger name] on [dbo].[table name 1st] for DELETE as declare @ID varchar(15) SET @ID = (select [Material] from deleted) begin delete from [IP Address destination server].[2nd database name].[dbo].[table name 2nd]  where MATERIAL = @ID end

add below script !!!! on your query SQLDataAdapter.SelectCommand.Timeout = 0

 Dim Temukan As DataRow() = DTSumPO.Select("PONUM ='" & vPO & "' AND POQTY = '" & vQTY & "'")                                         If Temukan.Length = 0 Then                                             DTSumPO.Rows.Add(vPO, vQTY)                                         End If