Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

C# user app

Posted on 2014-04-12
6
Medium Priority
?
229 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 750 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 750 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

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!
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

705 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