为什么insert　into 会同时插入两条一样的记录？

DMPX 2004-12-07 02:34:28
public void Button1_ServerClick(object sender, System.EventArgs e)
{

string filename="";

if(myFile.PostedFile!=null)
{
string nam = myFile.PostedFile.FileName;

int i= nam.LastIndexOf(".");

string newext =nam.Substring(i);

DateTime now = DateTime.Now;

string newname=now.DayOfYear.ToString()
+myFile.PostedFile.ContentLength.ToString();

myFile.PostedFile.SaveAs(Server.MapPath("upload//"+newname+newext));
filename=newname+newext;
}


string strSQL="";

if (RadioButton1.Checked)
strSQL="insert into gdrw (NAME) values ('" + filename + "')";



string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath ("Data/LczArt.mdb");

OleDbConnection myConn = new OleDbConnection(strDSN);

OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);

myConn.Open();

OleDbDataReader myReader = myCmd.ExecuteReader();

myReader.Close();

myConn.Close();
}
}


表gdrw ID　字段是自动编号
执行上面语句表里会同时增加两条一样的记录，我想只增加一条。
...全文
1014 16 打赏 收藏 转发到动态 举报
写回复
用AI写文章
16 条回复
切换为时间正序
请发表友善的回复…
发表回复
nga96 2004-12-07
  • 打赏
  • 举报
 回复
没仔细看，呵
DMPX 2004-12-07
  • 打赏
  • 举报
 回复
OK了
GSXiaoXiao 2004-12-07
  • 打赏
  • 举报
 回复
改为:public void Button1_OnClick(object sender, System.EventArgs e)Handles Button1.click
GSXiaoXiao 2004-12-07
  • 打赏
  • 举报
 回复
把前台OnServerClick="Button1_ServerClick"去掉.
后台的public void Button1_ServerClick(object sender, System.EventArgs e)
改为:public void Button1_OnServerClick(object sender, System.EventArgs e)Handles Button1.click
yt_net 2004-12-07
  • 打赏
  • 举报
 回复
把this.Button1.ServerClick += new System.EventHandler(this.Button1_ServerClick);去掉
或者把前台代码中的OnServerClick="Button1_ServerClick"去掉，试一下，搞定了，回复一下
DMPX 2004-12-07
  • 打赏
  • 举报
 回复
