Tutorial Vb.Net : Export Database ke Microsoft Excel

Tutorial Vb.Net : Cara Export data dari Database ke Microsoft Excel di visual basic vb net 2010, tutorial vb net lihat selengkapnya di sector code !

Bagaimana cara Export Data dari Database ke Microsoft Excel di Vb.Net ?

Untuk mem-BackUp data dari database atau untuk Membuat laporan Rekap Data bisa dilakukan dengan meng-export data ke Microsoft Excel, tutorial Sector Code sebelumnya sudah banyak membahas tentang Cara - Cara membuat laporan menggunakan Crystall Report, Silahkan baca - baca pada label Vb.Net di Menu Utama.

Tutorial Vb.Net : Export Database ke Microsoft Excel

Untuk Export data ke Excel silahkan ikuti tutorial Vb.Net ini step by step, pertama buatlah sebuah Module Koneksi ke database, silahkan baca Tutorial Membuat Module Koneksi Database MySQL, Jika sudah buatlah Form baru dan desain seperti form berikut,

Tutorial Vb.Net : Form Export Database ke Microsoft Excel

Pada tutorial ini DateTimePicker1 dan DateTimePicker2 tidak digunakan,

Pada Form Baru, Import namespace MIcrosoft.Office.Interop.Excel

Tutorial Vb.Net : Namespace Export Database ke Microsoft Excel

klik 2x pada form dan masukkan Code Berikut :
Imports Excel = Microsoft.Office.Interop.Excel

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim x, y As Integer
        Dim vApp As Excel.Application
        Dim vWorkBook As Excel.Workbook
        Dim vWorkSheet As Excel.Worksheet
        Dim vsalah As Object = System.Reflection.Missing.Value
        vApp = New Excel.Application
        vWorkBook = vApp.Workbooks.Add(vsalah)
        vWorkSheet = vWorkBook.Sheets("sheet1")
        konek()
        DA = New OleDb.OleDbDataAdapter("SELECT * FROM tblkwitansi", conn)
        DS = New DataSet
        DS.Clear()
        DA.Fill(DS, "tblkwitansi")
        For x = 0 To DS.Tables(0).Rows.Count - 1
            For y = 0 To DS.Tables(0).Columns.Count - 1
                vWorkSheet.Cells(x + 1, y + 1) = _
                DS.Tables(0).Rows(x).Item(y)
            Next
        Next
        vWorkSheet.SaveAs("C:\Rekap-Kwitansi-SMAN4LAHAT.xlsx")
        vWorkBook.Close()
        vApp.Quit()
        releaseObject(vApp)
        releaseObject(vWorkBook)
        releaseObject(vWorkSheet)
        conn.Close()
        MsgBox("You can find the file C:\Rekap-Kwitansi-SMAN4LAHAT.xlsx")
    End Sub
    Private Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub
Setelah itu silahkan simpan dan tekan F5 untuk menjalankan aplikasi Export Database ke Microsoft Excel anda, jangan lupa share jika bermanfaat, terima kasih ;)

Next Recomended


Feel free to code it up and send us a pull request.

Hi everyone, let's me know how much this lesson can help your work. Please Subscribe and Follow Our Social Media 'kodeajaib[dot]com' to get Latest tutorials and will be send to your email everyday for free!, Just hit a comment if you have confused. Nice to meet you and Happy coding :) all ^^



Follow by E-Mail


Name

ADO.NET,3,Ajax,6,Android,9,AngularJS,4,ASP.NET,4,Blogger Tutorials,7,Bootstrap,7,C++,1,Codeigniter,2,Cplusplus,6,Crystal Report,6,CSharp,25,Ebook Java,2,FlyExam,1,FSharp,3,Game Development,2,Java,35,JDBC,2,Laravel,84,Lumen,2,MariaDB,2,Ms Access,3,MySQL,31,ODBC,6,OleDB,1,PHP,14,PHP Framework,5,PHP MYSQLI,9,PHP OOP,5,Python,8,Python 3,4,SQL Server,4,SQLite,4,Uncategorized,5,Vb 6,2,Vb.Net,89,Video,48,Vue Js,4,WPF,2,Yii,3,
ltr
item
KODE AJAIB: Tutorial Vb.Net : Export Database ke Microsoft Excel
Tutorial Vb.Net : Export Database ke Microsoft Excel
Tutorial Vb.Net : Cara Export data dari Database ke Microsoft Excel di visual basic vb net 2010, tutorial vb net lihat selengkapnya di sector code !
http://3.bp.blogspot.com/-FUuaN1bnkTM/VTm1-obUv4I/AAAAAAAAAWY/fPiAi9UNIyY/s1600/export-database-ke-excell.png
http://3.bp.blogspot.com/-FUuaN1bnkTM/VTm1-obUv4I/AAAAAAAAAWY/fPiAi9UNIyY/s72-c/export-database-ke-excell.png
KODE AJAIB
https://www.kodeajaib.com/2015/04/tutorial-vbnet-export-database-ke-excel.html
https://www.kodeajaib.com/
https://www.kodeajaib.com/
https://www.kodeajaib.com/2015/04/tutorial-vbnet-export-database-ke-excel.html
true
3214704946184383982
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy