HttpPostedFile UpFile = FileUpload1.PostedFile; //获取对由客户端指定的上传文件的访问
            FileLength = UpFile.ContentLength;//获取上传文件的字节大小
            string hname = FileUpload1.FileName.Substring(FileUpload1.FileName.LastIndexOf(".") + 1).ToString(); ;//截取后缀名?
            if (hname == "JPG" || hname == "GIF" || hname == "BMP")
            {
                if (FileLength > 204800)
                    Response.Write("<script>alert('对不起，图片大小不能大于200K');window.location.href='admin_link.aspx'</script>");
                return;
            }
            else
            {
                OleDbConnection conn = new OleDbConnection();
                conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../web.mdb");
                conn.Open();

                string ImageName = DateTime.Now.ToString("yyyyMMddhhmmssfff") + "." + hname;//图片名称设置为保存的时间
                Byte[] FileByte = new Byte[FileLength]; //图象文件储存到数组  
                Stream ObjectStream = UpFile.InputStream;//建立数据流对像,获取一个 Stream 对象，该对象指向一个上载文件，以准备读取该文件的内容。

                ObjectStream.Read(FileByte, 0, FileLength); //读取图象文件数据
                string StrSql = "Insert Into link(name,link,image) Values('" + linkname.Text + "','" + linkurl.Text + "',@ImageName)";
                OleDbCommand Cmd = new OleDbCommand(StrSql, conn);
                //Cmd.Parameters.Add("@Image",OleDbType.Binary, FileLength).Value = FileByte;
                Cmd.Parameters.Add("@ImageName", OleDbType.VarChar, 100).Value = ImageName;
                //conn.Open();
                this.FileUpload1.PostedFile.SaveAs(Server.MapPath("../upload") + "\\" + ImageName);
                Cmd.ExecuteNonQuery();                conn.Close();
                Response.Write("<script>alert('数据添加成功');window.location.href='admin_link.aspx'</script>");

在调试的时候Cmd.ExecuteNonQuery();出现错误显示说insert语法错误
大家看看到底是怎么回事啊?

string StrSql = "Insert Into link(name,link,image) Values('" + linkname.Text + "','" + linkurl.Text + "',@ImageName)";


直接保存IMAGENAME的变量不就可以了？

string StrSql = "Insert Into link(name,link,image) Values('" + linkname.Text + "','" + linkurl.Text + "','"+GetFile()+"')";





private string GetFile()
    {


        if (UpPic.FileBytes.Length == 0 || UpPic.FileName.Trim () =="") { return ""; }
        else
        {
            string nntype = UpPic.FileName.ToString().Substring(UpPic.FileName.ToString().Length - 3, 3).ToLower ();
            if (nntype!= "jpg" && nntype!="gif")
            {
                Code.MsgEnd("系统只允许上传jpg和gif类型的图片！", "", "");
                return "";
            }
            else
            {
                string fname = DateTime.Now.ToString("yyyyMMddhhmss") + "." +nntype ;
                UpPic.SaveAs(Server.MapPath("../Prpic/" + fname));
                return fname;
            }
        }

    }




-----------我原来就是这么做的......

修改:
string StrSql = "Insert Into link(name,link,image) Values('" + linkname.Text + "','" + linkurl.Text + "','" + ImageName + "')";
然后删除:
Cmd.Parameters.Add("@ImageName", OleDbType.VarChar, 100).Value = ImageName;

谢谢啊
解决了啊