Hello there,
I was wondering if anyone knows if there is an easy way to import
expressions into my typed dataset from the original view/sql statement
For example if I drag a view from the server explorer onto my dataset I
would like it to import not just the caculated field but also the expression
that creates the field.
I think that an ORM mapper would probably do this for me but unfortunatly I
am stuck with datasets :(
Any ideas would be much appreciated, thank you
John Sheppard 4 1103
Hello,
Have you tried to edit the text in the selectcommand for the created
tableadapter, and copy from the definition for the view in sql server and
paste on the selectcommand text ?
Bye,
--
Roger Tranchez
MCTS
..NET 2005 and DB developer
"John Sheppard" wrote:
Hello there,
I was wondering if anyone knows if there is an easy way to import
expressions into my typed dataset from the original view/sql statement
For example if I drag a view from the server explorer onto my dataset I
would like it to import not just the caculated field but also the expression
that creates the field.
I think that an ORM mapper would probably do this for me but unfortunatly I
am stuck with datasets :(
Any ideas would be much appreciated, thank you
John Sheppard
Thanks Roger,
Yes I could do that, I just thought perhaps there might be a better way...
The expression field isnt standard sql or anything either which makes things
kind of difficult :(
I think I was perhaps hoping too much that I could automate it....
"Roger Tranchez" <ru*****@commun ity.nospamwrote in message
news:B8******** *************** ***********@mic rosoft.com...
Hello,
Have you tried to edit the text in the selectcommand for the created
tableadapter, and copy from the definition for the view in sql server and
paste on the selectcommand text ?
Bye,
--
Roger Tranchez
MCTS
.NET 2005 and DB developer
"John Sheppard" wrote:
>Hello there,
I was wondering if anyone knows if there is an easy way to import expressions into my typed dataset from the original view/sql statement
For example if I drag a view from the server explorer onto my dataset I would like it to import not just the caculated field but also the expression that creates the field.
I think that an ORM mapper would probably do this for me but unfortunatly I am stuck with datasets :(
Any ideas would be much appreciated, thank you John Sheppard
In fact, if you have a view in sql server you can import it directly, doing
drag'n drop from server explorer to the design surface for your xsd file. It
seems obvious that if the select statement is not into a view, user function
or stored procedure, it is not possible to directly import it (you are trying
to import a "piece of text", so what could be expected ?!)
Bye,
--
Roger Tranchez
MCTS
..NET 2005 and DB developer
"John Sheppard" wrote:
Thanks Roger,
Yes I could do that, I just thought perhaps there might be a better way...
The expression field isnt standard sql or anything either which makes things
kind of difficult :(
I think I was perhaps hoping too much that I could automate it....
"Roger Tranchez" <ru*****@commun ity.nospamwrote in message
news:B8******** *************** ***********@mic rosoft.com...
Hello,
Have you tried to edit the text in the selectcommand for the created
tableadapter, and copy from the definition for the view in sql server and
paste on the selectcommand text ?
Bye,
--
Roger Tranchez
MCTS
.NET 2005 and DB developer
"John Sheppard" wrote:
Hello there,
I was wondering if anyone knows if there is an easy way to import
expressions into my typed dataset from the original view/sql statement
For example if I drag a view from the server explorer onto my dataset I
would like it to import not just the caculated field but also the
expression
that creates the field.
I think that an ORM mapper would probably do this for me but unfortunatly
I
am stuck with datasets :(
Any ideas would be much appreciated, thank you
John Sheppard
When I tried it it did not import the expression from the view..it just
creates the field like its any other field...I thought perhaps it might try
and import the underlying expression as well...
It's double the work and error prone to make views that calculate then have
to duplicate any expression into the dataset manually...seem s silly...
Thanks roger
John
"Roger Tranchez" <ru*****@commun ity.nospamwrote in message
news:2F******** *************** ***********@mic rosoft.com...
In fact, if you have a view in sql server you can import it directly,
doing
drag'n drop from server explorer to the design surface for your xsd file.
It
seems obvious that if the select statement is not into a view, user
function
or stored procedure, it is not possible to directly import it (you are
trying
to import a "piece of text", so what could be expected ?!)
Bye,
--
Roger Tranchez
MCTS
.NET 2005 and DB developer
"John Sheppard" wrote:
>Thanks Roger,
Yes I could do that, I just thought perhaps there might be a better way...
The expression field isnt standard sql or anything either which makes things kind of difficult :(
I think I was perhaps hoping too much that I could automate it....
"Roger Tranchez" <ru*****@commun ity.nospamwrote in message news:B8******* *************** ************@mi crosoft.com...
Hello,
Have you tried to edit the text in the selectcommand for the created
tableadapter, and copy from the definition for the view in sql server
and
paste on the selectcommand text ?
Bye,
--
Roger Tranchez
MCTS
.NET 2005 and DB developer
"John Sheppard" wrote:
Hello there,
I was wondering if anyone knows if there is an easy way to import expressions into my typed dataset from the original view/sql statement
For example if I drag a view from the server explorer onto my dataset I would like it to import not just the caculated field but also the expression that creates the field.
I think that an ORM mapper would probably do this for me but unfortunatly I am stuck with datasets :(
Any ideas would be much appreciated, thank you John Sheppard
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Garry Dawkins |
last post by:
Hey Frank, I'm a novice with this taking over someone elses application.
I'm attempting to add a dataset to a page. I have the query to populate
the page and I have the walkthrough instructions. Visual Studios does
not want to cooperate. This is what I'm following: To generate a
dataset
From the Data menu, choose Generate DataSet.
Tip If the Generate DataSet command is not enabled, click the page;
the page must have focus for the...
|
by: jtsree |
last post by:
i am using Visual Studio.net professional 2003 (VisualBasic.net).I am
building a very very simple project where i need to connect to Microsoft
access database through OledbDataAdapter in design mode by Dragging the
OledbDataAdapter Control from the Data tab on the ToolBox and then generate
the DataSet.
I am able to connect to MS ACCESS and test connection is succedded.Now when
i try to generate the Dataset by Right Clicking The Data...
|
by: jtsree |
last post by:
I am Using (Windows XP) Visual Studio.net 2003 professional edition working
on VB.net language.
I am bulding a very very simple project in VB.net where i connect to Access
Database by dragging OledbDataAdapter tool from the Data tab of the Toolbox.
When OledbDataAdapter has been added to the Component tray i am able to
generate a connection to Access database and generate Connection object and
also the Test Connection has Succeeded.
Now...
|
by: Ook |
last post by:
I think I'm being bitten by holes in the documentation - documentation that
assumes a certain knowledge of how dotnet works, knowledge that I lack :-)
I downloaded and installed odbc.net. I *finally* figured out how to add the
odbcDataAdaptor and odbcConnection to the toolbox, no thanks to the
documentation. So, now I have component1.cs on webform1.aspx. I have a MySQL
database up and running. I have odbcDataAdapter1 and odbcConnection1...
|
by: S. H. |
last post by:
I am using a small function to return information from an Access
database.
Whether I use xml formatted text or otherwise, the results are
returned to me in a formatted way. I'm new to C#, so I'm not certain
if I'm missing something or this is just the tough breaks with this
language. What I need is either a proper way of extracting the data
need WITHOUT the regular expressions or a work around - some way to
parse the results.
| |
by: ASP.Net programmer |
last post by:
I have a few SQLDataAdapters which select a MAX() value from a few
different tables.
Here is a sample of the SQL statement:
SELECT MAX(startdate) AS startdate
FROM some_table1
WHERE (startdate <= GETDATE())
The problem I have is this: When I select a few of those SQLDataAdapters
to generate a DataSet from them the list of DataAdapters shows:
|
by: pete |
last post by:
Help, I can not find this data wizard in my toolbox under data.
To generate a dataset
1.. From the Data menu, choose Generate DataSet.
Tip If you do not see the Data menu, click in the form; the form must
have focus for the menu to appear.
The Generate Dataset dialog box is displayed.
|
by: sambuela |
last post by:
All data controls and wizards
about dataset, adapter or dataviewer disappear in the IDE.
How can i let them appear again?
It is because i want to generate dataset by these wizard.
Thanks in advance.
ps. After i try to use previous generated adapter, i still can't
generate new dataset for it.
|
by: G .Net |
last post by:
Hi
Can anybody help with a problem with Expressions for DataColumns
Suppose I have a table with three fields A, B and C.
I want an expression in column C so that
C = 2 * A if A is not null
C = 3 * B otherwise
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
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...
| |