1、当内容超过列长度时,后面的部分不显示,而是用省略号表示.
>>>> cmd.CommandText = sql
da.Fill(ds, "yxgz")
dtable = ds.Tables("yxgz")
For i = 0 To dtable.Rows.Count - 1
str = dtable.Rows(i)("zcyx").ToString()
num = str.Length
If num > 4 Then
str = Left(str, 6) & "..."
dtable.Rows(i)("zcyx") = str
End If
Next
Me.DataGrid1.DataSource = dtable.DefaultView
Me.DataGrid1.DataBind()
Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
If e.Item.ItemType = ListItemType.Item Or _
e.Item.ItemType = ListItemType.AlternatingItem Or _
e.Item.ItemType = ListItemType.SelectedItem Then
e.Item.Cells(0).ToolTip = e.Item.Cells(0).text
e.Item.Cells(0).Text = e.Item.Cells(0).Text.ToString.Substring(1, 10) & "……"
end if
Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
If e.Item.ItemType = ListItemType.Item Or _
e.Item.ItemType = ListItemType.AlternatingItem Or _
e.Item.ItemType = ListItemType.SelectedItem Then
e.Item.Cells(0).ToolTip = e.Item.Cells(0).text
e.Item.Cells(0).Text = e.Item.Cells(0).Text.ToString.Substring(1, 10)
end if
Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
If e.Item.ItemType = ListItemType.Item Or _
e.Item.ItemType = ListItemType.AlternatingItem Or _
e.Item.ItemType = ListItemType.SelectedItem Then
e.Item.Cells(0).ToolTip = "你要的数据"