91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 90KB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2021-05-07
  • 語言: 其他
  • 標簽:

資源簡介

動態從數據庫中綁定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\Database\TreeNodeCom.mdb

?????文件??????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個文件信息

評論

共有 條評論

相關資源