To configure WCF logging you can use the standard tools provided by Microsoft. This posting describes how to configure your client to log the messages it sends to a service.
Continue reading →

1. Run “aspnet_regsql.exe” from c:windowsmicrosoft.netframeworkv2.0.50727
2. Add the Network Service account to your logins for the SQL Server be sure to set the User Mapping for this account to aspnetdb (the default database)
3. Select in the databse aspnetdb the role “aspnet_membership_Fullaccess; right click and add the Network Service account to this role
4. Add the following entry to your connectionstrings settings in the web.config:

       <add name="MySqlRoleManagerConnection" connectionString="Data Source=.;Initial Catalog=aspnetdb;Integrated Security=SSPI;" />
       

   Alternatively you could adjust the connectionstring section as shown below:

       <remove name="LocalSqlServer" /><add name="LocalSqlServer" connectionString="Data Source=.;Integrated Security=True;Initial Catalog=aspnetdb" />
       

   This removes the LocalSqlServer (which points to a SQLExpress instance) from the connectionstrings provided by the machine.config.
   There is no need to define the membership provider (step 5) this way.

5. Add the membership provider settings to your system.web settings (important: connectionStringName points to the name specified in step 4):

   <membership defaultProvider="CustomizedProvider"> <providers>       
       <add name="CustomizedProvider"       
           type="System.Web.Security.SqlMembershipProvider"       
           connectionStringName="MySqlRoleManagerConnection"       
           applicationName="aex_project"       
           minRequiredPasswordLength="5"       
           minRequiredNonalphanumericCharacters="0" /> </providers>       
   </membership>    

6. In Visual Studio go to the Project menu and choose ASP.NET Configuration. In the configuration tool change the “Authentication type” to “From the internet” (this adjusts your authentication mode in the web.config from “Windows” to “Forms”)

See also http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

In de Page_load of a ASP.NET page called inject.aspx:

Response.Write("Hello "  + Request.QueryString["name"]); 

Direct your browser to “…./…../inject.aspx?name=alert(“script injected”);”

To avoid HTML injection adjust the code below to:

Response.Write("Hello "  + Server.HtmlEncode(Request.QueryString["name"]));

This regular expression tests the input string for 40 alphanumeric characters

Regex r = new Regex(@"^[w]{1,40}$");
if (r.Match(strName).Success)
{
    // The string is ok
}
else
{
    // Invalid string
}

See this solution for a (simple) example to add users to the Active Directory. Good starting point for AD stuff…

See this solution for a (simple) example to read Excel files. Good starting point for Excel stuff……..

using System;    
using System.Collections.Generic;    
using System.Linq;    
using System.Text;    
  
namespace LINQSamples    
{    
    public class Person    
    {   
        public string Name { get; set; }   
        public int Age { get; set; }   
     
        public override string ToString()   
        {   
            return this.Name + " " + this.Age;   
        }   
    }   
     
    class Program   
    {   
        static void Main(string[] args)   
        {   
            List persons = new List();   
     
            persons.Add(new Person() { Name = "Berend", Age = 38 });   
            persons.Add(new Person() { Name = "Nynke", Age = 6 });  
            persons.Add(new Person() { Name = "Marije", Age = 5 });   
            persons.Add(new Person() { Name = "Bennie", Age = 2 });   
            persons.Add(new Person() { Name = "Marian", Age = 38 });   
            Console.WriteLine("All persons:");   
            foreach (var p in persons)   
            {   
                Console.WriteLine(p);   
            }   
            Console.WriteLine();   
    
            Console.WriteLine("All persons order by name descending:");   
            var query = from person in persons orderby person.Name descending select person;   
            foreach (var p in query)   
            {   
                Console.WriteLine(p.Name);   
            }   
            Console.WriteLine();   
    
            Console.WriteLine("# of persons that are 6 years old:");   
            Console.WriteLine(persons.Count(person => person.Age == 6).ToString());   
    
            Console.ReadKey();   
        }   
    }   
}