Re: retreiving both local users and active directory users - C# Discussion Boards

Use the System.DateTime.TryParse method.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Is Jesus the Jewish Messiah?
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Hi everyone,

I have a problem re: DataBindings. I binded a textbox with a database in which I would like to show the date in it, but unfortunately I can't remove the time, so that in the textbox the date only is shown. How can I do it? The following is the code I used for databinding.

this.txtDOB.DataBindings.Add("Text", DBHandler.DS, "UserLogInsteacher.DateOfBirth");

Thanks a lot!!

The Add call returns a Binding[^] object which has a Format[^] event. Use it to format your data.

I didn't understand you quite well. How can I do that?

Something like this (not tested):

Binding binding = this.txtDOB.DataBindings.Add("Text", DBHandler.DS, "UserLogInsteacher.DateOfBirth");
binding.Format += new ConvertEventHandler(binding_Format);

and

private void binding_Format(object sender, ConvertEventArgs e)
{
   DateTime dt = (DateTime)e.Value;
   e.Value = dt.ToShortDateString();
}

Some error handling etc should be added (like checking for DbNull etc.)

Hi,

i'm trying to create a dialog in c#, that populates a listbox with built-in users, on an xp, yet it should allow the user to browse for users from active direcotry outside their local machine.

actually i'm trying to mimic a dialog that shows in:

SQLServer2000 Enterprise Manager/security/logins/new login/browse button (...)

please advice, and many thanks in advace.

hi eyad do want to retrive the onfo. about users in the active directory domain.

i think this code will help you ;
but first you should sign on the domain as a administrator
then add the active directory refference to the code below:

////
//
//
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.DirectoryServices;// the active dirctory library

namespace abdallah1
{
///

/// Summary description for WebForm1.
///

public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.ListBox ListBox1;

private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
}
private void retrivedata(string strDoamin)
{
DirectoryEntry obDirEntry = null;
try
{
obDirEntry = new DirectoryEntry("WinNT://" + strDoamin);
DirectoryEntries entries = obDirEntry.Children;
foreach (DirectoryEntry chil in entries )
{
if ( chil.SchemaClassName =="User")// to retrive the user only
{
ListBox1.Items.Add( chil.Name + "//" +chil.SchemaClassName);
}
}

}
catch (Exception ex)
{
Trace.Warn(ex.Message);
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void Button1_Click(object sender, System.EventArgs e)
{

retrivedata ("nwtraders");
Label1.Text="Data retrived sucssfully";

}
}
}
////////

Thanks alot abdallah for your help, it worked great.

:->hi every one ,
i need some info. about rational rose model , its related with softwear eng.
so any info. will be usful for me .

my best Regards for all.

abdallah zaid

Some samples must be avilable at http://www.rational.com.

Best regards, Alexey.

:->thx for your help alexey ,

my regards.

abdallah ziad

please give idea or any help this issue:

how to rotate images in cycle with link.
description:

iam developing project to the musium.There various type of ancient type Categoriesare available. I have devided all in 6 Categories,so i like to rotate all Categoriesin cycle with picture.further more each Category has link that related to other information. Please give Ideas to begin project.

Amal
SOFTWARE DEVELOPER

hi Amal,

please clarify the terms you used: "rotate", "cycle" and "link"

did you mean with "rotate" turning clockwise and counter-clockwise an image canvas ?
or did you mean some sort of a CROSS JOIN between two entities ?

write in arabic if you like.

best regards.

my project likes encanrta 2005 interface .
rotate -clockwise or unti clock wise

in Encarta 2005 images have been rotating with links,that each links has own information

plese urgent

Amal

hi why don't u use an adrotator control.

hi to all
with regards,
susa

Does anyone know how to synchronize two databases (prefarebly mySQL) on different servers through C#?

What confuses me most is the comparing of the two databases. Note that the two databases can have the same data due to previous synchronizations. Also, the two databases can have different data but the same primary key.

Thank you

Elaine

Sounds like you need to look up System.Data.DataSet[^]

Graham

Hi,
I already worked with C# a while and I'd like to generate documentation. I've seen you can use '///' to add info in XML-style. So the XML can be parsed by using for example NDoc.
Is NDoc the best tool to use to generate C# Documentation? Any other software that I should use? (NDoc projet is not being update lately...)

Any advice/suggestions are welcome Smile | :)

Greetings,
Jens

I think NDoc is the best choice.

--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

I second NDoc, but as you have noticed they haven't released a binary for a while. Although there are currently working on a release for 2.0 framework features (like generics). I have a few c# 2.0 projects which could do with this.

Hello,
Thanks for your time to read my request for a help. I developed my windows application with C#, which has many background workers working at the same time, opening and closing sql databases, modifying sql tables etc. Now, very often I get this error message, " There is already an open DataReader associated with this Command which must be closed first.". I dont know why its happenning sometimes and sometimes not. Is that the reason one thred and another thread conflicting each other when they try to read or modify same sql database ? And sometimes, I get some weired error saying "in order to execute the sqlcommand, connection must be open. ", And I dont see any reason why connection is getting closed before that sqlcommand execution. Now I had to place if(myConn.State == ConnectionState.Close) myConn.Open() ; before every sqlcommand. Even after that I am getting same error sometimes. Can anyone please give me some clue to solve and seal this problem permanently.

Thanks and regards
emran

You can have any number of connections open to the database, so that is not the problem. The problem is most likely how you use the connection objects in your code. You can't share connetions between threads.

---
b { font-weight: normal; }

the exception you're getting is probably when executing SQLCommands using "ExecuteDataReader" and openning the datareader while another data reader is already opened in another thread.

example of creating the exception:

thread 1 executes:
SqlDataReader dr = LocalSqlCommand.ExecuteDataRead();
dr.Open();
...

in the same time thread 2 tries to execute the same symmantec:

SqlDataReader dr = LocalSqlCommand.ExecuteDataRead()
dr.Open() -> this will generate the exception...

its a .NET limitation to open only one DataReader per application !!!

a workaround:
- always close the dataReader when finished by executing: dr.Close()
- try raising a flag between threads (mutex) so they block each other while they open and close DataReaders

best regards

eyad al akhras wrote:
its a .NET limitation to open only one DataReader per application !!!

No, not per application, but per connection. Not really a limitation, as you easily can open as many connections as you like.

---
b { font-weight: normal; }