当前位置:编程学习 > C#/ASP.NET >>

总是说我数目对不上,请问哪里出错了吗



using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using System.Data.OleDb;


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

        Server.Execute("ceck.aspx");


    }
    protected void Button1_Click(object sender, EventArgs e)
    {











        bool fileIsValid = false;
        //如果确认了上传文件,则判断文件类型是否符合要求
        if (this.FileUpload1.HasFile)
        {
            //获取上传文件的后缀
            String fileExtension = System.IO.Path.GetExtension(this.FileUpload1.FileName).ToLower();
            String[] restrictExtension = { ".gif", ".jpg", ".bmp", ".png", ".rar", ".doc", ".ppt" };
            //判断文件类型是否符合要求
            for (int i = 0; i < restrictExtension.Length; i++)
            {
                if (fileExtension == restrictExtension[i])
                {
                    fileIsValid = true;

                }

            }
            //如果文件类型符合要求,调用SaveAs方法实现上传,并显示相关信息
            if (fileIsValid == true)
            {
                try
                {

                    this.FileUpload1.SaveAs(Server.MapPath("~/images/") + FileUpload1.FileName);
                    this.Label1.Text = "文件上传成功";
                    this.Label1.Text += "<li>" + "文件上传路径:" + "images/" + FileUpload1.FileName;

                }
                catch
                {
                    this.Label1.Text = "文件上传不成功!";

                }
                finally
                {



                }
            }
            else
            {
                this.Label1.Text = "只能够上传后缀为.gif,.jpg,.bmp,.png的文件夹";

            }

        }



    }
    protected void Button2_Click(object sender, EventArgs e)
    {





        string name = Request.Params["name"];


        string path = Request.Params["path"];

        string jianjie = Request.Params["jianjie"];
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OleDB.4.0;Data Source= " + Server.MapPath("../sjk.mdb"));
        conn.Open();

        string str = "insert into zaocang(name,path,jianjie) values ('" + name + "','" + path + "''"+jianjie+"')";


        OleDbCommand cmd = new OleDbCommand(str, conn);

        cmd.ExecuteNonQuery();
         conn.Close();
       

        Response.Write("<font color=red>添加成功!</font>");











    }
}
--------------------编程问答-------------------- 是  cmd.ExecuteNonQuery();
这句话 --------------------编程问答-------------------- values ('" + name + "','" + path + "','"+jianjie+"')";

--------------------编程问答--------------------  string str = "insert into zaocang(name,path,jianjie) values ('" + name + "','" + path + "','"+jianjie+"')";
  --------------------编程问答-------------------- 楼上正解 --------------------编程问答-------------------- 除 --------------------编程问答--------------------
引用 2 楼 liuchaolin 的回复:
values ('" + name + "','" + path + "','"+jianjie+"')";


bingo
补充:.NET技术 ,  ASP.NET
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,