2013年2月20日 星期三
2013年2月4日 星期一
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月27日 星期二
2012年11月21日 星期三
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
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("
== 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
==============================") '--下面這兩行,可以正常運作!
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
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
訂閱:
文章 (Atom)