歡迎~ 程式設計 學生 作業 專題製作 程式外包 家教...

【Web.config檔案】

<connectionStrings>
        <add name="MyBookstore_ConnectionString" connectionString="Data Source=127.0.0.1;Initial Catalog=MyBookstore;Persist Security Info=True;User ID=帳號;Password=密碼"          providerName="System.Data.SqlClient" />
</connectionStrings>

WITH table_CTE AS
(
    -- 設定遞迴的初始值
    SELECT CAST('20170101' AS datetime) AS Date  
    UNION ALL

語法
MERGE INTO table_name USING table_name ON (condition)
WHEN MATCHED THEN UPDATE SET column1 = value1 [, column2 = value2 ...]
WHEN NOT MATCHED THEN INSERT (column1 [, column2 ...]) VALUES (value1 [, value2 ...])
 

string strErrorLine = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetFileLineNumber().ToString();
string currentName = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetMethod().Name;
string callName = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetFileName();

string strBodyMsg = "";
strBodyMsg += "訊息提示: " + ex.Message.ToString() + "<br>";

SQL  的執行順序如下
1.FROM
2.ON
3.JOIN
4.Where

SELECT
name AS FileName,
size*1.0/128 AS FileSizeinMB,
CASE max_size
WHEN 0 THEN 'Autogrowth is off.'

Dim dt As New DataTable()

dt.DefaultView.Sort = "Number,ID" '將DataTable排序

dt = dt.DefaultView.ToTable()

display : none -不顯示這個元素。

display:block - 元素會換行，並且寬度會預設到最大。

display:inline - 所有元素都會在同一行，不會換行。

private void button1_Click(object sender, EventArgs e)
{
    OpenFileDialog file = new OpenFileDialog();
    file.ShowDialog();
    textBox1.Text = file.SafeFileName;

private void button1_Click(object sender, EventArgs e)
{
    FolderBrowserDialog path = new FolderBrowserDialog();
    path.ShowDialog();
    textBox1.Text = path.SelectedPath;