I have a stored procedure on Sql Server2k. I can fill a data table which I
can append to a dataset using an ADODB recordset object which gets populated
from a command object that runs the sp. I was hoping to use a DataAdapter.
But I think the data adapter only uses select statements. I could write the
sp in my vb.net app, but the sp references UDF's I wrote in the Sql Sever. I
will guess that I will need to stick with the ADODB recordset object for
this. But I am open to any better suggestions on how to fill the
datatable/dataset with the data from the stored procedure.
Thanks,
Rich 10 13305
OK. Now I remember my dilema. ADO.Net doesn't use recordset objects. So
how can I fill my data table/dataset from a stored procedure?
"Rich" wrote: I have a stored procedure on Sql Server2k. I can fill a data table which I can append to a dataset using an ADODB recordset object which gets populated from a command object that runs the sp. I was hoping to use a DataAdapter. But I think the data adapter only uses select statements. I could write the sp in my vb.net app, but the sp references UDF's I wrote in the Sql Sever. I will guess that I will need to stick with the ADODB recordset object for this. But I am open to any better suggestions on how to fill the datatable/dataset with the data from the stored procedure.
Thanks, Rich
Of course, the SqlDataReader. It's all coming back to me. Just haven't done
this for a while. Actually, I want to populate a datagrid with this. So I
am thinkin I will populate the datatable from the Reader object and set the
datagrid datasource to the datatable. Am I on track here? can a reader be
used as a datasource?
"Rich" wrote: OK. Now I remember my dilema. ADO.Net doesn't use recordset objects. So how can I fill my data table/dataset from a stored procedure?
"Rich" wrote:
I have a stored procedure on Sql Server2k. I can fill a data table which I can append to a dataset using an ADODB recordset object which gets populated from a command object that runs the sp. I was hoping to use a DataAdapter. But I think the data adapter only uses select statements. I could write the sp in my vb.net app, but the sp references UDF's I wrote in the Sql Sever. I will guess that I will need to stick with the ADODB recordset object for this. But I am open to any better suggestions on how to fill the datatable/dataset with the data from the stored procedure.
Thanks, Rich
> how can I fill my data table/dataset from a stored procedure?
Hi,
I am not an expert, but set the CommandType
to StoredProcedure .
CommandText to your StoredProc name.
I was hoping to use a DataAdapter. But I think the data adapter only uses select statements
DataAdapter has Select, Insert and Delete statements.
Then, DataAdapter.Fil l(DataTable)
Of course, Connection must be open.
Hope that helps,
Roger
The following code will connect to an SQL Server 2000 database, retrieve
records from a table, fill a dataset, and bind the dataset to a datagrid
object.
dim conn as SqlConnection = new SqlConnection(" Data
Source=(local); Integrated Security=SSPI; Initial Catalog=northwi nd")
dim da as SqlDataAdapter = new SqlDataAdapter( "SELECT CustomerID,
ContactName FROM Customers", thisConnection)
dim ds as dataset = new DataSet
da.Fill(ds, "Customers" )
datagrid1.datas ource = ds
datagrid1.datab ind
It isn't necessary to call the databind method if you're creating a Windows
Forms application, but is required for ASP.NET.
"Rich" <Ri**@discussio ns.microsoft.co m> wrote in message
news:20******** *************** ***********@mic rosoft.com... I have a stored procedure on Sql Server2k. I can fill a data table which I can append to a dataset using an ADODB recordset object which gets populated from a command object that runs the sp. I was hoping to use a DataAdapter. But I think the data adapter only uses select statements. I could write the sp in my vb.net app, but the sp references UDF's I wrote in the Sql Sever. I will guess that I will need to stick with the ADODB recordset object for this. But I am open to any better suggestions on how to fill the datatable/dataset with the data from the stored procedure.
Thanks, Rich
Oops.. when converting this code from C# to VB.NET, I missed changing
"thisconnection " to "conn". Change that and the code should work.
"Steve" <sp*********@ya hoo.com> wrote in message
news:O7******** ******@TK2MSFTN GP15.phx.gbl... The following code will connect to an SQL Server 2000 database, retrieve records from a table, fill a dataset, and bind the dataset to a datagrid object.
dim conn as SqlConnection = new SqlConnection(" Data Source=(local); Integrated Security=SSPI; Initial Catalog=northwi nd")
dim da as SqlDataAdapter = new SqlDataAdapter( "SELECT CustomerID, ContactName FROM Customers", thisConnection)
dim ds as dataset = new DataSet
da.Fill(ds, "Customers" ) datagrid1.datas ource = ds datagrid1.datab ind
It isn't necessary to call the databind method if you're creating a Windows Forms application, but is required for ASP.NET.
"Rich" <Ri**@discussio ns.microsoft.co m> wrote in message news:20******** *************** ***********@mic rosoft.com...I have a stored procedure on Sql Server2k. I can fill a data table which I can append to a dataset using an ADODB recordset object which gets populated from a command object that runs the sp. I was hoping to use a DataAdapter. But I think the data adapter only uses select statements. I could write the sp in my vb.net app, but the sp references UDF's I wrote in the Sql Sever. I will guess that I will need to stick with the ADODB recordset object for this. But I am open to any better suggestions on how to fill the datatable/dataset with the data from the stored procedure.
Thanks, Rich
Rich,
When you combine the answers from Roger and Steve, than you have your
answer,
I hope this helps,
Cor
Actually, I ended up using a datareader to load the data from the stored
procedure and then loaded a datatable in a dataset from the datareader and
binded that to the datagrid. My question is if it is possible to use a
dataAdapter with a stored procedure? I don't think it is, is it?
"Cor Ligthert" wrote: Rich,
When you combine the answers from Roger and Steve, than you have your answer,
I hope this helps,
Cor
Rich,
Here is an example. Note that this particular stored procedure requires a
parameter. Also note that this code uses OleDb objects, but you can easily
change it to use SQLClient:
Public Function GetRentedTapesB yCustomerID(ByV al CustomerID As Integer)
As DataTable
Dim cn As OleDb.OleDbConn ection = Settings.GetCon nection()
Dim cmd As New OleDb.OleDbComm and
Dim da As New OleDb.OleDbData Adapter
Dim dt As New DataTable
cmd.CommandType = CommandType.Sto redProcedure
cmd.CommandText = "RentedTapesByC ustomerID"
cmd.Parameters. Add("@CustomerI D", CustomerID)
cn.Open()
cmd.Connection = cn
da.SelectComman d = cmd
da.Fill(dt)
cn.Close()
Return dt
End Function
Kerry Moorman
"Rich" wrote: Actually, I ended up using a datareader to load the data from the stored procedure and then loaded a datatable in a dataset from the datareader and binded that to the datagrid. My question is if it is possible to use a dataAdapter with a stored procedure? I don't think it is, is it?
"Cor Ligthert" wrote:
Rich,
When you combine the answers from Roger and Steve, than you have your answer,
I hope this helps,
Cor
why recode for what is already coded? use a data adapter it will do all the
reader work and such for you... using a reader to do it alone is dangerous
because you can only have one open at once and have to make sure you close
it when done, etc...
"Rich" <Ri**@discussio ns.microsoft.co m> wrote in message
news:72******** *************** ***********@mic rosoft.com... Actually, I ended up using a datareader to load the data from the stored procedure and then loaded a datatable in a dataset from the datareader and binded that to the datagrid. My question is if it is possible to use a dataAdapter with a stored procedure? I don't think it is, is it?
"Cor Ligthert" wrote:
Rich,
When you combine the answers from Roger and Steve, than you have your answer,
I hope this helps,
Cor This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mervin Williams |
last post by:
I have several tables involved in my application, but the two in question
here are the company and address tables. The company table has
business_address_id and mailing_address_id columns, which are both foreign
keys to the address table.
So, the stored procedure to which my SelectCommand points to reads as:
ALTER PROCEDURE dbo.CompanyInfoByCompanyID
(
@companyid int
|
by: JIM.H. |
last post by:
Hello,
Can I send a dataset as a parameter into stored procedure and import data to
a table in the stored procedure?
Thanks,
Jim.
|
by: Nikolay Petrov |
last post by:
How to fill DataSet from stored procedure?
|
by: Nikolay Petrov |
last post by:
How to fill dataset with multiple tables and set their relaition?
Can I get the relations from the SQL server?
Also I would like to do it using stored procedures.
TIA
|
by: moondaddy |
last post by:
I have a website where cataloge pages are populated by calling a stored
procedure on sql server. I use the sql data adapter's fill method to call
this stored procedure and fill the dataset. about 6 to 15 times a day the
server hangs and times out when this fill method is called. The SP is
simple and uses very little resources (as tested using client statistics in
query analyzer). Here's data from my error log which includes the...
| |
by: SomebodyElse |
last post by:
Hi.
Apologies if this has been asked here before - I've searched & searched
but can't find anything. It's probably my serach parameters, but I'm
having trouble even describing it to a search engine!
I'm sure this is a very simple problem, with straighforward solution. It
certainly is in classic asp/ado, but I'm finally learning this .NET
business. I like it, but can't get my head around some concepts. Anyway....
|
by: john wright |
last post by:
I have a stored procedure that returns a dataset. I want this dataset to
fill a tree view.
Here is the Stored Procedure Query
SELECT Product.Product_#, Product.Part_Number, Status.Status,
Traveler_Step.Step, Station.Station_Name
FROM Product INNER JOIN
Traveler_Step ON Product.Traveler_Step_# =
Traveler_Step.Traveler_Step_# INNER JOIN
|
by: Laura K |
last post by:
This is probably a simple question but I want to make sure I am doing
it right.
I have a spoc with two select statements which results in two tables.
Very Basic
---------------------------------------------------------------------------------
@strProductCode nvarchar (50)
|
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: 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: 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: 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: 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.
| |