我想用两个TextBox的值插入到数据库!前台代码和后台都写出来了!当我输入内容后,点提交,就有错误!你输入的内容有错误?难道是我下面的insert 语句有错误吗?麻烦大家帮忙看看
前台:<asp:TextBox ID="txtTitle" runat="server"></asp:TextBox>
<asp:TextBox ID="txtBody" runat="server" TextMode="MultiLine">
<asp:Button ID="btnSubmit" runat="server" onclick="btnSubmit_Click" Text="提交" />
<asp:Button ID="btnRest" runat="server" Text="取消" />后台:
protected void btnSubmit_Click(object sender, EventArgs e)
{
conn = new SqlConnection(str);//str是连接数据库
conn.Open();
string SQL = "insert into Froms(Title,Body) values ('" + txtTitle.Text + "'," +txtBody.Text + ");";
comm = new SqlCommand(SQL, conn);
comm.ExecuteNonQuery();
conn.Close();
}
前台:<asp:TextBox ID="txtTitle" runat="server"></asp:TextBox>
<asp:TextBox ID="txtBody" runat="server" TextMode="MultiLine">
<asp:Button ID="btnSubmit" runat="server" onclick="btnSubmit_Click" Text="提交" />
<asp:Button ID="btnRest" runat="server" Text="取消" />后台:
protected void btnSubmit_Click(object sender, EventArgs e)
{
conn = new SqlConnection(str);//str是连接数据库
conn.Open();
string SQL = "insert into Froms(Title,Body) values ('" + txtTitle.Text + "'," +txtBody.Text + ");";
comm = new SqlCommand(SQL, conn);
comm.ExecuteNonQuery();
conn.Close();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
conn = new SqlConnection(str);//str是连接数据库
conn.Open();
string SQL = "insert into Froms(Title,Body) values ('" + txtTitle.Text + "'," +txtBody.Text + ");";
comm = new SqlCommand(SQL, conn);
comm.ExecuteNonQuery();
conn.Close();
}
catch (Execption ex)
{
conn.close();
throw ex;
}
}
Body是文本类型吧?
txtBody.Text两边要加单引号'