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
| public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
affichage();
}
public void affichage()
{
string strConnexion = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\admin\Documents\Visual Studio 2010\WebSites\TP_Compte_mode_connecté\App_Data\baseCompte.accdb";
string strRequete = "SELECT * from Compte";
try
{
OleDbConnection oConnection = new OleDbConnection(strConnexion);
OleDbCommand oCommand = new OleDbCommand(strRequete, oConnection);
oConnection.Open();
OleDbDataReader oReader = oCommand.ExecuteReader();
GridView1.DataSource = oReader;
GridView1.DataBind();
GridViewRow row = GridView1.Rows[0];
oReader.Close();
oConnection.Close();
}
catch (Exception exc)
{
//Label3.Text = exc.Message;
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
public void ExcecuterRequette(string req)
{
string strConnexion = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\admin\Documents\Visual Studio 2010\WebSites\TP_Compte_mode_connecté\App_Data\baseCompte.accdb";
try
{
OleDbConnection oConnection = new OleDbConnection(strConnexion);
OleDbCommand oCommand = new OleDbCommand(req, oConnection);
oConnection.Open();
oCommand.ExecuteNonQuery();
oConnection.Close();
}
catch (Exception ex)
{
//Label3.Text += ex.Message;
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strRequete = "delete from Compte where id_compte = "+GridView1.SelectedDataKey.Value;
ExcecuterRequette(strRequete);
Response.Redirect("Default.aspx");
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
Label2.Text = "juste test";
GridView1.EditIndex = GridView1.SelectedIndex;
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
Response.Redirect("Default.aspx");
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string strRequete = "update Compte set titulaire = '" + GridView1.SelectedRow.Cells[2].Text + "', solde = '" + GridView1.SelectedRow.Cells[3].Text + "'where id_compte = " + GridView1.SelectedDataKey.Value;
ExcecuterRequette(strRequete);
Label2.Text = strRequete;
}
} |
Partager