Forms Data Controls :: How To Use A DetailsView And ListView With A Stored Procedure

Feb 3, 2010

I want to use the ListView and DetailsView to build a new aspx page

I have designed a database and defined three stored procedures for one of my tables. (one procedure each for Select, Insert & Update). The stored procedures use parameters.

My problem is with the "Define Parameters" dialog box of the SqlDataSource- Configure Data Source procedure.
Specifically, I'm not sure how to use the "Parameter Source" drop down box.

The "Parameters" box on the left correctly lists all of the columns in my stored procedure.
However, when I choose "Control" in the drop down box, the next dialog box asks for the ControlID.

But I want to use either the ListView or the DetailsView and I thought that these two controls somehow "read" the data source and sort of configure themselves.

In a nutshell, I can't find any way to "point" to either the ListView or the DetailsView.

I'm left with the impression that by asking for a "ControlID" for each parameter, the system seems to expect that I have already defined the "to be bound" controls before I can use the stored procedure.

So I'm wondering if it is the case that ListView and DetailsView don't work with stored procedures. True or False? Or is there some way of making this happen?

View 4 Replies


Similar Messages:

Data Controls :: Implement Custom Paging Using Stored Procedure In ListView Control?

May 7, 2015

Is it possible Custom Paging in Listview, And also how to add css class for Datapager control?

View 1 Replies

Forms Data Controls :: Working Procedure With Varbinary From Existing Stored Procedure?

Feb 22, 2010

[Code]....

i have a stored procedure with this values and i need just to make a button that will send something to "Equip" column,how to do it? write the values on my webpage and make a button to exec the procedu

View 1 Replies

Forms Data Controls :: Populate Drop Down List Using Stored Stored Procedure

Mar 14, 2010

i want data to drop down list using stored procedure .

However im not able to do that.

View 3 Replies

DataSource Controls :: How To Convert The Oracle Stored Procedure To Sqlserver 2005 Stored Procedure

Apr 2, 2010

This is surareddy. i nead some small clarification in the "Stored Procedure"

how to convert the oracle Stored Procedure to sqlserver2005/2008 Stored Procedure.

right now i am enhancing the project that project already developed the oracle Stored Procedure. now our company is using sqlserver 2005/2008.

how to convert the Oracle Stored Procedure to sqlserver 2005 Stored Procedure

View 4 Replies

DataSource Controls :: Do Not Use Or Call Any Stored Procedure But It Says "Could Not Find Stored Procedure 'xxxxx'?

Dec 9, 2010

Initially, I have tried to use stored procedure. But I changed my mind and preferred to call sql query in codebase with command text. However, it stills tries to find initially-called stored procedure (which is neither called or exists).I think that it is related caching. But I tried it with different browsers it did not work.What might be the reason?

View 4 Replies

DataSource Controls :: Execute A Stored Procedure Within A Stored Procedure?

Jan 18, 2010

Does anybody if it is possible that a stored procedure returns rows which is the result of the execution of another sp? Something like..

[Code]....

View 11 Replies

DataSource Controls :: How To Call A Stored Procedure In Another Stored Procedure

May 13, 2010

i want to return output parameter from 1 storeprocedure. into another stored procedure.

View 7 Replies

Forms Data Controls :: Listview Bind To Detailsview?

Sep 24, 2010

I have a listview that is bound to a table. I want to select a record from the listview and that record display in the detailvew from which I can edit. How do you bind these two controls so the detailview uses the records selected in the listview?

View 1 Replies

Forms Data Controls :: Using MSChart With Stored Procedure?

Jan 5, 2010

Does anyone have an example of using MSChart with a stored procedure? I have a chart control on the web page and have bound it to the stored procedure. I have also set the parameters for the stored procedure. However nothing shows in the chart. All the examples I can find only show adding points one at a time, but this seems to defeat the purpose of binding the chart to the stored procedure.

Some of the problems I am trying to solve:

The stored procedure returns about 6 columns of data. I only need to use two of them. How do I select which of the columns will be displayed in the chart?

I want to use two or more series on the chart. Do I have to run a separate stored procedure for each series or can I make one call to the stored procedure and then display the data in the two series? If so, how?

