Click here to Skip to main content
       

C#

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