private void button1_Click(object sender, EventArgs e)
{
// Instantiate_all_tables();
try
{
using (conn = new OracleConnection(CONNECTION_STRING))
{
//deschiderea conexiunii
conn.Open();
//Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.DropClientTable(), conn);
//Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.CreateClientTable(), conn);
string sqlCommand1 = Comenzi_SQL.CreateClientiTable();
string sqlCommand = "SELECT * from client";
using (OracleDataAdapter oda = new OracleDataAdapter(sqlCommand, conn))
{
// Utilizare DataAdapter pentru a seta datele intr-un DataTable
DataTable dt = new DataTable();
oda.Fill(dt);
// setare dataSource pentru controld grid
dataGridView1.DataSource = dt;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Dispose();
}
}
private void Instantiate_all_tables()
{
try
{
using (conn = new OracleConnection(CONNECTION_STRING))
{
//deschiderea conexiunii
conn.Open();
Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.CreateCategorieTable(), conn);
MessageBox.Show("CreateCategorieTable a fost creata");
Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.CreateClientiTable(), conn);
MessageBox.Show("CreateClientiTable a fost creata");
Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.CreateClientTable(), conn);
MessageBox.Show("CreateClientTable a fost creata");
Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.CreateComenziTable(), conn);
MessageBox.Show("CreateComenziTable a fost creata");
Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.CreateDetalii_ComandaTable(), conn);
MessageBox.Show("CreateDetalii_ComandaTable a fost creata");
Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.CreateLista_ProduseTable(), conn);
MessageBox.Show("CreateLista_ProduseTable a fost creata");
Comenzi_SQL.ExecuteOracleCommand(Comenzi_SQL.CreateProdusTable(), conn);
MessageBox.Show("CreateProdusTable a fost creata");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Dispose();
}
}