I am using VS 2008, MS SQL Server 2008, .Net 3.5 and VB .Net.

View 1 Replies

Forms Data Controls :: Stored Procedure And Gridview?

Jul 31, 2010

I have one problem with stored procedure.

My table:
tbl_payments

UserId
PaymentId
PaymentType

Stored procedure:

ALTER PROCEDURE dbo.Select_Customer

@PaymentId varchar(100)
/*
(
@parameter1 int = 5, [code]....

View 10 Replies

Forms Data Controls :: Executing A Stored Procedure Using A SQL Datasource?

May 13, 2010

[Code]....

SelectCommand="Execute ClassesSelect" runat="server">
<SelectParameters>
<asp:ControlParameter Type="Boolean" Name="@all" ControlID="chkAll" PropertyName="Checked" />
</SelectParameters>
</asp:SqlDataSource>

View 1 Replies

Forms Data Controls :: Paging Using Stored Procedure In Gridview?

Jul 12, 2010

i need an example of a paging gridview using stored procedure.

i tried finding on the web and i can't find exactly what i need.

View 7 Replies

Forms Data Controls :: Paging Through Records Using A Stored Procedure?

Sep 7, 2010

i have a stored procedure i want to display the income of this procedure in a HTML table ona aspx page. It that possible.

[code]....

View 4 Replies

Forms Data Controls :: Trying To Populate Gridview From Stored Procedure?

May 12, 2010

[Code]....

[Code]....

View 1 Replies

Forms Data Controls :: Trying To Populate A Datagrid Using A Stored Procedure

Jun 7, 2010

I'm tring to populate a datagrid using a stored procedure that returns about 20 fields (this part I figured out), but the kicker here is that for this one particular page I only want to display about 6 of those 20 returned fields.

I did find on passing the procedure the parameters that are required, and populating the datagrid, but haven't found anything (not that I can tell) that explains how to only view certain fields that have been returned.

I'm using VS 2008 and VB for my coding against a MS SQL 2008 server. All of the stored procedures are working with current windows applications.

View 6 Replies

Forms Data Controls :: Stored Procedure - Parameters Required?

Oct 13, 2010

The update option is using a stored procedure. There are no parameters fro the SP but the error message is saying that parameters are expected. If executed as SQL string then it works OK. I need to use a SP as other updates are required. Code: THIS WORKS

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:appConnectionString%>"
ProviderName = "<%$ ConnectionStrings:appConnectionString.ProviderName %>"
SelectCommand = "SELECT * FROM [qryNewManifestSub] where manifestid = 6855"
InsertCommand = "INSERT INTO [qryNewManifest] ([LocationId], [ManifestDate],
[RouteId], [VehicleType], [ManifestType])
VALUES (@LocationId,
CONVERT(DATETIME,@ManifestDate,103), @RouteId, @VehicleType, @ManifestType)"
UpdateCommand = "INSERT INTO dbo.tbl_DEBUG
(ManifestId, ManifestTripId, LocationId, Manifestdate, RouteId, VehicleType, ManifestType)
VALUES (1,2,3,'01/01/2010',4,5,6)"
UpdateCommandType="Text"
DeleteCommandType="Text">
<InsertParameters>
<asp:Parameter Name="LocationId" Type="Int32" />
<asp:Parameter Name="ManifestDate" Type="DateTime" />
<asp:Parameter Name="RouteId" Type="String" />
<asp:Parameter Name="VehicleType" Type="String" />
<asp:Parameter Name="ManifestType" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource

This does not work Error Message - parameters expected but none given

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:appConnectionString%>"
ProviderName = "<%$ ConnectionStrings:appConnectionString.ProviderName %>"
SelectCommand = "SELECT * FROM [qryNewManifestSub] where manifestid = 6855"
InsertCommand = "INSERT INTO [qryNewManifest] ([LocationId], [ManifestDate],
[RouteId], [VehicleType], [ManifestType])
VALUES (@LocationId,
CONVERT(DATETIME,@ManifestDate,103), @RouteId, @VehicleType, @ManifestType)"
UpdateCommand = "usp_TESTSP"
UpdateCommandType="StoredProcedure"
DeleteCommandType="Text">
<InsertParameters>
<asp:Parameter Name="LocationId" Type="Int32" />
<asp:Parameter Name="ManifestDate" Type="DateTime" />
<asp:Parameter Name="RouteId" Type="String" />
<asp:Parameter Name="VehicleType" Type="String" />
<asp:Parameter Name="ManifestType" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
Stored Proc
usp_TESTSP

This SP has been tested and works OK

USE [TMSWEBALL]
GO
/****** Object: StoredProcedure [dbo].[usp_TESTSP] Script Date: 10/06/2010 14:03:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_TESTSP]
As
BEGIN
SET NOCOUNT ON added to prevent extra result sets from
interfering with SELECT statements.
SET NOCOUNT ON;
*/
INSERT INTO dbo.tbl_DEBUG
(ManifestId, ManifestTripId, LocationId, Manifestdate, RouteId, VehicleType, ManifestType)
VALUES (1,2,3,'01/01/2010',4,5,6)
END
>

