namespace WindowsApplication1
{
public partial class Form1 : Form
{
#region init
private SqlConnection connect;
private string connection1;
private DataSet ds = new DataSet();
private CurrencyManager CM;
private SqlDataAdapter MonAdapter;
private SqlCommand CmdSelect, CmdInsert, CmdUpdate, CmdDelete;
#endregion
#region Constructeur
public Form1()
{
InitializeComponent();
try
{
connection1 = @"Data Source=sept;Initial Catalog=db1;User ID=gstock;password=gst01;Trusted_connection=False";
connect = new SqlConnection(connection1);
//-
ds.Tables.Add("Liste_article");
}
catch (Exception xcp)
{
MessageBox.Show(xcp.Message);
}
}
#endregion
#region Button1 - Connection/Rq Simple
private void button1_Click(object sender, EventArgs e)
{
try
{
CmdSelect = new SqlCommand("SELECT ref_art, nom_art, designation_art FROM articles", connect);
CmdSelect.CommandType = System.Data.CommandType.Text;
//-
MonAdapter = new SqlDataAdapter(CmdSelect);
//-
ds.Clear();
//-
MonAdapter.Fill(ds.Tables["Liste_article"]);
CM = (CurrencyManager)BindingContext[ds.Tables["Liste_article"]];
//-
dataGridView1.DataSource = ds.Tables["Liste_article"];
}
catch (Exception xcp)
{
MessageBox.Show(xcp.Message);
}
}
#endregion
#region Button2 - DataAdapter
private void button2_Click(object sender, EventArgs e)
{
try
{
CmdSelect = new SqlCommand("SELECT id_art, ref_art, nom_art, designation_art FROM articles", connect);
CmdSelect.CommandType = System.Data.CommandType.Text;
//-
CmdUpdate = new SqlCommand("UPDATE articles SET ref_art = @refart, nom_art = @nomart, designation_art = @designationart WHERE id_art = @idart", connect);
CmdUpdate.Parameters.Add(new SqlParameter("@refart", SqlDbType.VarChar, 50, "ref_art"));
CmdUpdate.Parameters.Add(new SqlParameter("@nomart", SqlDbType.VarChar, 50, "nom_art"));
CmdUpdate.Parameters.Add(new SqlParameter("@designationart", SqlDbType.VarChar, 250, "designation_art"));
CmdUpdate.Parameters.Add(new SqlParameter("@idart", SqlDbType.Int, 10,"id_art"));
//-
MonAdapter = new SqlDataAdapter(CmdSelect);
MonAdapter.UpdateCommand = CmdUpdate;
//-
ds.Clear();
//-
MonAdapter.Fill(ds.Tables["Liste_article"]);
//-
textBox1.DataBindings.Clear();
textBox2.DataBindings.Clear();
textBox3.DataBindings.Clear();
textBox4.DataBindings.Clear();
//-
textBox1.DataBindings.Add("Text", ds.Tables["Liste_article"], "id_art");
textBox2.DataBindings.Add("Text", ds.Tables["Liste_article"], "ref_art");
textBox3.DataBindings.Add("Text", ds.Tables["Liste_article"], "nom_art");
textBox4.DataBindings.Add("Text", ds.Tables["Liste_article"], "designation_art");
//-
dataGridView1.DataSource = ds.Tables["Liste_article"];
//-
button3.Enabled = true;
}
catch (Exception xcp)
{
MessageBox.Show(xcp.Message);
}
}
#endregion
#region Button3 - Update
private void button3_Click(object sender, EventArgs e)
{
try
{
CM.EndCurrentEdit();
//-
MonAdapter.Update(ds.Tables["Liste_article"]);
//-
ds.Clear();
//-
MonAdapter.Fill(ds.Tables["Liste_article"]);
}
catch (Exception xcp)
{
MessageBox.Show(xcp.Message);
}
}
#endregion
}
}
Partager