Protected Sub Submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Submit.Click
Dim NewsId As String = Request.QueryString("ID")
Dim constr As String = Web.Configuration.WebConfigurationManager.ConnectionStrings("grsqConnectionString").ConnectionString
Dim con As SqlConnection = New SqlConnection(constr) Dim UpdateCmd As SqlCommand = New SqlCommand("update News set Title=@Title,Author=@Author,FromUrl=@FromUrl,Contents=@Contents where NewsID=@NewsID", con) Dim PTitle As SqlParameter = New SqlParameter("Title", SqlDbType.VarChar, 50, ParameterDirection.Input)
PTitle.Value = Title.Text Dim PNewsID As SqlParameter = New SqlParameter("NewsID", SqlDbType.Int)
PNewsID.Value = CInt(NewsId) Dim PAuthor As SqlParameter = New SqlParameter("Author", SqlDbType.VarChar, 50, ParameterDirection.Input)
PAuthor.Value = Author.Text Dim PFromUrl As SqlParameter = New SqlParameter("FromUrl", SqlDbType.VarChar, 50, ParameterDirection.Input)
PFromUrl.Value = FromURL.Text Dim PContents As SqlParameter = New SqlParameter("Contents", SqlDbType.NText, ParameterDirection.Input)
PContents.Value = Contents.Text UpdateCmd.Parameters.Add(PTitle)
UpdateCmd.Parameters.Add(PAuthor)
UpdateCmd.Parameters.Add(PFromUrl)
UpdateCmd.Parameters.Add(PNewsID)
UpdateCmd.Parameters.Add(PContents) con.Open()
UpdateCmd.ExecuteNonQuery()
UpdateCmd.ExecuteNonQuery() Response.Write("<script language='javascript'>alert('发布成功!')</script>")
con.Close()
End Sub请问,这代码有什么问题吗?为什么我的TextBox总是只能得到一个字符呢?比如我Update时向Textbox输入"aaaaaaaaaaaaaaaaaaaaaaaa",结果更新后我再看,只有一个a了,这是怎么回事呢?
Dim NewsId As String = Request.QueryString("ID")
Dim constr As String = Web.Configuration.WebConfigurationManager.ConnectionStrings("grsqConnectionString").ConnectionString
Dim con As SqlConnection = New SqlConnection(constr) Dim UpdateCmd As SqlCommand = New SqlCommand("update News set Title=@Title,Author=@Author,FromUrl=@FromUrl,Contents=@Contents where NewsID=@NewsID", con) Dim PTitle As SqlParameter = New SqlParameter("Title", SqlDbType.VarChar, 50, ParameterDirection.Input)
PTitle.Value = Title.Text Dim PNewsID As SqlParameter = New SqlParameter("NewsID", SqlDbType.Int)
PNewsID.Value = CInt(NewsId) Dim PAuthor As SqlParameter = New SqlParameter("Author", SqlDbType.VarChar, 50, ParameterDirection.Input)
PAuthor.Value = Author.Text Dim PFromUrl As SqlParameter = New SqlParameter("FromUrl", SqlDbType.VarChar, 50, ParameterDirection.Input)
PFromUrl.Value = FromURL.Text Dim PContents As SqlParameter = New SqlParameter("Contents", SqlDbType.NText, ParameterDirection.Input)
PContents.Value = Contents.Text UpdateCmd.Parameters.Add(PTitle)
UpdateCmd.Parameters.Add(PAuthor)
UpdateCmd.Parameters.Add(PFromUrl)
UpdateCmd.Parameters.Add(PNewsID)
UpdateCmd.Parameters.Add(PContents) con.Open()
UpdateCmd.ExecuteNonQuery()
UpdateCmd.ExecuteNonQuery() Response.Write("<script language='javascript'>alert('发布成功!')</script>")
con.Close()
End Sub请问,这代码有什么问题吗?为什么我的TextBox总是只能得到一个字符呢?比如我Update时向Textbox输入"aaaaaaaaaaaaaaaaaaaaaaaa",结果更新后我再看,只有一个a了,这是怎么回事呢?
解决方案 »
- 请教一下Graphics.DrawImage这个方法的问题
- 请问我这个网站有购物车的功能,请问怎么跟银行连?
- 为什么网站运行一段时间就要回收一下程序池?
- 关于AJAX前台取值到后台的问题
- Scott ToDoList (ajax.net)的程序 输入中文显示问号该如何解决
- 那么对于生成静态页面的网站 ,要实现多语言,是不是要生成两份静态页面,一份简体,一份繁体???
- ASP.NET配置错误 新手问题
- 无法获取执行权限 的配置错误!
- 请教。
- 关于ASP.NET MVC4+Jquery EasyUi上传图片的问题?
- 求asp.net(C#)打开Excel,读数据,写Excel,最后关闭Excel的小例子!
- 为什么在代码混合的ASPX页面中,这时if(!IsPostBack)语句好象不起作用了?
UpdateCmd.ExecuteNonQuery()//怎么有两个??