Hi, I have cooreected that statement and the code was not wrkng.....

Hi all, i was trying to do a mutiple select with following fileds ServiceCategoryName(field)->ServiceCategory(Table) ServiceName(field)->Service(Table) ServiceLocation(field)->Location(Table) Created Date,SendersName,SendersEmaild(fields) ->ServiceItemForward (Table) DB:SQLServer 2008 and the sp i wrote is following what changes should i make to this ALTER PROC [dbo].[usp__Search_ServiceItemForward] @CategoryID int, @ServiceID int, @LocationName varchar(100), @createdFromDate date, @createdToDate date, @sender varchar(100), @senderEmail varchar(100) AS if(@createdFromDate is null) set @createdFromDate =dateadd(d,-7, CONVERT(date, GETDATE())) if(@createdToDate is null) set @createdToDate=CONVERT(date, GETDATE()) Begin SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN SELECT dbo.ServiceItemForward.* FROM dbo.ServiceItemForward INNER JOIN dbo.ServiceItems ON dbo.ServiceItemForward.ServiceItemID = dbo.ServiceItems.ServiceItemID INNER JOIN dbo.Service ON dbo.ServiceItems.ServiceID = dbo.Service.ServiceID INNER JOIN dbo.ServiceCategory ON dbo.Service.ServiceCategoryID = dbo.ServiceCategory.ServiceCategoryID where (@CategoryID=0 or ServiceCategory.ServiceCategoryID = @CategoryID) and (@ServiceID=0 or Service.ServiceID = @ServiceID) and (@LocationName=0 or ServiceItems.ServiceLocation = @LocationName) and (ServiceItemForward.CreatedDate Between @createdFromDate and @createdToDate) and(@sender is null or ServiceItemForward.SendersName=@sender) and (@senderEmail is null or ServiceItemForward.SendersEmaild=@senderEmail) COMMIT End please help me out in htis.... Thanks in advance

Hi all, Can anybody help me in the following issue. I have a course table contains coursename and type I want to select course name and type and the display should like Coursename(type) th problem is my type values are integers.. For example 1 for Regular type ,2 for distance type so if type is 1 and coursename is MCA Output should be MCA(Regular) is it possiblle thru the sql statement Thanks in advance, Reena

In a web application

Hi all, I wanted to create a table trhough c# code and add bind each row of it from the values from the database Pls help me...Thanks In advance Reogeo2008

Hi everyone, I created a ajaxenabledwebsite using VS2005 and using obout suite also with this...It was working well ..Last day onwards ,.aspx pages takes much time to load and status bar shows "loading designer..." .Even if it loaded,editing the markup is not possible and F10 and F11 keys are not working for debugging.. Help me .. Thanks in advance,

Hi Every1, I have webpage which displays an article and at the end of the same i have a print buttn (Asp:ImageButton).When i click on it ,i want to open a new window with article on it and a print dialogue box for printing..How can i acheive this... Thanks in Advance,

Hi Every1, I visited a site and found a search bar which is not moving when we scroll down or up the web page .http://www.plastemart.com/plasticnews.asp#[^].this is the link for that page and you can find a search bar on the right lower corner.Please help me to make one similar to that.I really want to know how can we do that in asp.net... Thanks in advance

Hi Everyone, I've just finish re-installing VS.NET 2005 and tried the Walkthrough: Displaying Data in a Web Forms Page I followed exactly as it is that is I tested the connection "Connection Sucessful", test Query "Successfull" but when i run it prompt me with the following error message: ------------------------------------------------------------------------------------------------- Failed to find or load the registered .Net Framework Data Provider. 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.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider. PLease help me in this... Thanks in Advance

Hi all, What does the below code means?What exactly the secod line tells ...pls help me in this Application.Lock(); an class="smallblack">Application[“mydata”]=”mydata”; Application.UnLock(); Thanks In Advance

Hi all, I have set a breakpoint in the page_Load event of the Statrtup page of the website.But is is not hitting while runnong the project.What may the reason,Can anybody suggest me the reason and how can i solve it. THank in advance.

Hi all, my website has a search function that search youtube videos for the user.its works well in local machine.when i click the button for search after hosting my site, it leads to a security exception can anybody help me in solving the same Thanks in Advance

Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

only one web config file

Hi all, While i am browsing the website hosted in my hosteing server ,im getting the error" Security Exception ".when i googled most ofthe solutions say to keep the trustlevel in web.config to Full as follows lt;system.web>      <trust level="Full" originUrl=""/>   </system.web>But the prolem is my hosting server doesn't support it..That will allow onlu medium trust level so What will be the next solution..Can anyone help me.. Thatnks in advance

Hi all, I have a web application developed using .net 2005.I have used Ajax control toolkit 1.0 along with this.It was working perfectly.When i tried to run the project somedays after ,Ajax control tool kit is not working .What will be the reason.? These are the errors im getting 1.Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The system cannot find the file specified. 2.Unknown server tag 'ajaxToolkit:ToolkitScriptManager'. Help me to solve this problem.. Thanks in advance for any help.

Hi All, Can anybody suggest the mysql equivalent for the sql query Select top 3 * From Table Thanks in advance

Dear all, I have a gridview which contains number of video links listed down.when the user click on of the link it shuld display the coresponding video.my video is opeing and playing in real player.the problem is that it takes mych time to download video..how can i avoid the downloading time to make it fast.. Thanks in advance for any help

Hi all, Whn im tryin gto run a web application im getting the error pop up "unable to start debugging on the web server.Server side error occured on sending debug http request" CAn anybody help me to solve the same Thanks

Whn i open http://localhost im getting the error Page can not be dispalyed.What will be exactly happening