I have created a master/detail asp.net page using detailview control and
gridview control, out of which detailview is editable.
I have created a dataset using Oracle Connection and I want to display
Product Name Column besides its Product ID Column.
If I use a sub query as recommended by Microsoft in of Oracle in dataset, it
gives error.
Select productID,price ,amount
(Select productName from Products
where productID=A.Pro ductID) ProductName
from Invoice A
However, if I run the same query using Sql Server, its acceptable by
Dataset, any idea please ?
Please note, I want this query so that I can generate Insert,Update
Statements to update the records, thats why I am not using the Joins.
Best Regards,
Luqman 5 1827
Select productID,price ,amount
(Select productName from Products
where productID=A.Pro ductID) ProductName
from Invoice A
try this
Select productID,price ,amount , (Select productName from Products
where productID=A.Pro ductID) as ProductName
from Invoice A
Lenny
Your query gives following error, if I use Oracle.
Generated SELECT statement.
Error in SELECT clause: expression near 'SELECT',
Error in SELECT clause: expression near 'FROM',
Missing FROM clause.
Unable to parse query text.
However if I copy and paste the same query in Oracle Sql Plus, it runs
fantastic, I don't understand why Dataset not accepting it.
Even after typing the query in Dataset, it successfully runs in Query
Builder when I click on Execute Query Button.
Any idea please ?
Best Regards,
Luqman
"Lenny" <no****@la.dico wrote in message
news:uz******** ******@TK2MSFTN GP02.phx.gbl...
Select productID,price ,amount
(Select productName from Products
where productID=A.Pro ductID) ProductName
from Invoice A
try this
Select productID,price ,amount , (Select productName from Products
where productID=A.Pro ductID) as ProductName
from Invoice A
Lenny
However if I copy and paste the same query in Oracle Sql Plus, it runs
fantastic, I don't understand why Dataset not accepting it.
Even after typing the query in Dataset, it successfully runs in Query
Builder when I click on Execute Query Button.
are you pasting the code into the gridview wizard ?
I had the same problem.
if it's this issue, paste a simple query in the wizard and then go into the
source code to edit it with your query.
Lenny
Hi Lenny,
I am not using the gridview wizard, I dragged the table from Server Explorer
into Dataset Designer, right click on TableAdapter fill,getdata method,
click on configure and create the query.
I think oracle.net Provider is not supporting this type of query.
Best Regards,
Luqman
"Lenny" <no****@la.dico wrote in message
news:9D******** *************** ***********@mic rosoft.com...
>
>However if I copy and paste the same query in Oracle Sql Plus, it runs fantastic, I don't understand why Dataset not accepting it. Even after typing the query in Dataset, it successfully runs in Query Builder when I click on Execute Query Button.
are you pasting the code into the gridview wizard ?
I had the same problem.
if it's this issue, paste a simple query in the wizard and then go into
the source code to edit it with your query.
Lenny
I am not using the gridview wizard, I dragged the table from Server
Explorer
into Dataset Designer, right click on TableAdapter fill,getdata method,
click on configure and create the query.
I think oracle.net Provider is not supporting this type of query.
I do not use dataset and objectdatasourc e. I had some difficultes too with
oracle.
try to use sqldatasource instead of datset.
edit the selectcommand in sqldatasource with the complex sql.
Lenny This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: jonathan |
last post by:
hey all,
I realize that this question might pop up from time to time, but I
haven't seen it a while and things might of changed, so -
Right now (July 2004) how does mysql stand up in comparison to oracle?
We are seriously considering migrating our multi-processor oracle
system to mysql to save on licensing costs, and would need several
features that mysql may or may not have:
|
by: ruca |
last post by:
Hi,
I have a master and a detail datagrid. I put detail grid showing insise of a
column of master grid. The problem is that it's not what I really want.
What I really want would be that the detail grid appears between rows of
master grid, i.e., when I select one record in master grid that detail grid
appears between the selected row and next row.
I know that the reason why my detail grid is show in one master column it's
because I...
|
by: Brian H |
last post by:
I am looking for working examples of making use or 2 datagrids and one dataset
Grid 1 master Display minimul info
Grid 2 slave. Disply detail info
When the user clicks a row on the master I then load Grid 2 with detail information.
Thanks for any help
B
|
by: Ken C |
last post by:
I've setup a Master detail table from a typed dataset on 2 different data grid
The first one I bind it with the Master data table name
The second data set I bind it with the MasterDetail Relation name so that I can obtain a "Detail Auto change" effect when current master record is moving around, which is suggested on syncfusion FA
http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp#q780
But the problem is when I try to update a new...
|
by: Coen |
last post by:
Hello,
I have a strange performance delay of about 2 sec's in moving to the next
row. I use multiple forms with each master-detail table relations. The
master-table displays it's table rows in databound textboxes, the detail
tables in datagrids, and of course relations defined between the master and
detail tables. All the tables are part of one dataset (per form). The
following happens.
When moving to the next tablerow (next record) I...
| |
by: fstenoughsnoopy |
last post by:
Ok the complete story. I have a Contact Table, Query and Form, that
are used to input
and store the contact info for customers. They have FirstName, LastName
and Address as the primary key fields to keep out duplicates. I am
trying to put a full name box on the query, that uses the FirstName,
LastName and Middle Initial and puts them together to form a full name.
That I have so far. On my order database(consisting of a master table
with...
|
by: Sam |
last post by:
Sorry to post the same post multiple times but the URL Addresses were
not Correct in Earlier Posts.
Here are the correct URL's:
1) Run It URL is here:
http://www.asp.net/QuickStart/aspnet/samples/data/GridViewMasterDetailsInsertPage_vb.aspx
|
by: gene kelley |
last post by:
I had a VB6 app that used a third party ListView control to simply display various recordsets. The
control had a VirtualMode which I used for this display.
Now in VB2005, I want to do the same with the native ListView to display various datasets in
VirtualMode. I have a ListView with the VirtualListSize set and the appropriate columns in place
which is all similar to the old VB6 app. However, the similarities end there as I can't find...
|
by: John |
last post by:
Hi
I am trying to create a master/detail form. I have my master and details
tables dragged onto the dataset. I have also dragged the fields from master
table on the form which has created the navigation toolbar for me and which
works fine with the master table. I also have a dataview on the same form
ready for detail table but as yet not assigned to the detail table. How can
I now create a master/detail relationship between my master and...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |