How To Login Using LinkedIN in Javascript

How To Login Using LinkedIN in Javascript ? 

How To Login To Website Using LinkedIN in Javascript ?

How To Login To Website Using LinkedIN in Asp.Net ?

How To Add Linkedin Login Button To Website ?

Step:1-

Go to Linked In Developer Network .

Step:2-

 Click On ApiKeys

Step:3-

Click On Add New Application

Step:4-

Fillup The Form

Step:5-

Step:6-

Add the following Javascript code to your webpage

<script type="text/javascript" src="http://platform.linkedin.com/in.js">

api_key: fqvj3fbvjt0

onLoad: onLinkedInLoad

authorize: true

</script>

<script type="text/javascript">

function onLinkedInLoad() {

IN.Event.on(IN, "auth", onLinkedInAuth);

}

function onLinkedInAuth() {

     IN.API.Profile("me")

  .fields(["id","firstName","lastName","pictureUrl","headline","industry","email-address","picture-urls::(original)"])

    .result(function(result) {

var indata=result.values[0];

        $('#in_name').text(indata.firstName +' '+indata.lastName);

 $('#in_cmpny').text(indata.industry);

 $('#in_deg').text(indata.headline);

$('#in_img').attr("src",indata.pictureUrls.values[0]);

$('#in_logout').show();

      });

}

$(document).ready(function(){

$('#in_logout').click(function(){

IN.User.logout();

$('#in_name').text("User Name");

 $('#in_cmpny').text("Company Name");

 $('#in_deg').text("Designation");

$('#in_img').attr("src","image/user.png");

$('#in_logout').hide();

});});

</script>

<div style="margin:5px;" ><script type="in/Login"></script></div>

    <a href="#" style="display:none;" id="in_logout">LogOut</a>

<div style="width:600px;height:300px;border:1px solid #FB8938;float:left;display:block;">

        <div style="float:left;display:block;height:300px; width:300px;margin:0 auto;" >

            <img  id="in_img" height="300" width="300" src="image/user.png" />

        </div>

        <div style="float:left;display:block;width:300px;height:300px;overflow:hidden">

<div id="dv_result" style="float:left;display:block;width:280px;height:200px;margin:80px 0 0 10px;display:none;">

                <ul style="list-style:none;" class="linkedin_class">

                    <li id="in_name" style="list-style-image:url('image/User-icon.png');">

                        User Name

                    </li>

                    <li id="in_cmpny" style="list-style-image:url('image/company_icon.png');">

                        Company Name

                    </li>

<li id="in_deg" style="list-style-image:url('image/user_logo.png');">

                        Designation

                    </li>

                </ul>

            </div>

        </div>

    </div>

    <style>

    .linkedin_class > li

    {-webkit-box-shadow: 0 0 5px#888;

box-shadow: 0 0 5px #888;

-moz-border-radius: 10px;

-webkit-border-radius: 10px;

border-radius: 10px; 

-khtml-border-radius: 10px;

list-style: none;

padding:10px;

margin:2px;

font-style:italic;

font-weight:bolder;

color:#FB8938;

        }

    </style>

Reference linkedin-javascript-api-soup-to-nuts

How To Read Data From Csv File in C#

How To Read Data From Csv File in C# ?
How To Read Data From Csv File in Asp.net ?
How To Read Data From Csv File in using Odbc ?

I am going to show you how to read a CSV File in C# ,Asp.net .Just Follow the following steps.

Step : -1

Create a webform which contains one FileUpload ,Button and a Gridview

<asp:FileUpload ID="fu_csv" runat="server" />
<asp:Button ID="btn_Upload" runat="server" Text="Upload" OnClick="btn_Upload_Click"/>

<asp:GridView ID="gv_csv" runat="server" HeaderStyle-BackColor="BurlyWood"></asp:GridView>

Step :-2

Then Go to Code behind and write the following Code

