Jason's 程設BLOG

在OBS02DataSet_12.vb中自行撰寫：

Namespace OBS02DataSet1TableAdapters
Partial Public Class OBS12TableAdapter

Public ReadOnly Property DbCommandCollection() As IDbCommand()
Get
Return Me.CommandCollection
End Get
End Property

Public Function FillWhere(ByVal dataTable As DataTable, ByVal whereExpression As String) As Integer
Dim text1 As String = Me.CommandCollection(0).CommandText
Try
Me.CommandCollection(0).CommandText += " WHERE " + whereExpression
Return Me.Fill(DataTable)
Finally
Me.CommandCollection(0).CommandText = text1
End Try
End Function
End Class
End Namespace

用法：

Dim whereExpression As String = "lastname='batman'" '組WHERE字串
Me.OBS12TableAdapter.FillWhere(Me.OBS02DataSet_12.OBS12, whereExpression)

TableAdapter 概觀
http://msdn2.microsoft.com/zh-tw/library/bz9tthwx(VS.80).aspx

在 TableAdapter 中使用 Null 值
http://msdn2.microsoft.com/zh-tw/library/ms233762(VS.80).aspx

Visual Studio 2005中的新DataSet特性
http://www.7dspace.com/doc/24/0602/200622219310134530.htm

How can I get tableadapter to process dynamic sql ‘select’ queries?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=319884&SiteID=1

讀取INI文件..可以用外部方法.使用API
[vbnet]
[DllImport(“kernel32”)]
private static extern int GetPrivateProfileInt(
string lpApplicationName,
string lpKeyName,
int nDefault,
string lpFileName);
[DllImport(“kernel32”)]
private static extern bool GetPrivateProfileString(
string lpApplicationName,
string lpKeyName,
string lpDefault,
StringBuilder lpReturnedString ,
int nSize,
string lpFileName);
[DllImport(“kernel32”)]
private static extern bool WritePrivateProfileString(
string lpApplicationName,
string lpKeyName,
string lpString,
string lpFileName);

[DllImport(“kernel32”)]
private static extern bool GetPrivateProfileSection(
string lpAppName,
StringBuilder lpReturnedString,
int nSize,
string lpFileName );
[DllImport(“kernel32”)]
private static extern bool WritePrivateProfileSection(
string lpAppName,
string lpString,
string lpFileName);
[/vbnet]

Read/Write App.Config File with .NET 2.0
http://www.codeproject.com/useritems/SystemConfiguration.asp

ConfigurationManager.OpenExeConfiguration 方法 (ConfigurationUserLevel)
http://msdn2.microsoft.com/zh-tw/library/ms134265(VS.80).aspx

Configuration 類別
http://msdn2.microsoft.com/zh-tw/library/system.configuration.configuration(VS.80).aspx

在VB.NET 2005中如何取得APP.CONFIG中的資料庫連接字串?
http://blog.blueshop.com.tw/sweetboy/archive/2006/10/12/42229.aspx

讀寫配置文件APP.CONFIG
http://hobe.cnblogs.com/archive/2005/10/04/248679.aspx

動態讀改APP.CONFIG
http://www.cnblogs.com/robber/archive/2007/03/19/679988.html

CSS @ .NET WinForm
http://leoto.blogspot.com/2006/10/css-winform.html

其它.NET技巧
http://www.1-100.org/AspNet/21456.htm

逐步解說：在 Visual Basic 中為字串加密和解密
http://msdn2.microsoft.com/zh-tw/library/ms172831(VS.80).aspx