Ejemplos de ClsConnection.ClsGetConMSSQL en C# (CSharp)

Ejemplo n.º 1

        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();
        }