首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >插入数据库?

插入数据库?
EN

Stack Overflow用户
提问于 2018-08-06 05:22:16
回答 1查看 0关注 0票数 0

前端代码是:

 <div id="demo-form2"  class="form-horizontal form-label-left">
                   <div class="form-group">
                    <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Banner Image <span class="required">*</span>
                    </label>
                    <div class="col-md-6 col-sm-6 col-xs-12">
                          <asp:Image runat="server"  CssClass="img-thumbnail" Height="200px" Width="550px"  id="img1" />
              <br /><br />
              <asp:FileUpload runat="server" ID="fuPic1" BackColor="#F6F3F3" CssClass="form-control" />
                         </div>
                    </div>
                    <div class="form-group">
                    <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Blog Title <span class="required">*</span>
                    </label>
                    <div class="col-md-6 col-sm-6 col-xs-12">
                           <asp:TextBox runat="server"  CssClass=" form-control col-md-7 col-xs-12 "  placeholder="Blog Title" id="txtTitle" />

                    </div>
                  </div>
       <div class="form-group">
                    <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">First Paragraph <span class="required">*</span>
                    </label>
                    <div class="col-md-6 col-sm-6 col-xs-12">
                        <textarea runat="server" id="txtA1" style="width:100%; height:200px;" class="form-control col-md-7 col-xs-12" placeholder="Write here................"></textarea>


                    </div>
                  </div>
                    <div class="form-group">
                    <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Sub-Title <span class="required">*</span>
                    </label>
                    <div class="col-md-6 col-sm-6 col-xs-12">
                         <asp:TextBox runat="server"  CssClass="form-control col-md-7 col-xs-12"  placeholder="Sub-Title" id="txtSTitle" />


                    </div>
                  </div>
            <div class="form-group">
                    <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Second Paragraph <span class="required">*</span>
                    </label>
                    <div class="col-md-6 col-sm-6 col-xs-12">
                        <textarea runat="server" id="txtA2" style="width:100%; height:200px;" class="form-control col-md-7 col-xs-12" placeholder="Write here................"></textarea>


                    </div>
                  </div>
                  <div class="form-group">
                    <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Second Image <span class="required">*</span>
                    </label>
                    <div class="col-md-6 col-sm-6 col-xs-12">
                          <asp:Image runat="server"  CssClass="img-thumbnail" Height="150px" Width="150px"  id="img2" />
              <br /><br />
              <asp:FileUpload runat="server" ID="fuPic2" BackColor="#F6F3F3" CssClass="form-control" />
                         </div>
                    </div>



         <div class="ln_solid"></div>
                  <div class="form-group">
                    <div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
                      <asp:Button   runat="server" CssClass="btn btn-success submit form-control" Text="Add" ID="btnAdd" OnClick="btnAdd_Click" /><br />
        <br />   <a href="AIndex.aspx" class="btn btn-danger form-control">Cancel</a>
                        <br /><br />
                    </div>
                  </div>
                  </div>

在以下查询的帮助下插入数据:

        string pic = "";

        if (fuPic1.HasFile)
        {
            string fPath1 = Server.MapPath("~/BlogPics/");
            fuPic1.SaveAs(fPath1 + fuPic1.FileName);
            pic = "~/BlogPics/" + fuPic1.FileName;

        }
        else
        {
            pic = "";
        }

        string pic1 = "";

        if (fuPic2.HasFile)
        {
            string fPath2 = Server.MapPath("~/BlogPics/");
            fuPic2.SaveAs(fPath2 + fuPic2.FileName);
            pic1 = "~/BlogPics/" + fuPic2.FileName;
        }
        else
        {
            pic1 = "";
        }

        SqlConnection con = new SqlConnection("Data Source=Saad_Zahid ;  Database=DJ ; Integrated Security=True; ");
        string query = "insert into Blog(Blog_Banner,Blog_Title,Blog_Para1,Blog_SubTitle,Blog_Para2,Blog_Img) values('" + pic + "','" + txtTitle.Text + "', '" + txtA1.InnerText + "','" + txtSTitle.Text + "','" + txtA2.InnerText + "','" + pic1 + "')";

        SqlCommand cmd = new SqlCommand(query, con);

        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();

        img1.ImageUrl = pic;
        img2.ImageUrl = pic1;
        ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Blog Added');window.location ='AIndex.aspx';", true);

出现以下错误,当数据进入服务器控件时,无法将数据插入数据库。

这就是错误:

不正确的语法接近‘D’。不正确的语法接近关键字‘with’。如果该语句是公共表达式、xmlNamespaces子句或更改跟踪上下文子句,则必须用分号终止前面的语句。如果此语句是公共表达式、xmlNamespaces子句或更改跟踪上下文子句,则必须用分号终止前面的语句。

EN

回答 1

Stack Overflow用户

发布于 2018-08-06 14:24:32

在下面一行放置一个断点,检查查询的值,并检查其语法是否正确。

SqlCommand cmd = new SqlCommand(query, con);

如果使用参数化查询,此问题将自动修复。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/-100001947

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档