新闻评论功能，每次点击刷新都自动向数据库加入刚才输入的内容，不知道是什么原因？
热门软件下载：
代码如下：
<% @ page language="c#" %>
<% @ import namespace="system.data" %>
<% @ import namespace="system.data.sqlclient" %>
<% @ import namespace="system.collections" %>
<% @ import namespace="system.componentmodel" %>
<% @ import namespace="system.configuration" %>
<script language="c#" runat="server">
private int newsid;
private void page_load(object sender, system.eventargs e)
{
if(!ispostback)
{
bindgrid();
}
}
private void bindgrid()
{
string str = "select * from remark where newsid="+request.params["id"]+" order by remarkid desc";
sqlconnection myconnection =new sqlconnection(configurationsettings.appsettings["sqlconn"]);
myconnection.open();
sqldataadapter mycommand1 = new sqldataadapter(str, myconnection);
myconnection.close();
dataset dataset = new dataset();
mycommand1.fill(dataset, "remark");
newsreview.datasource = dataset.tables["remark"].defaultview;
newsreview.databind();
username.text="";
body.text="";
}
private void butadd_click(object source, eventargs e)
{
sqlconnection myconnection =new sqlconnection(configurationsettings.appsettings["sqlconn"]);
sqlcommand mycommand=new sqlcommand("insert into remark(username,body,addtime,newsid) values("+ username.text.tostring() +","+ body.text.tostring() +","+ datetime.now.tostring() +","+ request.params["id"] +")",myconnection);
myconnection.open();
mycommand.executenonquery();
myconnection.close();
bindgrid();
}
void changepage(object sender, datagridpagechangedeventargs e)
{
newsreview.currentpageindex = e.newpageindex;
bindgrid();
}
</script>
<html>
<head>
<link rel="stylesheet" href="style1.css" type="text/css">
</head>
<body>
<style type="text/css">
body {color: #000000; font-size: 14px}
td {color: #000000; font-size: 14px}
td.lighnav1
{
background-image: url(image/tabs_m_tile.gif);
}
.tableborder1
{
width:600;
border: 1px #0099ff solid;
background-color: #ffffff;
}
</style>
<form id="myform" runat=server>
<table" class="tableborder1" cellpadding="0" cellspacing="0">
<tr>
<td background="pic/tabs_m_tile.gif"> 相关评论：（评论内容仅代表网友个人观点）</td>
</tr>
<tr>
<td> <asp:datagrid id="newsreview" runat="server" autogeneratecolumns="false" allowpaging="true" pagesize="20" pagerstyle-horizontalalign="right" pagerstyle-mode="numericpages"
onpageindexchanged="changepage" width="100%" bordercolor="black" borderwidth="0" gridlines="both" datakeyfield="remarkid" showheader="false">
<columns>
<asp:hyperlinkcolumn datatextfield="body"
datanavigateurlfield="remarkid" target ="_new" datanavigateurlformatstring="../reviewshow.aspx?reviewid={0}"/>
</columns>
</asp:datagrid></td>
</tr>
<tr>
<td background="pic/tabs_m_tile.gif"> 发表评论：<font color="#ff0000">爱国 守法 自律 真实
文明</font></td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" align="right">作者：</td>
<td><asp:textbox id="username" runat="server" /><font color="#ff0000">*</font>
</td>
</tr>
<tr>
<td width="30%" align="right" valign="top">内容：</td>
<td valign="top"><asp:textbox id="body" textmode="multiline" height="300px" width="300px" runat="server" /><font color="#ff0000">*</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
<asp:button id="butadd" onclick="butadd_click" text="发表" runat="server"/>
</td>
</tr>
</table>
</form>
</body>
</html>
推荐阅读
相关评论