Wednesday, 24 July 2013

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-

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

Monday, 22 July 2013

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