C#

Member 1439977 wrote:

Has anyone seen this type of problem?

SomeCommand.CommandText = @"
SELECT *
  FROM Bla
 WHERE SomeDate BETWEEN @StartDate AND @EndDate";
SomeCommand.Parameters.AddWithValue("@StartDate", DateTime.Now);
SomeCommand.Parameters.AddWithValue("@EndDate", DateTime.Now.AddDays(-30));

Bastard Programmer from Hell

string filter = " (Date >= #" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "# And Date <= #" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "# ) ";

Font font = new Font("Verdana", 12.0F);
private void myPanel_Paint(object sender, PaintEventArgs e)
    {
    Graphics g = e.Graphics;
    g.DrawString("Hello", font, Brushes.Black, 10, 10);
    Matrix m = new Matrix();
    m.Scale(2, 1);
    g.Transform = m;
    g.DrawString("Hello", font, Brushes.Black, 10, 30);
    g.ResetTransform();
    m = new Matrix();
    m.Scale(1.5F, 1);
    g.Transform = m;
    g.DrawString("Hello", font, Brushes.Black, 10, 60);
    g.ResetTransform();
    }

turbosupramk3 wrote:

a unique identifier

turbosupramk3 wrote:

get all of the account related objects for that account.

turbosupramk3 wrote:

An example would be first name, last name, phone, email, any status codes/custom
attributes, etc.

using (var rootDirectory = new DirectoryEntry("LDAP://[Server IP or Host name]", "[user name in the directory]", "[User Password]")) {
           using (var directorySearch = new DirectorySearcher(rootDirectory)) {
              // your filter should be an LDAP Query, the one i put in the sample look a matching name or sAMAccountName
              directorySearch.Filter = string.Format("(|(sAMAccountName={0})(name={0}))", "[User Name you want or account you want]");
              // you can add non standard properties to your query:
              // some samples are "memberOf" for getting all groups the entry you want are related to (1 level up only)
              // or "member" for all members of a group (1 level down only
              directorySearch.PropertiesToLoad.Add("[Name of the property you want, exactly as it appears in the AD]");

              // return an entry if there's a match
              var result = directorySearch.FindOne();

              if (result != null) {
                 // by the search result, get the associated directory entry, as the result object can be complex to work with.
                 var directoryEntry = result.GetDirectoryEntry();

                 // Note that entries contain between 40-60 properties by default, plus whatever properties you asked to load
                 // in the directory search, as long as your domain admin did not restrict access to them
                 // (in which case the root user you used to start this chain need to have permissions to read those properties)
                 var propertyIwant = directoryEntry.Properties["Name of the property you want"];
              }
           }
        }