protected void btn_Upload_Click(object sender, EventArgs e) 
        {
            fu_csv.SaveAs(Server.MapPath("~/upload/") + fu_csv.FileName);
           string csv_path = Server.MapPath("~/upload/") + fu_csv.FileName;
            ReadCVS( Server.MapPath("~/upload/"),fu_csv.FileName);
        }
        public void ReadCVS(string dir_path,string filename)
        {
            DataSet ds = new DataSet();
            try
            {
                // Creates and opens an ODBC connection
                string ConnString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + dir_path + ";Extensions=asc,csv,tab,txt;Persist Security Info=False";
                string qry_select;
                OdbcConnection conn;
                conn = new OdbcConnection(ConnString.Trim());
                conn.Open();
                qry_select= "select * from [" + filename + "]";
                //Creates the data adapter
                OdbcDataAdapter oledb_da = new OdbcDataAdapter(qry_select, conn);
  
                //Fills records to the Dataset from CSV file
                oledb_da.Fill(ds, "csv_data");
  
                //closes the connection
                conn.Close();
                gv_csv.DataSource = ds.Tables["csv_data"].DefaultView;
                gv_csv.DataBind();
            }
            catch (Exception e) //Error
            {
            }

         }

See Live Demo 

Load CSV file:

How to Read data From Excel Sheet in Asp.net

How to Read data From Excel Sheet in Asp.net?

How to Read data From Excel Sheet in C# ?

Step-1:

Download Jet Driver and Microsoft Access database Engine  and Install it to your computer. 

Step -2 :

Create a File Upload Control and a Button

<div style="width:100%;">

<asp:FileUpload ID="fu_Excel" runat="server" />

<asp:Button ID="btn_Upload" runat="server" Text="Upload" onclick="btn_Upload_Click"/>

<asp:Label ID="lbl_Error" runat="server"/>

</div>

<div style="width:100%;">

 <asp:GridView ID="gv_Data" runat="server" RowStyle-BackColor="Aqua" HeaderStyle-BackColor="Bisque" HeaderStyle-Font-Bold="true"></asp:GridView>

</div>

Step-3: 

Write the following Code in your Code Behind file

protected void btn_Upload_Click(object sender,EventArgs e)

{

string FileName = fu_Excel.PostedFile.FileName;

if (Path.GetExtension(FileName) == ".xls" || Path.GetExtension(FileName) == ".xlsx")

        {

fu_Excel.SaveAs(Server.MapPath("~/upload/"));

              string connectString = string.Empty;

             if (Path.GetExtension(FileName) == ".xls")

               connectString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/upload/"+FileName) + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=0\"";

              else if (Path.GetExtension(FileName) == ".xlsx")

                    connectString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/upload/"+FileName) + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";

                        OleDbConnection con = new OleDbConnection(connectString);

                        con.Open();

 OleDbDataAdapter adpt = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", con);

                        string col = "";

                        DataTable dtab = new DataTable();

                        adpt.Fill(dtab);

gv_Data.DataSource=dtab.DefaultView;

gv_Data.DataBind();

                }

                catch (Exception ex)

                {

                }

                

            }

else

lbl_Error.Text="Invalid File";

return;

}

How To Connect To MySql Database in Asp.Net

How To Connect To MySql Database in Asp.Net ?
Connect To MySql Database in C# ?

Here I am going to Show how to Connect to mysql database using C#.

Step-1:

Just click link and down load the mysql connecter and install it in your computer.

Step-2:

After Installing go to your solution area of your project

Step-3:

Right Click on References and click on add Reference

 Step-4:
Choose .Net tab on the popup dialogue box

Step-5:
Choose Mysql.Data and press Ok

Step-6:
After That Mysql connecter will be added to project refrence

Step - 7:
Write Your Code to access the MySql Database

<form id="form1" runat="server"> 
    <asp:GridView ID="gv_Data" runat="server" RowStyle-BackColor="Aqua" HeaderStyle-BackColor="Bisque" HeaderStyle-Font-Bold="true"></asp:GridView>

  </form> 

Step-8:

protected void Page_Load(object sender, EventArgs e)
{
 MySqlConnection con = new MySqlConnection("Server=localhost;DataBase=Demo;User=root;password=");
            con.Open();
            MySqlDataAdapter adpt = new MySqlDataAdapter("SELECT member_id,first_name FROM tbl_member", con);
            DataSet ds = new DataSet();
            adpt.Fill(ds);
            gv_Data.DataSource = ds.Tables[0].DefaultView;

            gv_Data.DataBind();
}

Result

ASP.Net State management

What is State Management?

State management is the process by which you maintain state and page information over multiple requests for the same or different pages.

ASP.NET includes several options that help you preserve data on both a per-page basis and an application-wide basis.

Types of State Management

There are two basic types of State Management:

1.       Client-Based State Management

2.       Server-Based State Management

