Use Filter to filter Data Table
Imports System
Imports System.Data
Imports System.Data.SqlClient
public class MainClass
Shared Sub Main()
Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;" & _
"integrated security=sspi;database=MyDatabase")
' Sql Query
Dim sql As String = "SELECT ID, FirstName, LastName FROM Employee"
Try
' Create Data Adapter
Dim da As New SqlDataAdapter
da.SelectCommand = New SqlCommand(sql, thisConnection)
' Create and fill Dataset
Dim ds As New DataSet
da.Fill(ds, "Employee")
' Get the Data Tables Collection
Dim dtc As DataTableCollection = ds.Tables
' Get and Display First Data Table
' 1. Display header
Console.WriteLine("Results From Employee Table")
Console.WriteLine("FirstName".PadRight(25) & " | LastName")
' 2. Set display filter
Dim filter1 As String = "FirstName = 'Joe'"
' 3. Set sort
Dim sort1 As String = "LastName asc"
' 4. Display filtered and sorted data
For Each row As DataRow In dtc("Employee").Select(filter1, sort1)
Console.WriteLine("{0} | {1}", _
row("FirstName").ToString().PadRight(25), _
row("LastName"))
Next
Catch ex As SqlException
' Display error
Console.WriteLine("Error: " & ex.ToString())
Finally
' Close Connection
thisConnection.Close()
Console.WriteLine("Connection Closed")
End Try
End Sub
End Class
Monday, February 16, 2009
VB.Net » Database ADO.net
Simple Connection String
Imports System
Imports System.Data
Imports System.Data.OleDb
Imports System.Data.SqlClient
Imports System.Collections
Imports System.Windows.Forms
Imports System.Resources
Public Class MainClass
Shared Sub Main()
'Declare variables and objects
Dim strConnectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=Employee.mdb;"
Dim objConnection As New OleDbConnection(strConnectionString)
Dim strSQL As String = _
"SELECT FirstName, LastName FROM Employee"
Dim objCommand As New OleDbCommand(strSQL, objConnection)
Dim objDataAdapter As New OleDbDataAdapter(objCommand)
Dim objDataTable As New Data.DataTable("Employee")
Dim objDataRow As DataRow
Try
'Open the database connection
objConnection.Open()
'Fill the DataTable object
objDataAdapter.Fill(objDataTable)
'Load the list box on the form
For Each objDataRow In objDataTable.Rows
Console.WriteLine(objDataRow.Item("FirstName") & " " & _
objDataRow.Item("LastName"))
Next
Catch OleDbExceptionErr As OleDbException
'Write the exception
Console.WriteLine(OleDbExceptionErr.Message)
Catch InvalidOperationExceptionErr As InvalidOperationException
'Write the exception
Console.WriteLine(InvalidOperationExceptionErr.Message)
End Try
'Close the database connection
objConnection.Close()
'Clean up
objDataRow = Nothing
objDataTable.Dispose()
objDataTable = Nothing
objDataAdapter.Dispose()
objDataAdapter = Nothing
objCommand.Dispose()
objCommand = Nothing
objConnection.Dispose()
objConnection = Nothing
End Sub
End Class
Imports System
Imports System.Data
Imports System.Data.OleDb
Imports System.Data.SqlClient
Imports System.Collections
Imports System.Windows.Forms
Imports System.Resources
Public Class MainClass
Shared Sub Main()
'Declare variables and objects
Dim strConnectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=Employee.mdb;"
Dim objConnection As New OleDbConnection(strConnectionString)
Dim strSQL As String = _
"SELECT FirstName, LastName FROM Employee"
Dim objCommand As New OleDbCommand(strSQL, objConnection)
Dim objDataAdapter As New OleDbDataAdapter(objCommand)
Dim objDataTable As New Data.DataTable("Employee")
Dim objDataRow As DataRow
Try
'Open the database connection
objConnection.Open()
'Fill the DataTable object
objDataAdapter.Fill(objDataTable)
'Load the list box on the form
For Each objDataRow In objDataTable.Rows
Console.WriteLine(objDataRow.Item("FirstName") & " " & _
objDataRow.Item("LastName"))
Next
Catch OleDbExceptionErr As OleDbException
'Write the exception
Console.WriteLine(OleDbExceptionErr.Message)
Catch InvalidOperationExceptionErr As InvalidOperationException
'Write the exception
Console.WriteLine(InvalidOperationExceptionErr.Message)
End Try
'Close the database connection
objConnection.Close()
'Clean up
objDataRow = Nothing
objDataTable.Dispose()
objDataTable = Nothing
objDataAdapter.Dispose()
objDataAdapter = Nothing
objCommand.Dispose()
objCommand = Nothing
objConnection.Dispose()
objConnection = Nothing
End Sub
End Class
Friday, February 6, 2009
Butuh Mendesak Programmer ASP.Net
Dibutuhkan cepat ASP.Net, hanya dua bulan
Membangun sistem, fulltime, 11 juta
Mulai kerja 12 Pebruari 2009
Hub: 085693301744
Membangun sistem, fulltime, 11 juta
Mulai kerja 12 Pebruari 2009
Hub: 085693301744
Tuesday, January 20, 2009
Lowongan Programmer VB.Net
Dibutuhkan segera, tenaga Programmerr di PT. Indo Cyber Multimedia (Incymedia), perusahaan yang bergerak di bidang IT
Kualifikasi :
* Pengalaman dibidang ini selama 1 – 2 tahun
* D3/S1 di bidang Informasi tekhnologi
* Pengetahuan yang mendalam mengenai Programming Language seperti vb.net, asp.net, php, java
* Pengetahuan yang mendalam mengenai Database SQL Server, Oracle, MySQL and postgresql
* Kemampuan Debugging
* Kemampuan untuk customize Program yang sudah ada
* Memiliki kendaraan sendiri
Kirimkan Surat lamaran, CV beserta foto terbaru ke : Email : vsehelen@incymedia.com
Webite : http://www.incymedia.com
Career Level Middle
Qualification Diploma
Yr(s) Exp 1 year(s)
Job Category Information Technology (I.T.) - Application Specialist, Information Technology (I.T.) - Programming, Information Technology (I.T.) - SAP / Oracle
Job Location DKI Jakarta - Jakarta
Salary Not Specified / Negotiable
Job Type Full Time, Permanent
Kualifikasi :
* Pengalaman dibidang ini selama 1 – 2 tahun
* D3/S1 di bidang Informasi tekhnologi
* Pengetahuan yang mendalam mengenai Programming Language seperti vb.net, asp.net, php, java
* Pengetahuan yang mendalam mengenai Database SQL Server, Oracle, MySQL and postgresql
* Kemampuan Debugging
* Kemampuan untuk customize Program yang sudah ada
* Memiliki kendaraan sendiri
Kirimkan Surat lamaran, CV beserta foto terbaru ke : Email : vsehelen@incymedia.com
Webite : http://www.incymedia.com
Career Level Middle
Qualification Diploma
Yr(s) Exp 1 year(s)
Job Category Information Technology (I.T.) - Application Specialist, Information Technology (I.T.) - Programming, Information Technology (I.T.) - SAP / Oracle
Job Location DKI Jakarta - Jakarta
Salary Not Specified / Negotiable
Job Type Full Time, Permanent
Wednesday, January 14, 2009
Job at PT. MICRON MUSTIKA INTEGRASI
We are a fast growing IT company which located in Jakarta, specialized in IT solutions and Hardware Resellers. We have extensive experience both in software development, implementation as well as hardware supplies. In addition we also have cooperation with reputable partners, both local and multinational companies.
PROGRAMMER
Requirements :
* Very familiar ASP.NET 2.0
* Very familiar with JavaScript
* Very familiar with ASP. NET Web Controls
* Familiar with Windows Services
* Familiar with XML web services
* Good programming in C#
* Very good command in SQL Server 2005 programming using T-SQL (Store Procedure and Function)
* Familiar in application development using Visual Studio 2005
* Web Form report viewer
Work Experiences :
* Min 2 years experience in software development project as programmer using ASP. Net and C#.Net
Some of Main Job Descriptions :
* Bug Tracking and fixing for existing applications.
* Update or/and add new function to the application based on customer requests.
* Update existing or/and create new report using Microsoft Report Viewer.
* Day to day application developing, monitoring and maintaining.
How to apply :
Please submit your application letter and CV, email to : care@micronmustika.com
PROGRAMMER
Requirements :
* Very familiar ASP.NET 2.0
* Very familiar with JavaScript
* Very familiar with ASP. NET Web Controls
* Familiar with Windows Services
* Familiar with XML web services
* Good programming in C#
* Very good command in SQL Server 2005 programming using T-SQL (Store Procedure and Function)
* Familiar in application development using Visual Studio 2005
* Web Form report viewer
Work Experiences :
* Min 2 years experience in software development project as programmer using ASP. Net and C#.Net
Some of Main Job Descriptions :
* Bug Tracking and fixing for existing applications.
* Update or/and add new function to the application based on customer requests.
* Update existing or/and create new report using Microsoft Report Viewer.
* Day to day application developing, monitoring and maintaining.
How to apply :
Please submit your application letter and CV, email to : care@micronmustika.com
PT. INTIKOM BERLIAN MUSTIKA
PT. Intikom Berlian Mustika works in partnerships with the world’s leading companies to provide a comprehensive range of IT services and products for a broad client base. Its main services and products are consultancy, software customization & implementation assistance, education & training, software and hardware, system integration, e-commerce, networking and communication, IT Security and maintenance service.
Intikom integrates people, process and technology to deliver innovative and reliable solutions to both the private and government sector. The company’s special focus is on banking, finance, manufacturing, distribution, hospital, pharmaceutical, chemical, insurance, retail, automotive, and mining industries.
PROGRAMMER
Qualification:
* Has experience 1-2 years with Object Oriented Programming (Power Builder / Visual Basic, Visual Basic.Net and SQL Server) under Windows-NT Platform
* Education background – S1 Teknik Informasi
* Strong academy record from reputable University, GPA 3.00
* Has good communication, presentation and writing skill
* Able to communicate in English
* Willing to work out of town
Please send your CV and recent photo to: recruitment@intikom.co.id
We are sorry that only those who meet the requirements will be processed
Intikom integrates people, process and technology to deliver innovative and reliable solutions to both the private and government sector. The company’s special focus is on banking, finance, manufacturing, distribution, hospital, pharmaceutical, chemical, insurance, retail, automotive, and mining industries.
PROGRAMMER
Qualification:
* Has experience 1-2 years with Object Oriented Programming (Power Builder / Visual Basic, Visual Basic.Net and SQL Server) under Windows-NT Platform
* Education background – S1 Teknik Informasi
* Strong academy record from reputable University, GPA 3.00
* Has good communication, presentation and writing skill
* Able to communicate in English
* Willing to work out of town
Please send your CV and recent photo to: recruitment@intikom.co.id
We are sorry that only those who meet the requirements will be processed
Jobs Programmer
Perusahaan distributor Consumer Goods yang sedang berkembang pesat, mengundang Anda yang menyukai tantangan dan kerja keras untuk bergabung sebagai:
PROGRAMMER
Kriteria:
* Pria / wanita, usia max 35 Thn
* Pendidikan S1 Manajemen Informatika / IT
* Pengalaman kerja dalam membuat program software min. 1 thn
* Menguasai Database SQL Server 2005 (Replication, Store Procedure, Trigger, OLAP) dan MS Access
* Menguasai bahasa pemrograman ASP / ASP.net, VB, VB.net (2)
* Menguasai network, Windows Server 2003, MS Exchange dan sistem distribusi (nilai tambah)
* Memiliki kemampuan analisis data yang kuat
* Rajin, disiplin, jujur, dan bertanggung jawab
* Bersedia bekerja lembur
Segera kirimkan surat lamaran dan CV lengkap Anda ke: recruit_me_id@yahoo.co.id
PROGRAMMER
Kriteria:
* Pria / wanita, usia max 35 Thn
* Pendidikan S1 Manajemen Informatika / IT
* Pengalaman kerja dalam membuat program software min. 1 thn
* Menguasai Database SQL Server 2005 (Replication, Store Procedure, Trigger, OLAP) dan MS Access
* Menguasai bahasa pemrograman ASP / ASP.net, VB, VB.net (2)
* Menguasai network, Windows Server 2003, MS Exchange dan sistem distribusi (nilai tambah)
* Memiliki kemampuan analisis data yang kuat
* Rajin, disiplin, jujur, dan bertanggung jawab
* Bersedia bekerja lembur
Segera kirimkan surat lamaran dan CV lengkap Anda ke: recruit_me_id@yahoo.co.id
Friday, December 26, 2008
Job for .Net Developer
# S1 / D3 in IT or similar
# 1-2 years experience in Visual Studio .NET environment, for both desktop and web application, preferrably VS2005 or 2008
# Windows Mobile (wm 05 or wm 06) programming experience is a plus
# Have a good knowledge of web service
# Familiar with wireless networking technology
# Experience with MSSQL server environment is a plus
# Familiar with offline data processing
# Good in C# or Visual Basic
Apa job descnya?
Job desc untuk setiap orang KT itu gampang. Anda dibayar untuk:
- Belajar dan belajar untuk diri Anda sendiri
- Membantu sesama rekan kerja improve, membantu customers dan clients untuk sukses
Selebihnya, anggaplah Anda di KT mengerjakan hobi Anda.
Ada syarat lagi supaya saya bisa menjadi bagian dari KT?
- Jujur dan berintegritas tinggi
- Senang belajar hal baru
- Senang menolong orang lain
- Mampu berkomunikasi dengan baik; bahasa Inggris diutamakan
- Mampu bekerja secara mendetail dan hati-hati
Bagaimana saya bisa mengirim lamaran?
Harap CV Anda dibersihkan dari hal-hal yang tidak perlu. Misalnya, kita tidak perlu tahu bahwa Anda seorang laki/perempuan, kita tidak perlu tahu ras, agama, tanggal lahir apalagi hobi Anda. Kita juga tidak perlu melihat foto Anda. Kita juga tidak perlu tahu Anda sekolah SD di mana, SMP di mana. Dan bila Anda pernah bekerja yg tidak relevan dengan posisi yang Anda lamar, tidak perlu ditulis. Bila Anda punya skill yang tidak relevan, juga tidak perlu ditulis.
Bila sudah siap kirim lamaran Anda ke hrd@kiranatama.com, dengan judul email '.NET DEVELOPER' Atau ke PO BOX 1183 Kode Pos 40011 Bandung.
# 1-2 years experience in Visual Studio .NET environment, for both desktop and web application, preferrably VS2005 or 2008
# Windows Mobile (wm 05 or wm 06) programming experience is a plus
# Have a good knowledge of web service
# Familiar with wireless networking technology
# Experience with MSSQL server environment is a plus
# Familiar with offline data processing
# Good in C# or Visual Basic
Apa job descnya?
Job desc untuk setiap orang KT itu gampang. Anda dibayar untuk:
- Belajar dan belajar untuk diri Anda sendiri
- Membantu sesama rekan kerja improve, membantu customers dan clients untuk sukses
Selebihnya, anggaplah Anda di KT mengerjakan hobi Anda.
Ada syarat lagi supaya saya bisa menjadi bagian dari KT?
- Jujur dan berintegritas tinggi
- Senang belajar hal baru
- Senang menolong orang lain
- Mampu berkomunikasi dengan baik; bahasa Inggris diutamakan
- Mampu bekerja secara mendetail dan hati-hati
Bagaimana saya bisa mengirim lamaran?
Harap CV Anda dibersihkan dari hal-hal yang tidak perlu. Misalnya, kita tidak perlu tahu bahwa Anda seorang laki/perempuan, kita tidak perlu tahu ras, agama, tanggal lahir apalagi hobi Anda. Kita juga tidak perlu melihat foto Anda. Kita juga tidak perlu tahu Anda sekolah SD di mana, SMP di mana. Dan bila Anda pernah bekerja yg tidak relevan dengan posisi yang Anda lamar, tidak perlu ditulis. Bila Anda punya skill yang tidak relevan, juga tidak perlu ditulis.
Bila sudah siap kirim lamaran Anda ke hrd@kiranatama.com, dengan judul email '.NET DEVELOPER' Atau ke PO BOX 1183 Kode Pos 40011 Bandung.
Monday, December 22, 2008
OleDbConnection - Using sql statement
Option Strict On
Imports System.Data
Imports System.Data.OleDb
Public Module UsingStatement
Public Sub Main()
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NorthWind.mdb")
Dim cmd As New OleDbCommand
Dim dr As OleDbDataReader
Using conn
conn.Open
cmd.CommandText = "Select * From Customers"
cmd.CommandType = CommandType.Text
cmd.Connection = conn
dr = cmd.ExecuteReader()
If dr.HasRows Then
Do While dr.Read()
' Get first and last name of customer
Console.WriteLine(CStr(dr.Item(1)) & " " & CStr(dr.Item(2)))
Loop
Else
Console.WriteLine("The table has no rows.")
End If
End Using
End Sub
End Module
Imports System.Data
Imports System.Data.OleDb
Public Module UsingStatement
Public Sub Main()
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NorthWind.mdb")
Dim cmd As New OleDbCommand
Dim dr As OleDbDataReader
Using conn
conn.Open
cmd.CommandText = "Select * From Customers"
cmd.CommandType = CommandType.Text
cmd.Connection = conn
dr = cmd.ExecuteReader()
If dr.HasRows Then
Do While dr.Read()
' Get first and last name of customer
Console.WriteLine(CStr(dr.Item(1)) & " " & CStr(dr.Item(2)))
Loop
Else
Console.WriteLine("The table has no rows.")
End If
End Using
End Sub
End Module
SqlConnection - Connection string for SqlConnection
Module Module1
Dim sConnection As String = "Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=CD;Data Source=(local)"
Sub Main()
Dim objConn As New System.Data.SqlClient.SqlConnection(sConnection)
Try
objConn.Open()
Catch myException As System.Exception
Console.WriteLine(myException.Message)
End Try
Console.ReadLine()
End Sub
End Module
Dim sConnection As String = "Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=CD;Data Source=(local)"
Sub Main()
Dim objConn As New System.Data.SqlClient.SqlConnection(sConnection)
Try
objConn.Open()
Catch myException As System.Exception
Console.WriteLine(myException.Message)
End Try
Console.ReadLine()
End Sub
End Module
Tuesday, December 16, 2008
JOB VACANCY PROGRAMMER AT QDC TECHNOLOGIES, PT
Company Description
PT. Qdc Technologies is The Fast Growing Company specialized in telecommunication infrastructure development and construction, invites you to be a part of our team for the following immediate opening:
PROGRAMMER
Job Responsibilities:
* Application development
* Web integration
* Website webmaster
* Intranet webmaster
Job Requirements:
· Having educational background minimum D3
· Having minimum experience in the same position min. 2 year
· Mastering Microsoft Visual Basic 6, Visual Studio.net, MySQL, Access, database (Store Procedure)
· Having Computer skill in PC Software, hardware, network trouble solving, Linux System Administration, VB, PHP, Java
· Good in Bahasa Indonesia & basic English
· Must be willing to learn new technologies
If you meet the criteria above, please send your application letter with detail resume to: hr@qdc.co.id
If you want to know more about our company profile, please visit our website at:
www.qdc.co.id
Career Level Middle
Qualification Diploma
Yr(s) Exp 2 year(s)
Job Category Information Technology (I.T.) - Application Specialist, Information Technology (I.T.) - Programming, Information Technology (I.T.) - Software Design & Engineering
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Full Time, Permanent, Contract
Quick Apply
PT. Qdc Technologies is The Fast Growing Company specialized in telecommunication infrastructure development and construction, invites you to be a part of our team for the following immediate opening:
PROGRAMMER
Job Responsibilities:
* Application development
* Web integration
* Website webmaster
* Intranet webmaster
Job Requirements:
· Having educational background minimum D3
· Having minimum experience in the same position min. 2 year
· Mastering Microsoft Visual Basic 6, Visual Studio.net, MySQL, Access, database (Store Procedure)
· Having Computer skill in PC Software, hardware, network trouble solving, Linux System Administration, VB, PHP, Java
· Good in Bahasa Indonesia & basic English
· Must be willing to learn new technologies
If you meet the criteria above, please send your application letter with detail resume to: hr@qdc.co.id
If you want to know more about our company profile, please visit our website at:
www.qdc.co.id
Career Level Middle
Qualification Diploma
Yr(s) Exp 2 year(s)
Job Category Information Technology (I.T.) - Application Specialist, Information Technology (I.T.) - Programming, Information Technology (I.T.) - Software Design & Engineering
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Full Time, Permanent, Contract
Quick Apply
JOB VACANCY DATACOM SOLUSINDO, PT
Company Description
Datacom Solusindo as the pioneer in Telephone Billing System with thousands of customers in local & global market, looking for talented & motivated individuals who love to be challenged and ready to grow together as a team and grab the opportunity within the company as a :
Senior Programmer Analyst Post Date: 15 Dec 08
Qualification:
* Male or Female
* Age between 25 – 35 years old
* Min Education: Bachelor Degree
* At least 2 year experience in the same position
* Experienced in using UML
* Experienced in Programmer
* Experienced in leading Development Project
* Good attitude performance and charming
* Able to work independently and/or as a part of team
* Fluent in English both oral and written is advantage
* A non smoking is a must
VB Programmer
Qualification:
* Male or Female
* Age between 23 – 32 years old
* Min Education: Bachelor Degree
* At least 2 year experience in the same position
* Experienced in VB & VB.Net
* Experienced in RDBMS (MYSQL/MSSQL)
* Experienced in WEB Programming
* Good attitude performance and charming
* Able to work independently and/or as a part of team
* Fluent in English both oral and written is advantage
* A non smoking is a must
Please send your Application, CV, Portfolio and Photograph to: recruit@datacomsolusindo.co.id
or
PT Datacom Solusindo Komplek Green Garden Blok Z2 / 64-65
Career Level Middle
Qualification Degree
Yr(s) Exp 2 year(s)
Job Category Information Technology (I.T.) - Application Specialist, Information Technology (I.T.) - Programming, Information Technology (I.T.) - Software Design & Engineering
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Permanent
Datacom Solusindo as the pioneer in Telephone Billing System with thousands of customers in local & global market, looking for talented & motivated individuals who love to be challenged and ready to grow together as a team and grab the opportunity within the company as a :
Senior Programmer Analyst Post Date: 15 Dec 08
Qualification:
* Male or Female
* Age between 25 – 35 years old
* Min Education: Bachelor Degree
* At least 2 year experience in the same position
* Experienced in using UML
* Experienced in Programmer
* Experienced in leading Development Project
* Good attitude performance and charming
* Able to work independently and/or as a part of team
* Fluent in English both oral and written is advantage
* A non smoking is a must
VB Programmer
Qualification:
* Male or Female
* Age between 23 – 32 years old
* Min Education: Bachelor Degree
* At least 2 year experience in the same position
* Experienced in VB & VB.Net
* Experienced in RDBMS (MYSQL/MSSQL)
* Experienced in WEB Programming
* Good attitude performance and charming
* Able to work independently and/or as a part of team
* Fluent in English both oral and written is advantage
* A non smoking is a must
Please send your Application, CV, Portfolio and Photograph to: recruit@datacomsolusindo.co.id
or
PT Datacom Solusindo Komplek Green Garden Blok Z2 / 64-65
Career Level Middle
Qualification Degree
Yr(s) Exp 2 year(s)
Job Category Information Technology (I.T.) - Application Specialist, Information Technology (I.T.) - Programming, Information Technology (I.T.) - Software Design & Engineering
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Permanent
JOB VACANCY IT PROGRAMMER AT MITRA INTEGRASI KOMPUTINDO, PT
Qualifications:
* Familiar or experience in Web-based application development (with HTML/Javascript)
* Familiar or experience in J2EE technology such as JSP, Servlet
* Familiar or experience with SQL statement in MS SQL Server or Oracle
Please send the CV to hrd@mik.co.id
or send to
PT. Mitra Integrasi Komputindo
Taman Perkantoran Kuningan
Graha MIK, 7th floor
Jl. Setiabudi Selatan Kav. 16-17
Jakarta Selatan 12920
Career Level Entry Level
Qualification Diploma
Yr(s) Exp N/A
Job Category Information Technology (I.T.) - Application Specialist, Information Technology (I.T.) - Programming, Information Technology (I.T.) - SAP / Oracle
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Full Time, Permanent
* Familiar or experience in Web-based application development (with HTML/Javascript)
* Familiar or experience in J2EE technology such as JSP, Servlet
* Familiar or experience with SQL statement in MS SQL Server or Oracle
Please send the CV to hrd@mik.co.id
or send to
PT. Mitra Integrasi Komputindo
Taman Perkantoran Kuningan
Graha MIK, 7th floor
Jl. Setiabudi Selatan Kav. 16-17
Jakarta Selatan 12920
Career Level Entry Level
Qualification Diploma
Yr(s) Exp N/A
Job Category Information Technology (I.T.) - Application Specialist, Information Technology (I.T.) - Programming, Information Technology (I.T.) - SAP / Oracle
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Full Time, Permanent
JOB VACANCY IT PROGRAMMER AT PASIFIK SATELIT NUSANTARA, PT
Company Description
URGENTLY REQUIRED
PT. Pasifik Satelit Nusantara is Indonesia’s first private satellite telecommunications company and one of the leading satellite companies in Asia Pacific region. Headquartered in Indonesia, the Company is focused on becoming a fully integrated provider of satellite based telecommunication products and services in the region.
Due to the Company’s rapidly expanding business; we invite young, energetic and talented person to join our professional team as :
IT Programer Post Date: 16 Dec 08
Jobdes:
1. Pengalaman membuat form dan report, diutamakan developer form & report Oracle
2. Dapat menganalisis ERD
3. Menguasai database, diutamakan oracle
4. Sudah biasa menggunakan query SQL
5. Memahami alur value chain perusahaan, lebih disukai
Kualifikasi:
1. Female
2. Pendidikan S-1
3. Jurusan Teknik Informatika atau Sistem Informatika
4. Usia 23 - 25 tahun
5. Pengalaman Kerja 0 - 1 thn
6. Untuk di tempatkan di Cikarang
Kirimkan Lamaran Lengkap, CV dan Pas Foto Ke: recruitment@psn.co.id
Please put the position’s code as the SUBJECT of your e-mail.
Only short listed candidate will be notified.
Career Level Entry Level
Qualification Degree
Yr(s) Exp N/A
Job Category Information Technology (I.T.) - Programming, Information Technology (I.T.) - SAP / Oracle, Information Technology (I.T.) - IT Technical Support
Job Location (Any)
Salary Negotiable
Job Type Full Time, Permanent
URGENTLY REQUIRED
PT. Pasifik Satelit Nusantara is Indonesia’s first private satellite telecommunications company and one of the leading satellite companies in Asia Pacific region. Headquartered in Indonesia, the Company is focused on becoming a fully integrated provider of satellite based telecommunication products and services in the region.
Due to the Company’s rapidly expanding business; we invite young, energetic and talented person to join our professional team as :
IT Programer Post Date: 16 Dec 08
Jobdes:
1. Pengalaman membuat form dan report, diutamakan developer form & report Oracle
2. Dapat menganalisis ERD
3. Menguasai database, diutamakan oracle
4. Sudah biasa menggunakan query SQL
5. Memahami alur value chain perusahaan, lebih disukai
Kualifikasi:
1. Female
2. Pendidikan S-1
3. Jurusan Teknik Informatika atau Sistem Informatika
4. Usia 23 - 25 tahun
5. Pengalaman Kerja 0 - 1 thn
6. Untuk di tempatkan di Cikarang
Kirimkan Lamaran Lengkap, CV dan Pas Foto Ke: recruitment@psn.co.id
Please put the position’s code as the SUBJECT of your e-mail.
Only short listed candidate will be notified.
Career Level Entry Level
Qualification Degree
Yr(s) Exp N/A
Job Category Information Technology (I.T.) - Programming, Information Technology (I.T.) - SAP / Oracle, Information Technology (I.T.) - IT Technical Support
Job Location (Any)
Salary Negotiable
Job Type Full Time, Permanent
Job Vacancy for GAC SAMUDERA LOGISTICS, PT
GAC is a leading multinational company that provides high-quality Shipping, Logistics, Solutions and Marine services in more than 50 countries in 200 offices around the globe. GAC currently employs over 7000 people. For more details visit www.gacworld.com.
GAC Group I.T. team is expanding and looking for Programmer / Analyst with minimum 1 year experience in one of the following areas.
1. ASP.Net (C# is preferred) + Sybase (or) MS SQL Server
2. Power Builder + Sybase (or) MS SQL Server
I.T. Programmer
The job requires to be based at PT. GAC Samudera Logistics our state-of-the-art facility at Lippo Cikarang. You will be developing in-house software’s for GAC business areas and will be involved in support & implementation of the software for GAC Group of companies world-wide. It might required little travel overseas. Oral & written communication in English is required.
Please send your detailed resume in English in the format described below.
1. Current Contact details, Qualification, Personal details
2. Technical Skills
3. Employment History
4. Current Salary & Expected Salary
5. Project wise details
- Project Title / Duration
- Software / Hardware platform
- Brief description of the project and your role in the project
Only serious candidates willing to work at Lippo Cikarang need apply. GAC provides transportation from Jakarta city. Candidates willing to relocate around Lippo Cikarang are more welcome. Salary is not a constraint for the right candidate. Only short-listed candidates will be called for an interview.
Interested applicants are invited to email your resume to HR Manager
hrgsl@cbn.net.id cc: Tutik.budiyanti@gacworld.com
Last date for submitting application: December 31st, 2008
Career Level Middle
Qualification Degree
Yr(s) Exp 1 year(s)
Job Category Information Technology (I.T.) - Programming, Information Technology (I.T.) - Software Design & Engineering, Information Technology (I.T.) - Others
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Full Time, Permanent
GAC Group I.T. team is expanding and looking for Programmer / Analyst with minimum 1 year experience in one of the following areas.
1. ASP.Net (C# is preferred) + Sybase (or) MS SQL Server
2. Power Builder + Sybase (or) MS SQL Server
I.T. Programmer
The job requires to be based at PT. GAC Samudera Logistics our state-of-the-art facility at Lippo Cikarang. You will be developing in-house software’s for GAC business areas and will be involved in support & implementation of the software for GAC Group of companies world-wide. It might required little travel overseas. Oral & written communication in English is required.
Please send your detailed resume in English in the format described below.
1. Current Contact details, Qualification, Personal details
2. Technical Skills
3. Employment History
4. Current Salary & Expected Salary
5. Project wise details
- Project Title / Duration
- Software / Hardware platform
- Brief description of the project and your role in the project
Only serious candidates willing to work at Lippo Cikarang need apply. GAC provides transportation from Jakarta city. Candidates willing to relocate around Lippo Cikarang are more welcome. Salary is not a constraint for the right candidate. Only short-listed candidates will be called for an interview.
Interested applicants are invited to email your resume to HR Manager
hrgsl@cbn.net.id cc: Tutik.budiyanti@gacworld.com
Last date for submitting application: December 31st, 2008
Career Level Middle
Qualification Degree
Yr(s) Exp 1 year(s)
Job Category Information Technology (I.T.) - Programming, Information Technology (I.T.) - Software Design & Engineering, Information Technology (I.T.) - Others
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Full Time, Permanent
VB.NET Programmer job in Jakarta
SANGHIANG PERKASA, PT (KALBE NUTRITIONALS)
Essential Responsibilities: To develop state of art software application which align with the requirement and to ensure that the deliveries are in high quality level.
Education: University Degree
Qualification: Degree in Computer Science.
Experience:
* Familiar with VB.NET programming using Visual Studio 2005.
* Familiar with SQL Server 2000/2005.
* Knowledge in state of art software development technology are advantageous.
* Experiences with .NET Framework 2.0, Microsoft Source Safe, and other ORM tools are advantageous.
* Experiences with ETL tools and Reporting tools are advantageous.
Personal Skills:
* Ability to deliver high quality work
* Ability to work in teams
* Eager to learn with minimum supervision
Please send your application and full resume to:
HRD – KALBE Nutritionals
Gedung Graha Kirana Lt.5 Suite 501
Jl. Yos Sudarso Kav. 88 Sunter
Jakarta Utara 14350
Or e-mail: recruitment@kalbenutritionals.com
(Put the position code on the envelope or email subject.)
Qualification Degree
Yr(s) Exp N/A
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Full Time, Permanent
Essential Responsibilities: To develop state of art software application which align with the requirement and to ensure that the deliveries are in high quality level.
Education: University Degree
Qualification: Degree in Computer Science.
Experience:
* Familiar with VB.NET programming using Visual Studio 2005.
* Familiar with SQL Server 2000/2005.
* Knowledge in state of art software development technology are advantageous.
* Experiences with .NET Framework 2.0, Microsoft Source Safe, and other ORM tools are advantageous.
* Experiences with ETL tools and Reporting tools are advantageous.
Personal Skills:
* Ability to deliver high quality work
* Ability to work in teams
* Eager to learn with minimum supervision
Please send your application and full resume to:
HRD – KALBE Nutritionals
Gedung Graha Kirana Lt.5 Suite 501
Jl. Yos Sudarso Kav. 88 Sunter
Jakarta Utara 14350
Or e-mail: recruitment@kalbenutritionals.com
(Put the position code on the envelope or email subject.)
Qualification Degree
Yr(s) Exp N/A
Job Location DKI Jakarta - Jakarta
Salary Negotiable
Job Type Full Time, Permanent
Friday, December 12, 2008
Creating Multimedia Applications
You can create various multimedia applications in VB that could play audio CD, audiofiles, VCD , video files and more.
To be able to play multimedia files or multimedia devices, you have to insert Microsoft Multimedia Control into your VB applications that you are going to create. However, Microsoft Multimedia Control is not normally included in the startup toolbox, therefore you need to add the MM control by pressing Ctrl+T and select it from the components dialog box that is displayed.
1. Creating a CD player
The Code
Private Sub Form_Load()
'To position the page at the center
Left = (Screen.Width - Width) \ 2
Top = (Screen.Height - Height) \ 2
'Initialize the CD
myCD.Command = "Open"
End Sub
Private Sub myCD_StatusUpdate()
'Update the track number
trackNum.Caption = myCD.Track
End Sub
Private Sub Next_Click()
myCD.Command = "Next"
End Sub
Private Sub Play_Click()
myCD.Command = "Play"
End Sub
Private Sub Previous_Click()
myCD.Command = "Prev"
End Sub
Private Sub Stop_Click()
myCD.Command = "Stop"
End Sub
To be able to play multimedia files or multimedia devices, you have to insert Microsoft Multimedia Control into your VB applications that you are going to create. However, Microsoft Multimedia Control is not normally included in the startup toolbox, therefore you need to add the MM control by pressing Ctrl+T and select it from the components dialog box that is displayed.
1. Creating a CD player
The Code
Private Sub Form_Load()
'To position the page at the center
Left = (Screen.Width - Width) \ 2
Top = (Screen.Height - Height) \ 2
'Initialize the CD
myCD.Command = "Open"
End Sub
Private Sub myCD_StatusUpdate()
'Update the track number
trackNum.Caption = myCD.Track
End Sub
Private Sub Next_Click()
myCD.Command = "Next"
End Sub
Private Sub Play_Click()
myCD.Command = "Play"
End Sub
Private Sub Previous_Click()
myCD.Command = "Prev"
End Sub
Private Sub Stop_Click()
myCD.Command = "Stop"
End Sub
Thursday, December 11, 2008
SqlConnection - Connection string for SqlConnection
Module Module1
Dim sConnection As String = "Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=CD;Data Source=(local)"
Sub Main()
Dim objConn As New System.Data.SqlClient.SqlConnection(sConnection)
Try
objConn.Open()
Catch myException As System.Exception
Console.WriteLine(myException.Message)
End Try
Console.ReadLine()
End Sub
End Module
Dim sConnection As String = "Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=CD;Data Source=(local)"
Sub Main()
Dim objConn As New System.Data.SqlClient.SqlConnection(sConnection)
Try
objConn.Open()
Catch myException As System.Exception
Console.WriteLine(myException.Message)
End Try
Console.ReadLine()
End Sub
End Module
OleDbConnection - Using sql statement
Option Strict On
Imports System.Data
Imports System.Data.OleDb
Public Module UsingStatement
Public Sub Main()
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NorthWind.mdb")
Dim cmd As New OleDbCommand
Dim dr As OleDbDataReader
Using conn
conn.Open
cmd.CommandText = "Select * From Customers"
cmd.CommandType = CommandType.Text
cmd.Connection = conn
dr = cmd.ExecuteReader()
If dr.HasRows Then
Do While dr.Read()
' Get first and last name of customer
Console.WriteLine(CStr(dr.Item(1)) & " " & CStr(dr.Item(2)))
Loop
Else
Console.WriteLine("The table has no rows.")
End If
End Using
End Sub
End Module
Imports System.Data
Imports System.Data.OleDb
Public Module UsingStatement
Public Sub Main()
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NorthWind.mdb")
Dim cmd As New OleDbCommand
Dim dr As OleDbDataReader
Using conn
conn.Open
cmd.CommandText = "Select * From Customers"
cmd.CommandType = CommandType.Text
cmd.Connection = conn
dr = cmd.ExecuteReader()
If dr.HasRows Then
Do While dr.Read()
' Get first and last name of customer
Console.WriteLine(CStr(dr.Item(1)) & " " & CStr(dr.Item(2)))
Loop
Else
Console.WriteLine("The table has no rows.")
End If
End Using
End Sub
End Module
Create OleDbConnection to Access database
Imports System.Data
Module Test
Sub Main()
Dim sConnectionString, sSQL As String
'SQL Connection String
sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourdatabase.mdb"
sSQL = "SELECT Title FROM yourTable"
Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString)
Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn)
Dim dr As System.Data.OleDb.OleDbDataReader
conn.Open()
dr = cmd.ExecuteReader()
Do While dr.Read()
System.Console.WriteLine(dr.Item("Title"))
Loop
dr.Close()
conn.Close()
End Sub
End Module
Module Test
Sub Main()
Dim sConnectionString, sSQL As String
'SQL Connection String
sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourdatabase.mdb"
sSQL = "SELECT Title FROM yourTable"
Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString)
Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn)
Dim dr As System.Data.OleDb.OleDbDataReader
conn.Open()
dr = cmd.ExecuteReader()
Do While dr.Read()
System.Console.WriteLine(dr.Item("Title"))
Loop
dr.Close()
conn.Close()
End Sub
End Module
Subscribe to:
Posts (Atom)