Click here to Skip to main content
   

C#

 
GeneralRe: How to creat a beep sound in 20 miliseconds PinsubeditorWalt Fair, Jr.23-Nov-12 15:48 
AnswerRe: How to creat a beep sound in 20 miliseconds PinmemberBMS12122-Nov-12 23:35 
AnswerRe: How to creat a beep sound in 20 miliseconds PinmvpRichard MacCutchan23-Nov-12 0:49 
QuestionDetermine Hardware ID in Windows XP Pinmembercpt_veerhoek22-Nov-12 20:43 
QuestionNeed football game comments Pinmemberleone22-Nov-12 1:35 
AnswerRe: Need football game comments PinmvpDave Kreskowiak22-Nov-12 5:59 
AnswerRe: Need football game comments PinprotectorPete O'Hanlon22-Nov-12 6:26 
GeneralMessage Removed PinmemberRichard Deeming22-Nov-12 6:51 
GeneralRe: Need football game comments PinprotectorPete O'Hanlon22-Nov-12 10:29 
GeneralRe: Need football game comments PinmemberRichard Deeming23-Nov-12 2:38 
AnswerRe: Need football game comments PinmemberBobJanova23-Nov-12 2:00 
GeneralRe: Need football game comments Pinmemberleone23-Nov-12 10:23 
GeneralRe: Need football game comments PinmemberBobJanova23-Nov-12 15:31 
QuestionEmpty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pinmemberawedaonline22-Nov-12 0: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+ PinmemberSimon_Whale22-Nov-12 6:12 
GeneralRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pinmemberawedaonline22-Nov-12 6:38 
GeneralRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ PinmemberSimon_Whale22-Nov-12 6:49 
GeneralRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ PinmemberRay Yagubyan22-Nov-12 14:30 
GeneralRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pinmemberawedaonline22-Nov-12 22:12 
AnswerRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ Pinmemberjschell23-Nov-12 8:18 
AnswerRe: Empty record returned with this query when querying Oracle database with .NET but gave rows in SQL+ [modified] PinmemberPIEBALDconsult23-Nov-12 10:01 
Questionvs.net 2010 exe on demo machine PinmemberKrishnaRayalu_Talisetti22-Nov-12 0:01 
AnswerRe: vs.net 2010 exe on demo machine PinprotectorPete O'Hanlon22-Nov-12 0:36 
AnswerRe: vs.net 2010 exe on demo machine PinmemberSimon_Whale22-Nov-12 0:38 
GeneralRe: vs.net 2010 exe on demo machine PinmemberKrishnaRayalu_Talisetti22-Nov-12 0:41 
GeneralRe: vs.net 2010 exe on demo machine PinmemberSimon_Whale22-Nov-12 0:46 
QuestionSAP Dotnet Integration Pinmemberrohitnegi0921-Nov-12 22:14 
AnswerRe: SAP Dotnet Integration PinprotectorPete O'Hanlon21-Nov-12 23:39 
AnswerRe: SAP Dotnet Integration PinmemberV.22-Nov-12 0:12 
QuestionWrite XML Dynamically according to tree structure in windows c# Pinmemberrummer21-Nov-12 21:19 
AnswerRe: Write XML Dynamically according to tree structure in windows c# Pinmembermarkovl21-Nov-12 21:37 
AnswerRe: Write XML Dynamically according to tree structure in windows c# PinmemberPIEBALDconsult22-Nov-12 11:23 
QuestionUnit Test for LDAP Search PinmemberSFORavi21-Nov-12 16:10 
QuestionAutomatically Compiler Generated Unique Constants ? PinmemberC-P-User-321-Nov-12 14:01 
AnswerRe: Automatically Compiler Generated Unique Constants ? PinmemberEddy Vluggen21-Nov-12 14:16 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberC-P-User-321-Nov-12 14:34 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberEddy Vluggen21-Nov-12 14:40 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberC-P-User-321-Nov-12 14:52 
SuggestionRe: Automatically Compiler Generated Unique Constants ? PinmemberEddy Vluggen21-Nov-12 14:55 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberC-P-User-321-Nov-12 15:52 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberC-P-User-321-Nov-12 16:03 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberC-P-User-321-Nov-12 16:01 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberPIEBALDconsult21-Nov-12 17:27 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberEddy Vluggen21-Nov-12 22:08 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmvpRichard MacCutchan21-Nov-12 23:01 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberC-P-User-322-Nov-12 15:22 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmvpRichard MacCutchan23-Nov-12 0:24 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberBobJanova23-Nov-12 0:29 
GeneralRe: Automatically Compiler Generated Unique Constants ? PinmemberC-P-User-323-Nov-12 5:43 
QuestionDataGridView doesn't appear on screen [modified] PinmemberRickSharp21-Nov-12 13:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.150129.1 | Last Updated 31 Jan 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid