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
|
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class Enregistrer_psy : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void annuler_Click(object sender, EventArgs e)
{
this.nom.Text = "";
this.prenom.Text = "";
this.cin.Text = "";
this.code.Text = "";
}
protected void valider_Click(object sender, EventArgs e)
{
string connChaine = ConfigurationSettings.AppSettings["connectionString"];
OleDbConnection connection = null;
OleDbCommand command = null;
try
{
connection = new OleDbConnection(connChaine);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
command = new OleDbCommand("insert into MATABLE(id, nom, prenom, code, cin ) values() ", connection);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
command.Dispose();
connection.Close();
}
}
} |
Partager