DataSource Controls :: Validating Length Of Data In Context With Stored Procedure Parameters?
Apr 19, 2010
I am building a WCF Web Service that has a Business Logic layer (that implements all validation logic and other business rules) and a Data Access Layer that makes calls to Stored Procedures in my database.
I would like to be able to validate the length of data passed against that of the length of the parameters in the Stored Procedures without having to explicitly define the parameter lengths in my WCF Web Service.
Eg:
Person Object
Person.Name = "John Dhoe"
Person.Age = 37
SQL Stored Procedure
SavePerson
FullName Varchar(15)
Age Int
In my BLL or DAL, I would like to be able to do something like :
If(Person.Name.length == SavePerson.Parameters["FullName"].Length)
{
Return true;
}
else
{
Return false;
}
Has anyone tried this out before? Is this even possible?
View 2 Replies
Similar Messages:
Jun 22, 2010
I am trying to write a function that can be called to run a stored procedure. I pass the stored procedure name, followed by as many parameters as I need to run the procedure. I am able to do this by using the params keyword, so my function looks something like this;
[Code]....
How can I determine what the data type of the parameter is? Maybe I need to alter the string[] part, above?
View 5 Replies
Apr 30, 2010
Ive tried a few ways of doing this without success and got together a simplified example so hopefully I can get an answer. When I try to INSERT using a stored procedure InsertTest (normal SQL works OK) I cannot. I need to know how to pass the @Model parameter to the Stored procedure
Have a Stored procedure which can be executed and after entering string for @Model through wizard a new record is created
My asp:SqlDataSource includes InsertCommand="InsertTest" InsertCommandType="StoredProcedure"
Also my <InsertParameters includes the asp:Parameter Name="Model" Type="String"/>
My drop down (and I think this is where the problem is ). Record is Inserted after choosing Model and pressing enter
Do I have to set one of the properties in the drop down to tell the Stored procedure the parameter being passed is the parameter Model ??
[Code]....
View 4 Replies
Nov 11, 2010
I am trying to populate a dropdown from a stored procedure that includes parameters. The parameters are programmatically defined variables. I have been working at this for hours, and scoured the internet for a tutorial. I have come up with the following solution below. However, it does not work. Its not pulling any data, and I am not even sure that the page is making it into the GetLast5Schedules_Selecting Event. There has to be a more efficient/less time consuming way to do this!
[Code]....
[Code]....
[Code]....
View 1 Replies
May 3, 2010
I am trying to allow users to grab their stored procs and call certain ones from within code. I can get the stored procedures and then fill a dropdown with them, but what I cannot find at this point is how to get the parameters that each stored procedure needs. I would like, once an SP is chosen from the dropdown to make a call to the db with that sp name and grab its paramter list so I can report what needs to be sent in to the user.
View 1 Replies
Jun 14, 2010
How do I pass the ID and SelectedDate values in to the stored procedure as parameters??
[Code]....
View 2 Replies
Jun 11, 2010
[Code]....
View 2 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
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
Mar 30, 2011
I have a stored procedure that works fine for classic asp, but how can I get my output parameters data back from in /MVC 2 / linq/ entities framework model . I have inported the function also, but when i try to code it i dont get results ...i know this is a matter of lack of / knowledge or exmple because i have been scouring the web for it and cannnot find into that accually works.
here is the stored proc.
[Code]....
Here was the one of the few tries I did:
[Code]....
but it executes fine does not give me an error, but also does not return the info i need to the viewmodel
I keep seeing stuff about "ref" on the net but "ref" shows " arbument # should not be passed with the ref keyword.
So i am not sure if there is a problem with the model, or with my understanding this, Now for your info I can do the same step with returning a dataset from a stored procedure fine, but I dont want a data set I just want excatly the data in the output parameters from the stored procedure.
View 2 Replies
Sep 19, 2010
I want to have a dropdownlist in the footer row of a gridview. The dropdownlist must be populated with an stored procedure that receives a parameter and has a select. Is that posible?? I think yes but I having problems with the parameters.
[Code]....
The exception says incorrect sintax... but I've changed the procedure for something very simple to solve the problem like select 'hello' or select 1, 'hello' and I'm getting the same problem...
View 3 Replies
Oct 27, 2010
I have a grid view that populates and displays data at btn click event from the following sql statement in one of the SP:
SELECT
reg_code, pc_serial, act_code
FROM user_reg
WHERE reg_code=@reg_code
I want to pass parameters to the other Stored procedure when the edit button is clicked in order to update the 2 columns in the specific row at the time. I now how to pass parameters in a regular btn click event or function, but in the case of edit btn in grid view I don't know how to capture data from specific row and then pass it to the SP. Here is Stored Procedure to update the columns (every user always has the same reg code, but may have more than one serial number and activation code, I want to let the user update serial number and then based on the serial number generate new activation code in the SP.):
[Code]....
View 3 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
Apr 27, 2010
I have a DAL for accessing data from sql server in my asp.net 3.5 application.
[code]....
Here I am passing parameter and connection string. I want to create a common method which i can use for anywhere. I don't want to specify parameter datatype. sometime i have 3 or 4 parameter.
View 6 Replies
May 1, 2010
I want to apply other stored procedure select query on result of first stored procedure.
View 1 Replies
Apr 27, 2010
I am using Visual Studio 2008 and SQL Server 2008 and have added a SQL datasource to my form.
When I configure the datasource, I choose my connection string which looks like this in my webconfig:
<connectionStrings>
<add
name="PSFSPRD_ConnectionString"
connectionString="Data
The database I am using has a schema called EQB and as such, my stored procedures are named as EQB.usp_SelectFunds, EQB.usp_SelectAccount, etc.
On the select tab of the Configure Data Source screen, I choose to use a stored procedure. The dropdown shows my stored procedures, however, the schema name does not show up in front of the stored procedures in the drop down. I see only usp_SelectFunds, usp_SelectAccount, etc.
I select one of the stored procedures and when I click TEST, I get the message that the stored procedure is not found. If I instead choose to use a SQL statement instead on the configuration screen and enter EXEC EQB.usp_SelectFunds and click TEST, it works fine.
Why are my stored procedures not showing up correctly in the stored procedure drop down and how can I fix this?
View 3 Replies
Jan 27, 2010
I am bulding a dvd catalog and have a table called DVD which holds all my details about each dvd except Genre, Director and Actor as I want more than 1 Genre, Director, Actor per DVD so put these in seperate tables to avoid repeating the data and used a joining tabe to join the tables so the tables I have are
DVD, Genre, Director, Actor, DVDGenre, DVDDirector and DVDActor
I have now written a stored procedure to pull the info about 1 DVD out of all the tables to display on the webpage I have now got the info I want out of the tables but as the data is now in 1 table I have repeating data is there a way to stop the data repeating the stored procedure i have written is
[code]....
View 8 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
Apr 11, 2010
I'm looking for a steer on how to go about running stored procs efficiently.
I have a current requirement to populate a control, so I have all the specific data i.e the parameter value I need to pass and the control I want to populate, plus generic data such as SqlConnection etc.
I'd like to be able to call, say, "MyStoredProc". MyStoredProc would contain all the necessary information to run the proc, but then pass onto a method, say, GetSpData, which contained all the generic stuff about running stored procs.
Then when setting up MyStoredProc2 I could do without repeating a lot of the original function
Im I barking up the wrong tree or is there an efficient way of managing this kind of situation.
View 2 Replies
Jun 8, 2010
i have a grid bound to sqldatasource control which gets its data from stored procedure. in page load event i code a dropdownlist where i take the selectedvalue parameter for the parameter query. only when a second dependant dropdownlist is selected (coded in dropdownlist1 selected event)is data returned ?
View 12 Replies
Jan 22, 2010
I'm using below stored procedure to reterive data and i'm displaying it in datalist... Now i want to reterive data from two tables by using this stored procedure...collegedetails is my table name... I want data from coursedetails also.
CREATE PROCEDURE [dbo].[SearchInstitute]
@startRowIndex int,
@Category varchar(500),
@inst_name varchar(500),
@course_name varchar(500),
@city varchar(500),
@pageSize int,
@totalCount int output
AS
BEGIN
SET NOCOUNT ON;
SET @totalCount = 0
SET @startRowIndex = @startRowIndex + 1
BEGIN
SELECT * FROM
( SELECT distinct *, ROW_NUMBER() OVER (ORDER BY ArticleList.clgid DESC) as RowNum
FROM (
Select distinct collegedetails.*
FROM collegedetails
WHERE category like '%' +@Category+ '%' OR inst_name like '%' +@inst_name+ '%' Or city like '%' +@city+ '%'
) as ArticleList
) as ArticleList1
WHERE RowNum BETWEEN @startRowIndex AND (@startRowIndex + @pageSize) - 1
ORDER BY clgId DESC
SELECT distinct @totalCount = Count(clgId) FROM collegedetails WHERE category like '%' +@Category+ '%' OR inst_name like '%' +@inst_name+ '%' Or city like '%' +@city+ '%'
END
END
View 4 Replies
Jan 20, 2010
I'm using asp.net 3.5 inc#.
How can I read the data from a stored procedure in Sql Server into a datatable using a datareader.
View 4 Replies
Mar 22, 2010
More specifically, i'm trying to create a stored procedure that displays data from a table if the date column in the table matches a specific day of the week. (IE. Monday, Tuesday, ect...)
The date in my table is stored as MM/DD/YYYY.
View 5 Replies