CREATE PROCEDURE [dbo].[Procedure]
@GroupId as varchar(500) = ''
SET NOCOUNT ON;
DECLARE @query as nvarchar(500)
set @query = 'select VideoTitle from Item where ItemId in(select ItemId from GroupLink
where GroupId in (' + @GroupId +'))'
exec SP_EXECUTESQL @query
Now execute the procedure as exec Procedure (2,3,4)
I used to do like the above whenever I have to retrieve the values based on a list...Don't know if it has any performance issues...
"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)
i have used aspnet authentication to logging into my site.When i click logout and i click back button,i can see the last page.How can i logout properly.I used FormsAuthentication.Signout() to logout.What is the problem of dont properly logout fro site.
Actually i put a login control in masterpage enabled page and i put menu in masterpage.in the menu i put a menuitem logout and in the menu item click event i given formsauthentication.signout and the above given code.and i retdirect the page to home page where the login control, is situated.This is the flow of login and logout.After logout i checked username is null or not in another menuitem page.but i can easily access the page because the username still exists.What is the problem.
if (txt != array[p].ToString())
/*The I is representing the Rows and the J is representing the Cells
*///These are the Cells that are Supposed to be disabled
cycleGrid.Rows[i].Cells[j].Style.BorderColor = System.Drawing.Color.DarkGray;
cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.DarkGray;
cycleGrid.Rows[i].Cells[j].Style.Cursor = Infragistics.WebUI.Shared.Cursors.Wait;
cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.Black;
cycleGrid.Rows[i].Cells[j].Style.Cursor = Infragistics.WebUI.Shared.Cursors.Auto;
cycleGrid.Rows[i].Cells[j].Style.Font.Bold = true;
Now as you can see am disabling cells by turing the color to be gray and by making sure that its not selectable. Now this will work perfectly if the array has a single value in the Array, but when the Value is like this
i need to Disable the values that does not appear in the array like the above example 15,16,19 will be missing from the list, so in the grid they should be gray and the other should be bold and black. Mybe there is something wrong here , because it only make the 35 im the list and it made it bold and it made others bold to but they are grey but bold. like this
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."