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
|
using System;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
using System.Data.OracleClient;
using System.Data;
namespace autretest
{
/// <summary>
/// Description of MainForm.
/// </summary>
public partial class MainForm : Form
{
[STAThread]
public static void Main(string[] args)
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new MainForm());
}
private DataSet ds;
private OracleConnection myConnect;
private OracleDataAdapter da ;
private string strCommand ;
private OracleCommand myCommand;
private OracleDataReader myReader;
private DataTable laTable;
public MainForm()
{
string strConnect = "Data Source=nom_de_la_base; User Id=user; Password=password;";
OracleConnection myConnect = new OracleConnection();
myConnect.ConnectionString = strConnect;
myConnect.Open();
InitializeComponent();
dataGridView1.AutoGenerateColumns = false;
ds = new DataSet();
strCommand = "SELECT * FROM une_table ";
da = new OracleDataAdapter(strCommand, myConnect);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
string[] nomCol = new string[12]{"Code", "Nom", "Prenom", "","","","","","","","",""};
int[] largCol = new int[12]{100, 150, 150,0,0,0,0,0,0,0,0,0};
laTable = new DataTable();
laTable.TableName = "La Table";
DataColumn[] TabCol = new DataColumn[nomCol.Length];
for(int i = 0; i < nomCol.Length; i++)
{
TabCol[i] = new DataColumn(nomCol[i] ,Type.GetType("System.String"));
TabCol[i].ColumnName = nomCol[i].ToString();
laTable.Columns.Add(TabCol[i]);
}
try
{
while(myReader.Read())
{
DataRow entree;
entree = laTable.NewRow();
for(int i = 0; i < myReader.FieldCount; i++)
if(myReader .GetString(i) != null)
entree[i] = myReader.GetString(i);
laTable.Rows.Add(entree);
}
}
catch(Exception se)
{
MessageBox.Show("Erreur au chargement : " + se.Message);
}
}
}
} |
Partager