打印报表可以使用水晶报表工具,,
连接数据库和将数据显示在dataGrid控件里..代码下:
        private void Form1_Load(object sender, System.EventArgs e)
        {
            //Connect Sql Server
            SqlConnection conNorthwind=null;
            string ConnectString="Server=purana;DataBase=Northwind;Integrated Security=SSPI";

            try
            {
                conNorthwind=new SqlConnection(ConnectString);
                conNorthwind.Open();
                try
                {
                    SqlCommand comNorthwind=new SqlCommand();
                    comNorthwind.CommandText="Select * From Orders";
                    comNorthwind.Connection=conNorthwind;
                    SqlDataAdapter DataAdapter=new SqlDataAdapter(comNorthwind);
                    DataSet dataset=new DataSet();
                    DataAdapter.Fill(dataset,"Orders");
                    dataGrid1.DataSource=dataset.Tables["Orders"].DefaultView;
                }
                catch(SqlException exep)
                {
                    MessageBox.Show("连接失败"+"\n"+exep.Message.ToString());
                    return;
                }
                finally
                {
                    if(conNorthwind.State==ConnectionState.Open)
                    {
                        conNorthwind.Close();
                    }
                }
            }
            catch(Exception ex)
            {
                MessageBox.Show("无法连接数据库"+"\n"+ex.Message.ToString());
            }
        }