<%@ Import Namespace="System.IO" %>
<%@ Page language="c#" Codebehind="FileUpload.aspx.cs" AutoEventWireup="false" Inherits="LczArt.FileUpload" smartnavigation="true"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>上传文件</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<center>
<form id="uploderform" action="FileUpload.aspx" method="post" encType="multipart/form-data" runat="server">
<asp:RadioButton id="RadioButton2" style="Z-INDEX: 102; LEFT: 168px; POSITION: absolute; TOP: 192px"
runat="server" Text="人体" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton22" style="Z-INDEX: 122; LEFT: 280px; POSITION: absolute; TOP: 288px"
runat="server" Text="静物" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton21" style="Z-INDEX: 121; LEFT: 200px; POSITION: absolute; TOP: 288px"
runat="server" Text="风景" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton20" style="Z-INDEX: 120; LEFT: 120px; POSITION: absolute; TOP: 288px"
runat="server" Text="动物" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton19" style="Z-INDEX: 119; LEFT: 40px; POSITION: absolute; TOP: 288px"
runat="server" Text="人物" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton18" style="Z-INDEX: 118; LEFT: 832px; POSITION: absolute; TOP: 240px"
runat="server" Text="狗" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton17" style="Z-INDEX: 117; LEFT: 760px; POSITION: absolute; TOP: 240px"
runat="server" Text="鸟" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton16" style="Z-INDEX: 116; LEFT: 680px; POSITION: absolute; TOP: 240px"
runat="server" Text="马" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton15" style="Z-INDEX: 115; LEFT: 608px; POSITION: absolute; TOP: 240px"
runat="server" Text="虎" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton14" style="Z-INDEX: 114; LEFT: 520px; POSITION: absolute; TOP: 240px"
runat="server" Text="海景" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton13" style="Z-INDEX: 113; LEFT: 440px; POSITION: absolute; TOP: 240px"
runat="server" Text="花园" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton12" style="Z-INDEX: 112; LEFT: 336px; POSITION: absolute; TOP: 240px"
runat="server" Text="建筑景" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton11" style="Z-INDEX: 111; LEFT: 224px; POSITION: absolute; TOP: 240px"
runat="server" Text="印象风景" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton10" style="Z-INDEX: 110; LEFT: 120px; POSITION: absolute; TOP: 240px"
runat="server" Text="古典风景" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton9" style="Z-INDEX: 109; LEFT: 40px; POSITION: absolute; TOP: 240px"
runat="server" Text="雕塑" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton8" style="Z-INDEX: 108; LEFT: 784px; POSITION: absolute; TOP: 192px"
runat="server" Text="印象静物" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton7" style="Z-INDEX: 107; LEFT: 672px; POSITION: absolute; TOP: 192px"
runat="server" Text="古典静物" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton6" style="Z-INDEX: 106; LEFT: 568px; POSITION: absolute; TOP: 192px"
runat="server" Text="儿童画" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton5" style="Z-INDEX: 105; LEFT: 480px; POSITION: absolute; TOP: 192px"
runat="server" Text="抽象" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton4" style="Z-INDEX: 104; LEFT: 352px; POSITION: absolute; TOP: 192px"
runat="server" Text="印象人物 " GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton3" style="Z-INDEX: 103; LEFT: 256px; POSITION: absolute; TOP: 192px"
runat="server" Text="宗教" GroupName="Ren"></asp:RadioButton>
<asp:RadioButton id="RadioButton1" style="Z-INDEX: 100; LEFT: 40px; POSITION: absolute; TOP: 192px"
runat="server" Text="古典人物" GroupName="Ren"></asp:RadioButton>
<table cellSpacing="2" cellPadding="2" border="1">
<tr>
<td>
<h5>选择要上传的文件:</h5>
</td>
<tr>
<td><input id="myFile" type="file" name="myFile" runat="server">
</td>
</tr>
<tr>
<td><input id="Button1" type="button" value="上 传" name="Button1" runat="server" OnServerClick="Button1_ServerClick">
</td>
</tr>
</table>
</form>
<br>
<br>
<br>
<br>
<br>
</center>
</body>
</HTML>
DMPX 2004-12-07
  • 打赏
  • 举报
 回复
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace LczArt
{
/// <summary>
/// FileUpload 的摘要说明。
/// </summary>
public class FileUpload : System.Web.UI.Page
{

protected System.Web.UI.HtmlControls.HtmlInputFile myFile;
protected System.Web.UI.HtmlControls.HtmlInputButton Button1;
protected System.Web.UI.WebControls.RadioButton RadioButton1;
protected System.Web.UI.WebControls.RadioButton RadioButton2;
protected System.Web.UI.WebControls.RadioButton RadioButton3;
protected System.Web.UI.WebControls.RadioButton RadioButton4;
protected System.Web.UI.WebControls.RadioButton RadioButton5;
protected System.Web.UI.WebControls.RadioButton RadioButton6;
protected System.Web.UI.WebControls.RadioButton RadioButton7;
protected System.Web.UI.WebControls.RadioButton RadioButton8;
protected System.Web.UI.WebControls.RadioButton RadioButton9;
protected System.Web.UI.WebControls.RadioButton RadioButton10;
protected System.Web.UI.WebControls.RadioButton RadioButton11;
protected System.Web.UI.WebControls.RadioButton RadioButton12;
protected System.Web.UI.WebControls.RadioButton RadioButton13;
protected System.Web.UI.WebControls.RadioButton RadioButton14;
protected System.Web.UI.WebControls.RadioButton RadioButton15;
protected System.Web.UI.WebControls.RadioButton RadioButton16;
protected System.Web.UI.WebControls.RadioButton RadioButton17;
protected System.Web.UI.WebControls.RadioButton RadioButton18;
protected System.Web.UI.WebControls.RadioButton RadioButton19;
protected System.Web.UI.WebControls.RadioButton RadioButton20;
protected System.Web.UI.WebControls.RadioButton RadioButton21;
protected System.Web.UI.WebControls.RadioButton RadioButton22;


private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面


}

#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.ServerClick += new System.EventHandler(this.Button1_ServerClick);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

public void Button1_ServerClick(object sender, System.EventArgs e)
{

string filename="";

if(myFile.PostedFile!=null) //检查上传文件不为空
{
string nam = myFile.PostedFile.FileName ;

int i= nam.LastIndexOf("."); //取得文件名(抱括路径)里最后一个"."的索引

string newext =nam.Substring(i); //取得文件扩展名

DateTime now = DateTime.Now; //这里我自动根据日期和文件大小不同为文件命名,确保文件名不重复

string newname=now.DayOfYear.ToString()+myFile.PostedFile.ContentLength.ToString(); //保存文件到你所要的目录,这里是IIS根目录下的upload目录.你可以改变.

myFile.PostedFile.SaveAs(Server.MapPath("upload//"+newname+newext)); //注意: 我这里用Server.MapPath()取当前文件的绝对目录.在asp.net里"\"必须用"\\"代替

filename=newname+newext;
}


string strSQL="";

if (RadioButton1.Checked)
strSQL="insert into gdrw (NAME) values ('" + filename + "')";
else
if (RadioButton2.Checked)
strSQL="insert into rt (NAME) values ('" + filename + "')";
else
if (RadioButton3.Checked)
strSQL="insert into zj (NAME) values ('" + filename + "')";
else
if (RadioButton4.Checked)
strSQL="insert into yxrw (NAME) values ('" + filename + "')";
else
if (RadioButton5.Checked)
strSQL="insert into cx (NAME) values ('" + filename + "')";
else
if (RadioButton6.Checked)
strSQL="insert into baby (NAME) values ('" + filename + "')";
else
if (RadioButton7.Checked)
strSQL="insert into gdjw (NAME) values ('" + filename + "')";
else
if (RadioButton8.Checked)
strSQL="insert into yxjw (NAME) values ('" + filename + "')";
else
if (RadioButton9.Checked)
strSQL="insert into ds (NAME) values ('" + filename + "')";
else
if (RadioButton10.Checked)
strSQL="insert into gdfj (NAME) values ('" + filename + "')";
else
if (RadioButton11.Checked)
strSQL="insert into yxfj (NAME) values ('" + filename + "')";
else
if (RadioButton12.Checked)
strSQL="insert into jzj (NAME) values ('" + filename + "')";
else
if (RadioButton13.Checked)
strSQL="insert into hy (NAME) values ('" + filename + "')";
else
if (RadioButton14.Checked)
strSQL="insert into hj (NAME) values ('" + filename + "')";
else
if (RadioButton15.Checked)
strSQL="insert into lh (NAME) values ('" + filename + "')";
else
if (RadioButton16.Checked)
strSQL="insert into m (NAME) values ('" + filename + "')";
else
if (RadioButton17.Checked)
strSQL="insert into n (NAME) values ('" + filename + "')";
else
if (RadioButton18.Checked)
strSQL="insert into dog (NAME) values ('" + filename + "')";
else
if (RadioButton19.Checked)
strSQL="insert into rw (NAME) values ('" + filename + "')";
else
if (RadioButton20.Checked)
strSQL="insert into dw (NAME) values ('" + filename + "')";
else
if (RadioButton21.Checked)
strSQL="insert into fj (NAME) values ('" + filename + "')";
else
if (RadioButton22.Checked)
strSQL="insert into jw (NAME) values ('" + filename + "')";


string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath ("Data/LczArt.mdb");

OleDbConnection myConn = new OleDbConnection(strDSN);

OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);

myConn.Open();

OleDbDataReader myReader = myCmd.ExecuteReader();

myReader.Close();

myConn.Close();
}
}
}
yt_net 2004-12-07
  • 打赏
  • 举报
 回复
