[原创]用户控件 IP文本框 VB.net

评分 0.00, 满分 5星 0 票 No comments

vb.net 的textbox 没有 mask 特地制作一个 以备使用。
源码打包 MyIPBox 附带实例。

Public Class IpBox
    Inherits System.Windows.Forms.UserControl

#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'UserControl overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    Friend WithEvents Panel1 As System.Windows.Forms.Panel
    Friend WithEvents textBox3 As System.Windows.Forms.TextBox
    Friend WithEvents label3 As System.Windows.Forms.Label
    Friend WithEvents textBox4 As System.Windows.Forms.TextBox
    Friend WithEvents label1 As System.Windows.Forms.Label
    Friend WithEvents textBox1 As System.Windows.Forms.TextBox
    Friend WithEvents label2 As System.Windows.Forms.Label
    Friend WithEvents textBox2 As System.Windows.Forms.TextBox
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.Panel1 = New System.Windows.Forms.Panel
Me.textBox3 = New System.Windows.Forms.TextBox
Me.label3 = New System.Windows.Forms.Label
Me.textBox4 = New System.Windows.Forms.TextBox
Me.label1 = New System.Windows.Forms.Label
Me.textBox1 = New System.Windows.Forms.TextBox
Me.label2 = New System.Windows.Forms.Label
Me.textBox2 = New System.Windows.Forms.TextBox
Me.Panel1.SuspendLayout()
Me.SuspendLayout()
'
'Panel1
'
Me.Panel1.BackColor = System.Drawing.SystemColors.Window
Me.Panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D
Me.Panel1.Controls.Add(Me.textBox3)
Me.Panel1.Controls.Add(Me.label3)
Me.Panel1.Controls.Add(Me.textBox4)
Me.Panel1.Controls.Add(Me.label1)
Me.Panel1.Controls.Add(Me.textBox1)
Me.Panel1.Controls.Add(Me.label2)
Me.Panel1.Controls.Add(Me.textBox2)
Me.Panel1.Dock = System.Windows.Forms.DockStyle.Fill
Me.Panel1.Location = New System.Drawing.Point(0, 0)
Me.Panel1.Name = "Panel1"
Me.Panel1.Size = New System.Drawing.Size(118, 18)
Me.Panel1.TabIndex = 0
'
'textBox3
'
Me.textBox3.BorderStyle = System.Windows.Forms.BorderStyle.None
Me.textBox3.Location = New System.Drawing.Point(59, -1)
Me.textBox3.Name = "textBox3"
Me.textBox3.Size = New System.Drawing.Size(24, 14)
Me.textBox3.TabIndex = 11
Me.textBox3.Text = ""
Me.textBox3.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
'
'label3
'
Me.label3.BackColor = System.Drawing.Color.Transparent
Me.label3.Font = New System.Drawing.Font("Arial", 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Me.label3.Location = New System.Drawing.Point(83, 1)
Me.label3.Name = "label3"
Me.label3.Size = New System.Drawing.Size(4, 14)
Me.label3.TabIndex = 12
Me.label3.Text = "."
Me.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
'
'textBox4
'
Me.textBox4.BorderStyle = System.Windows.Forms.BorderStyle.None
Me.textBox4.Location = New System.Drawing.Point(87, -1)
Me.textBox4.Name = "textBox4"
Me.textBox4.Size = New System.Drawing.Size(24, 14)
Me.textBox4.TabIndex = 13
Me.textBox4.Text = ""
Me.textBox4.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
'
'label1
'
Me.label1.BackColor = System.Drawing.Color.Transparent
Me.label1.Font = New System.Drawing.Font("Arial", 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Me.label1.Location = New System.Drawing.Point(27, 3)
Me.label1.Name = "label1"
Me.label1.Size = New System.Drawing.Size(4, 10)
Me.label1.TabIndex = 8
Me.label1.Text = "."
Me.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
'
'textBox1
'
Me.textBox1.BorderStyle = System.Windows.Forms.BorderStyle.None
Me.textBox1.Location = New System.Drawing.Point(3, -1)
Me.textBox1.Name = "textBox1"
Me.textBox1.Size = New System.Drawing.Size(24, 14)
Me.textBox1.TabIndex = 7
Me.textBox1.Text = ""
Me.textBox1.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
'
'label2
'
Me.label2.BackColor = System.Drawing.Color.Transparent
Me.label2.Font = New System.Drawing.Font("Arial", 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Me.label2.Location = New System.Drawing.Point(55, 1)
Me.label2.Name = "label2"
Me.label2.Size = New System.Drawing.Size(4, 14)
Me.label2.TabIndex = 10
Me.label2.Text = "."
Me.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
'
'textBox2
'
Me.textBox2.BorderStyle = System.Windows.Forms.BorderStyle.None
Me.textBox2.Location = New System.Drawing.Point(31, -1)
Me.textBox2.Name = "textBox2"
Me.textBox2.Size = New System.Drawing.Size(24, 14)
Me.textBox2.TabIndex = 9
Me.textBox2.Text = ""
Me.textBox2.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
'
'IpBox
'
Me.Controls.Add(Me.Panel1)
Me.Name = "IpBox"
Me.Size = New System.Drawing.Size(118, 18)
Me.Panel1.ResumeLayout(False)
Me.ResumeLayout(False)

    End Sub

#End Region

    Public strIP As String
    Public Property IPAddress() As String
        Get
            strIP = ""
            strIP += IIf(textBox1.Text.Trim() <> "", textBox1.Text.Trim(), "0")
            strIP += "."
            strIP += IIf(textBox2.Text.Trim() <> "", textBox2.Text.Trim(), "0")
            strIP += "."
            strIP += IIf(textBox3.Text.Trim() <> "", textBox3.Text.Trim(), "0")
            strIP += "."
            strIP += IIf(textBox4.Text.Trim() <> "", textBox4.Text.Trim(), "0")
            Return strIP
        End Get

        Set(ByVal Value As String)
            strIP = Value
            Dim arrIP As String() = strIP.Split(".")
            If arrIP.Length > 0 Then
                Try

                    Value = Convert.ToInt32(arrIP(0).Trim)
                    If Value < 0 Then
                        textBox1.Text = "0"
                    ElseIf Value > "255" Then
                        textBox1.Text = "255"
                    Else
                        textBox1.Text = Value.ToString
                    End If

                Catch ex As Exception
                    textBox1.Text = "0"
                Finally
                    textBox1.Text = "0"
                End Try
            End If

            If arrIP.Length > 1 Then
                Try

                    Value = Convert.ToInt32(arrIP(1).Trim)
                    If Value < 0 Then
                        textBox2.Text = "0"
                    ElseIf Value > "255" Then
                        textBox2.Text = "255"
                    Else
                        textBox2.Text = Value.ToString
                    End If

                Catch ex As Exception
                    textBox2.Text = "0"
                Finally
                    textBox2.Text = "0"
                End Try
            End If

            If arrIP.Length > 2 Then
                Try

                    Value = Convert.ToInt32(arrIP(2).Trim)
                    If Value < 0 Then
                        textBox3.Text = "0"
                    ElseIf Value > "255" Then
                        textBox3.Text = "255"
                    Else
                        textBox3.Text = Value.ToString
                    End If

                Catch ex As Exception
                    textBox3.Text = "0"
                Finally
                    textBox3.Text = "0"
                End Try
            End If

            If arrIP.Length > 3 Then
                Try

                    Value = Convert.ToInt32(arrIP(3).Trim)
                    If Value < 0 Then
                        textBox4.Text = "0"
                    ElseIf Value > "255" Then
                        textBox4.Text = "255"
                    Else
                        textBox4.Text = Value.ToString
                    End If

                Catch ex As Exception
                    textBox4.Text = "0"
                Finally
                    textBox4.Text = "0"
                End Try
            End If
        End Set

    End Property


    Private Sub textBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles textBox1.TextChanged _
                                                                                                        , textBox2.TextChanged _
                                                                                                        , textBox3.TextChanged _
                                                                                                        , textBox4.TextChanged
        If sender.Text.Trim <> "" Then
            Dim val As Integer = Convert.ToInt32(sender.Text.Trim)
            If val < 0 Then
                sender.Text = "0"
            ElseIf val > 255 Then
                sender.Text = "255"
                sender.SelectionStart = sender.TextLength
            End If
        End If
    End Sub


    Private Sub textBox1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles textBox1.KeyDown
        If e.KeyCode = Keys.Right And textBox1.SelectionStart = textBox1.TextLength Then
            textBox2.Focus()
            textBox2.SelectAll()
        End If
    End Sub


    Private Sub textBox2_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles textBox2.KeyDown
        If textBox2.Text.Trim = "" And e.KeyCode = Keys.Back Then
            textBox1.Focus()
            textBox1.SelectionStart = textBox1.Text.Length
        End If
        If e.KeyCode = Keys.Right And textBox2.SelectionStart = textBox2.TextLength Then
            textBox3.Focus()
            textBox3.SelectAll()
        ElseIf e.KeyCode = Keys.Left And textBox2.SelectionStart = 0 Then
            textBox1.Focus()
            textBox1.SelectAll()
        End If
    End Sub


    Private Sub textBox3_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles textBox3.KeyDown
        If textBox3.Text.Trim = "" And e.KeyCode = Keys.Back Then
            textBox2.Focus()
            textBox2.SelectionStart = textBox2.Text.Length
        End If
        If e.KeyCode = Keys.Right And textBox3.SelectionStart = textBox3.TextLength Then
            textBox4.Focus()
            textBox4.SelectAll()
        ElseIf e.KeyCode = Keys.Left And textBox3.SelectionStart = 0 Then
            textBox2.Focus()
            textBox2.SelectAll()
        End If
    End Sub


    Private Sub textBox4_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles textBox4.KeyDown
        If textBox4.Text.Trim = "" And e.KeyCode = Keys.Back Then
            textBox3.Focus()
            textBox3.SelectionStart = textBox3.Text.Length
        End If
        If e.KeyCode = Keys.Left And textBox4.SelectionStart = 0 Then
            textBox3.Focus()
            textBox3.SelectAll()
        End If
    End Sub

    Private Sub textBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles textBox1.KeyPress
        If Char.IsControl(e.KeyChar) Then
        Else
            If Not Char.IsDigit(e.KeyChar) Then
                e.Handled = True
            End If
        End If
        If e.KeyChar = "." Then
            textBox2.Focus()
            textBox2.SelectAll()
        End If
    End Sub


    Private Sub textBox2_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles textBox2.KeyPress
        If Char.IsControl(e.KeyChar) Then
        Else
            If Not Char.IsDigit(e.KeyChar) Then
                e.Handled = True
            End If
        End If
        If e.KeyChar = "." Then
            textBox3.Focus()
            textBox3.SelectAll()
        End If
    End Sub


    Private Sub textBox3_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles textBox3.KeyPress
        If Char.IsControl(e.KeyChar) Then
        Else
            If Not Char.IsDigit(e.KeyChar) Then
                e.Handled = True
            End If
        End If
        If e.KeyChar = "." Then
            textBox4.Focus()
            textBox4.SelectAll()
        End If
    End Sub


    Private Sub textBox4_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles textBox4.KeyPress

        If Char.IsControl(e.KeyChar) Then
        Else
            If Not Char.IsDigit(e.KeyChar) Then
                e.Handled = True
            End If
        End If

    End Sub

    Private Sub IpBox_SizeChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.SizeChanged
         Dim nTextBoxWidth As Integer = (Me.Width - 3 * label1.Width) / 4
            textBox1.Location = New Point(0, 2)
            textBox1.Width = nTextBoxWidth
            textBox1.Height = Me.Height

            label1.Left = textBox1.Right
            label1.Top = 0
            label1.Width = label1.Width
            label1.Height = Me.Height - 4

            textBox2.Left = label1.Right
            textBox2.Top = 2
            textBox2.Width = nTextBoxWidth
            textBox2.Height = Me.Height

            label2.Left = textBox2.Right
            label2.Top = 0
            label2.Width = label1.Width
            label2.Height = Me.Height - 4

            textBox3.Left = label2.Right
            textBox3.Top = 2
            textBox3.Width = nTextBoxWidth
            textBox3.Height = Me.Height

            label3.Left = textBox3.Right
            label3.Top = 0
            label3.Width = label1.Width
            label3.Height = Me.Height - 4

            textBox4.Left = label3.Right
            textBox4.Top = 2
            textBox4.Width = nTextBoxWidth
            textBox4.Height = Me.Height - 4
    End Sub
End Class

精妙 SQL语句

评分 4.00, 满分 5星 1 票 No comments
--说明:复制表(只复制结构,源表名:a 新表名:b) 
select * into b from a where 1<>1 

--说明:拷贝表(拷贝数据,源表名:a 目标表名:b) 
insert into b(a, b, c) select d,e,f from b; 

--说明:显示文章、提交人和最后回复时间 
select a.title
			,a.username
			,b.adddate 
from table a
,(select max(adddate) adddate from table where table.title=a.title) b 

--说明:外连接查询(表名1:a 表名2:b) 
select a.a, a.b, a.c, b.c, b.d, b.f 
from a 
LEFT OUT JOIN b 
	ON a.a = b.c 

--说明:日程安排提前五分钟提醒 
select * from 日程安排 where datediff('minute',f开始时间,getdate())>5 

--说明:两张关联表,删除主表中已经在副表中没有的信息 
delete from info where not exists ( select * from infobz where info.infid=infobz.infid ) 

好风景

评分 0.00, 满分 5星 0 票 No comments

image

rt

HP 安装Windows 2003 问题

评分 0.00, 满分 5星 0 票 No comments

在HP电脑上安装windows 2003 server / Ghost 系统时有时会遇到:
windows could not start because of a computer disk hardware configuration problem could not read from the selected boot disk check boot path and disk hardware. please check the windows documentation about hardware disk configuration  and your hardware refer once manuals for additional information.
在格式化和拷贝完安装文件后第一次重启时提示“因计算机磁盘硬件的配置问题,无法启动。不能读取所选的引导盘,请检查引导路径和磁盘硬件。请参阅文档中有关磁盘配置的信息并参阅您的硬件参考手册,以获得进一步的信息。

只要将BIOS中Power Management Setup中的 WDRT support 禁止掉,windows2003就可以正常启动了

*WDRT是watchdog resource table

断掉 指定数据库的 当前链接

评分 0.00, 满分 5星 0 票 No comments

断掉 当前链接 数据库的 链接,便于恢复数据库。

--终结 数据库连接
--2009-04-18 Edit by Xing
--断掉 当前链接 数据库的 链接,便于恢复数据库。
--

  Use   Master   
    
  Create   Table   #aa(spid   int,ecid   int,status   varchar(300),loginname   varchar(100),hostname   varchar(200),blk   int   ,dbname   varchar(30),cmd   varchar(100),request_id   int)   
  Insert   Into   #aa   Exec   sp_who   
  Declare   tt   Cursor   for   Select   spid   From   #aa   Where   spid>50   and   dbname='DATANAME'   ----dbname   是你的数据库名字   
  Open   tt   
  Declare   @ActiveUserId   Int,@KillString   Varchar(100)   
  Fetch   Next   From   tt   Into   @ActiveUserId   
  While(@@Fetch_Status=0)   
  Begin   
      Set   @KillString='Kill   '+Convert(Varchar(50),@ActiveUserId)   
      Exec(@KillString)   
      Fetch   Next   From   tt   Into   @ActiveUserId   
  End   
  Drop   Table   #aa   
  Close   tt   
  Deallocate   tt 

[原创]VB.net Group Box 窗口内 自由 拖拽

评分 0.00, 满分 5星 0 票 No comments
#Region "Group Box 拖拽"

    Dim CurrX As Integer
    Dim CurrY As Integer
    Dim MousX As Integer
    Dim MousY As Integer
    Dim MovBoll As Boolean

    '*--将 gpbMATERIAL_INFO 更换为 自己Group Box的名字
    Private Sub gpbATT_FILE_MouseDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles gpbMATERIAL_INFO.MouseDown
        MousX = e.X
        MousY = e.Y
        MovBoll = True
    End Sub

    Private Sub gpbATT_FILE_MouseMove(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles gpbMATERIAL_INFO.MouseMove
         If MovBoll = True Then
            CurrX = sender.Left - MousX + e.X
            CurrY = sender.Top - MousY + e.Y
            sender.Location = New System.Drawing.Point(CurrX, CurrY)
        End If
    End Sub

    Private Sub gpbATT_FILE_MouseUp(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles gpbMATERIAL_INFO.MouseUp
        MovBoll = False
    End Sub


#End Region

[原创]VB.net 使用XML 对 FpSpread 列宽记忆

评分 0.00, 满分 5星 0 票 1 comment
'需要引入的 命名空间
Imports System.Xml
Imports System.IO

#Region "XML 读取 写入 生成"
Private Sub createXML(ByVal xmlFileName As String)
	Try
	
		Dim writer As New Xml.XmlTextWriter(xmlFileName, System.Text.Encoding.GetEncoding("utf-8"))
		'使用自动缩进便于阅读
		writer.Formatting = Xml.Formatting.Indented
		writer.WriteRaw("<!--l version=""1.0"" encoding=""utf-8""-->")
		writer.WriteRaw("<!--   Xing   -->")
		'书写根元素()
		writer.WriteStartElement("xx")
		'关闭根元素
		writer.WriteFullEndElement()
		'将XML写入文件并关闭writer
		writer.Close()
	
	Catch ex As System.Exception
		MsgBox(ex.Message & vbCrLf & ex.StackTrace)
	End Try
End Sub

Private Sub FpSpread_Column_Size_load(ByVal FpSpread As FarPoint.Win.Spread.FpSpread)
	Dim xmlDoc As New XmlDocument
	Dim XmlFileName As String = "C:\XX\INI\FpSpread_Config.xml" '修改为实际XML路径
	Dim intCol As Integer
	
	Try
	
		If File.Exists(XmlFileName) Then
			xmlDoc.Load(XmlFileName)		
			Dim nodeList As XmlNodeList = xmlDoc.SelectSingleNode("xx").ChildNodes '获取xx节点的所有子节点
			Dim xn As XmlNode
			
			For Each xn In nodeList
				Dim xe As XmlElement = CType(xn, XmlElement)				
				If xe.GetAttribute("form") = Me.Name And xe.GetAttribute("Name") = FpSpread.Name Then				
					Dim nls As XmlNodeList = xe.ChildNodes '继续获取xe子节点的所有子节点
					Dim xn1 As XmlNode
					
					For Each xn1 In nls '遍历
						Dim xe2 As XmlElement = CType(xn1, XmlElement) '转换类型
						
						intCol = xe2.Name.Substring(1, xe2.Name.Length - 1)
						FpSpread.ActiveSheet.Columns(Val(intCol)).Width = Integer.Parse(xe2.InnerText)					
					Next xn1
				
				End If
			
			Next
		End If
		
	Catch ex As System.Exception
		File.Delete(XmlFileName)
	End Try
End Sub

Private Sub FpSpread_Column_Size_save(ByVal FpSpread As FarPoint.Win.Spread.FpSpread)
	Dim xmlDoc As New XmlDocument
	Dim XmlFileName As String = "C:\xx\INI\FpSpread_Config.xml" '修改为实际XML路径
	Dim intRecord As Integer
	
	Try
	If File.Exists(XmlFileName) = False Then
		createXML(XmlFileName)
	End If
	
	xmlDoc.Load(XmlFileName)	
	Dim nodeList As XmlNodeList = xmlDoc.SelectSingleNode("xx").ChildNodes '获取xx节点的所有子节点
	Dim xn As XmlNode
	
		For Each xn In nodeList '遍历所有子节点
			Dim xe As XmlElement = CType(xn, XmlElement) '将子节点类型转换为XmlElement类型
			If xe.GetAttribute("form") = Me.Name And xe.GetAttribute("Name") = FpSpread.Name Then '如果form属性值为“当前窗口”Name为 当前spread 那么就 清空下面的数据
			intRecord += 1
			xe.RemoveAll() '*清空数据
			
				If intRecord < 2 Then
				xe.SetAttribute("form", Me.Name)
				xe.SetAttribute("Name", FpSpread.Name)
				
				Dim child_node As XmlElement
					For i As Integer = 0 To FpSpread.ActiveSheet.Columns.Count - 1
						child_node = xmlDoc.CreateElement("C" & i)
						child_node.InnerText = FpSpread.ActiveSheet.Columns(i).Width
						xe.AppendChild(child_node)
					
					Next
				End If
			End If
		Next xn
	
	If intRecord < 1 Then
		Dim root As XmlNode = xmlDoc.SelectSingleNode("xx")
		Dim xe1 As XmlElement = xmlDoc.CreateElement("spread")
		xe1.SetAttribute("form", Me.Name)
		xe1.SetAttribute("Name", FpSpread.Name)
		
		Dim child_node As XmlElement
			For i As Integer = 0 To FpSpread.ActiveSheet.Columns.Count - 1
			child_node = xmlDoc.CreateElement("C" & i)
			child_node.InnerText = FpSpread.ActiveSheet.Columns(i).Width
			xe1.AppendChild(child_node)
	
		Next
	
		root.AppendChild(xe1) '添加到节点中
	
	End If
	
	xmlDoc.Save(XmlFileName) '保存。
	Catch ex As System.Exception
	
	End Try
	
End Sub
#End Region

#Region "Form Load"
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
	'spread load
	FpSpread_Column_Size_load(Me.spListMain)
End Sub
#End Region

#Region "form 关闭"
Private Sub Form1_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
	FpSpread_Column_Size_save(Me.spListMain)
End Sub
#End Region

生成的XML文件内如如下

<?xml version="1.0" encoding="utf-8"?>
<!--   Xing   -->
<xx>
  <spread form="FORM1" Name="spListMain">
    <C0>60</C0>
    <C1>90</C1>
    <C2>106</C2>
    <C3>60</C3>
    <C4>80</C4>
    <C5>60</C5>
    <C6>178</C6>
    <C7>60</C7>
    <C8>119</C8>
    <C9>82</C9>
    <C10>145</C10>
    <C11>88</C11>
    <C12>123</C12>
    <C13>60</C13>
  </spread>
  <spread form="FORM1" Name="spListList">
    <C0>17</C0>
    <C1>65</C1>
    <C2>65</C2>
    <C3>31</C3>
    <C4>60</C4>
    <C5>65</C5>
    <C6>118</C6>
    <C7>69</C7>
    <C8>62</C8>
    <C9>71</C9>
    <C10>34</C10>
    <C11>52</C11>
    <C12>58</C12>
    <C13>58</C13>
    <C14>59</C14>
    <C15>106</C15>
    <C16>34</C16>
    <C17>34</C17>
  </spread>
  <spread form="FORM1" Name="spList1">
    <C0>60</C0>
    <C1>60</C1>
    <C2>60</C2>
    <C3>32</C3>
    <C4>60</C4>
    <C5>71</C5>
    <C6>60</C6>
    <C7>60</C7>
    <C8>60</C8>
    <C9>60</C9>
    <C10>60</C10>
    <C11>72</C11>
    <C12>68</C12>
    <C13>70</C13>
    <C14>60</C14>
    <C15>60</C15>
    <C16>60</C16>
    <C17>60</C17>
    <C18>60</C18>
    <C19>60</C19>
    <C20>60</C20>
    <C21>60</C21>
    <C22>65</C22>
  </spread>
</xx>

VB.net 删除文件夹内所有文件

评分 0.00, 满分 5星 0 票 No comments
Imports System.IO

Public Shared Sub DeleteDir(ByVal aimPath As String)
    Try

        '判断待删除的目录是否存在,不存在则退出.    
        If (Not Directory.Exists(aimPath)) Then Exit Sub
        ' 得到源目录的文件列表,该里面是包含文件以及目录路径的一个数组    
        ' 如果你指向Delete目标文件下面的文件而不包含目录请使用下面的方法    
        ' string[] fileList = Directory.GetFiles(aimPath);    
        Dim fileList() As String = Directory.GetFileSystemEntries(aimPath)
        ' 遍历所有的文件和目录    
        For Each FileName As String In fileList
        If (Directory.Exists(FileName)) Then
        ' 先当作目录处理如果存在这个目录就递归Delete该目录下面的文件    
        DeleteDir(aimPath + Path.GetFileName(FileName))
        Else
        ' 否则直接Delete文件    
        File.Delete(aimPath + Path.GetFileName(FileName))
        End If
        Next
        '删除文件夹、不删除    
        'System.IO.Directory.Delete(aimPath, True)
        Catch ex As Exception
        MessageBox.Show(ex.ToString())
    End Try
End Sub