假設我要將目錄內的檔案全列出來,可以用下面的code
foreach (string filename in System.IO.Directory.GetFileSystemEntries("c:\\awslive\\"))
假設我要將目錄內的檔案全列出來,可以用下面的code
foreach (string filename in System.IO.Directory.GetFileSystemEntries("c:\\awslive\\"))
ExecuteNonQuery 方法不會返回任何資料庫的資料, 它只會返回整數值來表示成功或受影響的資料列數目.
If use ExecuteNonQuery to create or modify database structure, eg. create table, this method returns -1 if success, returns 0 if fail.
string cs = System.Configuration.ConfigurationManager.ConnectionStrings["transferConnectionString"].ConnectionString;
//上面這行是在Web.config中有 <add name="transferConnectionString" connectionString="Data Source=127.0.0.1;Initial Catalog=transfer;User ID=username;Password=yourpassword"
這段程式碼是從http://stackoverflow.com/questions/1344221/how-can-i-generate-random-alphanumeric-strings-in-c 複製的
var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
var stringChars = new char[8];
var random = new Random();
for (int i = 0; i < stringChars.Length; i++)
{
stringChars[i] = chars[random.Next(chars.Length)];
}
var finalString = new String(stringChars);
最後產生的finalString就是我們要的亂數,至於亂數長度,你可以調整第二行中8這個數字,如果沒改就是長度8的亂數.
using System;
using System.Collections.Generic;
出處 http://www.java2s.com/Tutorial/ASP.NET/0360__ADO.net-Database/InsertupdateanddeleteC.htm
File: Default.aspx
出處 https://msdn.microsoft.com/zh-tw/library/kb5kfec7(v=vs.110).aspx
Client side sample code
出處 https://msdn.microsoft.com/zh-tw/library/bew39x2a(v=vs.110).aspx
Client side sample code