While configuring sharepoint server 2007 for form based authentication, I have came across a lot of issues. One site that was really helpful while configuring was:
http://www.codeproject.com/KB/sharepoint/FBA.aspx
After going through all the steps, whenever I try to access the site that was configured for form based authentication. The page just refereshes to itself and do not produce any errors. I read through a lot of blog items to find the result but none of them worked for me.
While trying different options, I came to know that the user provider database which contains all form users should have a windows local account in order to access the users. Once I had configured that, the login page started functioning
admin SharePoint Aspx, Authentication Server, Provider Database, Server Authentication, sharepoint server, Sharepoint Server 2007
Problem
One of the common problems faced in the data retrieval is to avoid duplicate rows from dataset or datatable. If you google for it, you will come across many solutions asking to loop through the complete in order to get rid of the duplicates. There is a very simple solution available in .Net that does not need looping but it comes with one problem that it can apply duplicate on a single column only.
Solution
For a dataset the following line will return distinct records for the column:
ds.Tables["MyTable"].DefaultView.ToTable(true,”column_name”);
For a datatable the following line of code will return distince records for the column:
dt.DefaultView.ToTable( true, “column_name”);
The first parameter of ToTable is a boolean for distinct or non-distinct. The second one is the name of the column. It is as simple as it looks
admin .Net Boolean, Column Name, Data Retrieval, Dataset, Datatable, Google, Loop Through, Simple Solution
Recent Discussions