1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96
|
public partial class Modification : Form
{
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection("Data Source = user-tosh\\Sqlexpress ;database=yosra;User ID =sa;Password=med;");
SqlDataAdapter da = new SqlDataAdapter();
BindingSource tblNamesBS = new BindingSource();
public Modification()
{
InitializeComponent();
}
// afiichage dans la datagridview
private void Afficher_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source = user-tosh\\Sqlexpress ;database=yosra;User ID =sa;Password=med;");
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = new SqlCommand("SELECT * from sagem", conn);
ds.Clear();
da.Fill(ds);
dg.DataSource = ds.Tables[0];
tblNamesBS.DataSource = ds.Tables[0];
txtNom.DataBindings.Add(new Binding("Text", tblNamesBS, "Nom"));
txtPrenom.DataBindings.Add(new Binding("Text", tblNamesBS, "Prenom"));
txtCIN.DataBindings.Add(new Binding("Text", tblNamesBS, "CIN"));
txtID.DataBindings.Add(new Binding("Text", tblNamesBS, "ID"));
}
private void precedent_Click(object sender, EventArgs e)
{
tblNamesBS.MovePrevious();
dgUpdate();
}
private void suivant_Click(object sender, EventArgs e)
{
tblNamesBS.MoveNext();
dgUpdate();
}
private void dgUpdate()
{
dg.ClearSelection();
dg.Rows[tblNamesBS.Position].Selected = true;
}
// Modification
private void button2_Click(object sender, EventArgs e)
{
conn.Open();
da.UpdateCommand = new SqlCommand("UPDATE sagem SET Nom= @Nom, Prenom= @Prenom, CIN= @CIN WHERE ID=@ID", conn);
//da.UpdateCommand.Parameters.Add("@Nom", SqlDbType.VarChar).Value = dg.SelectedCells[0].OwningRow.Cells["Nom"].Value;
//da.UpdateCommand.Parameters.Add("@Prenom", SqlDbType.VarChar).Value = dg.SelectedCells[0].OwningRow.Cells["Prenom"].Value;
//da.UpdateCommand.Parameters.Add("@CIN", SqlDbType.Char).Value = dg.SelectedCells[0].OwningRow.Cells["CIN"].Value;
da.UpdateCommand.Parameters.Add("@Nom", SqlDbType.VarChar).Value = txtNom.Text;
da.UpdateCommand.Parameters.Add("@Prenom", SqlDbType.VarChar).Value = txtPrenom.Text;
da.UpdateCommand.Parameters.Add("@CIN", SqlDbType.Char).Value = txtCIN.Text;
da.UpdateCommand.Parameters.Add("@ID", SqlDbType.Int).Value =txtID.Text;
da.UpdateCommand.ExecuteNonQuery();
conn.Close();
} |
Partager