| 网站首页 | VB.Net实例分析 | .Net技术文摘 | 下载中心 | VB.Net书籍笔记 | .Net源码 | VBS脚本与组件调用 | Windows2008技术文摘 | 给我们留言 | 
最新公告:

  没有公告

您现在的位置: 乐博网 >> VB.Net实例分析 >> 数据库编程 >> 实例分析正文
最新推荐 更多内容
文本模式下将LINQ 查询的输出写入到屏幕的实用工具
文本模式下将LINQ 查询的输出写入到屏幕的实用工具
作者:Akyao    来源:乐博网整理     更新时间:2011-6-27

本文演示用于在文本模式下将来自 LINQ 查询的输出写入到屏幕的实用工具的方法,来自乐博网lob.cn。

如果你想下载本文的源代码RAR压缩集合包  请访问
VB2010源代码集合包(芋头糕)    http://www.lob.cn/code/utility/2795.shtml
特别感谢网友 芋头糕 将此资源提供乐博网分享,欢迎加入 40797788 的.Net超级qq群交流。

用于在文本模式下将来自 LINQ 查询的输出写入到屏幕的实用工具的代码 如下:

' Copyright (c) Microsoft Corporation. All rights reserved.
Imports System.Threading
Imports System.Globalization
Imports System.Text


