www.pudn.com > FORU(SMS).rar > SMS_GoodsChk.cs

using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Drawing; 
using System.Text; 
using System.Windows.Forms; 
using System.Data.SqlClient; 
using System.IO; 
 
namespace FORU_SMS_ 
{ 
    public partial class SMS_GoodsChk : Form 
    { 
        BaseClass.DataConn Dconn = new FORU_SMS_.BaseClass.DataConn(); 
        BaseClass.DataClass Dclass = new FORU_SMS_.BaseClass.DataClass(); 
        SqlDataAdapter adpter = new SqlDataAdapter(); 
        DataSet ds; 
        public SMS_GoodsChk() 
        { 
            InitializeComponent(); 
        } 
 
        private void SMS_GoodsChk_Load(object sender, EventArgs e) 
        { 
            dGridView.Controls.Add(hScrollBar1); 
        } 
 
        private void toolStripButton2_Click(object sender, EventArgs e) 
        { 
            ds = Dclass.GetDataSet("select * from V_Check", "V_Check"); 
            dGridView.DataSource = ds.Tables[0]; 
        } 
 
        private void toolStripButton3_Click(object sender, EventArgs e) 
        { 
            ds = Dclass.GetDataSet("select * from V_Check", "V_Check"); 
            CrystalReport.SMS_GoodsReport Greport = new FORU_SMS_.CrystalReport.SMS_GoodsReport(ds.Tables[0]); 
            Greport.Show(); 
 
            //SqlCommand sqlcom = new SqlCommand("select * from V_Check", Dconn.OpenConn()); 
            //adpter = new SqlDataAdapter(); 
            //adpter.SelectCommand = sqlcom; 
            //ds = new DataSet(); 
            //adpter.Fill(ds); 
            //CrystalReport.SMS_GoodsReport Greport = new FORU_SMS_.CrystalReport.SMS_GoodsReport(ds.Tables[0]); 
            //Greport.Show(); 
        } 
 
        private void toolStripButton4_Click(object sender, EventArgs e) 
        { 
            this.saveFileDialog1.Filter = "Microsoft Office Excel 工作簿(*.xls)|*.xls"; 
            this.saveFileDialog1.Title = "导出数据"; 
            this.saveFileDialog1.ShowDialog(); 
            int j; 
            ds = Dclass.GetDataSet("select * from V_Check", "V_Check"); 
            if (saveFileDialog1.FileName != "") 
            { 
                StreamWriter strWriter = System.IO.File.CreateText(this.saveFileDialog1.FileName); 
                strWriter.Write(""); 
                if (ds.Tables[0].Rows.Count > 0) 
                { 
                    strWriter.Write(""); 
                    for (int i = 0; i < ds.Tables[0].Columns.Count; i++) 
                    { 
                        strWriter.Write(""); 
                        for (int k = 0; k < ds.Tables[0].Columns.Count; k++) 
                        { 
                            strWriter.Write("
"); 
                        strWriter.Write(ds.Tables[0].Columns[i].ToString()); 
                    } 
                    for (j = 0; j < ds.Tables[0].Rows.Count; j++) 
                    { 
                        strWriter.Write("
"); 
                            strWriter.Write(ds.Tables[0].Rows[j][k].ToString()); 
                        } 
                    } 
 
                } 
                strWriter.Close(); 
                MessageBox.Show("成功导出数据！"); 
            } 
        } 
 
    } 
}