图片上传与数据库代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace WA1
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        //创建数据库连接
        static string conStr = @"Data Source=PC-201502051038\SQLEXPRESS;Initial Catalog=EmployeeDB;uid=sa;pwd=chuangye";
        SqlConnection conn = new SqlConnection(conStr);
        
        //SqlDataAdapter da = new SqlDataAdapter();
        
        
        protected void Button1_Click(object sender, EventArgs e)
        {
            

            HttpFileCollection uploadFiles = Request.Files;
            for (int i = 0; i < uploadFiles.Count; i++)
            {
                HttpPostedFile postedFile = uploadFiles[i];
                try
                {
                    //连接可以在外面，这些操作则在函数里
                    SqlCommand cmd = conn.CreateCommand();
                    conn.Open();
                    string filenames = postedFile.FileName;//获取文件名称

                    //command
                    cmd.CommandText = "insert into T_PhotoInfo(PhotoTitle,PhotoName,PhotoDes,UploadTime)values(@A,@PhotoName,@PhotoDes,@UploadTime)";
                    cmd.Parameters.Add(new SqlParameter("A", txtTitle.Text));
                    cmd.Parameters.Add(new SqlParameter("PhotoName", filenames));
                    cmd.Parameters.Add(new SqlParameter("PhotoDes", txtDes.Text));
                    cmd.Parameters.Add(new SqlParameter("UploadTime", DateTime.Now));
                    int count = cmd.ExecuteNonQuery();
                    if (count > 0)
                    {
                        string suffix = Path.GetExtension(filenames).ToLower();//获取文件后缀
                        if (suffix == ".gif" || suffix == ".jpg" || suffix == ".bmp" || suffix == ".png")
                        {
                            int filelength = (FUload.PostedFile.ContentLength) / 1024;
                            if (filelength < 2048)
                            {
                                //保存图片的网络服务目录
                                string ok = Server.MapPath("MyFile\\" + postedFile.FileName);
                                //保存图片
                                postedFile.SaveAs(ok);




                            }
                            else
                            {
                                Response.Write("上传图片太大，请上传小于2M的图片");
                                return;
                            }
                        }
                    }

                }
                catch (Exception ex)
                {
                    Response.Write("fdad" + ex.Message);
                    return;
                }
                finally
                {
                    conn.Close();
                }

            }
            Response.Write("上传成功");

        }
    }
}