Dear frens,
from your help I succeeded in creating data grid . Thank you for it.
Now i need to generate report from data grid.
my data grid code is as follows;
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
<code class="inlinecode">
Db1DataSet1.Clear()
Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source=K:\Database\db1.mdb"
Dim con As OleDb.OleDbConnection = New OleDb.OleDbConnection(conStr)
Dim S As String
Dim datagrid1 As New DataGrid
S = "select * from add1 where ID='" & TextBox1.Text & "'"
Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(S, con)
da.Fill(Db1DataSet1, "add1")
datagrid1.DataSource = Db1DataSet1.DefaultViewManager
</code>
End Sub
Now I want to generate report from the data field available in data grid in the form :
[Salutation] [fname] [mname] [lname], [degree]
[Position]
[organisation]
[Street] [City]
[State]
[Country]
Phone:[tel1] ,[tel2],[tel3]
Fax: [fax]
Email: [email]
URL: [URL]
I want to make two columns in the report to show various contacts' addresses in the data grid into printable form by generating report.
I don have any idea to generate report as i have never done it .
Please provide me with help with necessary explanations.
Anticipating for your help
Regards;
Kshiteesh