.term=1"
Dim comm As SqlCommand = New SqlCommand(sql, conn)
Dim dr As SqlDataReader
conn.Open()
dr = comm.ExecuteReader
While dr.Read
Label3.Text = dr.Item("nick")
Label4.Text = dr.Item("tim")
Label5.Text = dr.Item("content")
TextBox1.Text = dr.Item("nick")
TextBox3.Text = dr.Item("fromstu_id")
TextBox1.Enabled = False
Label8.Visible = False
End While
dr.Close()
comm.Cancel()
'//////////////////////更新留言使留言属性为已阅读过
Dim sql_1 As String = "update info set term=0 where tostu_id='" & Session("stu_id") & "' and term=1 and tim='" & Label4.Text & "'"
comm = New SqlCommand(sql_1, conn)
comm.ExecuteNonQuery()
Else
'////////////////////当发送留言时
Dim mysql As String = "select nick from pwd where stu_id='" & tostu_id & "'"
Dim comm As SqlCommand = New SqlCommand(mysql, conn)
Dim dr As SqlDataReader
conn.Open()
dr = comm.ExecuteReader
While dr.Read
TextBox1.Text = dr.item("nick")
End While
TextBox1.Enabled = False
Label3.Text = ""
Label4.Text = ""
Label5.Visible = False
Label8.Visible = True
Label6.Visible = False
La
Dim comm As SqlCommand = New SqlCommand(sql, conn)
Dim dr As SqlDataReader
conn.Open()
dr = comm.ExecuteReader
While dr.Read
Label3.Text = dr.Item("nick")
Label4.Text = dr.Item("tim")
Label5.Text = dr.Item("content")
TextBox1.Text = dr.Item("nick")
TextBox3.Text = dr.Item("fromstu_id")
TextBox1.Enabled = False
Label8.Visible = False
End While
dr.Close()
comm.Cancel()
'//////////////////////更新留言使留言属性为已阅读过
Dim sql_1 As String = "update info set term=0 where tostu_id='" & Session("stu_id") & "' and term=1 and tim='" & Label4.Text & "'"
comm = New SqlCommand(sql_1, conn)
comm.ExecuteNonQuery()
Else
'////////////////////当发送留言时
Dim mysql As String = "select nick from pwd where stu_id='" & tostu_id & "'"
Dim comm As SqlCommand = New SqlCommand(mysql, conn)
Dim dr As SqlDataReader
conn.Open()
dr = comm.ExecuteReader
While dr.Read
TextBox1.Text = dr.item("nick")
End While
TextBox1.Enabled = False
Label3.Text = ""
Label4.Text = ""
Label5.Visible = False
Label8.Visible = True
Label6.Visible = False
La
| 对此文章发表了评论 |

