form1.cs

windows mobile读取GPS数据

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Reflection;
using Excel;
namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void hongniangBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.hongniangBindingSource.EndEdit();
            this.hongniangTableAdapter.Update(this.dataSet1.hongniang);

        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“dataSet1.hongniang”中。您可以根据需要移动或移除它。
            this.hongniangTableAdapter.Fill(this.dataSet1.hongniang);

        }
        private void button1_Click(object sender, EventArgs e)
        {
            DataTableReader dr;
            string filetxt= "c:/hong.xls";
 
           
            string str="";
            dr = this.dataSet1.hongniang.CreateDataReader();
            while (!dr.Read())
            {
                str = dr.GetString(2);
                MessageBox.Show(str);
            }
            string filename = "c:/code.xml";
            //this.dataSet1.hongniang.WriteXml(filename);
            //this.dataSet1.hongniang.WriteXml("c:/hongniang.xml");
            DataSet ds = new DataSet();
            ds.WriteXml("c:/hong1.xml");
            ds.ReadXml(filename);
            ds.WriteXml("c:/hong2.xml");
            DataTableReader dr2;
            dr2 = ds.CreateDataReader();
            
            using (StreamWriter sw = File.CreateText(filetxt))
            {
                while (dr2.Read())
                {
                    for (int i = 0; i < dr2.FieldCount; i++)
                    {
                         sw.Write(dr2.GetValue(i));
                         sw.Write("\t");
                    }
                    sw.Write(sw.NewLine);
                }
            }

        }

        private void form1ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form2 frm = new Form2();
            frm.MdiParent = this;
            //this.splitContainer1.SendToBack();
            //this.splitContainer1.Hide();
            frm.Show();
        }

        private void button2_Click(object sender, EventArgs e)
        {

        }

        private void splitContainer1_Panel2_Paint(object sender, PaintEventArgs e)
        {
        }

        private void form3ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form3 frm1 = new Form3();
            frm1.MdiParent = this;
            frm1.Show();
        }

        private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {

        }

        private void button2_Click_1(object sender, EventArgs e)
        {
            File.Create(@"e:/11.xls");

            Excel.ApplicationClass excel = new Excel.ApplicationClass();
            Excel.Workbook wb = excel.Workbooks._Open(@"e:/10.xls",Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
            wb = excel.Workbooks.Add(Missing.Value);

        }
            

        
    }
}