Click here to Skip to main content
12,453,873 members (74,146 online)
   

C#

 
GeneralRe: How to creat a beep sound in 20 miliseconds Pin
long dao22-Nov-12 22:44
memberlong dao22-Nov-12 22:44 
GeneralRe: How to creat a beep sound in 20 miliseconds Pin
Walt Fair, Jr.23-Nov-12 14:48
subeditorWalt Fair, Jr.23-Nov-12 14:48 
AnswerRe: How to creat a beep sound in 20 miliseconds Pin
BMS12122-Nov-12 22:35
memberBMS12122-Nov-12 22:35 
AnswerRe: How to creat a beep sound in 20 miliseconds Pin
Richard MacCutchan22-Nov-12 23:49
mvpRichard MacCutchan22-Nov-12 23:49 
QuestionDetermine Hardware ID in Windows XP Pin
cpt_veerhoek22-Nov-12 19:43
membercpt_veerhoek22-Nov-12 19:43 
QuestionNeed football game comments Pin
leone22-Nov-12 0:35
memberleone22-Nov-12 0:35 
AnswerRe: Need football game comments Pin
Dave Kreskowiak22-Nov-12 4:59
mvpDave Kreskowiak22-Nov-12 4:59 
AnswerRe: Need football game comments Pin
Pete O'Hanlon22-Nov-12 5:26
protectorPete O'Hanlon22-Nov-12 5:26 
GeneralRe: Need football game comments Pin
Pete O'Hanlon22-Nov-12 9:29
protectorPete O'Hanlon22-Nov-12 9:29 
GeneralRe: Need football game comments Pin
Richard Deeming23-Nov-12 1:38
memberRichard Deeming23-Nov-12 1:38 
AnswerRe: Need football game comments Pin
BobJanova23-Nov-12 1:00
memberBobJanova23-Nov-12 1:00 
GeneralRe: Need football game comments Pin
leone23-Nov-12 9:23
memberleone23-Nov-12 9:23 
GeneralRe: Need football game comments Pin
BobJanova23-Nov-12 14:31
memberBobJanova23-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
memberawedaonline21-Nov-12 23:35 
Hello guys;

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

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
memberSimon_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
memberawedaonline22-Nov-12 5:38 
GeneralRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pin
Simon_Whale22-Nov-12 5:49
memberSimon_Whale22-Nov-12 5:49 
GeneralRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pin
Ray Yagubyan22-Nov-12 13:30
memberRay Yagubyan22-Nov-12 13:30 
GeneralRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pin
awedaonline22-Nov-12 21:12
memberawedaonline22-Nov-12 21:12 
AnswerRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pin
jschell23-Nov-12 7:18
memberjschell23-Nov-12 7:18 
AnswerRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pin
PIEBALDconsult23-Nov-12 9:01
memberPIEBALDconsult23-Nov-12 9:01 
Questionvs.net 2010 exe on demo machine Pin
KrishnaRayalu_Talisetti21-Nov-12 23:01
memberKrishnaRayalu_Talisetti21-Nov-12 23:01 
AnswerRe: vs.net 2010 exe on demo machine Pin
Pete O'Hanlon21-Nov-12 23:36
protectorPete O'Hanlon21-Nov-12 23:36 
AnswerRe: vs.net 2010 exe on demo machine Pin
Simon_Whale21-Nov-12 23:38
memberSimon_Whale21-Nov-12 23:38 
GeneralRe: vs.net 2010 exe on demo machine Pin
KrishnaRayalu_Talisetti21-Nov-12 23:41
memberKrishnaRayalu_Talisetti21-Nov-12 23:41 
GeneralRe: vs.net 2010 exe on demo machine Pin
Simon_Whale21-Nov-12 23:46
memberSimon_Whale21-Nov-12 23:46 
QuestionSAP Dotnet Integration Pin
rohitnegi0921-Nov-12 21:14
memberrohitnegi0921-Nov-12 21:14 
AnswerRe: SAP Dotnet Integration Pin
Pete O'Hanlon21-Nov-12 22:39
protectorPete O'Hanlon21-Nov-12 22:39 
AnswerRe: SAP Dotnet Integration Pin
V.21-Nov-12 23:12
memberV.21-Nov-12 23:12 
QuestionWrite XML Dynamically according to tree structure in windows c# Pin
rummer21-Nov-12 20:19
memberrummer21-Nov-12 20:19 
AnswerRe: Write XML Dynamically according to tree structure in windows c# Pin
markovl21-Nov-12 20:37
membermarkovl21-Nov-12 20:37 
AnswerRe: Write XML Dynamically according to tree structure in windows c# Pin
PIEBALDconsult22-Nov-12 10:23
memberPIEBALDconsult22-Nov-12 10:23 
QuestionUnit Test for LDAP Search Pin
SFORavi21-Nov-12 15:10
memberSFORavi21-Nov-12 15:10 
QuestionAutomatically Compiler Generated Unique Constants ? Pin
C-P-User-321-Nov-12 13:01
memberC-P-User-321-Nov-12 13:01 
AnswerRe: Automatically Compiler Generated Unique Constants ? Pin
Eddy Vluggen21-Nov-12 13:16
memberEddy Vluggen21-Nov-12 13:16 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
C-P-User-321-Nov-12 13:34
memberC-P-User-321-Nov-12 13:34 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
Eddy Vluggen21-Nov-12 13:40
memberEddy Vluggen21-Nov-12 13:40 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
C-P-User-321-Nov-12 13:52
memberC-P-User-321-Nov-12 13:52 
SuggestionRe: Automatically Compiler Generated Unique Constants ? Pin
Eddy Vluggen21-Nov-12 13:55
memberEddy Vluggen21-Nov-12 13:55 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
C-P-User-321-Nov-12 14:52
memberC-P-User-321-Nov-12 14:52 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
C-P-User-321-Nov-12 15:03
memberC-P-User-321-Nov-12 15:03 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
C-P-User-321-Nov-12 15:01
memberC-P-User-321-Nov-12 15:01 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
PIEBALDconsult21-Nov-12 16:27
memberPIEBALDconsult21-Nov-12 16:27 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
Eddy Vluggen21-Nov-12 21:08
memberEddy Vluggen21-Nov-12 21:08 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
Richard MacCutchan21-Nov-12 22:01
mvpRichard MacCutchan21-Nov-12 22:01 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
C-P-User-322-Nov-12 14:22
memberC-P-User-322-Nov-12 14:22 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
Richard MacCutchan22-Nov-12 23:24
mvpRichard MacCutchan22-Nov-12 23:24 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
BobJanova22-Nov-12 23:29
memberBobJanova22-Nov-12 23:29 
GeneralRe: Automatically Compiler Generated Unique Constants ? Pin
C-P-User-323-Nov-12 4:43
memberC-P-User-323-Nov-12 4:43 
QuestionDataGridView doesn't appear on screen Pin
RickSharp21-Nov-12 12:44
memberRickSharp21-Nov-12 12:44 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160826.1 | Last Updated 29 Aug 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid