前端代码是:
<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子句或更改跟踪上下文子句,则必须用分号终止前面的语句。
发布于 2018-08-06 14:24:32
在下面一行放置一个断点,检查查询的值,并检查其语法是否正确。
SqlCommand cmd = new SqlCommand(query, con);
如果使用参数化查询,此问题将自动修复。
https://stackoverflow.com/questions/-100001947
复制相似问题