private void Sell(int Code) { DataTable tableToFill; tableToFill = new DataTable("tableToFill"); MySqlDataAdapter adapter; adapter = new MySqlDataAdapter(qSelectWareByCode, connection); adapter.SelectCommand.Parameters.AddWithValue("?pcode", Code.ToString()); adapter.Fill(tableToFill); // TODO: fillschema() only if no schema if (dataSet1.Tables["chetab"].Columns.Count == 0) { adapter.FillSchema(dataSet1.Tables["chetab"], SchemaType.Source); } tableToFill.PrimaryKey = new DataColumn[] { tableToFill.Columns["id"] }; int n = tableToFill.Rows.Count; active_q_id = -1; #region Determine exact ware active_q_id if (n == 0) { PrintLog("[Oops] The ware is not found by the code: count(*) == 0"); return; } if (n > 1) { FormSearch fs = new FormSearch(connection); if (fs.ShowDialog() != DialogResult.OK) { PrintLog("[Abort] Search canceled (fs.ShowDialog != OK)"); return; } active_q_id = fs.SelectedId; fs.Dispose(); } else { active_q_id = (int)tableToFill.Rows[0].ItemArray[0]; } #endregion DataRow wareRow = tableToFill.Rows.Find(active_q_id); dataSet1.Tables["chetab"].ImportRow(wareRow); dgv1.DataMember = "chetab"; // Focus on kol-vo dgv1.CurrentCell = dgv1["countDataGridViewTextBoxColumn", dgv1.Rows.Count - 1]; dgv1.BeginEdit(true); }
private void поискToolStripMenuItem_Click(object sender, EventArgs e) { FormSearch fs = new FormSearch(connection); if (fs.ShowDialog() != DialogResult.OK) { PrintLog("[Abort] Search canceled (fs.ShowDialog != OK)"); return; } active_q_id = fs.SelectedId; fs.Dispose(); // тут надо продать найденное textBoxCode.SelectAll(); }