Solved

C# user app

Posted on 2014-04-12
6
227 Views
Last Modified: 2014-04-14
Hi guys ,

I would like to know it there is some possibility to create login for users that authenticate with active directory like LDAP.


For now I'm using sql database and wrote this code for authenticate users:

private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string Conn = "Data Source=srv-db-02;Initial Catalog=rmsmasterdbtest;Persist Security Info=True;User ID=test;Password=masterB4";
                SqlConnection Myconn = new SqlConnection(Conn);
                SqlCommand SelectCommand = new SqlCommand("select * from rmsmasterdbtest.dbo.UserLogin where Fname='" + this.txtUsernamelogin.Text + "' and passw='" + this.txtpass_Login.Text + "' ;", Myconn);

                SqlDataReader reader;
                Myconn.Open();
                reader = SelectCommand.ExecuteReader();
                int count = 0;
                while (reader.Read())
                {
                    count = count + 1;
                }
                if (count == 1)
                {
                    this.Hide();
                    frmControlusers f2 = new frmControlusers("Welcome," +txtUsernamelogin.Text);
                    f2.ShowDialog();
                }
                else if (count > 1)
                {
                    MessageBox.Show("Duplicate username and password.....access denied");
                }
                else
                    MessageBox.Show("Username and Password is Not Correct");
                Myconn.Close();
            }
            catch (Exception ex)
            { 
                MessageBox.Show(ex.Message);
            }

Open in new window

0
Comment
Question by:Moti Mashiah
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 3

Assisted Solution

by:aces4all00
aces4all00 earned 250 total points
ID: 39996386
Yes you can use LDAP based authentication against an AD domain controller.  See http://support.microsoft.com/kb/316748 for an example
0
 
LVL 1

Author Comment

by:Moti Mashiah
ID: 39996427
Thanks for this article but my app is windows form application.
0
 
LVL 10

Accepted Solution

by:
Korbus earned 250 total points
ID: 39997574
looks like you want to include and use this C# library for AD authentication: System.DirectoryServices

I actually found it in the link Peter provided, which creates a kind of wrapper around it (which I would copy/paste and use in c#), and then uses it in aspx.
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 1

Author Comment

by:Moti Mashiah
ID: 39997646
I'm using windows application form and the code peter sent is not working in this situation
0
 
LVL 10

Expert Comment

by:Korbus
ID: 39997725
Check out the IsAuthenticated function in the "Write the authentication code" section, and the explanation of it, below the code.  This is an example of how to use the System.DirectoryServices library for AD authentication in c#.  You can also look up the library on MSDN for more details.

Will need more detail on HOW it's not working to help further.
0
 
LVL 1

Author Closing Comment

by:Moti Mashiah
ID: 39999815
partly helped
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question