在SQL语句结束时缺少分号（;） [英] Missing semicolon (;) at end of SQL statement

问题描述

插入数据后...  image  和 description < span class =code-keyword> not   insert 该特定行 as  am 使用 session   ... 和错误是（  SQL末尾缺少分号（;）声明。）和  我的下一个时间运行程序我可以在数据列表bt 
中看到 image       数据库 .... plz告诉我......看下面的代码...... 

  protected   void  btnSubmit_Click（ object  sender，EventArgs e）
 {
  //  从fileupload控件获取文件名 
 字符串 extention; 
  String  name = fileuploadimages.FileName; 
  String  name1 = name.ToUpper（）; 
 
  if （name1.EndsWith（ 。JPG））
 extention =   .JPG ; 
  else   if （name1.EndsWith（  。GIF））
 extention =   GIF。; 
  else   if （name1.EndsWith（   .JPEG））
 extention =   JPEG。; 
  else  
 extention =   ; 
 
 
 字符串 filename = Path.GetFileName（DateTime.Now.Year.ToString（）+ DateTime.Now.Month.ToString （）+ DateTime.Now.Day.ToString（）+ DateTime.Now.Hour.ToString（）+ DateTime.Today.Minute.ToString（）+ DateTime.Now.Second.ToString（）+ extention）; 
  //  将图像保存到SlideImages文件夹 
 
 fileuploadimages.SaveAs （Server.MapPath（  SlideImages / + filename））; 
  //  打开数据库连接 
 con.Open（）; 
  //  查询将图像名称和描述插入数据库 
 OleDbCommand cmd =  new  OleDbCommand（ 插入SlideShowTable（ImageName，Description）值（@ ImageName，@ Description）其中CategoryID =' + txtcat.Text +  '和ArName =' + txtarea.Text +  '，con）; 
  //  将参数传递给查询 
 cmd.Parameters.AddWithValue（  @ ImageName，filename）; 
 cmd.Parameters.AddWithValue（  @ Description，txtDesc.Text）; 
 cmd.ExecuteNonQuery（）; 
  //  关闭dbconnection  
 
 txtDesc.Text = 串 .Empty; 
  //   BindDataList（）;  
 
 
  //   string filename = Path.GetFileName（fileuploadimages.PostedFile.FileName）;  
  string  targetPath = Server.MapPath（  SlideImages / + filename）; 
 Stream strm = fileuploadimages.PostedFile.InputStream; 
  var  targetFile = targetPath; 
  //  基于scalefactor的图像大小会有所不同 
 GenerateThumbnails（ 0 。 5 ，strm，targetFile）; 
 con.Close（）; 
 BindDataList（）; 
} 
 
  private   void  GenerateThumbnails（ double  scaleFactor，Stream sourcePath， string  targetPath）
 {
 使用（ var  image = Image.FromStream（sourcePath））
 {
  var  newWidth =（ int ）（ 700  * scaleFactor）; 
  var  newHeight =（ int ）（ 700  * scaleFactor）; 
  var  thumbnailImg =  new 位图（newWidth，newHeight）; 
  var  thumbGraph = Graphics.FromImage（thumbnailImg）; 
 thumbGraph.CompositingQuality = CompositingQuality.HighQuality; 
 thumbGraph.SmoothingMode = SmoothingMode.HighQuality; 
 thumbGraph.InterpolationMode = InterpolationMode.HighQualityBicubic; 
  var  imageRectangle =  new 矩形（ 0 ， 0 ，newWidth，newHeight）; 
 thumbGraph.DrawImage（image，imageRectangle）; 
 thumbnailImg.Save（targetPath，image.RawFormat）; 
} 
} 
} 

解决方案

查询错误....



插入... 条件 错误

< pre lang =c＃> OleDbCommand cmd = new OleDbCommand（ 插入SlideShowTable（ImageName，Description）值（@ ImageName，@ Description）其中CategoryID =' + txtcat.Text + '和ArName =' + txtarea.Text + '，con）;

语法是

插入tblnm（列表。 ..）值（值列表......）



快乐编码！

：）

After inserting the data...image and description not insert that particular row as am using session for that...and the error is ("Missing semicolon (;) at end of SQL statement.") and the when i next time run the program i can see the image in the datalist bt
not in database....plz tell me...see the code below...

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        //Get Filename from fileupload control
        String extention;
        String name = fileuploadimages.FileName;
        String name1 = name.ToUpper();

        if (name1.EndsWith(".JPG"))
            extention = ".JPG";
        else if (name1.EndsWith(".GIF"))
            extention = ".GIF";
        else if (name1.EndsWith(".JPEG"))
            extention = ".JPEG";
        else
            extention = "";


        String filename = Path.GetFileName(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Today.Minute.ToString() + DateTime.Now.Second.ToString() + extention);
        //Save images into SlideImages folder

        fileuploadimages.SaveAs(Server.MapPath("SlideImages/" + filename));
        //Open the database connection
        con.Open();
        //Query to insert images name and Description into database
        OleDbCommand cmd = new OleDbCommand("Insert into SlideShowTable(ImageName,Description) values(@ImageName,@Description) where CategoryID='" + txtcat.Text + "'And ArName='" + txtarea.Text + "' ", con);
        //Passing parameters to query
        cmd.Parameters.AddWithValue("@ImageName", filename);
        cmd.Parameters.AddWithValue("@Description", txtDesc.Text);
        cmd.ExecuteNonQuery();
        //Close dbconnection

        txtDesc.Text = string.Empty;
        //BindDataList();


        // string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);
        string targetPath = Server.MapPath("SlideImages/" + filename);
        Stream strm = fileuploadimages.PostedFile.InputStream;
        var targetFile = targetPath;
        //Based on scalefactor image size will vary
        GenerateThumbnails(0.5, strm, targetFile);
        con.Close();
        BindDataList();
    }

    private void GenerateThumbnails(double scaleFactor, Stream sourcePath, string targetPath)
    {
        using (var image = Image.FromStream(sourcePath))
        {
            var newWidth = (int)(700 * scaleFactor);
            var newHeight = (int)(700 * scaleFactor);
            var thumbnailImg = new Bitmap(newWidth, newHeight);
            var thumbGraph = Graphics.FromImage(thumbnailImg);
            thumbGraph.CompositingQuality = CompositingQuality.HighQuality;
            thumbGraph.SmoothingMode = SmoothingMode.HighQuality;
            thumbGraph.InterpolationMode = InterpolationMode.HighQualityBicubic;
            var imageRectangle = new Rectangle(0, 0, newWidth, newHeight);
            thumbGraph.DrawImage(image, imageRectangle);
            thumbnailImg.Save(targetPath, image.RawFormat);
        }
    }
}

解决方案

wrong query....

Insert into ... with where condition is wrong

OleDbCommand cmd = new OleDbCommand("Insert into SlideShowTable(ImageName,Description) values(@ImageName,@Description) where CategoryID='" + txtcat.Text + "'And ArName='" + txtarea.Text + "' ", con);

syntax is
Insert into tblnm(column list...) values(value list...)

Happy Coding!
:)

这篇关于在SQL语句结束时缺少分号（;）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！