No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I want to build a module to combine multiple text file in a .csv file by using vb.net. My text file data like this: (T1.txt) UnitCode|Qty 001|56 002|45 003|100 004|78 005|67 (T2.txt) UnitCode|Qty 001|78 002|166 003|10 005|12 I want the output like this: (Output.csv) UnitCode,T1,T2 001,56,78 002,45,166 003,100,10 004,78, 005,67,12 … | |
Public Sub SearchUser() Try conn = New MySqlConnection() conn.ConnectionString = "server=localhost; user id=root; database=eps" conn.Open() sqlquery = "SELECT username FROM pass WHERE username = '" & cmbUserName.Text & "'" Dim myCommand As New MySqlCommand() myCommand.Connection = conn myCommand.CommandText = sqlquery 'start query myAdapter.SelectCommand = myCommand Dim myData As MySqlDataReader myData … | |
[code=vbnet]Imports MySql.Data.MySqlClient Imports System.Data Imports System.Configuration Public Class frmMasterCode Dim conn As New MySqlConnection Dim myDataAdapter As New MySqlDataAdapter Dim sqlquery As String Dim cmd As New MySqlCommand() Dim myDataReader As MySqlDataReader Private aeps1DataSet As epsDataSet Private amasterCodeTableAdapter As epsDataSetTableAdapters.master_codeTableAdapter Private WithEvents amaster_codeBindingSource As BindingSource Private Sub frmMasterCode_Load(ByVal sender As … |