Post
Ask Question

Import Emails From Gmail In ASP.NET

In this blog, learn how to import gmail data (email id from gmail) in ASP.NET. You must provide a gmail account (user id and password) to authenticate. The code uses Google Data API.
 
Step 1: Download the latest version of Google_Data_API_Setup_2.1.0.0.msi and install to your machine from
https://code.google.com/p/google-gdata/downloads/list. Make sure the find the right location and version of the msi. The location of the download may have moved.
 
Step 2: Create a Web Application in Visual Studio and design a page. Here is my .aspx page look like.   
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="import_gmail.aspx.cs" Inherits="import_gmail" %>  
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  3. <html xmlns="http://www.w3.org/1999/xhtml">  
  4. <head id="Head1" runat="server">  
  5. <title></title>  
  6. <style type="text/css">  
  7. .style1  
  8. {  
  9. width: 100%;  
  10. }  
  11. </style>  
  12. </head>  
  13. <body>  
  14. <form id="form1" runat="server">  
  15. <div style="height: 100px; background-color: #808080">  
  16. </div>  
  17. <div align="center">  
  18. <table class="style1">  
  19. <tr>  
  20. <td>  
  21.  </td>  
  22. <td>  
  23.  </td>  
  24. <td>  
  25.  </td>  
  26. <td>  
  27.  </td>  
  28. </tr>  
  29. <tr>  
  30. <td>  
  31.  </td>  
  32. <td>  
  33. Enter your Gmail id</td>  
  34. <td>  
  35. <asp:TextBox ID="txt_email" runat="server" Width="250px"></asp:TextBox>  
  36. <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"  
  37. ControlToValidate="txt_email" ErrorMessage="*"></asp:RequiredFieldValidator>  
  38. </td>  
  39. <td>  
  40.  </td>  
  41. </tr>  
  42. <tr>  
  43. <td>  
  44.  </td>  
  45. <td>  
  46. Enter your Gmail Password</td>  
  47. <td>  
  48. <asp:TextBox ID="txtpass" runat="server" TextMode="Password" Width="250px"></asp:TextBox>  
  49. <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"  
  50. ControlToValidate="txtpass" ErrorMessage="*"></asp:RequiredFieldValidator>  
  51. </td>  
  52. <td>  
  53.  </td>  
  54. </tr>  
  55. <tr>  
  56. <td>  
  57.  </td>  
  58. <td align="right">  
  59. <asp:Button ID="Button1" runat="server" onclick="Button1_Click"  
  60. Text="Get List" />  
  61. </td>  
  62. <td>  
  63.    
  64. <asp:Label ID="lbl_email_count" runat="server" Text="Label"></asp:Label>  
  65.  </td>  
  66. <td>  
  67.  </td>  
  68. </tr>  
  69. <tr>  
  70. <td>  
  71.  </td>  
  72. <td>  
  73.  </td>  
  74. <td>  
  75. <asp:GridView ID="GV_List" runat="server" EnableModelValidation="True"  
  76. PageSize="25" AutoGenerateColumns="False">  
  77. <Columns>  
  78. <asp:BoundField DataField="emailid" HeaderText="Email List" />  
  79. </Columns>  
  80. </asp:GridView>  
  81. </td>  
  82. <td>  
  83.  </td>  
  84. </tr>  
  85. <tr>  
  86. <td>  
  87.  </td>  
  88. <td>  
  89.  </td>  
  90. <td>  
  91.  </td>  
  92. <td>  
  93.  </td>  
  94. </tr>  
  95. <tr>  
  96. <td>  
  97.  </td>  
  98. <td>  
  99.  </td>  
  100. <td>  
  101.  </td>  
  102. <td>  
  103.  </td>  
  104. </tr>  
  105. </table>  
  106. </div>  
  107. </form>  
  108. </body>  
  109. </html>  
Step 3: Add Referance to four DLLs from C:\Program Files\Google\Google Data API SDK\Redist or the location where you installed Google SDK. 
  1. Google.GData.Apps.dll  
  2. Google.GData.Client.dll  
  3. Google.GData.Contacts.dll  
  4. Google.GData.Extensions.dll  
Step 4: Here is the code behind .cs file and code.
  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.Linq;  
  4. using System.Web;  
  5. using System.Web.UI;  
  6. using System.Web.UI.WebControls;  
  7. using Google.GData.Contacts;  
  8. using Google.GData.Client;  
  9. using Google.GData.Extensions;  
  10. using Google.Contacts;  
  11. using System.Data;  
  12. using System.Data.SqlClient;  
  13. public partial class import_gmail : System.Web.UI.Page  
  14. {  
  15. protected void Page_Load(object sender, EventArgs e)  
  16. {  
  17. }  
  18. public DataSet GetGmailContacts(string p_name, string e_id, string psw)  
  19. {  
  20. DataSet ds = new DataSet();  
  21. DataTable dt = new DataTable();  
  22. DataColumn dc = new DataColumn();  
  23. dc.DataType = Type.GetType("System.String");  
  24. dc.ColumnName = "emailid";  
  25. dt.Columns.Add(dc);  
  26. try  
  27. {  
  28. RequestSettings rs = new RequestSettings(p_name, e_id, psw);  
  29. rs.AutoPaging = true;  
  30. ContactsRequest cr = new ContactsRequest(rs);  
  31. Feed<Contact> f = cr.GetContacts();  
  32. foreach (Contact t in f.Entries)  
  33. {  
  34. foreach (EMail email in t.Emails)  
  35. {  
  36. DataRow dr1 = dt.NewRow();  
  37. dr1["emailid"] = email.Address.ToString();  
  38. dt.Rows.Add(dr1);  
  39. }  
  40. }  
  41. ds.Tables.Add(dt);  
  42. }  
  43. catch (Exception ex)  
  44. {  
  45. lbl_email_count.Text = "There is a Problem in Id Or Password!!!";  
  46. }  
  47. return ds;  
  48. }  
  49. protected void Button1_Click(object sender, EventArgs e)  
  50. {  
  51. getcontacts();  
  52. }  
  53. public void getcontacts()  
  54. {  
  55. DataSet ds = GetGmailContacts("Web Application!", txt_email.Text, txtpass.Text);  
  56. if (ds.Tables.Count < 1)  
  57. {  
  58. lbl_email_count.Text = "No Contacts Found!!!!";  
  59. }  
  60. else  
  61. {  
  62. lbl_email_count.Text = "Total Emails from your list :: " + ds.Tables[0].Rows.Count.ToString();  
  63. GV_List.DataSource = ds;  
  64. GV_List.DataBind();  
  65. }  
  66. }  
  67. }  
For more details and code sample, download the attached project, Zip file.
Next Recommended Reading How To Import Excel Data In SQL Server Using ASP.NET