|
by: RitaG |
last post by:
Hi.
Is it possible to run a Stored Procedure that takes 1 parameter using the
SQLDataAdapter. I'm currently using the SQLCommand with the SQLDataReader to
do this but would like to use a disconnected recordset.
Maybe a way to do this is to use the SQLCommand and then set a DataTable to
the
SQLDataReader. I played around with this approach for awhile but could not
get it to work.
|
by: Alex |
last post by:
Hi all,
I'm sure this is really really easy but I do need some help.
I'm writing a java stored prcedure to manage the assignment of IP
addresses to mac addresses for a network device database I've got.
Basically a user fills in a template detailing information about
themselves, the location of the pc and its mac address. The SP takes
this input info and scans a database table that stores the assigned ip
addresses in a subnet looking...
|
by: Ed Stevens |
last post by:
A tale of woe, and a question . . .
Last week my boss said to me "we've installed DB2 Connect on this
Solaris box. Make it work."
Now, I've barely seen DB2 Connect on Windows, having fumbled thru one
install and config, with a lot of handholding from IBM Support. I'm
comfortable in unix but have never dealt with DB2 Connect there. (my
main job is as an Oracle DBA, and most of my db's are on Solaris or
AIX) I've found the install...
|
by: W Akthar |
last post by:
I am trying to use SqlDataAdapter to execute a Stored
Procedure.
The Stored Procedure is as follows
CREATE Procedure SP_GetAddressesFromContactID
@ID int
AS
SELECT
b.StreetAddress1,
|
by: Matt Jensen |
last post by:
Howdy
Fairly simple question I think, I presume the answer is no it can't be
reused for 2 *SELECT* statements, but just hoping for clarification. Just
asking in the interests of trying to minimise code.
i.e. if the SqlDataAdapter uses a connection to the one database for a
select statement and I want to do a second select statement on exactly the
same database, can I reuse the SqlDataAdapter?
I ask because I want to put both 'select'...
|
|
by: Richard |
last post by:
Hi,
I have in VB ASP.NET design mode, a SQLDataSource and I need to connect it
to a stored procedure in Oracle 9i, but this stored procedure is inside an
Oracle package.
The problem is that in design mode when I'm in the SALDataAdapter wizard,
trying to locate the stored procedure to select it, and generate the
parameters, etc, I can see other tables and stored procs. in the schema, but
the wizard doesn't show me the packages, so I...
|
by: dawson |
last post by:
Hello, from the code below, how do I add/send a parameter to the stored
procedure?
SqlConnection conn = null;
conn = new
SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings.ConnectionString);
conn.Open();
SqlDataAdapter daProjects = new SqlDataAdapter("dbo.getProjectFiles",
conn);
|
by: Ryan |
last post by:
PLEASE HELP!!
I am trying to do what I think should be the simplest thing. In
Visual Studio 2005, I set up a datagrid and then went ot configure a
datasource for it. I made my connection to the database using the
same connection string as I used to view the databse in server
explorer. (In server explorer I see all stored procedures). I then
go through the wizard and choose "Specify a custom SQL Statement or
Stored Procedure." Then...
|
by: suganya |
last post by:
Hi
I have to bind the DropDownList box with ID field hidden using SQLDataAdapter.
For that I have given the coding as
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
|
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: 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: 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: 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: 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...
|