Database name is TEST, user name test, pass test1234
I create fake acocunt, conection to db work
Data are located ond next loaction:
When connected do db OTHER USERS/MASTER/Table1
How to read that data to datarid?
I try this cod and have error: NETWORK LIBRARY: Name-Value syntax error
Error number: ORA-00303
private void TABLE_fill()
{
String connectionString = "Data Source=("
+ " TEST = "
+ " (DESCRIPTION = "
+ " (ADDRESS = (PROTOCOL = TCP)(HOST = test.localdomain.intra)(PORT = 1521)) "
+ " (CONNECT_DATA = "
+ " (SERVICE_NAME = TEST) "
+ " (INSTANCE_NAME = TEST) "
+ " ) "
+ " ) "
+ " User Id=test; password=test1234; ";
OracleConnection con = new OracleConnection();
con.ConnectionString = connectionString;
con.Open();
OracleCommand cmd= new OracleCommand();
cmd.CommandText = "select * from Table1";
cmd.Connection= con;
cmd.CommandType = CommandType.Text;
//cmd.ExecuteNonQuery();
OracleDataReader dr = cmd.ExecuteReader();
dr.Read();
System.Data.DataTable dataTable = new System.Data.DataTable();
dataTable.Load(dr);
ListDataGridView.DataSource = dataTable;
ListDataGridView.Update();
ListDataGridView.Refresh();
}