Dim m_sqlConn As SqlConnection
Dim m_strSqlConn As String
m_strSqlConn = "Data Source=localhost; initial catalog=pubs;User id=sa;password="
m_sqlConn = New SqlConnection(m_strSqlConn)
Try
Dim sqlAdp As SqlDataAdapter
Dim strSql As String
Dim ds = New DataSet()
m_sqlConn.Open()
strSql = "SELECT au_lname AS Column1, au_fname AS Column2, phone AS Column3, address AS Column4 FROM dbo.authors"
sqlAdp = New SqlDataAdapter(strSql, m_sqlConn)
sqlAdp.Fill(ds)
Dim crReportDocument = New CrystalReport1()
crReportDocument.SetDataSource(ds.Tables(0))
CrystalReportViewer1.ReportSource = crReportDocument
Catch ex As Exception
MessageBox.Show(ex.ToString())
End Try
strSql="select a.plan_no,a.vendername as vender,a.shopname as shop,a.plan_date,a.empname as planer,a.remark "+
",b.line_no,b.shoplocname as shoploc,b.barid,b.goodsname,b.unitname as unit,b.price,b.PLAN_QTY,a.planfmno" +
" from Vw_PLANPOMAIN a inner join Vw_PLANPODETAIL b on a.plan_no=b.plan_no";
SqlConnection myConnection=new SqlConnection(ConnectionString);
myConnection.Open();