把你的后台代码全贴出来给我看看
yt_net 2004-12-07
  • 打赏
  • 举报
 回复
把你的后台代码全贴出来给我看看
DMPX 2004-12-07
  • 打赏
  • 举报
 回复
加了　AutoEventWireup="false" 　还是一个样
GSXiaoXiao 2004-12-07
  • 打赏
  • 举报
 回复
一定是提交了两次;
在页首加上: AutoEventWireup="False"
esterlee 2004-12-07
  • 打赏
  • 举报
 回复
察看一下提交动作，是不是提交了两次
DMPX 2004-12-07
  • 打赏
  • 举报
 回复
不可能点两下，我试了好多次，数据表里就是有两条一样的记录！
DMPX 2004-12-07
  • 打赏
  • 举报
 回复
<%@ Import Namespace="System.IO" %>
<%@ Page language="c#" Codebehind="FileUpload.aspx.cs" AutoEventWireup="false" Inherits="LczArt.FileUpload" %>
<HTML>
<body MS_POSITIONING="GridLayout">

<form id="uploderform" action="FileUpload.aspx" method="post" encType="multipart/form-data"
runat="server">

<asp:RadioButton id="RadioButton1" runat="server" GroupName="Ren"></asp:RadioButton>

asp:RadioButton id="RadioButton2" runat="server" GroupName="Ren"></asp:RadioButton>

