VishwaKL wrote: , but the issue with application That's what I was saying. You're probably trying to display too much data. There are only 10 types of people in the world, those who understand binary and those who don't.

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

VishwaKL wrote: is this style of query takes less execution time ? Less than what? You'd need to measure the performance of this query against the query you want to compare it to. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Everyone may be facing this. I think,some updations are being carried out :java: Rule of debugging: "If you get a different error message, you're making progress."

http://forums.asp.net/t/1596782.aspx?Star+Rating+with+decimals[^] see this link this is perfect what you want to do :)

You're welcome! The quick red ProgramFOX jumps right over the Lazy<Dog>. My latest article: Understand how bitwise operators work (C# and VB.NET examples) My group: C# Programmers Group

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

Your welcome Thanks -Amit Gajjar (MinterProject)

In the Mvc application we can find ASPNETDB.MDF in Server Explorer. Add roles (Programmer,reviewer,Admin) and its users to respective tables. Now based on the logged-in user's role we can make panel visible property true or false. Sample Code: if (User.IsInRole("Administrator")) adminPanel.Visible=True; I hope this will help you. Please accept it as answer if it helped you. With Regards, Rohith.

Great design - what happens when you want to add a new check! You need to add the values of the 32 checks (presumably booleans where 1= positive) if it = 32 then the program passes andything els the program fails. Select * From (Select C1 + C2+C3+... as checktotal, Program from table) as SubQuery where checktotal = 32 Never underestimate the power of human stupidity RAH

SELECT DATEPART(YEAR,trans_date) AS 'Year',DATEPART(wk,trans_date) AS 'Week #',MIN(DATEADD(wk, DATEDIFF(wk,0,trans_date), 0)) AS 'Week date', SUM(COALESCE(debit,0)) AS 'Debits', SUM(COALESCE(credit,0)) AS 'Credits' FROM trans GROUP BY DATEPART(YEAR,trans_date),DATEPART(wk,trans_date)ORDER BY 1,2;

VishwaKL wrote: How to make session values alive still user logout. Not advisable as you will be blocking sever memory and can be very bad when multiple people connect. VishwaKL wrote: make it '0' to never expire, but still my session expire on 20 min Session timeout is set in Web.Config file. Default is 20 min. Change it to as per need there and will be used by IIS. You can also have FormsAuthentication timeout if you are using FormsAuthentication. Following is sample change in Web.Config file: <system.web> <authentication mode="Forms"> <forms timeout="55"/> </authentication> <sessionState timeout="60" /> </system.web> Sandeep Mewara Microsoft ASP.NET MVP 2012 & 2013 [My Blog]: Sandeep Mewara's Tech Journal! [My Latest Article]: HTML5 Quick Start Web Application

VishwaKL wrote: document.getElementById("dvGridview").scrollTop = strPos; I see call to only one. Where is both? Set scroll position for both control. Sandeep Mewara Microsoft ASP.NET MVP 2012 & 2013 [My Blog] [My Latest Post]: How to extend a WPF Textbox to Custom Picker

Table: site - id - Site_name - Site_url Table: site_parameter - id - Site_id (foreign key to above table) - name - value For "26 parameters" you would have 26 rows in the site_parameter table.

thank you so much J4amieC, it worked for me,

Hey i just used the trunc method for oracle, u can replace to yr old year and month method to get the result, but the concept is that we will use the union clause to get the data for those month for which we dont have the data than we will do a union with yr old query then on the top of that put a sum for monthcount with group by month and year. so yr query will be select years, month, sum(MonthCount) from ( SELECT YEAR(RequestedDate) as Years, Month(RequestedDate) as MonthInNumbers,Count(Month(RequestedDate)) FROM MYTABLE group by YEAR(RequestedDate),Month(RequestedDate) union select '2012' as years, 'JAN' as Month, 0 as MonthCount from dual union select '2012' as years, 'FEB' as Month, 0 as MonthCount from dual union select '2012' as years, 'MAR' as Month, 0 as MonthCount from dual union select '2012' as years, 'APR' as Month, 0 as MonthCount from dual union select '2012' as years, 'MAY' as Month, 0 as MonthCount from dual union select '2012' as years, 'JUN' as Month, 0 as MonthCount from dual union select '2012' as years, 'JULY' as Month, 0 as MonthCount from dual union select '2012' as years, 'AUG' as Month, 0 as MonthCount from dual union select '2012' as years, 'SEPT' as Month, 0 as MonthCount from dual union select '2012' as years, 'OCT' as Month, 0 as MonthCount from dual union select '2012' as years, 'NOV' as Month, 0 as MonthCount from dual union select '2012' as years, 'DEC' as Month, 0 as MonthCount from dual ) group by years, month

Your description isn't clear enough, so here's a design that could be used for some interpretations of what you wrote. 0) There are several sites. 1) A check list has several check list items. 2) Each site has a check list with a subset of all available check list items. 3) Each check list item may be on several sites' check lists. This is a classic many-to-many relationship and the typical implementation is to have (at least) three tables: Site: ID, Name, etc. Item: ID, Name, etc. SiteList: SiteID, ItemID (usually no other data here, but maybe in some cases) Another schema would allow for defining lists and assigning them to sites: Site: ID, Name, etc. Item: ID, Name, etc. List: ID, Name, etc. ListItem: ListID, ItemID (usually no other data here, but maybe in some cases) SiteList: SiteID, ListID (usually no other data here, but maybe in some cases) This second way may be approriate for your needs, you can define a common list and custom lists and assign multiple lists to the sites. Getting a complete list of all items for a site is simple as well.

I also have this book, i am reading from 2 days, may be i have to go through more to clear my doubts. Thanks buddy :-D