This is a simple application which allow user to sign up using his/her LinkedIn Account. And after successfully signing in save some of the user details in the database.
- Create a ASP.NET Page.
- Create a LinkedIn Application.
Here are the steps to create this application.
Create an ASP.NET Page
Create a blank ASP.NET website, run it and copy its URL.
Create a LinkedIn Application
- Before moving further you should have a LinkedIn account. If not create it.
- Visit the following link: https://www.linkedin.com/developer/apps.
- Here you will find all your apps if you already have any apps like the following image.
![]()
As you see I have an app Test Users.
Now click create application and it will look like the following image:
See the following image:
![]()
After that it will redirect you to the authentication page and you can find your
Client Id(api_key) and Client Secret.
On Default Application Permissions check r-emailAddress if you want to save User EmailId.
Go to JavaScript, give your website url, click add and update like the following image:
![]()
- I have used JavaScript SDK.
- Below are my codes follow the comments for better understanding.
- Copy the code in .aspx Page.
- In api_key provide your own Client ID.
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head runat="server">
-
- <title>Linkedin User Details</title>
-
- <script type="text/javascript" src="//platform.linkedin.com/in.js">
- api_key: 75zd01h5j2597m //Add your own Client ID
- authorize: true
- onLoad: onLinkedInLoad
- </script>
-
-
- <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js">
- </script>
-
-
- <script type="text/javascript">
-
- function onLinkedInLoad() {
- IN.Event.on(IN, "auth", getDetails);
- }
- function getDetails() { // Getting required details
- IN.API.Profile("me")
- .fields("firstName", "lastName", "industry", "current-share", "location:(name)", "picture-url", "headline", "summary", "num-connections", "public-profile-url", "distance", "positions", "email-address", "educations", "date-of-birth")
- .result(displayProfiles)
- .error(displayProfilesErrors);
- }
- function displayProfiles(data) {
- console.log(data); // See the log in your browser you can find all the data
- var details = data.values[0];
- var user = {};
- user.FName = details.firstName; // FName as per my User Class in .cs page
- user.LName = details.lastName;
- user.Email = details.emailAddress;
- user.FunctionalArea = details.industry;
- $.ajax({ // Ajax call to save user details
- type: "Post",
- contentType: "application/json; charset=utf-8",
- url: "Default.aspx/SaveUser", // Default.aspx is my page and SaveUser is my WebMethod.
- data: '{objUserdtl: ' + JSON.stringify(user) + '}',
- success: function () {
- alert("Data Added Successfully.");
- }, error: function () {
- alert("Some error encountered.");
- }
- });
- }
- function displayProfilesErrors(error) {
- console.log(error);
- }
- </script>
-
- </head>
- <body>
- <form id="form1" runat="server">
- <div>
-
- <script type="in/Login">
- Login
- </script>
-
- </div>
- </form>
- </body>
- </html>
Create Table in
SQL to save data in the database. I have taken only some columns.
- CREATE TABLE [dbo].[Userdetails]
- (
- [UserId] [int] IDENTITY(1,1) NOT NULL,
- [FName] [varchar](50) NULL,
- [LName] [varchar](50) NULL,
- [Email] [varchar](50) NULL,
- [FunctionalArea] [varchar](50) NULL,
- [CreatedDateTime] [datetime] NULL
- )
In my
Web.Config I have provided connection string as in the following code snippet:
- <connectionStrings>
- <add name="Linkedin" connectionString="Data Source=local;Initial Catasign-up-users-using-linkedin-and-save-users-detail=Demo;User ID=sa;Password=Admin;" providerName="System.Data.SqlClient" />
- </connectionStrings>
My
Default.aspx.cs page.
- public partial class Default : System.Web.UI.Page
- {
- public static string Constr = ConfigurationManager.ConnectionStrings["Linkedin"].ConnectionString; // Connection string
- protected void Page_Load(object sender, EventArgs e)
- {
-
- }
- [WebMethod]
- public static void SaveUser(User objUserdtl)
- {
- try
- {
- using (var con = new SqlConnection(Constr))
- {
- using (var cmd = new SqlCommand("INSERT INTO Userdetails VALUES(@Fname,@Lname,@Email,@FunctionalArea,@CreatedDate)"))
- {
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@Fname", objUserdtl.FName);
- cmd.Parameters.AddWithValue("@Lname", objUserdtl.LName);
- cmd.Parameters.AddWithValue("@Email", objUserdtl.Email);
- cmd.Parameters.AddWithValue("@FunctionalArea", objUserdtl.FunctionalArea);
- cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
- cmd.Connection = con;
- con.Open();
- cmd.ExecuteNonQuery();
- con.Close();
- }
- }
- }
- catch (Exception ex)
- {
- throw;
- }
- }
- }
-
- public class User
- {
- public int UserId;
- public string FName;
- public string LName;
- public string Email;
- public string FunctionalArea;
- public DateTime CreatedDateTime;
- }
Now if you run the code you will see the following button:
On click of this button you will get the following popup window asking for your LinkedIn EmailId and Password:
Give your details and click Allow access.
See your console response you will find the details as I am also showing all the data in console.sign-up-users-using-linkedin-and-save-users-detail (data) in Ajax.
Now see your database, the data has been added in your database. You can provide your desired condition for not storing multiple times data for same user.
Note
- I have taken my page as Default.aspx and SaveUser is my method for ajax call. Any change in page name and Method has to change in Ajax.
- If you run the attached project it will open my apps that I have created in LinkedIn. I suggest you to create your own.
Hope that helps you.
Please add comments you you find any difficulties while building this application.