<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[vb.net 专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/wangpeixian</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wangpeixian]]></copyright><item><title><![CDATA[not exists]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4747131</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4747131</guid><author>wangpeixian</author><pubDate>Fri, 30 Oct 2009 11:38:00 +0800</pubDate><description><![CDATA[   --将b表与a表中不相同的记录从a表中删除  delete from a  WHERE not exists (SELECT b.item_id,b.item_type_id  FROM  b   WHERE a.item_id =b.item_id and a.item_type_id =b.item_type_id and a.acc_id=b.acc_id )  --将b表]]></description><category></category></item><item><title><![CDATA[CheckedListBox 设置checkbox 为不可操作]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4417260</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4417260</guid><author>wangpeixian</author><pubDate>Thu, 06 Aug 2009 10:00:00 +0800</pubDate><description><![CDATA[事实上CheckedListBox中checkbox 并没有Enabled属性，但是我们却经常想做到这样的操作：根据自己的条件，让某些选项永远处在checked 状态，处理方法有很多中，我使用的是以下方法： 1、 CheckedListBox并不能直接与DataSet进行绑定，因此在绑定前做一些处理：        Dim CheckedListBoxItems As New Arra]]></description><category></category></item><item><title><![CDATA[用代码生成DataGridView,DataSet，并且对DataGridView进行绑定]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4348297</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4348297</guid><author>wangpeixian</author><pubDate>Tue, 14 Jul 2009 18:00:00 +0800</pubDate><description><![CDATA[        Dim column As DataGridViewTextBoxColumn        Me.gdv_detail_list.DataSource = Nothing        Me.gdv_detail_list.Columns.Clear()        column = New DataGridViewTextBoxColumn()        colu]]></description><category></category></item><item><title><![CDATA[DataGridView鼠标经过Cell时弹出对话框]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4348265</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4348265</guid><author>wangpeixian</author><pubDate>Tue, 14 Jul 2009 17:49:00 +0800</pubDate><description><![CDATA[ Private Sub gdv_view_schedule_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles gdv_view_schedule.MouseMove        Dim hitCell As DataGridView.HitTestInfo = ]]></description><category></category></item><item><title><![CDATA[播放声音文件]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4206535</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4206535</guid><author>wangpeixian</author><pubDate>Thu, 21 May 2009 15:12:00 +0800</pubDate><description><![CDATA[  Imports System.Media  Dim sp As System.Media.SoundPlayer   Me.sp = New System.Media.SoundPlayer(soundfilepath)sounffilepath一定是本机磁盘上的位置，不能把声音文件做为项目的资源，否则在播放声音的时候会出现杂音 Me.sp.PlayLooping()有几种播放]]></description><category></category></item><item><title><![CDATA[如何将资源的声音文件写到磁盘指定的位置]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4206524</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4206524</guid><author>wangpeixian</author><pubDate>Thu, 21 May 2009 15:07:00 +0800</pubDate><description><![CDATA[   Imports System.IO        Me.soundFolder =   String.Format("{0}/sound", System.Environment.GetFolderPath   (Environment.SpecialFolder.LocalApplicationData))System.Environment.GetFolderPath(Envi]]></description><category></category></item><item><title><![CDATA[如何新建一个DataSet,并且插入相应的数据]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4052947</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4052947</guid><author>wangpeixian</author><pubDate>Mon, 06 Apr 2009 22:01:00 +0800</pubDate><description><![CDATA[ init 0 to 23 ingition percent        Dim table As DataTable = New DataTable("Table")        Dim column As DataColumn        Dim row As DataRow        column = New DataColumn()        column.DataType]]></description><category></category></item><item><title><![CDATA[如何用键盘上下键来控制gridview list行的选择]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4052941</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4052941</guid><author>wangpeixian</author><pubDate>Mon, 06 Apr 2009 21:58:00 +0800</pubDate><description><![CDATA[ selected girdview rows using keyboard operate    Private Sub gdv_route_points_list_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles gdv_route_points_list.]]></description><category></category></item><item><title><![CDATA[如何动态生成多个相同的控件]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/4052914</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/4052914</guid><author>wangpeixian</author><pubDate>Mon, 06 Apr 2009 21:44:00 +0800</pubDate><description><![CDATA[选择一下容器控件放入form中,本例子选用的是table,并且数据全部是从DB中读取出来的.动态生成多个checkbox,然后对checkbox的事件进行相应的处理:        For Each dr As DataRow In Me.DS.Tables(0).Rows从DB中读取数据            chk = New CheckBox()            chk.Na]]></description><category></category></item><item><title><![CDATA[关于datagridview的常用操作]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/3847134</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/3847134</guid><author>wangpeixian</author><pubDate>Wed, 21 Jan 2009 10:21:00 +0800</pubDate><description><![CDATA[1、关于DataGridView数据绑定是一件很简单的事情，只需要将其DataSource设置为你所需要的数据就行 2、如何遍历整个DataGridView，并且取出相应的数据进行操作   Dim drv As DataRowView  Dim x As Double  For i As Integer = 0 To DataGridViewName.Rows.Count - ]]></description><category></category></item><item><title><![CDATA[如何使用哈希表传递数据]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/3838946</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/3838946</guid><author>wangpeixian</author><pubDate>Tue, 20 Jan 2009 10:59:00 +0800</pubDate><description><![CDATA[定义哈希表，并且参加相应的参数 Dim values As New Hashtable() Dim y As Double Dim x As Double values.Add("x", x) values.Add("y", y) FunctionA(values)  接收哈希表传来的数据，并且使用他的数据   Public Sub FunctionA(ByVa]]></description><category></category></item><item><title><![CDATA[gridview如何改变行显示的内容以及设置单元格的是否允许编辑]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/3224260</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/3224260</guid><author>wangpeixian</author><pubDate>Wed, 05 Nov 2008 10:12:00 +0800</pubDate><description><![CDATA[   ds.Tables(0).Columns.Add("colunmname", GetType(String)) ds代表数据源        For i As Integer = 0 To ds.Tables(0).Rows.Count - 1            If CBool((ds.Tables(0).Rows(i)("colunmname"))) Then 更改那个字段的显示]]></description><category></category></item><item><title><![CDATA[设置siteMapPath路径]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/3174467</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/3174467</guid><author>wangpeixian</author><pubDate>Wed, 29 Oct 2008 12:49:00 +0800</pubDate><description><![CDATA[http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >                                       ]]></description><category></category></item><item><title><![CDATA[sql server 函数的编写与调用]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/3174293</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/3174293</guid><author>wangpeixian</author><pubDate>Wed, 29 Oct 2008 12:29:00 +0800</pubDate><description><![CDATA[编写函数create function FunctionName(  @functionparameter parametertype)returns @ReturnFunctionName table( returnDBfield DBtype)asbegin insert into @ReturnFunctionName select returnDBfield from DBtable  r]]></description><category></category></item><item><title><![CDATA[如何正确使用reporting servies]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/3167883</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/3167883</guid><author>wangpeixian</author><pubDate>Tue, 28 Oct 2008 16:11:00 +0800</pubDate><description><![CDATA[如何正确使用reporting servies（其中SQL2005DEV为安装sql server 2005是给的实例名）1、  安装好sql server 2005，选择全部的功能进行安装，对于xp版不能安装企业版sql server 2005，只能安装个人版与开发版；2、  安装好sql server 2005后，在sql server 2005中会自动带有二个数据库：ReportSe]]></description><category></category></item><item><title><![CDATA[如何为DropDownList设置默认项]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/3136749</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/3136749</guid><author>wangpeixian</author><pubDate>Fri, 24 Oct 2008 15:30:00 +0800</pubDate><description><![CDATA[            Dim ds As Data.DataSet            Dim dr As Data.DataRow            ds = SDS.CROCS.DBManager.Plan.Plan.GetPlanListBeforeDateIncludeLive(scheduleRadCalendar.SelectedDate.AddDays(+1))     ]]></description><category></category></item><item><title><![CDATA[在不同SQL服务器上的数据库之间表记录的复制(sql语句实现) ]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/2833559</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/2833559</guid><author>wangpeixian</author><pubDate>Tue, 26 Aug 2008 15:35:00 +0800</pubDate><description><![CDATA[在不同SQL服务器上的数据库之间表记录的复制(sql语句实现) 现有服务器server1，server2，server1上有数据库db1，server2上有数据库db2，db1上有数据表table1，db2上都有数据表table2，table1和table2的结构是完全相同. 现在需要解决的是把server1数据库db1中的tabl1复制到server2上的db2数据库tabl]]></description><category></category></item><item><title><![CDATA[ VS.NET 2005 常用快捷键]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/2831824</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/2831824</guid><author>wangpeixian</author><pubDate>Tue, 26 Aug 2008 11:30:00 +0800</pubDate><description><![CDATA[常用快捷键Shift+Alt+Enter: 切换全屏编辑 Ctrl+B,T / Ctrl+K,K: 切换书签开关 Ctrl+B,N / Ctrl+K,N: 移动到下一书签 Ctrl+B,P: 移动到上一书签 Ctrl+B,C: 清除全部标签 Ctrl+I: 渐进式搜索 Ctrl+Shift+I: 反向渐进式搜索 Ctrl+F: 查找 Ctrl+Shift+F: 在文件中查找 F3: 查]]></description><category></category></item><item><title><![CDATA[怎么样才能嫁给有钱人？经典问答  ]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/2813329</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/2813329</guid><author>wangpeixian</author><pubDate>Fri, 22 Aug 2008 12:24:00 +0800</pubDate><description><![CDATA[无论男女，都想要嫁个有钱人。所以本专题是为男人和女人一起准备的，但出于阐述问题的方便，我们以女人为第一主角，至于那些想嫁有钱人的男人，只要注意把本专题中出现的有钱男人换成有钱女人，也是可以的。（注：本专题所谓的有钱人是指有钱有品位的人士，如果你只想找个暴发户，请直接在山西煤矿旁边蹲点就成。）　 　（一个年轻漂亮的美国女孩波尔斯在美国一家大型网上论坛金融版上发表了这样一个问题帖）　　 本人25岁，是]]></description><category></category></item><item><title><![CDATA[通过存储过程来进行数据绑定]]></title><link>https://blog.youkuaiyun.com/wangpeixian/article/details/2632527</link><guid>https://blog.youkuaiyun.com/wangpeixian/article/details/2632527</guid><author>wangpeixian</author><pubDate>Thu, 10 Jul 2008 09:42:00 +0800</pubDate><description><![CDATA[在.aspx页面有一个下拉列表,命名为:TypeID,他所使用表为AssetType表, 存储过程的编写: set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo create PROCEDURE [dbo].[PR_SelectAssetType] @ID INT=, @TypeName VARCHAR(50)=, @Error VARCH]]></description><category></category></item></channel></rss>