19-06-16, 02:04 AM
PHP كود :
ds.Clear()
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = haider.mdb"
cn.Open()
sql = "select * from course where c_no = " + TextBox1.Text
dtadpt = New OleDbDataAdapter(sql, cn)
dtadpt.Fill(ds, "course")
sql = " select * from trained where c_no = " + TextBox1.Text
dtadpt = New OleDbDataAdapter(sql, cn)
dtadpt.Fill(ds, "trained")
rpt.SetDataSource(ds)
CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.RefreshReport()
cn.Close()
