You can see the sample without LINq:
with LINQ
chanmm
Frankly, people need to know many factors in order to advise you on best practice.
What I say, as long as your code performance is acceptable, record is accurate (also means no bug), and can easily maintain. That is good enough.
chanmm
chanmm
If you really so concern on the design then go to the links below.
chanmm
One should not be too surprised that a query typed right out of the blue does not return anything.
The best way to get help with a problem like this is to post:
1) CREATE TABLE statements for your tables.
2) INSERT statements with sample data, enough to demonstrate the problem.
3) The desired output, given the sample.
4) A short description of the business rules which explains why you want that output.
5) Which version of SQL Server you are using.
My question here framework is authenticating site correctly based on user permissions but not the documents, when user tries to open the document uploaded in the site user can open the document(by giving complete URL link). In simple terms I want to restrict users when they try to open the document by giving url link if they dont have access permission.
I have mentioned custom HTTP handler is one of the way to resolve the above issue.
You can iterate through all items this way
$list = $web.Lists["YourCustomList"]
$collListItems = $list.Items;
$count = $collListItems.Count - 1
for($intIndex = $count; $intIndex -gt -1; $intIndex--)
{
}
and search for the value in your field
Please mark a post helpful/answer if it is really helpful or answer your query
Your problem is that you are using the textboxes to perform two separate functions, displaying the current selection and editing. This sort of approach is asking for just the kind of trouble that you are experiencing. Experience tells me that if you persevere for long enough, you will eventually get it to work, but the result will be a confusing tangle of setting and unsetting flags based on whether the textboxes have gained or lost the focus (and hence the text change is due to the user typing in the box or not), and you won't have any way for the user to cancel their changes if they make a mistake.