Click here to Skip to main content
15,894,405 members
Home / Discussions / C#
   

C#

 
AnswerRe: alpha numeric char Pin
BobJanova22-Nov-12 23:27
BobJanova22-Nov-12 23:27 
AnswerRe: alpha numeric char Pin
V.23-Nov-12 0:06
professionalV.23-Nov-12 0:06 
GeneralRe: alpha numeric char Pin
Richard MacCutchan23-Nov-12 1:46
mveRichard MacCutchan23-Nov-12 1:46 
GeneralRe: alpha numeric char Pin
DaveAuld23-Nov-12 3:02
professionalDaveAuld23-Nov-12 3:02 
GeneralRe: alpha numeric char Pin
V.23-Nov-12 3:23
professionalV.23-Nov-12 3:23 
GeneralRe: alpha numeric char Pin
Richard MacCutchan23-Nov-12 5:22
mveRichard MacCutchan23-Nov-12 5:22 
QuestionHow to creat a beep sound in 20 miliseconds Pin
long dao22-Nov-12 21:22
long dao22-Nov-12 21:22 
AnswerRe: How to creat a beep sound in 20 miliseconds Pin
Sivaraman Dhamodharan22-Nov-12 22:27
Sivaraman Dhamodharan22-Nov-12 22:27 
GeneralRe: How to creat a beep sound in 20 miliseconds Pin
long dao22-Nov-12 22:44
long dao22-Nov-12 22:44 
GeneralRe: How to creat a beep sound in 20 miliseconds Pin
Dr.Walt Fair, PE23-Nov-12 14:48
professionalDr.Walt Fair, PE23-Nov-12 14:48 
AnswerRe: How to creat a beep sound in 20 miliseconds Pin
Braj_1222-Nov-12 22:35
Braj_1222-Nov-12 22:35 
AnswerRe: How to creat a beep sound in 20 miliseconds Pin
Richard MacCutchan22-Nov-12 23:49
mveRichard MacCutchan22-Nov-12 23:49 
QuestionDetermine Hardware ID in Windows XP Pin
cpt_veerhoek22-Nov-12 19:43
cpt_veerhoek22-Nov-12 19:43 
QuestionNeed football game comments Pin
leone22-Nov-12 0:35
leone22-Nov-12 0:35 
AnswerRe: Need football game comments Pin
Dave Kreskowiak22-Nov-12 4:59
mveDave Kreskowiak22-Nov-12 4:59 
AnswerRe: Need football game comments Pin
Pete O'Hanlon22-Nov-12 5:26
mvePete O'Hanlon22-Nov-12 5:26 
GeneralMessage Closed Pin
22-Nov-12 5:51
mveRichard Deeming22-Nov-12 5:51 
GeneralRe: Need football game comments Pin
Pete O'Hanlon22-Nov-12 9:29
mvePete O'Hanlon22-Nov-12 9:29 
GeneralRe: Need football game comments Pin
Richard Deeming23-Nov-12 1:38
mveRichard Deeming23-Nov-12 1:38 
AnswerRe: Need football game comments Pin
BobJanova23-Nov-12 1:00
BobJanova23-Nov-12 1:00 
GeneralRe: Need football game comments Pin
leone23-Nov-12 9:23
leone23-Nov-12 9:23 
GeneralRe: Need football game comments Pin
BobJanova23-Nov-12 14:31
BobJanova23-Nov-12 14:31 
QuestionEmpty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pin
awedaonline21-Nov-12 23:35
awedaonline21-Nov-12 23:35 
Hello guys;

The code below returns an empty records but gave records from SQL+.

C#
DbProviderFactory factory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
DbConnection connection = factory.CreateConnection();

connection.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Simplex-IT-02)(PORT=1521)))
                     (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Simplex))); User Id=User_Test;Password=password;";

DataTable table = new DataTable();

DbCommand command = connection.CreateCommand();
command.Connection = connection;
command.CommandText = "SELECT text FROM user_views WHERE (view_name='ACCOUNT_BALANCES_BY_PERIOD');";

DbDataReader dataReader = command.ExecuteReader();

table.Load(dataReader);
dataReader.Close();


Meanwhile, when I replaced the command.CommandText with "SELECT DISTINCT view_name FROM user_views" it gave me list of all available views for the given schema.

Why can't I get the sql text of a given view?


Thank you in anticipation.
AnswerRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pin
Simon_Whale22-Nov-12 5:12
Simon_Whale22-Nov-12 5:12 
GeneralRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pin
awedaonline22-Nov-12 5:38
awedaonline22-Nov-12 5:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.