資源簡介
動態從數據庫中綁定TreeView節點,很實用。

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data.OleDb;
using?System.Data;
using?System.Configuration;
namespace?DBHelper
{
????public?class?DBAccess
????{
????????static?public?string?connStr?=?ConfigurationManager.ConnectionStrings[“DBConnectionString“].ConnectionString;
????????///?
????????///?執行無參數無返回SQL查詢,返回影響的記錄數
????????///?
????????///?SQL語句
????????///?影響的記錄數
????????public?static?int?ExecuteNonQuery(string?SQLString)
????????{
????????????using?(OleDbConnection?conn?=?new?OleDbConnection(connStr))
????????????{
????????????????using?(OleDbCommand?cmd?=?new?OleDbCommand(SQLString?conn))
????????????????{
????????????????????try
????????????????????{
????????????????????????if?(conn.State.Equals(ConnectionState.Closed))
????????????????????????????conn.Open();
????????????????????????int?rows?=?cmd.ExecuteNonQuery();
????????????????????????return?rows;
????????????????????}
????????????????????catch?(OleDbException?err)
????????????????????{
????????????????????????throw?new?Exception(err.Message);
????????????????????}
????????????????????finally
????????????????????{
????????????????????????cmd.Dispose();
????????????????????????conn.Close();
????????????????????}
????????????????}
????????????}
????????}
????????///?
????????///?執行有參數無返回查詢,返回影響的記錄數
????????///?
????????///?SQL
????????///?參數
????????///?影響的記錄數
????????public?static?int?ExecuteNonQuery(string?SQLString?OleDbParameter[]?prams)
????????{
????????????using?(OleDbConnection?conn?=?new?OleDbConnection(connStr))
????????????{
????????????????using?(OleDbCommand?cmd?=?new?OleDbCommand(SQLString?conn))
????????????????{
????????????????????try
????????????????????{
????????????????????????foreach?(OleDbParameter?item?in?prams)//添加參數
????????????????????????{
????????????????????????????cmd.Parameters.Add(item);
????????????????????????}
????????????????????????if?(conn.State.Equals(ConnectionState.Closed))
????????????????????????????conn.Open();
????????????????????????int?rows?=?cmd.ExecuteNonQuery();
????????????????????????return?rows;
????????????????????}
????????????????????catch?(OleDbException?err)
????????????????????{
????????????????????????throw?new?Exception(err.Message);
????????????????????}
????????????????????finally
????????????????????{
????????????????????????cmd.Parameters.Clear();
????????????????????????cmd.Dispose();
????????????????????????conn.Close();
????????????????????}
????????????????}
????????????}
????????}
????????///?
????????///?執行有參數有返回查詢語句,返回SqlDataReader
????????///?
????????///?查詢語句
????????///?參數
????????///?SqlDataReader
????????public?static?Ole
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1560??2009-08-01?01:05??動態從數據庫中綁定TreeView節點\51bcw下載必讀.txt
?????文件???????1560??2009-08-01?01:05??動態從數據庫中綁定TreeView節點\DBHelper\51bcw下載必讀.txt
?????文件??????20480??2009-07-19?12:20??動態從數據庫中綁定TreeView節點\DBHelper\bin\Debug\DBHelper.dll
?????文件??????22016??2009-07-19?12:20??動態從數據庫中綁定TreeView節點\DBHelper\bin\Debug\DBHelper.pdb
?????文件???????7848??2009-07-19?12:20??動態從數據庫中綁定TreeView節點\DBHelper\DBAccess.cs
?????文件???????2005??2009-07-18?21:28??動態從數據庫中綁定TreeView節點\DBHelper\DBHelper.csproj
?????文件???????1324??2010-04-28?10:56??動態從數據庫中綁定TreeView節點\DBHelper\obj\DBHelper.csproj.FileListAbsolute.txt
?????文件??????20480??2009-07-19?12:20??動態從數據庫中綁定TreeView節點\DBHelper\obj\Debug\DBHelper.dll
?????文件??????22016??2009-07-19?12:20??動態從數據庫中綁定TreeView節點\DBHelper\obj\Debug\DBHelper.pdb
?????文件??????16384??2009-07-19?11:04??動態從數據庫中綁定TreeView節點\DBHelper\obj\Debug\Refactor\DBHelper.dll
?????文件???????1311??2009-07-18?21:27??動態從數據庫中綁定TreeView節點\DBHelper\Properties\AssemblyInfo.cs
?????文件???????1560??2009-08-01?01:05??動態從數據庫中綁定TreeView節點\TreeViewDemo\51bcw下載必讀.txt
?????文件????????247??2009-07-18?21:39??動態從數據庫中綁定TreeView節點\TreeViewDemo\App.config
?????文件?????221184??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\bin\Debug\Databa
?????文件??????20480??2009-07-19?12:20??動態從數據庫中綁定TreeView節點\TreeViewDemo\bin\Debug\DBHelper.dll
?????文件??????22016??2009-07-19?12:20??動態從數據庫中綁定TreeView節點\TreeViewDemo\bin\Debug\DBHelper.pdb
?????文件??????28672??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\bin\Debug\TreeViewDemo.exe
?????文件????????247??2009-07-18?21:39??動態從數據庫中綁定TreeView節點\TreeViewDemo\bin\Debug\TreeViewDemo.exe.config
?????文件??????32256??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\bin\Debug\TreeViewDemo.pdb
?????文件???????5632??2005-11-11?22:25??動態從數據庫中綁定TreeView節點\TreeViewDemo\bin\Debug\TreeViewDemo.vshost.exe
?????文件????????247??2009-07-18?21:39??動態從數據庫中綁定TreeView節點\TreeViewDemo\bin\Debug\TreeViewDemo.vshost.exe.config
?????文件???????9703??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\FrmTreeView.cs
?????文件??????16251??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\FrmTreeView.Designer.cs
?????文件???????6408??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\FrmTreeView.resx
?????文件??????10535??2010-04-28?10:56??動態從數據庫中綁定TreeView節點\TreeViewDemo\obj\Debug\ResolveAssemblyReference.cache
?????文件????????848??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\obj\Debug\TreeViewDemo.csproj.GenerateResource.Cache
?????文件??????28672??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\obj\Debug\TreeViewDemo.exe
?????文件????????180??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\obj\Debug\TreeViewDemo.FrmTreeView.resources
?????文件??????32256??2009-07-19?12:37??動態從數據庫中綁定TreeView節點\TreeViewDemo\obj\Debug\TreeViewDemo.pdb
?????文件????????180??2009-07-19?12:20??動態從數據庫中綁定TreeView節點\TreeViewDemo\obj\Debug\TreeViewDemo.Properties.Resources.resources
............此處省略32個文件信息
評論
共有 條評論