</div> </form> </body> </html>cs文件 using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.IO; using System.Data.SqlClient;public partial class news_add : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void bind() { } protected void btnButton1_Click(object sender, EventArgs e) {
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="news_add.aspx.cs" Inherits="news_add" %><%@ Register Assembly="DotNetTextBox" Namespace="DotNetTextBox" TagPrefix="DNTB" %>
<%@ Register Assembly="FredCK.FCKeditorV2" Namespace="FredCK.FCKeditorV2" TagPrefix="FCKeditorV2" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>增加新闻</title>
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table cellpadding="0" cellspacing="0" class="style1">
<tr>
<td><asp:Label ID="addOK" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
新闻标题:<asp:TextBox ID="newsTitle" runat="server"></asp:TextBox><asp:RequiredFieldValidator
ID="rfv_newsTitle" runat="server" ControlToValidate="newsTitle" ErrorMessage="新闻标题不能为空"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td>
新闻类别:<asp:DropDownList ID="DDL1" runat="server" AutoPostBack="True">
<asp:ListItem Selected="True" Value="1">滚动新闻</asp:ListItem>
<asp:ListItem Value="3">盘中播报高级</asp:ListItem>
<asp:ListItem Value="2">盘中播报低级</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td>
新闻内容: <br />
<FCKeditorV2:FCKeditor ID="FCKeditor1" runat="server">
</FCKeditorV2:FCKeditor>
<br />
</td>
</tr>
<tr>
</tr>
<tr>
<td><asp:Button ID="btnButton1" runat="server" Text="提交新闻" OnClick="btnButton1_Click" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>cs文件
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Data.SqlClient;public partial class news_add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void bind()
{ }
protected void btnButton1_Click(object sender, EventArgs e)
{
string sguestTitle = newsTitle.Text;
string sguestContent = FCKeditor1.Value;
string sguestname = DDL1.SelectedItem.ToString();
DbClass SqlConnection = new DbClass("connectionString");
string strSql = "Insert into news(news_Title,news_Content,news_Datetime,news_name)Values('" + sguestTitle + "','" + sguestContent + "',getdate(),'"+sguestname+"')"; SqlConnection.execSql(strSql);
addOK.Text = strSql ;
SqlConnection.Dispose();
}
}
想必是你自己想看看Sql语句是否有错误。
你可以将拼接的SQL语句直接复制粘贴到数据库中执行,看看能不能插入。
如果可以插入,说明是权限问题。