ΠΠΏΠΈΡΠ°Π½ΠΈΠ΅ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ.
Π‘ΠΎΠ·Π΄Π°Π½ΠΈΠ΅ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΡ "ΠΠΎΡΡΠΈΠ½ΠΈΡΠ°" Π² ΡΡΠ΅Π΄Π΅ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠΈΡΠΎΠ²Π°Π½ΠΈΡ Π‘#
TextBox9.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.Π½ΠΎΠΌΠ΅Ρ_ΠΏΠ°ΡΠΏ»); TextBox6.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.Π½ΠΎΠΌΠ΅Ρ_ΡΠ΅Π»»); TextBox5.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.Π½ΠΎΠΌΠ΅Ρ_ΠΊΠΎΠΌ»); TextBox3.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.ΠΎΡΡΠ΅ΡΡΠ²ΠΎ»); TextBox2.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.ΡΠ°ΠΌΠΈΠ»ΠΈΡ»); Cmd.Parameters.Add (new SqlParameter («@Π½ΠΎΠΌΠ΅ΡΡΠ΅Π»», SqlDbType. VarChar… Π§ΠΈΡΠ°ΡΡ Π΅ΡΡ >
ΠΠΏΠΈΡΠ°Π½ΠΈΠ΅ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ. Π‘ΠΎΠ·Π΄Π°Π½ΠΈΠ΅ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΡ "ΠΠΎΡΡΠΈΠ½ΠΈΡΠ°" Π² ΡΡΠ΅Π΄Π΅ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠΈΡΠΎΠ²Π°Π½ΠΈΡ Π‘# (ΡΠ΅ΡΠ΅ΡΠ°Ρ, ΠΊΡΡΡΠΎΠ²Π°Ρ, Π΄ΠΈΠΏΠ»ΠΎΠΌ, ΠΊΠΎΠ½ΡΡΠΎΠ»ΡΠ½Π°Ρ)
Π Π΄Π°Π½Π½ΠΎΠΌ ΡΠ°Π·Π΄Π΅Π»Π΅ ΠΎΠΏΠΈΡΡΠ²Π°ΡΡΡΡ:
- — Π΄ΠΎΠ±Π°Π²Π»Π΅Π½ΠΈΠ΅ ΠΈΠ½ΡΠΎΡΠΌΠ°ΡΠΈΠΈ ΠΊΠ»ΠΈΠ΅Π½ΡΠΎΠ² Π² Π±Π°Π·Π΅ Π΄Π°Π½Π½ΡΡ ;
- — ΠΏΠ΅ΡΠ°ΡΡ ΠΈ ΠΈΠ·ΠΌΠ΅Π½Π΅Π½ΠΈΠ΅ ΠΈΠ½ΡΠΎΡΠΌΠ°ΡΠΈΠΈ Π² Π±Π°Π·Π΅ Π΄Π°Π½Π½ΡΡ
using System;
using System.Collections.Generic;
using System. ComponentModel;
using System. Data;
using System. Drawing;
using System. Linq;
using System. Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;
namespace ΠΠΎΡΡΠΈΠ½ΠΈΡΠ°.
public partial class Π΄ΠΎΠ±Π°Π²Π»Π΅Π½ΠΈΠ΅: Form.
Form pourtr = null;
public Π΄ΠΎΠ±Π°Π²Π»Π΅Π½ΠΈΠ΅ (Form tre).
InitializeComponent ();
pourtr = tre;
private void button1_Click (object sender, EventArgs e).
SqlConnection cn = new SqlConnection (@" data source =ΠΠ ΠΠ‘-ΠΠSQLEXPRESS;initial catalog = ΠΠΎΡΡΠΈΠ½ΠΈΡ;integrated security = true");
try.
SqlCommand cmd = new SqlCommand («insert into Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ° (ΠΈΠΌΡ, ΡΠ°ΠΌΠΈΠ»ΠΈΡ, ΠΎΡΡΠ΅ΡΡΠ²ΠΎ, ΠΏΠΎΠ»,[Π½ΠΎΠΌΠ΅Ρ_ΠΊΠΎΠΌ],[Π½ΠΎΠΌΠ΅Ρ_ΡΠ΅Π»], Π΄Π°ΡΠ°1, Π΄Π°ΡΠ°2, [Π½ΠΎΠΌΠ΅Ρ_ΠΏΠ°ΡΠΏ]) values (@ΠΈΠΌ, @ΡΠ°ΠΌΠΈ, @ΠΎΡΡΠ΅, @ΠΏΠΎ, @Π½ΠΎΠΌΠ΅ΡΠΊΠΎΠΌ, @Π½ΠΎΠΌΠ΅ΡΡΠ΅Π», @Π΄Π°ΡΠ°1, @Π΄Π°ΡΠ°2, @Π½ΠΎΠΌΠ΅ΡΠΏΠ°Ρ)», cn);
cmd.Parameters.Add (new SqlParameter («@ΠΈΠΌ», SqlDbType. VarChar, 50));
cmd.Parameters.Add (new SqlParameter («@ΡΠ°ΠΌΠΈ», SqlDbType. VarChar, 50));
cmd.Parameters.Add (new SqlParameter («@ΠΎΡΡΠ΅», SqlDbType. VarChar, 50));
cmd.Parameters.Add (new SqlParameter («@ΠΏΠΎ», SqlDbType. VarChar, 50));
cmd.Parameters.Add (new SqlParameter («@Π½ΠΎΠΌΠ΅ΡΠΊΠΎΠΌ», SqlDbType.Int));
cmd.Parameters.Add (new SqlParameter («@Π½ΠΎΠΌΠ΅ΡΡΠ΅Π»», SqlDbType. VarChar, 50));
cmd.Parameters.Add (new SqlParameter («@Π΄Π°ΡΠ°1», SqlDbType. Date));
cmd.Parameters.Add (new SqlParameter («@Π΄Π°ΡΠ°2», SqlDbType. Date));
cmd.Parameters.Add (new SqlParameter («@Π½ΠΎΠΌΠ΅ΡΠΏΠ°Ρ», SqlDbType. VarChar, 50));
cmd.Parameters[" @ΠΈΠΌ" ]. Value = textBox1. Text;
cmd.Parameters[" @ΡΠ°ΠΌΠΈ" ]. Value = textBox2. Text;
cmd.Parameters[" @ΠΎΡΡΠ΅" ]. Value = textBox3. Text;
cmd.Parameters[" @ΠΏΠΎ" ]. Value = textBox4. Text;
cmd.Parameters[" @Π½ΠΎΠΌΠ΅ΡΠΊΠΎΠΌ" ]. Value = textBox5. Text;
cmd.Parameters[" @Π½ΠΎΠΌΠ΅ΡΡΠ΅Π»" ]. Value = textBox6. Text;
cmd.Parameters[" @Π΄Π°ΡΠ°1″ ]. Value = textBox7. Text;
cmd.Parameters[" @Π΄Π°ΡΠ°2″ ]. Value = textBox8. Text;
cmd.Parameters[" @Π½ΠΎΠΌΠ΅ΡΠΏΠ°Ρ" ]. Value = textBox9. Text;
cn.Open ();
cmd.ExecuteNonQuery ();
MessageBox.Show (this," Π²ΡΠΏΠΎΠ»Π½ΠΈΠ»" ," «, MessageBoxButtons. OK, MessageBoxIcon. Information);
if (textBox1.Text ≠ «»).
textBox2.Text = «» ;
else.
MessageBox.Show («ΠΡΠΈΠ±ΠΊΠ°»);
catch.
MessageBox.Show («ΠΡΠΈΠ±ΠΊΠ°»);
finally.
textBox1.ResetText ();
textBox3.ResetText ();
textBox2.ResetText ();
textBox4.ResetText ();
textBox5.ResetText ();
textBox6.ResetText ();
textBox7.ResetText ();
textBox8.ResetText ();
textBox9.ResetText ();
cn.Close ();
private void button2_Click (object sender, EventArgs e).
this.Close ();
private void Form4_FormClosed (object sender, FormClosedEventArgs e).
pourtr.Show ();
ΠΠΈΡΡΠΈΠ½Π³ Form5.cs.
using System;
using System.Collections.Generic;
using System. ComponentModel;
using System. Data;
using System. Drawing;
using System. Linq;
using System. Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System. Collections;
namespace WindowsFormsApplication19.
public partial class Form5: Form.
{ Form part = null;
public Form5(Form bs).
InitializeComponent ();
sqlcon ();
part =bs;
SqlConnection cn = new SqlConnection (@" data source =ΠΠ ΠΠ‘-ΠΠSQLEXPRESS;initial catalog = ΠΠΎΡΡΠΈΠ½ΠΈΡ;integrated security = true");
SqlCommand cmd = new SqlCommand ();
DataSet ds = new DataSet ();
SqlDataAdapter da = new SqlDataAdapter ();
SqlDataAdapter dataAdapter;
SqlCommandBuilder cb;
private void contol ().
dataGridView1.DataSource = ds;
dataGridView1.DataMember = «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°» ;
textBox1.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.ΠΈΠΌΡ»);
textBox2.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.ΡΠ°ΠΌΠΈΠ»ΠΈΡ»);
textBox3.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.ΠΎΡΡΠ΅ΡΡΠ²ΠΎ»);
textBox4.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.ΠΏΠΎΠ»»);
textBox5.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.Π½ΠΎΠΌΠ΅Ρ_ΠΊΠΎΠΌ»);
textBox6.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.Π½ΠΎΠΌΠ΅Ρ_ΡΠ΅Π»»);
textBox7.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.Π΄Π°ΡΠ°1»);
textBox8.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.Π΄Π°ΡΠ°2»);
textBox9.DataBindings.Add («Text», ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°.Π½ΠΎΠΌΠ΅Ρ_ΠΏΠ°ΡΠΏ»);
private void sqlcon ().
SqlConnection cn = new SqlConnection (@" data source =ΠΠ ΠΠ‘-ΠΠSQLEXPRESS;initial catalog = ΠΠΎΡΡΠΈΠ½ΠΈΡ;integrated security = true");
string aff = «select * from Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°» ;
SqlCommand cmd = new SqlCommand (aff, cn);
DataTable datatablt = new DataTable ();
cn.Open ();
dataAdapter = new SqlDataAdapter (cmd);
SqlCommandBuilder commandbuild = new SqlCommandBuilder (dataAdapter);
dataAdapter.Fill (datatablt);
dataGridView1.DataSource = datatablt;
cn.Close ();
private void button1_Click (object sender, EventArgs e).
if (MessageBox.Show («voulez-vous vraiment modifier la base des donnees?», «», MessageBoxButtons. YesNo) == DialogResult. Yes).
this.BindingContext[ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°» ]. EndCurrentEdit ();
if (ds.HasChanges () ≠ true).
try.
da.Update (ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°»);
catch.
MessageBox.Show (this, «erreur fatal», «», MessageBoxButtons. OK, MessageBoxIcon. Error);
private void Form5_Load (object sender, EventArgs e).
cn.Open ();
cmd = new SqlCommand («select * from Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°», cn);
da = new SqlDataAdapter (cmd);
da.Fill (ds, «Π΄Π°ΡΠ°Π³ΠΎΡΡΠ½ΠΈΡΠ°»);
contol ();
cb = new SqlCommandBuilder (da);
this.Close ();
private void Form5_FormClosed (object sender, FormClosedEventArgs e).
part.Show ();