View 1 Replies

Forms Data Controls :: Use Datatable - Getting Results Of Stored Procedure

May 22, 2010

Can a datatable be used as shown below when getting the results of a stored procedure. If yes, when would one use a dataset instead?

[Code]....

View 6 Replies

Forms Data Controls :: How To Bind To Label From Stored Procedure

Aug 4, 2010

I have gone through all of the forums and couldn't find an answer to my problem, which is:: I need to bind a result from a stored procedure to a label. What I have done so far is to try to use <%# Bind(SP_Result_FIeld_Name)#> and that does nothing. I also tried to assign the results to a string in the code behind, all that did was put the words "TTLCount" in my label. Part of the problem might be that it is pulling from a temp table and the field I'm pulling has an assigned name ( Count(*) as TTLCount)... The rest of my SP is returning to a gridview which works fine. I just need to display the total number returned and the total number of returned that have email addresses. Here is what I have so far::

[Code]....

View 18 Replies

Forms Data Controls :: Gridview Populate From Stored Procedure?

Oct 15, 2010

I'm pretty new at web programming but a lot of years as a client-server dev.

I'm populating a gridview from a stored procedure, but I don't want to actually execute the populate till I have all the values filled in the page. (some are static textboxes, a calendar (date) value and some drop-downs that are populated earlier) I see there's nothing like gridview1.show() like there is in c# windows form programming. I tried

[Code]....

[Code]....

View 2 Replies

Forms Data Controls :: Populate ListBox From Stored Procedure?

Aug 11, 2010

I have a listbox which I need to populate with the results from a stored procedure. I have a class Ethics and I can call my stored proc there but I don't know how to populate the listBox from this point on. Here's what I have so far:

[Code]....

View 2 Replies

Forms Data Controls :: How To Use A GridView With A Stored Procedure With Changing Columns

Sep 21, 2010

I have a stored procedure that returns a dataset with a different number of columns and different column names depending on user input. How can I use this with a GridView? Normally I define the columns beforehand in a static fashion, but, have never done a dynamic dataset like this.

View 1 Replies

Forms Data Controls :: Styling Columns In GridView From Stored Procedure?

Feb 16, 2010

Im loading some results from a SQL Stored procedure into a Grid View. From my stored procedure I simply get 2 columns returned, Details and Savings, the savings are being returned in the format 30.50123 I want to limit this to 2 decimal places and put a euro sign in front of it like so €30.50, I have managed to do this however its adding a new "savings"column to my Grid view which I obviously don't want. So I now have a savings column with the correct format of €30.50 and my 2 columns from my stored procedure

details and savings. Heres my code....

[Code]...

View 2 Replies

Forms Data Controls :: Call A Stored Procedure And Display In Gridview?

Feb 23, 2011

how to call a stored procedure and to display it in a grid view table..

View 3 Replies

Forms Data Controls :: Calling Stored Procedure Sqldatasource Dropdownlist?

Mar 5, 2010

i try to fill datatextfield and datavaluefield through sqldatasource throuh calling soterd procedure,

but i don't get any value after running the application, here my code

[code]....

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved