Personal Mind of ASEP

Namespaces to be included
Imports ADODB
Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlDataAdapter

Sqlconnection object has to be instantiated .
The parameters are
data source = sql server name
initial catalog = database name
user id and password
workstation id=YBRAO2000
SqlCommand object has to be instantiated to execute the Sql statement.

SqlAdapter object has to be instantiated to fill the data into DataSet.

Data set must be instantiated.
Dim objConn As SqlConnection = New SqlConnection(“data source=YBRAO2000;initial catalog=pubs;persist security info=False;user id=sa;workstation id=YBRAO2000;packet size=4096”)

Dim become As New SqlCommand()
Dim JobsDA As SqlDataAdapter = New SqlDataAdapter()
Dim JobsDS As DataSet = New DataSet()

Now the commandobject has to be created with CreateCommand method.
objcomm = objConn.CreateCommand()
Now Specify the SQL Statement.
objcomm.CommandText = “SELECT * FROM JOBS”
Now open the connection

objConn.Open()

Now Assign the command object to Sql Adapter.
JobsDA.SelectCommand = objcomm

Now Fill the Dataset with SqlAdapter
JobsDA.Fill(JobsDS, “jobs”)

Now using DataRow we can retrive all the values from the table as given below from the dataset.
Dim pRow As DataRow
For Each pRow In JobsDS.Tables(“Jobs”).Rows
system.Console.WriteLine (pRow(“job_id”).ToString())
Next

Now Close the connection
objConn.Close()
Let me explain about the SqlDataAdapter class .
SqlDataAdapter Class :
————————
Name space Required is System.Data.SqlClient
SqlDataAdapter Class Represents a set of data commands and a database connection that are used
to fill the dataset and update a SQL Server database and this class can not be
inherited.
The SqlDataAdapter, serves as a bridge between a
dataset and SQL Server for retrieving and saving data.
SqlDataAdapter is used in conjunction with SqlConnection and SqlCommand to increase
performance when connecting to a Microsoft SQL Server database.

The SqlDataAdapter also includes the SelectCommand ,InsertCommand ,DeleteCommand ,UpdateCommand ,
and TableMappings properties to facilitate the loading and updating of data.
Below I am giving some sample examples through which you can understand how exactly this object works .

JobsDA.SelectCommand = New sqlCommand( “SELECT JobID,JobName FROM Jobs” , objConn)
JobsDA.InsertCommand = New sqlCommand( “Insert Into Jobs values (1,’Marketing’)” , objConn)
JobsDA.UpdateCommand = New sqlCommand( “Update Jobs Set JobName =’Financial” Where JobID =1 ” , objConn)
JobsDA.DeleteCommand = New sqlCommand( “Delete From Jobs Where JobID =1 ” , objConn)
I hope now you are able to get the core Concepts of the SqlDataAdapter class and its behaviour.

Hari ini haru pertama masuk gawe lagih..setelah sekian lama liburan idul fitri….oh yah mohon maaf lahir batin sebelumnya..
Rasanya baru kemaren ajah libur sekarang dah masuk lagih…
Hari pertama rasanya males banget dah mau gawe, ya mungkin karena keenakan liburnya banyak kali ya..heheh..btw beberapa hari menjelan lebaran gw malah sakit sakit ampe hari sabtu setelah lebaran masuh kerasa nyut-nyutannya..
Yah kepaksa deh lebaran taun ini gw nga bayak jalan2 paling paling gw ketempat nenek gw didaerah ciparay…trus ke tempat paman gw di daerah pangalengan sekalian meres susu sapi hheheheh enak bo :)) terus ngunjung beberapa saudara ma temen2 lama gw udah deh

gambar 1. plang pesantren Al Wutsqo

gambar 2. hmmm…foto ge hehehe kebetulan gw kebagean job jadi MC

gambar 3. ini di posko SBD 6 yaitu di kedai Rubend dimana kita lagi ngedengerin pengarahan dari sang ketua SBD 6

gambar 4. ketika sudah sampe tujuan langsung kita menurunkan barang barang bawaan kita

gambar 5. nasi kotak buat makan sahur sudah diagikan

gambar 6. selain pembagian makan sahur kita juga ngebagiin bingkisan ato paket

gambar 7. ade ade santri

gambar 8. ade ade santri

Hari ini adalah hari jum’at, trus emang ada apaan dengan hari jum’at sehh..??hmmm…nga ada yang terlalu istimewa seh, cuman hari ini hari terakhir gawe, soalnya mulai besok ampe tanggal 8 novenber gw dapat liur buad lebaran…lumayan khaan ada seminggu lebih buat liburan en refresing hehhhe

oh ya kemungkinan gw mudik ke bandung hari sabtu sore besok, soalnya ntar melem dini hari gw musti ngadirin acara sahur bersama dhuafa (SBD) ke -6 di pesantren al-wutsqo yang merupakan program rutin tahunan gw ma temen-temen yang dulunya suka nongkrong di warnet iPark Margonda, ato kita-kita sering nyebutnya komunitas iPark Margonda.

Nah kalo gw dah pulkam alias pulang kampung berarti ntar gw bakalan jaran online internet lagih soalnya tempat bokap, nyokap trus nenek lumayan jauh dari warnet, trus kenapah kagak pake dial-up saja? wadoh kumaha yah….ditempat gw jalur telponnya belom nyampe bozzz…trus kalo mau pake hp wadoh wadoh biayanya kagak keuberrr hiks hiks sedih bangeettt

Asyiikkk…liburan buat lebaran jadinya tanggal 31 euy aliah hari senin.
Pengumumannya seh baru tadi, yang sebelumnya yang setau gw kalo libur lebaran tahun ini tanggal 2 November ato hari rabu alis sehari sebelum lebaran.
Tapi nga tau kenapa ko jadi di majuin, mungkin kerena beberapa pertimbangan tertentu jadinyaseperti ini. Kalo gw sehh asik asik aje…enak lagiihh liburnya jadi agak panjangan dikid heheheh