private void PreviewAR() { ClsConnection1.ClsGetConMSSQL(); myconnection = new SqlConnection(ClsConnection1.plsMyConMSSQL); myconnection.Open(); string sqlstatement = "SELECT * FROM ViewInfo ORDER BY LastName"; SqlDataAdapter SqlDAViewBookAR = new SqlDataAdapter(sqlstatement, myconnection); DataTable DataTable1 = new DataTable(); SqlDAViewBookAR.Fill(DataTable1); myconnection.Close(); if (DataTable1.Rows.Count == 0) { MessageBox.Show("No data found"); return; } CRInfo objRpt = new CRInfo(); objRpt.SetDataSource(DataTable1); crystalReportViewer1.ReportSource = objRpt; objRpt.Refresh(); }