SharePoint

Showing posts with label how to check if an email address already exists in the database in asp.net. Show all posts

Add prefix to the phone no column in SharePoint using JavaScript/JQuery

In this article we are able to see how to add prefix to the phone no in SharePoint list column using JavaScript.

enter only numbers in text box in SharePoint
Generate unique id in SharePoint using jQuery/JavaScript
How to populate today’s date using JQuery in SharePoint
We are having a column with name Phone no, whenever we enter the number in that text box, once we click on save button, in the display form we can able to see the value like Call:987XXX3210.

We adding extent Call prefix before the Phoneno, we writing the code in PreSaveAction.

how to export data from gridview to Excel in asp.net using c#

Phani Kumar 13:22 Add Comment

how to export data from gridview to Excel in asp.net using c#

I will explain how to export data from gridview to Excel in asp.net using c#.

I created a database with table name EmployeeInfo as shown.

USE [chinnu]

/****** Object: Table [dbo].[EmployeeInfo] Script Date: 10/29/2013 00:13:10 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[EmployeeInfo](

[EmpId] [nvarchar](50) NOT NULL,

[EmpName] [nvarchar](50) NOT NULL,

[EmpAddress] [nvarchar](50) NOT NULL,

[EmpDesignation] [nvarchar](50) NOT NULL

) ON [PRIMARY]

In Default.aspx I am adding GridView and ImageButton as Shown.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="file_conversion._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>

</title>

</head>

<body>

<asp:GridView ID="gridview" runat="server" AutoGenerateColumns="False" >

<asp:BoundField DataField="EmpId" HeaderText="EmployeeId" InsertVisible="False"

<asp:BoundField DataField="EmpName" HeaderText="EmployeeName" InsertVisible="False"

<asp:BoundField DataField="EmpAddress" HeaderText="EmployeeAddress" />

<asp:BoundField DataField="EmpDesignation" HeaderText="EmployeeDesignation" />

</Columns>

</asp:GridView>

<asp:ImageButton ID="ImageButton1" runat="server" ToolTip ="Click To Export Excel Format" ImageUrl="Scripts/download (1).jpg" Width="32px" Height="32px"

OnClick="btnexcel_Click" />

</form>

</body>

</html>

Add iTextSharp DLL.

Now I am writing the logic in Default.aspx.cs to export gridview data in to Excel format as shown.

using System;

using System.Configuration;

using System.Data;

using System.IO;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using iTextSharp.text;

using iTextSharp.text.pdf;

using iTextSharp.text.html.simpleparser;

using System.Data.SqlClient;

namespace file_conversion

{

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridData();

}

private void BindGridData()

{

try

{

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connstring"].ConnectionString))

{

SqlCommand command = new SqlCommand("SELECT * from EmployeeInfo", con);

SqlDataAdapter da = new SqlDataAdapter(command);

DataTable dt = new DataTable();

da.Fill(dt);

gridview.DataSource = dt;

gridview.DataBind();

}

catch (Exception ex)

{

}

protected void btnexcel_Click(object sender, ImageClickEventArgs e)

{

string attachment = "attachment; filename=ExportData.xls";

Response.ClearContent();

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

HtmlForm frm = new HtmlForm();

gridview.Parent.Controls.Add(frm);

frm.Attributes["runat"] = "server";

frm.Controls.Add(gridview);

frm.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

In web.config I am adding the ConnectionString

</connectionStrings>

Now Press F5.

OutPut:

Unknown 14:11 9 Comments

In this article I will explain you how to generate random password in asp.net using c#.
Create one method and call that method in Insert mode or update mode. It generate random password.

Check the below code Example How to use.

 public static string CreateRandomPassword(int PasswordLength)
        {
            string _allowedChars = "0123456789abcdefghijkmnopqrstuvwxyzABCDEFGHJKLMNOPQRSTUVWXYZ";
            Random randNum = new Random();
            char[] chars = new char[PasswordLength];
            int allowedCharCount = _allowedChars.Length;
            for (int i = 0; i < PasswordLength; i++)
            {
                chars[i] = _allowedChars[(int)((_allowedChars.Length) * randNum.NextDouble())];
            }
            return new string(chars);
        }

call this method in Insert mode or update mode,based upon your requirement.

If you give 8 meants it will show like this ZeXdjOdx

string pwd = CreateRandomPassword(8);

how to send username and password to email in asp.net

Unknown 13:58 Add Comment

In this article I will explain how to send User id and password,when your are inserting the data first tie it will generate Password,it will sent mail to that Email id.

Add Name Space: using System.Net.Mail;


 public void sendingUidPwd(String Uid, String pwd)
        {
            try
            {
                MailMessage objeto_mail = new MailMessage();
                SmtpClient client = new SmtpClient();
                client.Port = 25;
                client.Host = "smtp.gmail.com";
                client.DeliveryMethod = SmtpDeliveryMethod.Network;
                client.UseDefaultCredentials = false;
                client.Credentials = new System.Net.NetworkCredential("yourmailid@gmail.com", "12345687");
                client.EnableSsl = true;
                objeto_mail.From = new MailAddress("yourmailid@gmail.com");
                objeto_mail.To.Add(new MailAddress(Uid));
                objeto_mail.Subject = "Your User ID and Password ";
                //objeto_mail.CC.Add(new MailAddress("phaniraavi@gmail.com"));
                objeto_mail.Body = "\n\nYour User ID and Password From RaaviChinnu.\n\n UserID : " + Uid + "\n\n Password : " + pwd;
                client.Send(objeto_mail);
            }
            catch (Exception)
            {
                
                
            }
        }

Call this method in Insert Method.

sendingUidPwd(txtEmailID.Text, pwd);

It will work :)

how to check if an email address already exists in the database in asp.net

Unknown 11:42 71 Comments

In this article we can see how to find exiting email id from data base and it will display error message if it already exits
We created a method with name uniqueEmail.
Established a connection to the database.
Getting the data from the table aspnet_Membership.
Using the ExecuteReader to read the values and checking the condition weather email id is already exists or not.

   public bool uniqueEmail()
        {
            
                string iemail;
                string constr = ABCDataAccessLayer.ABCConnctionString; // connection string
                SqlConnection con = new SqlConnection(constr);
                con.Open();
                string query = "select count(Email) as Email  from aspnet_Membership where Email= '" + txtEmailID.Text + "'";
                SqlCommand cmd = new SqlCommand(query, con);
                SqlDataReader dr;
                dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    iemail = dr["Email"].ToString();
                    if (iemail != "0")
                    {
                        mailerror.Text = "Enter different email id";
                        return false;
                    }
                   
                }

                return true;
            
        }

Keep if condition,if you want to check email in insert mode or update mode
if (uniqueEmail())
{
Insert Code logic //
or
Update Code Logic
}

Output:

how to populate values in dropdownlist from database using asp.net

Unknown 12:22 Add Comment

In this article we can able to see how to Populate values in to drop down from Data Base using asp.net

 public void loadDdlRoles()
        {

            string constr = ConfigurationManager.ConnectionStrings["DConnectionString"].ToString(); // connection string
            SqlConnection con = new SqlConnection(constr);
            con.Open();

            SqlCommand com = new SqlCommand("select *from dbo.aspnet_Roles", con); // table name 
            SqlDataAdapter da = new SqlDataAdapter(com);
            DataSet ds = new DataSet();
            da.Fill(ds);  // fill dataset
            DdlRoles.DataValueField = ds.Tables[0].Columns["RoleName"].ToString();             // to retrive specific  textfield name 
            DdlRoles.DataSource = ds.Tables[0];      //assigning datasource to the dropdownlist
            DdlRoles.DataBind();  //binding dropdownlist


        }

Don't Forget to call that method in Page load

 protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                loadDdlRoles();
          }

        }

Keep always Smile:)

Add prefix to the phone no column in SharePoint using JavaScript/JQuery

how to export data from gridview to Excel in asp.net using c#

how to generate random password in asp.net using c#

how to send username and password to email in asp.net

how to check if an email address already exists in the database in asp.net

how to populate values in dropdownlist from database using asp.net

Labels