Dim conn As SqlConnection
conn = New SqlConnection("server=.;uid=sa;pwd=kaokaohaoma;database=book;")
Dim mingling As String = "insert into [book] (username,qq,email,pic,zhuti,ly,ip,time) values (@username,@qq,@email,@pic,@zhuti,@ly,@ip,@time)"
Dim cmd As New SqlCommand(mingling, conn)
cmd.Parameters.Add(New SqlParameter("@username", SqlDbType.VarChar, 50))
cmd.Parameters("@username").Value = Me.UserName.Text
cmd.Parameters.Add(New SqlParameter("@qq", SqlDbType.VarChar, 50))
cmd.Parameters("@qq").Value = Me.QQ.Text
cmd.Parameters.Add(New SqlParameter("@email", SqlDbType.VarChar, 50))
cmd.Parameters("@email").Value = Me.email.Text
cmd.Parameters.Add(New SqlParameter("@pic", SqlDbType.VarChar, 50))
cmd.Parameters("@pic").Value = Me.pic.SelectedValue
cmd.Parameters.Add(New SqlParameter("@zhuti", SqlDbType.VarChar, 50))
cmd.Parameters("@zhuti").Value = Me.zhuti.Text
cmd.Parameters.Add(New SqlParameter("@ly", SqlDbType.Text, 500))
cmd.Parameters("@ly").Value = Me.ly.Text
cmd.Parameters.Add(New SqlParameter("@ip", SqlDbType.VarChar, 50))
cmd.Parameters("@ip").Value = ip
cmd.Parameters.Add(New SqlParameter("@time", SqlDbType.DateTime, 8))
cmd.Parameters("@time").Value = time
conn.Open()
Dim count As Integer = cmd.ExecuteNonQuery()
cmd.Connection.Close()
If count < 1 Then
Response.Write("<script>alert('信息添加失败');history.go(-1)</script>")
Else
Response.Write("<script>alert('信息添加成功');history.go(-1)</script>")
End If
以上是代码,请那位大哥帮我看下,为什么我每次提交!数据库会自动写入二条数据。一样的
conn = New SqlConnection("server=.;uid=sa;pwd=kaokaohaoma;database=book;")
Dim mingling As String = "insert into [book] (username,qq,email,pic,zhuti,ly,ip,time) values (@username,@qq,@email,@pic,@zhuti,@ly,@ip,@time)"
Dim cmd As New SqlCommand(mingling, conn)
cmd.Parameters.Add(New SqlParameter("@username", SqlDbType.VarChar, 50))
cmd.Parameters("@username").Value = Me.UserName.Text
cmd.Parameters.Add(New SqlParameter("@qq", SqlDbType.VarChar, 50))
cmd.Parameters("@qq").Value = Me.QQ.Text
cmd.Parameters.Add(New SqlParameter("@email", SqlDbType.VarChar, 50))
cmd.Parameters("@email").Value = Me.email.Text
cmd.Parameters.Add(New SqlParameter("@pic", SqlDbType.VarChar, 50))
cmd.Parameters("@pic").Value = Me.pic.SelectedValue
cmd.Parameters.Add(New SqlParameter("@zhuti", SqlDbType.VarChar, 50))
cmd.Parameters("@zhuti").Value = Me.zhuti.Text
cmd.Parameters.Add(New SqlParameter("@ly", SqlDbType.Text, 500))
cmd.Parameters("@ly").Value = Me.ly.Text
cmd.Parameters.Add(New SqlParameter("@ip", SqlDbType.VarChar, 50))
cmd.Parameters("@ip").Value = ip
cmd.Parameters.Add(New SqlParameter("@time", SqlDbType.DateTime, 8))
cmd.Parameters("@time").Value = time
conn.Open()
Dim count As Integer = cmd.ExecuteNonQuery()
cmd.Connection.Close()
If count < 1 Then
Response.Write("<script>alert('信息添加失败');history.go(-1)</script>")
Else
Response.Write("<script>alert('信息添加成功');history.go(-1)</script>")
End If
以上是代码,请那位大哥帮我看下,为什么我每次提交!数据库会自动写入二条数据。一样的
解决方案 »
- 誰能提供給我一個Erp系統 成品和半成品入庫的頁面給我啊?
- Lucene.net中StandardAnalyzer问题请教
- c# 做WEB 数据库系统 开发 怎样批量更新?
- 可以用ObjectDatasource查询到的值填充List<User>吗?
- 调了两天就是着不出来有什么错,完全模仿微软petshop3.0的,请高人指点!
- 各位老大,自定义的控件怎么引用页面控件的值?
- 想问问,想看300帖以前的帖,那么我该怎么看呢?莫非旧帖就不可以看了吗?指教一下小弟!
- 为什么我的页面不跳转
- asp.net用户上传图片的问题
- 页面刷新问题,怎么在一个页面中按了某个按钮后刷新另一个页面呢?
- DataGrid 在排序情况下 删除问题怎么解决
- 如何在一行里输入不定个数的标题(做过信息类网站的应该遇到过的问题)
page_load
中了
Me.guanbi.Attributes.Add("onclick", "window.close()")
End Sub Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim ip As String = Request.UserHostAddress
Dim time As String = Now
Dim username As String = Me.UserName.Text
Dim qq As String = Me.QQ.Text
Dim zhuti As String = Me.zhuti.Text
Dim ly As String = Me.ly.Text
Dim email As String = Me.email.Text
If Me.UserName.Text = "" Or Me.QQ.Text = "" Or Me.zhuti.Text = "" Or Me.ly.Text = "" Or Me.pic.SelectedValue = "" Or Me.email.Text = "" Then
Response.Write("<script>alert('请填写完整信息');history.back()</script>")
Response.End()
End If
If Len(qq) > 15 Or Len(username) > 10 Or Len(zhuti) > 10 Or Len(email) > 20 Or Len(ly) > 500 Then
Response.Write("<script>alert('内容过长,请从新添写!');history.back()</script>")
Response.End()
end if
Dim conn As SqlConnection
conn = New SqlConnection("server=.;uid=sa;pwd=kaokaohaoma;database=book;")
Dim mingling As String = "insert into [book] (username,qq,email,pic,zhuti,ly,ip,time) values (@username,@qq,@email,@pic,@zhuti,@ly,@ip,@time)"
Dim cmd As New SqlCommand(mingling, conn)
cmd.Parameters.Add(New SqlParameter("@username", SqlDbType.VarChar, 50))
cmd.Parameters("@username").Value = Me.UserName.Text
cmd.Parameters.Add(New SqlParameter("@qq", SqlDbType.VarChar, 50))
cmd.Parameters("@qq").Value = Me.QQ.Text
cmd.Parameters.Add(New SqlParameter("@email", SqlDbType.VarChar, 50))
cmd.Parameters("@email").Value = Me.email.Text
cmd.Parameters.Add(New SqlParameter("@pic", SqlDbType.VarChar, 50))
cmd.Parameters("@pic").Value = Me.pic.SelectedValue
cmd.Parameters.Add(New SqlParameter("@zhuti", SqlDbType.VarChar, 50))
cmd.Parameters("@zhuti").Value = Me.zhuti.Text
cmd.Parameters.Add(New SqlParameter("@ly", SqlDbType.Text, 500))
cmd.Parameters("@ly").Value = Me.ly.Text
cmd.Parameters.Add(New SqlParameter("@ip", SqlDbType.VarChar, 50))
cmd.Parameters("@ip").Value = ip
cmd.Parameters.Add(New SqlParameter("@time", SqlDbType.DateTime, 8))
cmd.Parameters("@time").Value = time
conn.Open()
Dim count As Integer = cmd.ExecuteNonQuery()
cmd.Connection.Close()
If count < 1 Then
Response.Write("<script>alert('信息添加失败');history.go(-1)</script>")
Else
Response.Write("<script>alert('信息添加成功');history.go(-1)</script>")
End If
End Sub
End Class