Sunday, February 1, 2015

Syntax error in INSERT INTO statement.

You can see the sample without LINq:


http://ift.tt/1tTIeAu


with LINQ


http://ift.tt/1tTIdfO


chanmm




chanmm


Design approach regarding loading data

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


Design approach regarding loading data

If you really so concern on the design then go to the links below.


http://ift.tt/164jTwZ


http://ift.tt/1tTIek2


chanmm




chanmm


Attendance Records for all users Select Problem

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.





Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Documents authentication in sharepoint

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.


power shell for checking if a item existed into custom list

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


Text Changed Event conflicting with Selected Index Changed Event

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.


I suggest adding an Edit button which explicitly sets the textboxes into edit mode, and Apply and Cancel buttons to confirm or discard the changes. Or possibly even better, write a new form just for editing that is invoked when the Edit button is pressed.