I have been trying to build a web form using the SQL Data Adapter
Configuration Wizard to create a dataset based on a parameterized stored
procedure. I find that if I select "Use existing stored procedure" on the
"Choose a query type" screen, the following screen allows me to choose only
one parameter, and the parameter must be selected from the output fields of
the procedure. My proc has two parameters and neither one is returned in the
output. If I select "Use SQL Statements", the wizard will not accept
"execute uspApptmtsOnDat e ?, ?" or "uspApptmtsOnDa te @OwnerID, @Dt", nor any
other variation I have tried.
Can this be done? 1 2395
Sheldon,
Populating a dataset using a stored procedure has no difference with
populating a dataset using a textstring.
Therefore in these kin of questions I have forever the same advice. Try your
problem first without the stored procedure. Mostly is it than a piece of
case to set the SQL textstring in your procedure and to change the command
in Execute.
I hope this helps,
Cor This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mike P |
last post by:
Is it possible to return a dataset from a stored procedure, or would you
need to write the SQL in your .cs file to return the dataset?
Any assistance would be really appreciated.
Cheers,
Mike
|
by: Telemaco |
last post by:
Ho la necessità di inserire i risultati di una stored procedure in un
dataset.
Mi spiego meglio ....
Ho costruito una store procedure che incapsula una query di lettura su un
database sqlserver che restituisce di dati in formato xml.
La clausola utilizzata per avere il risultato in xml è: FOR XML
AUTO,XMLDATA, e la stored procedure si chiama SP_Lettura ed accetta tre
parametri interi P1,P2,P3.
....
|
by: Yul |
last post by:
Hi,
We are in the process of designing an ASP.NET app, where a user will
enter some 'Customer ID' to be queried in the database. If the ID is
valid, several stored procedures will be called to populate multiple
webpages containing customer information. There isn't a one-to-one
correlation between the stored procedure and a webpage. In other
words, a webpage may have to refer to 1 or more DataTables to populate
itself. Therefore, a...
|
by: Mike Fellows |
last post by:
when i load my windows form i populate a combobox i use the code below
Dim conn As New System.Data.SqlClient.SqlConnection(strConn)
Dim sql As String = "AllLenders"
Dim da As New System.Data.SqlClient.SqlDataAdapter(sql, conn)
Dim ds As New DataSet()
da.Fill(ds)
ComboBox1.DataSource = ds.Tables(0)
ComboBox1.DisplayMember = "Lender"
da.Dispose()
|
by: Nikolay Petrov |
last post by:
How to fill DataSet from stored procedure?
| |
by: james.peer |
last post by:
I'm fairly new to this so hopefully it is a dumb mistake...
I need to create a simple stored procedure along the lines of:
delimiter //
CREATE DEFINER='root'@'localhost' PROCEDURE Insertuser()
BEGIN
insert into user (firstname,lastname) values (@fn, @ln);
END;
//
|
by: Tom |
last post by:
Looking for some help with stored procedure call issues. Conceptually, I
need to pass a data structure as the sole parameter to the Oracle stored
procedure. Sounds simple enough....but how?
First, looking at this from the stored procedure side, I see a few things
the procedure can do:
1) receive a CLOB/BLOB
2) receive a user defined data type
3) receive multiple params, one for each distinct data element
|
by: John |
last post by:
Hi,
I am developing a windows app using C# 2005. This app uses SQL Server or
Oracle database depending on the what the user is using.
Can I create one typed dataset and use it for SQL Server and Oracle?
Probably not.
How can I structure my data access layer so the app will be switching easily
between those two databases with a locally stored db connection string? How
about the following? Thanks for your suggestions.
|
by: TonFrere |
last post by:
Hello,
I'm building a windows form application in Visual C# using VS 2005. On my form I need to populate a combobox with Invoices# linked to the current reccord's Order# value. This means that:
- The combobox should repopulate if the user changes the value of Order#.
- The combobox should repopulate if the user moves through records (using the binding navigator.
My problem is that whenever I repopulate the combobox, it's value is reset to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
| |