public partial class Form1 : Form
{
public event EventHandler BossEventHandler; //處理事件的物件
- May 30 Wed 2018 10:46
-
事件用法
- Nov 22 Wed 2017 11:41
-
gridview顯示資料庫內容(Oracle)
public void output(string myConnectionString)
{
DataTable DT = new DataTable();
// If the connection string is empty, use default.
if (myConnectionString == "")
- Apr 26 Wed 2017 09:31
-
使用HtmlAgilityPack解析網路資料
using System.Net;
using System.IO;
using System.Web;
using HtmlAgilityPack;
- Apr 24 Mon 2017 15:51
-
List 自訂型別 快速寫法
(1) 原始寫法
List<RetestPackage> mRetestPkgList = new List<RetestPackage>();
RetestPackage AR = new RetestPackage();
AR.ID = InPut2DStr;
mRetestPkgList.Add(AR);
- Mar 02 Thu 2017 16:42
-
OLED 讀 CSV
public DataTable ReadCSVFile(string strFilePath, string strFileName) // strFilePath 為檔案所在資料夾,strFileName 為檔案名稱
{
OleDbConnection connection = new OleDbConnection(string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}; Extended Properties=""text;HDR=Yes;FMT=Delimited"";", strFilePath));
OleDbCommand command = new OleDbCommand("SELECT * FROM " + strFileName, connection);
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
- Feb 21 Tue 2017 17:25
-
c# 連線oleDB
using System.Data.OleDb;
public static OleDbConnection OleDbOpenConn(string Database)
{
string cnstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Database);
OleDbConnection icn = new OleDbConnection();
- Feb 09 Thu 2017 14:18
-
delegate(委派)用法
delegate void mydelegate(string name); //宣告delegate變數 mydelegate
class Program
{
static void Main(string[] args)
{
- Feb 06 Mon 2017 16:41
-
TCP/IP連接(CLIENT端)
class Program
{
//宣告網路資料流變數
NetworkStream myNetworkStream;
//宣告 Tcp 用戶端物件
- Feb 06 Mon 2017 16:01
-
TCP/IP連接(HOST端)
using System.Net.Sockets;
System.Net.IPAddress theIPAddress; //ip變數
theIPAddress = System.Net.IPAddress.Parse("127.0.0.1"); // 127.0.0.1
TcpListener myTcpListener = new TcpListener(theIPAddress, 36000); //監聽變數 myTcpListener
myTcpListener.Start(); //監聽開始
- Jan 26 Thu 2017 13:33
-
[FTP]上傳下載檔案
WebClient wc = new WebClient(); //宣告web client物件
wc.Credentials = new NetworkCredential(account, password); //登陸ftp
wc.DownloadFile("ftp://127.0.0.1//abcd.txt", "C:\\Users\\8044\\Desktop\\abcd.txt"); //下載
wc.UploadFile("ftp://127.0.0.1//ghig.xls", "C:\\Users\\8044\\Desktop\\9906.xls"); //上傳
- Jan 25 Wed 2017 15:20
-
從FTP下載文件
FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://127.0.0.1//55555.txt");
request.Method = WebRequestMethods.Ftp.DownloadFile;
request.Credentials = new NetworkCredential("ftpuser", "Aa123456");