<table cellSpacing="2" cellPadding="2" border="1">
<tr>
<td>
<h5>选择要上传的文件:</h5>
</td>
<tr>
<td><input id="myFile" type="file" name="myFile" runat="server">
</td>
</tr>
<tr>
<td><input id="Button1" type="button" value="上 传" name="Button1" runat="server" OnServerClick="Button1_ServerClick">
</td>
</tr>
</table>

</form>
</body>
</HTML>
thooy 2004-12-07
  • 打赏
  • 举报
 回复
语法看不出来有什么错,你是不是点了两下按钮啊??
betterwy 2004-12-07
  • 打赏
  • 举报
 回复
<%@ Page language="c#" smartnavigation="true" %>
mysql插入了两条数据_值班问题：insert语句插入了两条数据？
上周值班，碰到这样的一个客户问题，表结构简化如下：CREATE TABLE `aa` (`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,`c2` int(11) DEFAULT NULL,`c3` int(11) DEFAULT '0',`c4` int(11) DEFAULT NULL,PRIMARY KEY (`c1`)) ENGINE=InnoDB...
一条insert语句批量插入多条记录
常见的insert语句，向数据库中，一条语句只能插入一条数据： -- 一条insert只能插入一条数据 insert into person (id, personCode, personName , telNumber)values(1,'5112403' , '张三' , '1378902134');   一次插入多条数据的方法： 方式一： insert i
insert触发器 同时插入多条记录
需求：写了一个FOR INSERT的触发器，每次插入数据的时候向相关的数据表中也同时插入数据。 问题：测试的时候，一次只向主表中插入一条记录，那么触发器没有问题。在实际使用的时候，因为使用了insert into select语句，一次向主表中插入了超过一条的记录，如17条，但是发现其他数据表中却都只有一条记录，明显出现了错误。 解决： 1、上网查询“一次插入多条”这样的关键字 2、通过在
SQL中用insert into插入一行或多行记录
INSERT INTO插入一行记录：         INSERT INTO tablename values(v1,v2,...);  --这里需包括所有列的值    若只向指定列插入值：         INSERT INTO tablename (column1,column3) values(v1,v3); INSERT INTO插入多行记录：      若数据来自另一张表
MySQL命令insert into：向表中插入数据（记录）
insert into命令用于向表中插入数据。 insert into命令格式：insert into [([,.. ])] values ( 值1 )[, ( 值n )]; 例如：往表 MyClass中插入两条记录，这两条记录表示：编号为1的名为Tom的成绩为96.45，编号为2 的名为Joan 的成绩为82.99，编号为3 的名为Wang 的成绩为96.5。     mysql
.NET社区

62,074

社区成员

669,028

社区内容

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见，支持健康理性的辩论和互动，反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧

+ 用AI写文章