• 上传图片、word等文件到数据库



            private void button2_Click(object sender, EventArgs e)
            {
                //OpenFileDialog  opf = new OpenFileDialog();
                if (textBox2.Text == "" || comboBox1.Text  == "" || textBox3.Text == "")
                {
                    MessageBox.Show("请输入完整的信息!", "提示");
                }
                else
                {
                    FileStream fst = new FileStream(textBox2.Text, FileMode.Open, FileAccess.Read);
                    byte[] by = new Byte[fst.Length];
                    fst.Read(by, 0, (int)fst.Length);

                    if (fst.Length == 0)
                    {
                        MessageBox.Show("文件为空!", "提示");
                    }
                    else
                    {
                        

                        try
                        {
                            DataSet ds = new DataSet();
                            sqlDataAdapter2.Fill(ds, "content");
                            DataTable MyTable = ds.Tables[0];
                            DataRow MyRow = MyTable.NewRow();
                            MyRow["ProjectName"] = comboBox1.Text;
                            MyRow["Type"] = textBox4.Text;
                            MyRow["Title"] = textBox3.Text;
                            FileStream fs = new FileStream(textBox2.Text, FileMode.OpenOrCreate, FileAccess.Read);
                            byte[] MyData = new byte[fs.Length];
                            fs.Read(MyData, 0, (int)fs.Length);
                            fs.Close();
                            MyRow["ProjectContent"] = MyData;
                            MyTable.Rows.Add(MyRow);
                            sqlDataAdapter2.Update(ds, "content");
                            ds.AcceptChanges();
                            MessageBox.Show("成功存储!", "提示");
                            sqlDataAdapter2.Dispose();
                            this.Close();
                        }
                        catch(Exception ex)
                        {
                            MessageBox.Show(ex.ToString(),"错误提示");
                        }

                    }
                }
            }

  • 相关阅读:
    真的是简单、简洁、简易、简明之道!!!
    HashMap源码解读
    Jenkins Pipeline
    C语言二级指针free|一级指针存储内存地址
    openjdk编译和调试,JVM编译调试
    java linux和win jdk安装包jdk1.6、jdk1.7和jdk1.8 7u80 8u181 8u161
    关于java代码打包成jar在控制台运行变慢的问题
    Error response from daemon: driver failed programming external connectivity on endpoint quirky_allen
    mongodb副本集
    condition
  • 原文地址:https://www.cnblogs.com/hyd309/p/1182885.html
Copyright © 2020-2023  润新知