Hey SQL query works on very efficient manner, my stored procedure won't take more than 2sec to execute, but the issue with application

Hi Exports, I have an asp.net 2.0 application, which is very slow in performance. we have triggered the issue down the line, we are surprised with issue. The application used lot of database operations and respective stored procedure have lot of complicated business logic, but the stored procedure won't take much time to execute on SSMS(SQL Server) but when we access same stored procedure through the application it take huge time. please suggest me how i can resolve the time consuming problem.

Thank you so much for the help. I was trying something and achieved it.

Hi Raviranjan, Thanks for the reply, Ya exactly i wanted and achieved it, Thanks Vishwa

Hi, I want to develop a Survey module using MVC4, for that i have a set of questions for each questions i have 4 options & these options should be radio button in the application and all questions will be having same options EX, Agree,Disagree, Strongly agree,Strongly Disagree. How can i achieve this using MVC4. I tried several links but no link is helping out EX: Tried This[^] NOTE: I am a beginner in MVC

Thank you Richard Deeming. i written query like what you have written, is this style of query takes less execution time ?

Hi Guys, I have a condition that, I have to display data for all states with 3 different conditions like i have a state column and i have to calculate count for judicial, non-judicial , and redemption these columns i have to display for each state how can i make it happen in a single query with good performance. I have 3 different conditions to get count, so please help me ex

            State
        

        

            Judicial
        

        

            Non-Judicial
        

        

            Redumtion
        

    

    

        

            AZ
        

        

            10
        

        

            01
        

        

            0
        

    

    

        

            CA
        

        

            12
        

        

            94
        

        

            04
        

    

    

        

            NV
        

        

            32
        

        

            04
        

        

            04
        

    

    

        

            QA
        

        

            32
        

        

            49
        

        

            04

calculation part is done bind that "Double" value to the control is not so simple as you saying, i tried to bind 3.5 it covering 4 *'s in the control.

I was asked for average rating like 3 people rated the item average may come like 1.2, 3.5 that rating i have to bind from code/jquery or any technology. I also googled and got the links which you have given anyhow thanks for the reply. If you come to know the average binding of rating control please reply back Thanks Vishwa

Hi Guys, Here is a small bug, I have given around 101 comments to the questions and answer sections, when i go to user profile of mine it shows '0' if i click on the comments it shows 101 comments list. I you can check this on Comments Bug[^] Thanks and regards Vishwa

Hi guys, i have a data base table which has comments, users, and rating, i have to bind that rating information in the form stars according to individual user, like 1st user rated 1 so 1 star, 2nd user rated 3 so 3 star, what is the best way to achieve this.

hay thank you, its working :)

Hi guys, recently i started to learn WCF, i was referring a code project link but it is not showing chapters, it says unfortunately the page is not found here is the link http://www.codeproject.com/script/common/404.aspx?aspxerrorpath=/KB/WCF/wcfbyexample_baseline.aspx[^] check and please update.

Got solution for the issue This link worked for me[^]

I have a treeview control that gets populated at runtime with a pyramid of employee names. I put the css scrollbar on the view by putting overflow:auto" in the tag where the treeview is located. The users are now asking me to to have the scrollbar go down in the treeview where a treeview item is selected.

How do I make a scroll bar to go to a place where the treeview has been selected?

Note: treeView1.SelectedNode.EnsureVisible();

is not available in asp.net need another way.

Got some links in stackOverflow but no use.!!

Hi guys, I want to maintain the selected values of check box and drop down list values in MVC-4 on Post back of page, ex: I selected Drop down list which contains year, if the user selected 2012 as year on post back of page it should be selected as 2012 value, in classic asp.net we have Page.IsPostBack, is there any same way to do that in MVC 4. because on every post back i am loosing the state of controls, Please help me. Thanks and regards Vishwa

Hi Amit, Thanks for the reply, I was also thought the same, but not having idea how to make jpg files should be display depends on the condition, so put a question on the form, will try the possible ways, Thanks and regards Vishwa

Hi guys, I am building a report, in the report i should display 7 site name with check box, and if the report belongs to 1st site that check box should be checked, if the report belongs 2 sites it should check both 1st and 3rd any help will be appreciated. Thanks and regards VISHWA

Hi guys, I am beginner in MVC 4, I am facing problem to achieve one simple requirement. The problem described as below. I have 3 roles(Programmer,reviewer,Admin) and 1 razor view, that has 4 panels and each panel has set of controls , depends on the role and the some condition i have to make panels visible false/true. Please help me out. Thanks and regards Vishwa

each program having 32 bit checks to prove the item is defect or not