• 流方式文件读写(简单实现)


           //filename为打开的文件名称   结果是把filename所示的文件读到MyData中

    FileStream fs = new FileStream(filename, FileMode.OpenOrCreate, FileAccess.Read);

    byte[] MyData = new byte[fs.Length];
    fs.Read(MyData, 0, Convert.ToInt32(fs.Length));

    fs.Close();

    //textbox控件的TextChanged事件触发

    private void textBox_bar_TextChanged(object sender, EventArgs e)//扫描打开
    {
    string fileNumber = textBox_bar.Text;//扫描枪得到的字符
    string[] numbers = fileNumber.Split('\r');
    fileNumber = numbers[0];
    //fileNumber = fileNumber.Trim('\r');实现字符串的处理  剪去回车符
    SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename
    =|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");//连接数据库
    con.Open();
    using (SqlCommand cmd = con.CreateCommand())
    {
    cmd.CommandText = "Select imgField From MyImages where fileNumber=@fileNumber";

    cmd.Parameters.Add(new SqlParameter("@fileNumber", fileNumber));

    using (SqlDataReader reader = cmd.ExecuteReader())
    {

    if (reader.Read())
    {
    byte[] MyData = null;
    MyData = (byte[])reader["imgField"];
    int ArraySize = new int();
    ArraySize = MyData.GetUpperBound(0);
    FileStream fs = new FileStream(@"C:\1T02Dwg1\1.dwg", FileMode.OpenOrCreate, FileAccess.Write);
    fs.Write(MyData, 0, ArraySize);
    fs.Close();  //写数据库中得到的数据文件
    string filepath = @"C:\1T02Dwg1\1.dwg";
    this.axAvViewX1.src = filepath;
    this.axAvViewX1.ZoomExtents();

    this.Text = filepath;
    }
    else
    {
    MessageBox.Show("图纸不存在,请确认!");
    }

    }
    con.Close();
    }
    }

  • 相关阅读:
    Windows系统下安装运行Kafka
    Git强制拉取覆盖本地
    Windows Server 2008/2012 计划任务配置执行bat
    Task.Run()任务执行
    Oracle数据重复,只取一条
    Oracle数据库查看表空间是否为自增的
    How to disable Microsoft Compatibility Telemetry
    最新版谷歌浏览器的Flash设置已经不能保存了?
    亲子之间,在于看懂,无关耐心zz
    读懂孩子有方法
  • 原文地址:https://www.cnblogs.com/hanjiaxu/p/2886440.html
Copyright © 2020-2023  润新知