DateTime.Now();
通通一率是UTC時間。
經同事查證,只單純修改WebConfig 的時間是無效的,
需要在 Azure WebApp 中 設定 [ 應用程式設定 ]
實際操作如下 :
圖1.Web Application 中點選應用程式設定
圖2. 輸入應用程式設定 WEBSITE_TIME_ZONE : 自己的時區 (eg. Taipei Standard Time )。
參考:
4. [MSDN]時區清單
DateTime.Now();
<connectionStrings>
<add name="ConnectionString1" connectionString="Data Source=DatabaseName;Initial Catalog=AdventureWorksLT2008;Persist Security Info=True;User ID=xx;Password=xxxxxxxxx" providerName="System.Data.SqlClient"/>
</connectionStrings>
----------------------------------------------------------------------------------------------------------------------
<div>
<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" Skin="MetroTouch"></telerik:RadGrid>
<asp:Label ID="Label1" runat="server" Text="Label"/>
</div>
----------------------------------------------------------------------------------------------------------------------
protected void Page_Load(object sender, EventArgs e)
{
//呼叫Function
DataBind_GridView();
}
----------------------------------------------------------------------------------------------------------------------
// Function Start
private void DataBind_GridView() {
//Connection String
string Connection1 = ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString;
string selectDB = "SELECT * FROM SalesLT.Customer";
SqlConnection db = new SqlConnection(Connection1); //new Sql 連線
SqlCommand cmd = new SqlCommand(selectDB, db); //Sql Command
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
RadGrid1.DataSource = ds;
}
----------------------------------------------------------------------------------------------------------------------<a href="#id1">Test 錨點</a>
or
<button type="button" onclick="location.href='#id1'">
2.跨頁錨點
<a href='@Url.Action("Action", "Controller")#id1'>
or
<button type="button" onclick="location.href='@Url.Action("Action", "Controller")#id1'">
#region 準備範例資料
//建立DataTable
DataTable dt = new DataTable();
//新增2欄位
dt.Columns.Add("Name");
dt.Columns.Add("TEL");
//寫入直向的10筆資料
for (int i = 1; i < 11; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "A" + i;
dr[1] = "B" + i;
dt.Rows.Add(dr);
}
#endregion
//建立新的DataTablle
DataTable dtNew = new DataTable();
for (int i = 1; i < 4; i++)
{
dtNew.Columns.Add("Name" + i);
dtNew.Columns.Add("TEL" + i);
}
#region 開始準備進行轉為橫向
//dtNew 的新DataRow
DataRow drNew = dtNew.NewRow();
int iLast = 1; //用來記錄跑到第幾個舊資料列
//用來說明寫入的是新資料列的第幾個Cell
int iCellCount = 0;
//開始by 每一個舊資料的Rows 寫入新的DataTable
foreach (DataRow item in dt.Rows)
{
//寫入每個Rows的特定Column內
drNew[iCellCount] = item["Name"].ToString();
drNew[iCellCount + 1] = item["TEL"].ToString();
iCellCount = iCellCount + 2; //用來計算第幾個Column
//如果裝滿了一個Row,就在dtNew中新增新的Row
if (iCellCount >= 6)
{
iCellCount = 0;
dtNew.Rows.Add(drNew);
drNew = dtNew.NewRow();
}
//如果是最後一筆資料,直接新增進dtNew
else if (iLast == item.Table.Rows.Count)
{
dtNew.Rows.Add(drNew);
}
//紀錄 +1
iLast += 1;
}
#endregion
圖、3 完成後的資料
我相信一定會有更好的方法可以將DataTable 由直向轉為橫向呈現,也歡迎各位用力鞭打。
但目前還沒有知道更好的方法之前,可能先暫時以這種方式進行囉!!
<connectionStrings>
<!--連線字串--> <add name="ConnectionString1" connectionString="Data Source=mycomputer; Initial Catalog=AdventureWorksLT2008;Persist Security Info=True; User ID=xxxx;Password=xxxxxxxx" providerName="System.Data.SqlClient"/> </connectionStrings>-----------------------------------------------------------------------------------------------------------------
<body>
<body>
<div>
<telerik:RadXmlHttpPanel ID = "RadXmlHttpPanel1" runat="server">
<%-- TextBox 用來查詢該Table內資料 --%>
<telerik:RadTextBox ID = "tbFirstName" runat="server" Skin="MetroTouch"></telerik:RadTextBox>
<%-- Btn --%>
<telerik:RadButton ID = "btnSearch" runat="server" Text="Search"
Skin="MetroTouch" OnClick="btnSearch_Click"></telerik:RadButton>
</telerik:RadXmlHttpPanel>
<%-- GridView--%>
<telerik:RadGrid ID = "RadGrid1" runat="server" AllowPaging="True" Skin="Glow" AllowSorting="True"
Culture="zh-TW" GroupPanelPosition="Top"></telerik:RadGrid>
</div>
<body>
----------------------------------------------------------------------------------------------------------------- protected void Page_Load(object sender, EventArgs e)
protected void Page_Load(object sender, EventArgs e)
{
//Fumction
DataBind_GV();
}
public void DataBind_GV()
{
DBConnect dbc = new DBConnect(); //New Class
DataTable dt = new DataTable(); //New DataTable
dbc.DbSelect(dt);
this.RadGrid1.DataSource = dt; //指定DataTable給DataSource
this.RadGrid1.DataBind(); //綁訂資料
}
//查詢
protected void btnSearch_Click(object sender, EventArgs e)
{
string FirstName = tbFirstName.Text;
DBConnect dbc = new DBConnect();
DataTable dse = new DataTable();
//記得拿DataTable來裝資料
dse = dbc.SearchDB(FirstName );
this.RadGrid1.DataSource = dse;
this.RadGrid1.DataBind();
}
-----------------------------------------------------------------------------------------------------------------
DBConnect.cs
----------------------------------------------------------------------------------------------------------------- public class DBConnect
public class DBConnect
{
public string _conn = ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString;
public DataTable DbSelect(DataTable ds)
{
string selectDB = "SELECT * FROM SalesLT.Customer";
SqlConnection db = new SqlConnection(_conn);
SqlCommand cmd = new SqlCommand(selectDB, db);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return (ds);
}
//存放Sql語法的地方
public DataTable SearchDB(string FirstName)
{
string searchCmd = "SELECT * FROM SalesLT.Customer WHERE FirstName like @FirstName";
//string searchCmd = "SELECT * FROM SalesLT.Customer";
SqlCommand cmd = new SqlCommand(searchCmd);
// cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar);
//cmd.Parameters["@FirstName"].Value = "%" + FirstName + "%";
cmd.Parameters.AddWithValue("@FirstName", "%" + FirstName + "%");
return QueryToDataTable(_conn, cmd);
}
//執行語法並傳遞DataTable
public DataTable QueryToDataTable(string connstr, SqlCommand cmd)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
conn.Close();
return dt;
}
-----------------------------------------------------------------------------------------------------------------