Public Class MainForm

    Public Class Culture
        Private IdValue As String
        Private descValue As String

        Sub New(ByVal strDesc As String, ByVal strID As String)
            IdValue = strID
            descValue = strDesc
        End Sub

        Public ReadOnly Property ID() As String
            Get
                Return IdValue
            End Get
        End Property

        Public ReadOnly Property Description() As String
            Get
                Return descValue
            End Get
        End Property
    End Class

    Private formHasLoaded As Boolean = False
    Private cultureValue As String

    ' Calls the method to display the DateTime formatting examples based on a
    ' user-selected CultureInfo.
    Private Sub cboCultureInfoDateTime_SelectedValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboCultureInfoDateTime.SelectedIndexChanged
        ' Handler should work only if the Form has loaded as SelectedValueChanged
        ' fires during databinding and causes undesirable results.
        If formHasLoaded Then
            LoadDateTimeFormats()
        End If
    End Sub

    ' Calls the method to display the Numeric formatting examples based on a
    ' user-selected CultureInfo.
    Private Sub cboCultureInfoNumeric_SelectedValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboCultureInfoNumeric.SelectedIndexChanged
        ' Handler should work only if the Form has loaded as SelectedValueChanged
        ' fires during databinding and causes undesirable results.
        If formHasLoaded Then
            LoadNumericFormats()
        End If
    End Sub

    ' Loads the ComboBox controls from an ArrayList and calls the methods to display
    ' the various formatting examples.
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ' Databind the ComboBox controls to an ArrayList of custom objects. Refer to
        ' the comments about the Culture class for more information.
        Dim arlCultureInfo As New ArrayList()
        With arlCultureInfo
            .Add(New Culture("English - United States", "en-US"))
            .Add(New Culture("English - United Kingdom", "en-GB"))
            .Add(New Culture("English - New Zealand", "en-NZ"))
            .Add(New Culture("German - Germany", "de-DE"))
            .Add(New Culture("Spanish - Spain", "es-ES"))
            .Add(New Culture("French - France", "fr-FR"))
            .Add(New Culture("Portuguese - Brazil", "pt-BR"))
            .Add(New Culture("Malay - Malaysia", "ms-MY"))
            .Add(New Culture("Afrikaans - South Africa", "af-ZA"))
        End With

        cboCultureInfoDateTime.DataSource = arlCultureInfo
        cboCultureInfoDateTime.DisplayMember = "Description"
        cboCultureInfoDateTime.ValueMember = "ID"

        cboCultureInfoNumeric.DataSource = arlCultureInfo
        cboCultureInfoNumeric.DisplayMember = "Description"
        cboCultureInfoNumeric.ValueMember = "ID"

        LoadEnumFormats()
        LoadDateTimeFormats()
        LoadNumericFormats()

        formHasLoaded = True
    End Sub

    ' Calls the methods to display the formatting examples based on whether
    ' the user selects "standard" or "custom" formatting.
    Private Sub RadioButtons_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles optCustomNumeric.CheckedChanged, optCustomDateTime.CheckedChanged, optStandardDateTime.CheckedChanged, optStandardNumeric.CheckedChanged
        ' Handler should work only if the Form has loaded as SelectedValueChanged
        ' fires during databinding and causes undesirable results.
        If formHasLoaded Then
            Dim opt As RadioButton = CType(sender, RadioButton)
            Select Case opt.Name
                Case "optStandardNumeric", "optCustomNumeric"
                    LoadNumericFormats()
                Case "optStandardDateTime", "optCustomDateTime"
                    LoadDateTimeFormats()
                Case Else
                    LoadEnumFormats()
            End Select
        End If
    End Sub

    ' Displays the DateTime formatting examples.
    Private Sub LoadDateTimeFormats()
        Dim dtmNow As DateTime = Now
        Dim sb As New StringBuilder()
        cultureValue = cboCultureInfoDateTime.SelectedValue.ToString
        Thread.CurrentThread.CurrentCulture = New CultureInfo(cultureValue)

        sb.Append("When using " & cultureValue & " CultureInfo, today's date and time will format as follows:")
        sb.Append(vbCrLf)
        sb.Append(vbCrLf)

        If optStandardDateTime.Checked Then
            AppendLine(sb, dtmNow.ToString("d"), " [Short date pattern]")
            AppendLine(sb, dtmNow.ToString("D"), " [Long date pattern]")
            AppendLine(sb, dtmNow.ToString("t"), " [Short time pattern]")
            AppendLine(sb, dtmNow.ToString("T"), " [Long time pattern]")
            AppendLine(sb, dtmNow.ToString("F"), " [Full date/time pattern (long)]")
            AppendLine(sb, dtmNow.ToString("f"), " [Full date/time pattern (short)]")
            AppendLine(sb, dtmNow.ToString("G"), " [General date/time pattern (long)]")
            AppendLine(sb, dtmNow.ToString("g"), " [General date/time pattern (short)]")
            AppendLine(sb, dtmNow.ToString("M"), " [Month day pattern]")
            AppendLine(sb, dtmNow.ToString("R"), " [RFC1123 pattern]")
            AppendLine(sb, dtmNow.ToString("s"), " [Sortable date/time pattern]")
            AppendLine(sb, dtmNow.ToString("u"), " [Universable sortable date/time pattern]")
            AppendLine(sb, dtmNow.ToString("y"), " [Year month pattern]")
        ElseIf optCustomDateTime.Checked Then
            AppendLine(sb, dtmNow.ToString("d, M"), " [d, M]")
            AppendLine(sb, dtmNow.ToString("d MMMM"), " [d MMMM]")
            AppendLine(sb, dtmNow.ToString("dddd MMMM yy gg"), " [dddd MMMM yy gg]")
            AppendLine(sb, dtmNow.ToString("h , m: s"), " [h , m: s]")
            AppendLine(sb, dtmNow.ToString("hh,mm:ss"), " [hh,mm:ss]")
            AppendLine(sb, dtmNow.ToString("HH-mm-ss-tt"), " [HH-mm-ss-tt]")
            AppendLine(sb, dtmNow.ToString("hh:mm, G\MT z"), " [hh:mm, G\MT z]")
            AppendLine(sb, dtmNow.ToString("hh:mm, G\MT zzz"), " [hh:mm, G\MT zzz]")
        End If
        sb.Append(vbCrLf)

        txtDateTime.Text = sb.ToString
    End Sub

    ' Displays the Enum formatting examples.
    Private Sub LoadEnumFormats()
        Dim day As DayOfWeek = DayOfWeek.Friday
        Dim sb As New StringBuilder()
        Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")

        sb.Append("When using any CultureInfo, the system enumeration DayOfWeek.Friday will format as follows:")
        sb.Append(vbCrLf)
        sb.Append(vbCrLf)
        AppendLine(sb, day.ToString("G"), " [G or g]")
        AppendLine(sb, day.ToString("F"), " [F or f]")
        AppendLine(sb, day.ToString("D"), " [D or d]")
        AppendLine(sb, day.ToString("X"), " [X or x]")

        txtEnum.Text = sb.ToString
    End Sub

    ' Displays the Numeric formatting examples.
    Private Sub LoadNumericFormats()
        Dim intNumber As Int32 = 1234567890
        Dim sb As New StringBuilder()
        cultureValue = cboCultureInfoNumeric.SelectedValue.ToString
        Thread.CurrentThread.CurrentCulture = New CultureInfo(cultureValue)

        sb.Append("When using " & cultureValue & " CultureInfo, the Integer 1234567890 will format as follows:")
        sb.Append(vbCrLf)
        sb.Append(vbCrLf)

        If optStandardNumeric.Checked Then
            AppendLine(sb, intNumber.ToString("C"), " [Currency]")
            AppendLine(sb, intNumber.ToString("E"), " [Scientific (Exponential)]")
            AppendLine(sb, intNumber.ToString("P"), " [Percent]")
            AppendLine(sb, intNumber.ToString("N"), " [Number]")
            AppendLine(sb, intNumber.ToString("F"), " [Fixed-point]")
            AppendLine(sb, intNumber.ToString("X"), " [Hexadecimal]")
        ElseIf optCustomNumeric.Checked Then
            AppendLine(sb, intNumber.ToString("#####"), " [#####]")
            AppendLine(sb, intNumber.ToString("00000"), " [00000]")
            AppendLine(sb, intNumber.ToString("(###) ### - ####"), "[(###) ### - ####]")
            AppendLine(sb, intNumber.ToString("#.##"), " [#.##]")
            AppendLine(sb, intNumber.ToString("00.00"), " [00.00]")
            AppendLine(sb, intNumber.ToString("#,#"), " [#,#]")
            AppendLine(sb, intNumber.ToString("#,,"), " [#,,]")
            AppendLine(sb, intNumber.ToString("#.##"), " [#.##]")
            AppendLine(sb, intNumber.ToString("#,,,"), " [#,,,]")
            AppendLine(sb, intNumber.ToString("#,##0,,"), " [#,##0,,]")
            AppendLine(sb, intNumber.ToString("#0.##%"), " [#0.##%]")
            AppendLine(sb, intNumber.ToString("0.###E+000"), " [0.###E+000]")
            AppendLine(sb, intNumber.ToString("##;(##)"), " [##;(##)]")
        End If
        sb.Append(vbCrLf)

        txtNumeric.Text = sb.ToString
    End Sub

    Private Sub AppendLine(ByVal sb As StringBuilder, ByVal string1 As String, ByVal string2 As String)
        sb.Append(string1)
        sb.Append(string2)
        sb.Append(vbCrLf)
    End Sub

    Private Sub exitToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles exitToolStripMenuItem.Click
        Me.Close()
    End Sub
