I have a stored procedure that uses an encrypted querstring. If a user "messes" with the querystring value, the stored procedure failes because it isn't the right type. How can I catch that the stored procedure failed, and display a friendly message instead of the .net error?
I know how to handle if ExecuteReader returns no rows, but not how to handle it if it failes to even execute.
Can I still use Session_OnEnd to trap a session timeout? Is there a better way to trap a session timeout? I want to take the user to a page that tells them the session timed out, and give them an opportunity to re-enter the application in a new session if they wish. How can I accomplish this? Is there still a global.asax file in the .NET 4.0 world?
View 1 RepliesI am using this stored procedure with pivot.If i dont have data i am getting null with this stored procedure.Can u tell me how to handle null.below query is pivot.
[Code]....
i am trying to write a stored procedure which constructs an email containing a table. typically, when creating a string of HMTL code, i might have something like:
@strEmail = @strEmail + chkNum + '<br>'
but how do you handle it if the html needs single quotes?
for example:
@strEmail = @ strEmail + chkNum + '<td bgcolor='#000'>'
In sqlserver2005 how to handle exceptions in stored procedures and
1)redirect to other page
2)write in to log file
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
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 RepliesI could probably figure this out if I tried to, but I have been working so long on code, I'm a little fried
I have a stored procedure, and I want to execute another stored procedure during a time period of lets say 1/1/2011 to 12/31/2011
How Would I accomplish this?
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]....
i want to return output parameter from 1 storeprocedure. into another stored procedure.
View 7 Replieshow can I create stored procedure and write my select statement in it, I know how to create dataset then put type stored procedure and assign it to the sp ... what I want is writing my sp... how can I make it ?
check the following code, this is what I want to write put I don't know where or how !
CREATE STORED PROCEDURE SP_CATEGORY
@CATEGORY VARCHAR(30)
AS
BEGIN
SELECT LATIN_NAME, ENGLISH_NAME, ARABIC_NAME, CATEGORY
FROM FLORA, CATEGORY_LIST
WHERE FLORA.CATEGORY=CATEGORY_LIST.CATEGORY_NAME AND CATEGORY_LIST.CATEGORY_NAME IN (SELECT * FROM SPLITLIST(@CATEGORY, ','))
END
where can I write this code ?!
[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
I am trying to create the following stored procedure in sql server Lat and Lng are the parameters being passed from c# code behind .But I am not able to create this stored procedureit indicates with error saying undefined column name Lat,Lng
CREATE FUNCTION spherical_distance(@a float, @b float, @c float)
RETURNS float
AS
BEGIN
RETURN ( 6371 * ACOS( COS( (@a/@b) ) * COS( (Lat/@b) ) * COS( ( Lng/@b ) - (@c/@b) ) + SIN( @a/@b ) * SIN( Lat/@b ) ) )
END
sqlda.SelectCommand.CommandText = "select *, spherical_distance( Lat, 57.2958, Lng) as distance
from business
[code]...
I want to apply other stored procedure select query on result of first stored procedure.
View 1 RepliesI have created stored procedure and student database and also asp.net application for asp.net page but it could not found stored procedure what is the mistake actually I don't no
View 7 Repliesi want data to drop down list using stored procedure .
However im not able to do that.
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?
We have a page where you can insert a record. On the page we have validation to prevent duplicate IP addresses from being submitted for the same location. Now on the procedure side i have a condition that is checked, if you supply data that already exists for a location, then it will be updated. If its not then its inserted.. this all works fine.. issue now that i noticed is that we have a table that is part of the process, if you select say 3 from a drop down for number of emails, then when you submit the page, i have a loop for each of those emails and they are inserted into the email table as individual records.. works great also.. BUT here is my problem.. if i submit say an existing set of data and this time i provide say 1 email vs 3 from the previous time, i need to handle that in the procedure, so that the 3 are deleted and only 1 is now inserted and linked to that record..
Hope this makes sense..
Since im doing a foreach loop based on that dropdown selection, now when i look at my table im getting only 1 record in the email table... since the logic is within the procedure, when the page calls the procedure, it finds tha the record exists, deletes all the records, then only inserts the last record.
Example.
I submit the page with 3 emails today.. everything works and goes in as expected, there are 3 emails and record is created without issues..
Tomorrow someone else comes in from my team and decides to enter the same record data, thats not a problem, because there is an update statement if it already exists.. BUT this time they entered only 2 emails.. the 2 new emails are inserted / updated in the table, but the 3rd email is still in there.. its not removed.. so i tried to add a if exists condition to my procedure, but since the procedure is called in my foreach loop, the first loop sees the records, deletes them and inserts the first email, then on the 2nd foreach loop it deletes that last entry and inserts the next, so by the time it goes thru it has deleted everything it inserted and only captures the last record..
Just tried it now.. and since there was already 1 record in the table, i chose to add 4.. the end result should be 4, but i now have 5 records in there.. the first one and the 4 new ones..
Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.
View 4 RepliesI tried it and it only returns the first table.
View 2 RepliesI have migrated a database from one server to another and following the migration had an orphaned user (WholeSystem_webuser), which has been fixed using the auto_fix option of sp_change_users_login
•The WholeSystem_webuser account is used by ASP.NET pages to connect to the database and run stored procedures.
•I can log in to Management Studio as WholeSystem_webuser OK and execute the sp's from there
•When I try to run my ASP.NET page it was saying “Can’t find stored procedure [procedure name]”
•If I drop the sp and create it as [dbo].[GetContactsCount] instead of [WholeSystem_ webuser]. [GetContactsCount] it says “The EXECUTE permission was denied on the object 'GetContactsCount', database 'WholeSystem', schema 'dbo'.” (which is what I’d expect as the connection string is using the WholeSystem_webuser account??) –does that show that the web user is logging into the database OK??
•If I try and configure the SqlDataSource in VWD to see what it is looking at though, it won’t let me get beyond the connection string window and says “Default schema could not be retrieved for this connection”
•I tried setting up a new login/user/connection string but still get the
“Default schema could not be retrieved for this connection” error
IN SQL Server:
•Users mapped to the login WholeSystem_webuser - WholeSystem_webuser, default schema dbo
•User WholeSystem_webuser has default schema dbo and db_dataread and db_datawrite permissions
•There is a schema dbo whose owner is dbo, and a schema WholeSystem_webuser whose owner is WholeSystem_webuser
I am using sqldataadapter for my gridview, but it doesn't talk with stored procedure. How can I use it with stored procedure?
View 2 RepliesI have stored procedure in my database but its give error "Could not find stored procedure"Is this error occuring when maked error in permision,sp code or connection code
View 3 RepliesI am trying to re-write an existing asp.net website using MVC with Linq to SQL. A page we have is used to insert new contracts and uses usp_contract_insert to insert a new contract into t_contract as well as t_project. On my dbml file i have dragged t_contract on and then I try to drag usp_contract_insert on top of that and I get the error :- Microsoft Visual Studio
One or more selected database objects return a schema that does not match the schema of the target data class. Nothing has been added to the designer. The stored procedure returns the id of the last project which was inserted. I don't quite follow this and unsure how to go about hooking my Controller up using Linq to SQL to call this stored procedure
I have a stored procedure with 6 input parameter and 4 output parameter. In My asp.net - C# code I execute the stored procedure and return the parameter, first of all it gave me this error :
Procedure or function w_create_order has too many arguments specified. That I'm not sure why is that because the number of parameters is right, the only thing is may be the way that I used is not right.
Second, I would like to show the parameter in the label control in my page, I'm not sure how to do this.
[Code].....