private void TargetListView_ItemMouseClick(object sender, Telerik.WinControls.UI.ListViewItemEventArgs e) { ListViewDataItem item = TargetListView.SelectedItem; //將資料拉出來到ui上 // === 對 Access 資料庫下SQL語法 === //// Transact-SQL 陳述式 String strSQL = "SELECT id,TargetName,TargetIP,TargetAlert,TargetRes,TargetSpaceLog,TargetWarning FROM [LinuxTarget] WHERE id =" + int.Parse(item[0].ToString()); System.Data.OleDb.OleDbConnection oleConn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=FreeSpaceEyesDB.mdb"); //// 開啟資料庫連接。 oleConn.Open(); //// OleDbCommand (String, OleDbConnection) : 使用查詢的文字和 OleDbConnection,初始化 OleDbCommand 類別的新執行個體。 System.Data.OleDb.OleDbCommand oleCmd = new System.Data.OleDb.OleDbCommand(strSQL, oleConn); OleDbDataReader thisReader = oleCmd.ExecuteReader();//建立OleDbDataReader用來存放從Access裡面讀取出來的 //拉到ui while (thisReader.Read()) { ShowTargetID.Text = thisReader["id"].ToString(); ShowTargetName.Text = thisReader["TargetName"].ToString(); ShowTargetIP.Text = thisReader["TargetIP"].ToString(); ShowTargetAlert.Text = thisReader["TargetAlert"].ToString(); ShowTargetRes.Text = thisReader["TargetRes"].ToString(); ShowTargetWarning.Text = thisReader["TargetWarning"].ToString(); } //// 關閉資料庫連接。 thisReader.Close(); oleConn.Close(); //啟動更新即刪除 updata_btn.Enabled = true; deldata_btn.Enabled = true; }
private void radListViewClientList_ItemMouseClick(object sender, Telerik.WinControls.UI.ListViewItemEventArgs e) { if (radListViewClientList.CurrentItem.CheckState == Telerik.WinControls.Enumerations.ToggleState.On) { radListViewClientList.CurrentItem.CheckState = Telerik.WinControls.Enumerations.ToggleState.Off; } else { radListViewClientList.CurrentItem.CheckState = Telerik.WinControls.Enumerations.ToggleState.On; } }
private void radListView1_ItemMouseDoubleClick(object sender, Telerik.WinControls.UI.ListViewItemEventArgs e) { SelectSubSchemeType(); }
void radListView1_ItemDataBound(object sender, Telerik.WinControls.UI.ListViewItemEventArgs e) { e.Item.Image = Image.FromFile(Application.StartupPath + @"\Resources\CarRentalImages\" + e.Item["ImageFileName"]); }