create and populate table in Oracle through C#

[egil84]

'm trying to create table through this method. It connects to my database, it givs me a message that it was created but when I want to insert data through my form into the table, it says that the row/column/table doesn't exist. What am I doing wrong? Any help would be greatly appreciated. Thanks in advance.

//set up connection string
string connectionString = 
"Provider = OraOLEDB.Oracle;DataSource = csbank;User ID = system;Password = manager";
				
//create connection object and pass info  to it
OleDbConnection myOleDbConnection = 
new OleDbConnection(connectionString);

//string with the creation of table
string query = //got this down

//set up commands object and send the query 
OleDbCommand myOleDbCommand = new OleDbCommand(query,myOleDbConnection);

//create object so we can read the data (data reader)
OleDbDataReader datareader = null;

//open DB
myOleDbConnection.Open();

//execute the reader
datareader = myOleDbCommand.ExecuteReader();

//close reader
datareader.Close();
//close connection
myOleDbConnection.Close();	
myOleDbConnection.Dispose();

 

[obislavu]

I didn' t see in your code :
myOleDbCommand.ExecuteNoQuery();
-obislavu-

 

[egil84]

I can't think of another way of doing this. I just want to connect to my Database and create a table. In the end of my code I have a message box telling me that my table was created, that's how I know it went through all my code. I have this is a try-catch and it doesn't give me any error. But when I go to my DataBase and try to view the table it says that the table was not created. How can it be possible? What's wrong here? Please help me!!!

//set up connection string
string connectionString = "Provider = OraOLEDB.Oracle;DataSource = csbank;User ID = system;Password = manager";
				
//create object and pass info  to it
OleDbConnection myOleDbConnection = 
new OleDbConnection(connectionString);

//string with the creation of table
string query = "//got the creation";

//set up commands and send the query 
OleDbCommand myOleDbCommand = 
new OleDbCommand(query,myOleDbConnection);

//open DB
myOleDbConnection.Open();
//set command to command coded in string query
myOleDbCommand.CommandText = query;

//close connection
myOleDbConnection.Close();	
myOleDbConnection.Dispose();

MessageBox.Show("Table created","Data Store Hotel");

 

[obislavu]

Modify your code as I said before or something like that:

OleDbConnection myOleDbConnection = null;
OleDbCommand myOleDbCommand = null;
//set up connection string
string connectionString = "Provider = OraOLEDB.Oracle;DataSource = csbank;User ID = system;Password = manager";

try
{
//create object and pass info to it
myOleDbConnection = new OleDbConnection(connectionString);
myOleDbConnection.Open();

//string with the creation of table
string query = "//got the creation";

//set up commands and send the query
myOleDbCommand =new OleDbCommand();
myOleDbCommand.Connection = myOleDbConnection ;

//set command to command coded in string query
myOleDbCommand.CommandText = query;
myOleDbCommand.ExecuteNonQuery();

}
catch (Exception e)
{
MessageBox.Show(e.GetType() +e.Message();
}
finally
{
//close connection
if (myOleDbConnection!=null)
{
myOleDbConnection.Close();
myOleDbConnection.Dispose();
}
if (myOleDbCommand!=null)
myOleDbCommand.Dispose();

}

-obislavu-