Print ms access data in vb.net
Posted
by user225269
on Stack Overflow
See other posts from Stack Overflow
or by user225269
Published on 2010-03-08T11:28:08Z
Indexed on
2010/03/08
11:36 UTC
Read the original article
Hit count: 361
How do I print the ms access data(.mdb) in vb.net? Here is the code that I'm using to view the data in the form. What I want to do is to be able to print what is currently being viewed. Perhaps automatically save the .pdf file and the pdf viewer installed on the system will open that newly generated pdf file
Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\search.mdb")
Dim cmd As OleDbCommand = New OleDbCommand("Select * from GH where NAME= '" & TextBox6.Text & "' ", cn)
cn.Open()
Dim rdr As OleDbDataReader
rdr = cmd.ExecuteReader
If rdr.HasRows Then
rdr.Read()
NoAcc = rdr("NAME")
If (TextBox6.Text = NoAcc) Then TextBox1.Text = rdr("IDNUMBER")
If (TextBox6.Text = NoAcc) Then TextBox7.Text = rdr("DEPARTMENT")
If (TextBox6.Text = NoAcc) Then TextBox8.Text = rdr("COURSE")
End If
-some sites for beginners regarding this topic would help a lot:)
© Stack Overflow or respective owner