End Class

  • 上一篇:

  • 下一篇: 没有了
  • 【字体: 】【打印此文】【关闭窗口
      相关文章:(只显示最新16条)
    LINQ to XML使用入门
    将LINQ to XML代码绑定到WPF控件
    使用LINQ To SQL查询数据库的基本示例
    LINQ查看表达式树的方法(VB2010实例)
    在运行时创建LINQ查询的代码(VB2010实例)
    VB.Net使用LINQ获取单个进程使用的最大物理内存量
    VB.Net在LINQ中使用正则表达式设置查询条件
    VB.Net在LINQ to XML中通过内存将属性转换为元素
    VB.Net在LINQ to XML中使用XPath查询指定元素值
    VB.Net股票行情在LINQ to XML中执行文本到XML的流式转…
    VB.Net在LINQ to XML中将CSV文件转换为XML文件
    VB.Net在LINQ to XML中将XML文件转换为CSV文件
    VB.Net根据LINQ to DataSet查询创建DataView
    VB.Net返回LINQ to DataSet中指定行后的剩余记录
    VB.Net在LINQ to DataSet中根据字符串的长度排序
    VB.Net使用ToArray()方法强制立即执行LINQ查询

    | 设为首页 | 加入收藏 | 联系站长 | | 友情链接 | 版权申明 |
    乐博网欢迎各种媒体转载我们的原创作品[转载请注明出处];我们鼓励更多VB.Net开发者一起加入研究与探讨;如发现文章访问错误、内容错误或版权疑问、内容有违相关法律(如涉及政治、色情、反动或散布虚假有害信息)等情况,请及时向我们举报,我们将及时纠正!
    联系邮箱:Shiny#vip.qq.com (#替换为@) QQ交流群: 40797788 [闽ICP备05014267号]