private void button3_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(@"Data source=.\SQLEXPRESS;Initial Catalog=I002_Solodkov;User ID=user;Password=Passw0rd;")) { try { con.Open(); SqlCommand cmd = con.CreateCommand(); //заполнение данных cmd.CommandText = "DELETE [pcoming] WHERE [pcoming].id=" + ids; cmd.ExecuteScalar(); coming_new uc = new coming_new(id_com); uc.Location = new Point(0, 30); uc.Size = Size; this.Parent.Controls.Add(uc); this.Parent.Controls.RemoveAt(1); } catch (Exception ex) { errol.Text = "Ошибка записи"; errol.Visible = true; } finally { con.Close(); } } }
private void button2_Click(object sender, EventArgs e) { coming_new uc = new coming_new(id_com); uc.Location = new Point(0, 30); uc.Size = Size; this.Parent.Controls.Add(uc); this.Parent.Controls.RemoveAt(1); }
private void button1_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(@"Data source=.\SQLEXPRESS;Initial Catalog=I002_Solodkov;User ID=user;Password=Passw0rd;")) { try { con.Open(); SqlCommand cmd = con.CreateCommand(); SqlDataReader reader; cmd.CommandText = "INSERT coming (date) VALUES ('" + Convert.ToString(DateTime.Now) + "')"; cmd.ExecuteScalar(); cmd.CommandText = "SELECT * FROM [coming] ORDER BY id DESC"; string id_coming = ""; reader = cmd.ExecuteReader(); while (reader.Read()) { id_coming = Convert.ToString(String.Format("{0}", reader[0])); break; } reader.Close(); coming_new uc = new coming_new(id_coming); uc.Location = new Point(0, 30); uc.Size = Size; this.Parent.Controls.Add(uc); this.Parent.Controls.RemoveAt(1); } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex)); } finally { con.Close(); } } }
private void table_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == 1 || e.ColumnIndex == 2 || e.ColumnIndex == 3 || e.ColumnIndex == 4 || e.ColumnIndex == 5) { String id = Convert.ToString(table.Rows[Convert.ToInt32(e.RowIndex.ToString())].Cells[0].Value); using (SqlConnection con = new SqlConnection(@"Data source=.\SQLEXPRESS;Initial Catalog=I002_Solodkov;User ID=user;Password=Passw0rd;")) { try { con.Open(); SqlCommand cmd = con.CreateCommand(); //заполнение данных cmd.CommandText = "UPDATE [coming] SET id_kontragent='" + id + "' Where [coming].id=" + ids; cmd.ExecuteScalar(); coming_new uc = new coming_new(ids); uc.Location = new Point(0, 30); uc.Size = Size; this.Parent.Controls.Add(uc); this.Parent.Controls.RemoveAt(1); } catch (Exception ex) { } finally { con.Close(); } } } } catch { } }
private void button1_Click(object sender, EventArgs e) { string namess = textBox2.Text; string kol = textBox1.Text; string prices = textBox3.Text; if (namess != "" && kol != "" && prices != "") { using (SqlConnection con = new SqlConnection(@"Data source=.\SQLEXPRESS;Initial Catalog=I002_Solodkov;User ID=user;Password=Passw0rd;")) { try { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "select * from pcoming where id_coming=" + id_com + "AND id_product=" + id_product; bool prov = true; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { prov = false; } reader.Close(); if (prov) { //заполнение данных cmd.CommandText = "UPDATE [pcoming] SET id_product='" + id_product + "', price='" + prices + "', count='" + kol + "' Where [pcoming].id=" + ids; cmd.ExecuteScalar(); coming_new uc = new coming_new(id_com); uc.Location = new Point(0, 30); uc.Size = Size; this.Parent.Controls.Add(uc); this.Parent.Controls.RemoveAt(1); } else { errol.Text = "Ошибка записи"; errol.Visible = true; } } catch (Exception ex) { errol.Text = "Ошибка записи"; errol.Visible = true; } finally { con.Close(); } } } else { errol.Text = "Не все поля заполнены"; errol.Visible = true; } }