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:
May 7, 2015
Is it possible Custom Paging in Listview, And also how to add css class for Datapager control?
View 1 Replies
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
Mar 14, 2010
i want data to drop down list using stored procedure .
However im not able to do that.
View 3 Replies
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
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
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
May 13, 2010
i want to return output parameter from 1 storeprocedure. into another stored procedure.
View 7 Replies
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
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
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
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
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
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
May 12, 2010
[Code]....
[Code]....
View 1 Replies
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
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
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
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
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
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
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
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
Feb 23, 2011
how to call a stored procedure and to display it in a grid view table..
View 3 Replies
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