Client-Based State Management:

Client based state management techniques stores data on the client in various ways. Client based state management techniques are:

A.      View state

B.      Control state

C.      Hidden fields

D.      Cookies

E.       Query strings

View state:

The view state represents the state of the page when it was last processed on the server. It's used to build a call context and retain values across two successive requests for the same page. By default, the state is persisted on the client using a hidden field added to the page and is restored on the server before the page request is processed.

If the amount of data stored in the ViewState() property exceeds the specified value in the MaxPageStateFieldLength()property, multiple hidden fields are used to store View state data.

Ex:- ViewState["DotnetHelper"]="dotnetdoctorbikram.blogspot.com";

Advantages: 

    

a)      Server resources not required.

b)      Simple implementation

c)       automatic retention of page and control state

d)      Enhanced security features. The values in view state are hashed, compressed, and encoded for Unicode implementations.

Disadvantages:

a)      Scope is limited to only single page.

b)      Performance. The view state is stored in the page itself, so increase the page size.

c)       Security. The view state is stored in a hidden field on the page. Although view state stores data in a hashed format, it can be tampered with.

Control state:

If you create a custom control that requires view state to work properly, you should use control state to ensure your control work properly though developers disable view state. The ControlState() property allows you to persist property information that is specific to a control and cannot be turned off like the ViewState() property.

Advantages:

   

a)      Server resources not required.

b)      Reliable. Because control state can not be turned off like ViewState.

Disadvantages:

a)      Some programming is required.

Hidden Fields:

A hidden field acts as a repository for any page-specific information that you want to store directly in the page. ASP.NET allows you to store information in a HiddenField control, which renders as a standard HTML hidden field. A hidden field does not render visibly in the browser.

You must submit the page using an HTTP POST command in order for hidden-field values to be available.

Ex: <asp:HiddenField ID="DotnetHelper" Value="dotnetdoctorbikram.blogspot.com" runat="server"/>

Advantages:      

a)      Server resources not required.

b)      Simple implementation

c)       Widespread support.

Disadvantages:

a)      Potential security risk.

b)      Performance. The hidden fields are stored in the page itself, so increase the page size.

c)       Does not support rich data types to store.

Cookies:

A cookie is a small amount of data that is stored either in a text file on the client file system or in-memory in the client browser session. Browser sends with cookies values with every page request to the same server. Cookies can be temporary or persistent.

Ex: Response.Cookies.Add(new HttpCookie("DotnetHelper","dotnetdoctorbikram.blogspot.com"))

Advantages:

    

a)      Server resources not required.

b)      Simple implementation

c)       Configurable expiration rules

d)      Data persistent.

Disadvantages:

e)      Size limitation: Most browsers support maximum 4096 bytes cookies.

f)       User configuration refusal: User can disable cookies in their browser.

g)      Security risk: Can be tempered.  

Query strings:

A query string is information that is appended to the end of a page URL. Query strings provide a simple but limited way to maintain state information.  Some browsers and client devices impose a 2083 character limit on the length of the URL.

You must submit the page using an HTTP POST command in order for query string values to be available.

Ex: Request.QueryString["DotnetHelper"]

Advantages:

    

h)      Server resources not required.

i)        Simple implementation

j)        Widespread support.

Disadvantages:

k)      Size limitation: Some browser limits 2083 chars on the length of URLs.

l)        Security risk: Information is visible to the user. 

Server-Based State Management:

Server based state management techniques store data in memory on the server.  Server based state management techniques are:

A.      Application state

B.      Session state

C.      Profile Properties

Application state:

Application state provides a method of storing data global to whole application. These data are visible to entire application and shared by all active sessions. That’s why Application state variables are global variables for an ASP.Net application.

Ex: Application["DotnetHelper"] = "dotnetdoctorbikram.blogspot.com";

Advantages:

m)    Simple implementation

n)      Application wide scope

Disadvantages:

o)      Application scope in case of Web Garden or Web Firm.

p)      Limited Durability of data.

q)      Requires server memory.

Session state:

Session state provides a method of storing session specific information that is visible only within the session.

Ex: Session["DotnetHelper"] = "dotnetdoctorbikram.blogspot.com"

Advantages:     

r)       Simple implementation

s)       Session specific events

t)       Data can persists across multiple process

Disadvantages:

u)      Application scope

v)      Limited Durability of data.

w)    Requires server memory