2012年12月25日 星期二

7 essential tools for MySQL DBA


Linux Admin Zone - 7 essential tools for MySQL DBA



1. Percona Toolkit
2. Mydumper
3. MySQL Master HA
4. ESF Database Migration Toolkit
5. Xtrabackup
6. Mycheckpoint
7. Web based GUI Tools to manage MySQL

2012年11月15日 星期四

"選取" Gridview的某一列(RowIndex) & 那一列對應資料表的P.K.值

資料來源:MIS2000 Lab


要擷取「使用者點選了 GridView的哪一列(RowIndex)?」
有很多的寫法
當我們使用 GridView的「選取」命令欄位時,要抓取「使用者點選了哪一列?」,最好寫在 SelectedIndexChanged()事件裡面,運作起來會比較正常!



    Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
        Response.Write("
== GridView1_RowCommand() ==
")
        Response.Write("GridView1.SelectedIndex--  " & GridView1.SelectedIndex)
        Response.Write("
GridView1.SelectedValue-- " & GridView1.SelectedValue)

    End Sub

'--使用「選取(Select)」命令欄位,通常會用到底下這兩個事件!--
    Protected Sub GridView1_SelectedIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSelectEventArgs) Handles GridView1.SelectedIndexChanging
        Response.Write("
== GridView1_SelectedIndexChanging() ==
")
        Response.Write("GridView1.SelectedIndex--  " & GridView1.SelectedIndex)
        Response.Write("
GridView1.SelectedValue-- " & GridView1.SelectedValue)
        Response.Write("
==============================")    '--下面這兩行,可以正常運作!
        Response.Write("
GridView1.Rows(e.NewSelectedIndex).RowIndex-- " & GridView1.Rows(e.NewSelectedIndex).RowIndex.ToString())    '--抓取那一列「對應資料表」的主索引鍵
        Response.Write("
e.NewSelectedIndex-- " & e.NewSelectedIndex.ToString())  '--抓取那一列的index鍵
    End Sub

    Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged
        Response.Write("
== GridView1_SelectedIndexChanged() ==
")
        Response.Write("GridView1.SelectedIndex--  " & GridView1.SelectedIndex)
        Response.Write("
GridView1.SelectedValue-- " & GridView1.SelectedValue)
        Response.Write("
GridView1.SelectedDataKey.Value-- " & GridView1.SelectedDataKey.Value)
    End Sub