1
<
asp:UpdatePanel ID
=
"
UpdatePanel1
"
runat
=
"
server
"
><
ContentTemplate
>
2
<
asp:GridView id
=
"
GridView1
"
runat
=
"
server
"
AutoGenerateColumns
=
"
False
"
DataSourceID
=
"
SqlDataSource1
"
AllowPaging
=
"
True
"
BorderColor
=
"
#E0E0E0
"
BorderStyle
=
"
Solid
"
BorderWidth
=
"
1px
"
CellPadding
=
"
4
"
ForeColor
=
"
#333333
"
GridLines
=
"
None
"
>
3
<
footerstyle backcolor
=
"
#D1DDF1
"
font
-
bold
=
"
True
"
/>
4
5
<
columns
>
6
<
asp:BoundField DataField
=
"
Sender
"
SortExpression
=
"
Sender
"
HeaderText
=
"
发送者
"
></
asp:BoundField
>
7
<
asp:BoundField DataField
=
"
Title
"
SortExpression
=
"
Title
"
HeaderText
=
"
主题
"
></
asp:BoundField
>
8
<
asp:BoundField DataField
=
"
SendTime
"
SortExpression
=
"
SendTime
"
HeaderText
=
"
发送时间
"
></
asp:BoundField
>
9
<
asp:BoundField DataField
=
"
IsRead
"
SortExpression
=
"
IsRead
"
HeaderText
=
"
是否已读
"
></
asp:BoundField
>
10
<
asp:BoundField DataField
=
"
FileUrl
"
SortExpression
=
"
FileUrl
"
HeaderText
=
"
附件
"
></
asp:BoundField
>
11
<
asp:CommandField CausesValidation
=
"
False
"
ShowDeleteButton
=
"
True
"
></
asp:CommandField
>
12
</
columns
>
13
<
rowstyle backcolor
=
"
#EFF3FB
"
/>
14
<
editrowstyle backcolor
=
"
#2461BF
"
/>
15
<
selectedrowstyle backcolor
=
"
#D1DDF1
"
font
-
bold
=
"
True
"
forecolor
=
"
#333333
"
/>
16
<
pagerstyle backcolor
=
"
#D1DDF1
"
horizontalalign
=
"
Left
"
/>
17
<
headerstyle backcolor
=
"
#D1DDF1
"
font
-
bold
=
"
True
"
/>
18
<
alternatingrowstyle backcolor
=
"
White
"
/>
19
</
asp:GridView
>
20
<
asp:SqlDataSource id
=
"
SqlDataSource1
"
runat
=
"
server
"
ConnectionString
=
"
<%$ ConnectionStrings:sinoeseConnectionString %>
"
21
SelectCommand
=
"
SELECT * FROM [Message] WHERE ([Reciever] = @Reciever) ORDER BY [IsRead] DESC, [SendTime] DESC
"
DeleteCommand
=
"
DELETE FROM [Message] WHERE [MessageID] = @MessageID
"
InsertCommand
=
"
INSERT INTO [Message] ([Sender], [Reciever], [Title], [SendTime], [Content], [IsRead], [FileUrl]) VALUES (@Sender, @Reciever, @Title, @SendTime, @Content, @IsRead, @FileUrl)
"
UpdateCommand
=
"
UPDATE [Message] SET [Sender] = @Sender, [Reciever] = @Reciever, [Title] = @Title, [SendTime] = @SendTime, [Content] = @Content, [IsRead] = @IsRead, [FileUrl] = @FileUrl WHERE [MessageID] = @MessageID
"
>
22
<
deleteparameters
>
23
<
asp:Parameter Type
=
"
Int32
"
Name
=
"
MessageID
"
></
asp:Parameter
>
24
</
deleteparameters
>
25
<
updateparameters
>
26
<
asp:Parameter Type
=
"
String
"
Name
=
"
Sender
"
></
asp:Parameter
>
27
<
asp:Parameter Type
=
"
String
"
Name
=
"
Reciever
"
></
asp:Parameter
>
28
<
asp:Parameter Type
=
"
String
"
Name
=
"
Title
"
></
asp:Parameter
>
29
<
asp:Parameter Type
=
"
DateTime
"
Name
=
"
SendTime
"
></
asp:Parameter
>
30
<
asp:Parameter Type
=
"
String
"
Name
=
"
Content
"
></
asp:Parameter
>
31
<
asp:Parameter Type
=
"
Int32
"
Name
=
"
IsRead
"
></
asp:Parameter
>
32
<
asp:Parameter Type
=
"
String
"
Name
=
"
FileUrl
"
></
asp:Parameter
>
33
<
asp:Parameter Type
=
"
Int32
"
Name
=
"
MessageID
"
></
asp:Parameter
>
34
</
updateparameters
>
35
<
selectparameters
>
36
<
asp:ControlParameter PropertyName
=
"
Text
"
Type
=
"
String
"
DefaultValue
=
"
admin
"
Name
=
"
Reciever
"
ControlID
=
"
lblUserName
"
></
asp:ControlParameter
>
37
</
selectparameters
>
38
<
insertparameters
>
39
<
asp:Parameter Type
=
"
String
"
Name
=
"
Sender
"
></
asp:Parameter
>
40
<
asp:Parameter Type
=
"
String
"
Name
=
"
Reciever
"
></
asp:Parameter
>
41
<
asp:Parameter Type
=
"
String
"
Name
=
"
Title
"
></
asp:Parameter
>
42
<
asp:Parameter Type
=
"
DateTime
"
Name
=
"
SendTime
"
></
asp:Parameter
>
43
<
asp:Parameter Type
=
"
String
"
Name
=
"
Content
"
></
asp:Parameter
>
44
<
asp:Parameter Type
=
"
Int32
"
Name
=
"
IsRead
"
></
asp:Parameter
>
45
<
asp:Parameter Type
=
"
String
"
Name
=
"
FileUrl
"
></
asp:Parameter
>
46
</
insertparameters
>
47
</
asp:SqlDataSource
>
48
</
ContentTemplate
>
49
</
asp:UpdatePanel
>
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
20
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
22
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
25
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
26
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
27
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
29
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
30
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
31
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
32
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
33
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
34
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
35
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
36
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
39
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
40
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
41
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
42
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
43
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
44
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
45
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
46
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
47
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
48
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
49
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
这个问题不是每次都出现的,偶尔会有这样的问题,不知是什么原因?