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 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 End Sub
Now I want to generate report from the data field available in data grid in the form :
(Salutation) (fname) (mname) (lname), (degree)
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