|
|
can you please provide more info what kind of error you are getting
one syntax error is resolved
declare @clientName NVARCHAR(255)
SET NOCOUNT ON;
SELECT Distinct [Year]
FROM Engagement_Standards
WHERE [Year] IS NOT NULL AND
[Client Name] like
(CASE
WHEN @clientName IS NULL THEN '%'--error part
else @clientName END )
ORDER BY [Year];
|
|
|
|
|
WHERE [Year] IS NOT NULL
AND isNull(@clientName, [Client Name]) = [Client Name]
I think this is what you're after. If the parameter is null we're just saying if [Client Name] = [Client Name] which it will. If it's not null you'll be comparing the parameter with the column.
|
|
|
|
|
I have used some thing like this Rupert, is this method OK.
USE [INVENTORY_ MANAGEMENT]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
Create PROCEDURE [dbo].[Engagement_Get_StandardsByCriteria]
-- Add the parameters for the stored procedure here
(
@ClientName NVARCHAR(255)=NULL,
@Year FLOAT=NULL,
@Application NVARCHAR(255) =NULL,
@Database NVARCHAR(255)=NULL,
@OS NVARCHAR(255)=NULL,
@QuickName NVARCHAR(MAX)=NULL
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT [Client Name] AS Client,[Year],[Application],
[Database],OS,[MLP Heading] As Heading,
[Standard Observation] AS Observation,[Standard Impact]AS Impact,
[Standard Recommendation] AS Recommendation
FROM Engagement_Standards
WHERE (@ClientName IS NULL OR [Client Name]=@ClientName)
And
(@Year IS NULL OR [Year]=@Year)
And
(@Application IS NULL OR [Application]=@Application)
And
(@Database IS NULL OR [Database]=@Database)
And
(@OS IS NULL OR OS=@OS)
And
(@QuickName IS NULL OR [Quick Name]=@QuickName);
END
|
|
|
|
|
That'll probably work but It might be a bit easier to read/maintain like this:
WHERE isNull(@ClientName, [Client Name]) = [Client Name]
AND isNull(@Year, [Year]) = [Year]
AND isNull(@Application, [Application]) = [Application]
AND isNull(@Database, [Database]) = [Database]
AND isNull(@OS, [OS]) = OS
AND isNull(@QuickName, [Quick Name]) = [Quick Name];
|
|
|
|
|
Hi,
I am trying to use sqldatadependency in my asp.net application, for that iam start doing First step is to enable the Database notification like as follows..
aspnet_regsql -S localhost -E -d TestDatabase -ed in microsoft sql server notification service Environment (command prompt) in Sql server 2005 .... but i got error like..
aspnet_regsql operation is not recognized internal..
I dont dont know where am going wrong path ..can u able to track this plz..
Thanks in Advance..
kannak........
kannak
|
|
|
|
|
|
Hello,
I've been having this same problem for over 2 weeks now and have found dozens of sites claiming to solve this problem, but it hasn't worked for me. I've followed all steps in the documentation etc correctly. When I try to login to my site, or create a new user, I get the following error:
Server Error in '/' Application.
--------------------------------------------------------------------------------
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +378
System.Web.Security.SqlMembershipProvider.CheckSchemaVersion(SqlConnection connection) +89
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +815
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +78
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +60
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +119
System.Web.UI.WebControls.Login.AttemptLogin() +115
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.4200; ASP.NET Version:2.0.50727.4016
Can somebody please explain why this has happened, and how I may go about fixing it? I'd appreciate any help at all.
Thank you,
Bael
|
|
|
|
|
Just to confim, have you tried aspnet_regsql.exe from visual studio command line?
|
|
|
|
|
I have used it before but not in this case as I'm not sure of what to do with regards to this particular problem. The membership login/registration works perfectly on my local machine but it only fails with the above error when it's uploaded to the server. Would doing something in aspnet_regsql.exe fix this issue?
|
|
|
|
|
As it seems that your database does not have all items required to support membership related functionality, you can run aspnet_regsql from visual studio command prompt to fix all aspnet membership related items in database.
This will also include any missing stored procedure in the database.
|
|
|
|
|
In Visual Web Developer Express 08, in the Solution Explorer pane, if I expand the ASPNETDB and click Procedures, it contains a stored procedure that the above error claims it cannot find. ... Could you kindly suggest which commands I'd need to use in aspnet_regsql.exe?
|
|
|
|
|
In case only this particular stored procedure is missing then you can use this one...
CREATE PROCEDURE [dbo].[aspnet_CheckSchemaVersion]
@Feature nvarchar(128),
@CompatibleSchemaVersion nvarchar(128)
AS
BEGIN
IF (EXISTS( SELECT *
FROM dbo.aspnet_SchemaVersions
WHERE Feature = LOWER( @Feature ) AND
CompatibleSchemaVersion = @CompatibleSchemaVersion ))
RETURN 0
RETURN 1
END
|
|
|
|
|
If you want to do this using apnet_regsql.exe, use the following steps:
1. Open visual studio command prompt
2. type aspnet_regsql and press enter
3. Click next on the window just appeared
4. select "configure sql server for application services", click on next
5. enter server name, username & password
6. choose databse from drop down
7. click on NEXT & NEXT
This will repair your database.
|
|
|
|
|
Thank you for your help and the code. It appears that there is no Command Prompt in Visual Web Developer Express 08. Can I just use the MS-DOS Command Prompt?
|
|
|
|
|
|
Thank you for your help arun$aini 
|
|
|
|
|
My Pleasure
Hope you have solved the issue.
|
|
|
|
|
Yeah, with your help i managed to sort it out. If it weren't for you, i would've had to pay to get it fixed by somebody. You saved my butt! 
|
|
|
|
|
Hi, I'm looking into a problem on our website but other than the method I have no way of knowing which control/line number the error refers to. I know it is caused by one of 4 controls where we convert the contents to an int. For example, the code is:
private void SomeMethod()
{
int i = Convert.ToInt32(ddl.SelectedValue);
int i2 = Convert.ToInt32(txt.Text);
}
I think it is being caused by a custom textbox's value returning null. It is an intermittent problem and not something we have been able to recreate.
The stack trace is:
Input string was not in a correct format
System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +119
System.Convert.ToInt32(String value) +63
It would be nice to narrow the search down to a particular control and I would like to understand how exactly I can narrow the stack trace error down to a particular line. Can anybody please tell me how this is possible?
Thanks
|
|
|
|
|
Check which of the lines is returning String.Empty (i.e empty string) as the parameter to Convert.ToInt32() function.
Convert.ToInt32(null) will return 0 whereas Convert.ToInt32("") - throws the exception is mentioned.
I hope this would help you.
|
|
|
|
|
|
Have you considered telling the truth?
|
|
|
|
|
You've already failed the interview because you can't follow directions.
Don't cross post 
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
hello @ all
i've created a small website for our company with asp.net 2.0.
now i've started to make the website multilingual.
i know there a lot of good and easy solutions to get a website multilingual by using localization.
but...
my boss wants to write the website content by itselfs, so i needed to found a other solution and i found one.
for example, i use a usally aspx website and two ascx usercontrols (they are contains the english and french content).
i added to the aspx-website a contentplaceholder and two buttons (EN and FR).
if one of these buttons becomes clicked, the click-event loads the related ascx-usercontrol to the contentplaceholder at the aspx website.
the website loads by default the english-content.
now the poblem,
if someone search some content from our website by google or bing etc., they only matches the english content. the french content will be never matched by the search engines.
does anyone now why ?
what can i do to solve this problem ?
thanks a lot
tronix
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
