private void ENT_Click() { //打开数据库 OleDbConnection conn = new OleDbConnection(odbcConnStr); conn.Open(); //定义sql语句操作数据库 int ID1 = Convert.ToInt32(ID); //string sql = "UPDATE Coordinate_data SET D_NAME ='" + D_NAME.Text + "', D_CODE = '" + D_CODE.Text + "', N = '" + N.Text + "', E = '" + E.Text + "', Z = '" + Z.Text + "' Where ID='" + ID1 + "'"; string sql = "Update Original_data set D_NAME='" + tbItemName.Text.Trim() + "',D_CODE='" + tbItemCode.Text + "' where ID= " + ID1 + " "; OleDbCommand cmd = new OleDbCommand(sql, conn); cmd.CommandText = sql; cmd.ExecuteNonQuery(); MessageBox.Show("编辑成功!", "提示"); Window_Data3_CodedData codedData = new Window_Data3_CodedData(); codedData.LV.SelectedIndex = ID1 - 1; codedData.LV.ScrollIntoView(codedData.LV.SelectedItem); codedData.Show(); this.Close();//关闭当前窗口 }
private void Coded_Click(object sender, RoutedEventArgs e) { Window_Data3_CodedData window_Start1 = new Window_Data3_CodedData(); window_Start1.Show(); this.Close();//关闭当前窗口 }
private void ESC_Click() { int ID1 = Convert.ToInt32(ID); Window_Data3_CodedData codeData = new Window_Data3_CodedData(); codeData.Show(); codeData.LV.SelectedIndex = ID1 - 1; codeData.LV.ScrollIntoView(codeData.LV.SelectedItem); codeData.Show(); this.Close();//关闭当前窗口 }