Solved

C# user app

Posted on 2014-04-12
6
222 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
  • 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

895 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now