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 97 98 99 100 101 102 103
|
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
using System.Text;
using System.Collections.Generic;
using System.IO;
namespace WebApplication1
{
public partial class test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string cs1 = "DATA SOURCE=bdpbc;PERSIST SECURITY INFO=True;USER ID=bdpbcadmin;PASSWORD=bdpbcadmin123";
DataSet ENG = new DataSet();
ENG = Prepar_ENG1(cs1, "select * from testt");
GridView1.DataSource = ENG.Tables[0];
GridView1.DataBind();
}
DataSet Prepar_ENG1(string cs, string requete)
{
// REQUETE DEFINIE
DataSet ttest = new DataSet("testt");
try
{
OracleConnection connexion = new OracleConnection(cs);
connexion.Open();
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand sqlCommand = new OracleCommand(requete, connexion);
da.SelectCommand = sqlCommand;
OracleCommandBuilder builder = new OracleCommandBuilder(da);
da.Fill(ttest, "testt_image");
DataTable table = new DataTable();
table = ttest.Tables[0];
table.Columns["num"].Unique = true;
//da.InsertCommand = new OracleCommand("insert into testt (nom , prenom) values (@nom, @prenom) ", connexion);
//da.InsertCommand.Parameters.Add("@nom", OracleDbType.Varchar2, 20, "nom");
//da.InsertCommand.Parameters.Add("@prenom", OracleDbType.Varchar2, 20, "prenom");
DataRow ligne;
ligne = ttest.Tables[0].NewRow();
ligne["num"] = 4;
ligne["nom"] = "mohamed";
ligne["prenom"] = "boubaker";
ttest.Tables[0].Rows.Add(ligne);
da.UpdateCommand = builder.GetUpdateCommand();
da.Update(ttest, "testt");
ttest.AcceptChanges();
da.Dispose();
sqlCommand.Dispose();
connexion.Close();
}
catch (Exception ex)
{
Console.WriteLine("Erreur d'accès à la base de données (" + ex.Message + ")");
}
return ttest;
}
}
} |
Partager