Click here to Skip to main content
       

C#

 
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 

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.141223.1 | Last Updated 27 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid