C# FileUpload控件上传图片到数据库代码

FileUpload控件上传图片到数据库，并显示出来2008-05-13 10:48在添加页面的button按钮的click事件中写如下代码：

FileUpload1.PostedFile.SaveAs("路径//img//" + FileUpload1.FileName); // FileUpload控件把图片上传到img文件夹里。

string photo = "img/";

string lujing = photo + FileUpload1.FileName; //定义lujing ，及图片路径

string connStr = ConfigurationManager.ConnectionStrings["myBlogSQL1ConnectionString"].ConnectionString;
           string insertStr = "insert into photos (图像地址) values (''‘+ lujing + "')";//填入表photos中，取出路径在前台的image控件中显示，也就是把前台的image控件绑定在“图像地址”这个字段上

            SqlConnection conn = new SqlConnection(connStr);
           
            SqlCommand insertComm = new SqlCommand(insertStr, conn);

            try
            {
                conn.Open();
                //insertComm.ExecuteNonQuery();

                int flag = insertComm.ExecuteNonQuery();
                //测试是否添加
                if (flag > 0)
                {   
                    
                Session["flag"] = flag;
                   
                Response.Write("<script language=javascript>alert('添加成功!')");
                Response.Write("windows.documents.location.href='photo.aspx'</script>");
                //Response.Redirect("index.aspx");