我用freetextbox做一新闻系统,当我在页面载入时,把数据库中新闻内容的字段值赋入freetextbox.text,而当我在此页面中直接修改freetextbox.text的内容,想把修改后的结果保存入数据库中,发现update的内容仍是最初页面载入时加载的freetextbox.text,并未把我修改后的结果存入,请问这是怎么回事?我应当如何解决??紧急求助.....
调试欢乐多
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
Dim ConnectionString As String = "server=(local);database=xk;User ID=sa;Pwd=ddd"
Dim CommandText As String = "select 课程简介 from xkkcxxb where 课程编号=" & Request.QueryString("id")
Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlCommand(CommandText, myConnection)
Dim kcresult As SqlDataReader
myConnection.Open()
kcresult = myCommand.ExecuteReader()
If kcresult.Read = True Then
FreeTextBox1.Text = kcresult.GetValue(0)
Label1.Text = FreeTextBox1.Text
End If
End Sub Private Sub btnlogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnlogin.Click
'If Not Page.IsPostBack Then Dim ConnectionString As String = "server=(local);database=xk;User ID=sa;Pwd=dddd"
Dim CommandText As String
CommandText = "update xkkcxxb set 课程简介='" & FreeTextBox1.Text & "' where 课程编号=" & Request.QueryString("id")
Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlCommand(CommandText, myConnection)
myConnection.Open()
myCommand.ExecuteNonQuery() 'End If
End Sub
发现并未更新.
这个只要在Page_Load里面加上if(!page.ispostback)就可以了,把代码都放if里面,这样的话,代码只在第一次装载页面的时候才执行。
在Page_Load里面加上
if(!Page.ispostback)
{
……
}
else
{
……
}
{
……
}