Insert Data using Uploading Excel file and upload image and set water mark

Demo.aspx

<body>

    <form id="form1" runat="server">

    <div>

    <table>

    <tr>

    <td><asp:FileUpload ID ="fu" runat ="server" /></td>

    <td><asp:Button ID ="btnupload" runat ="server" Text="Upload File"

            onclick="btnupload_Click" /></td>

    </tr>

    </table>

    </div>

    </form>

</body>

Demo.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.IO;

using System.Data;

using System.Data.OleDb;

using System.Drawing;

using System.Drawing.Drawing2D;

using System.Text;

using System.Drawing.Imaging;

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

{

    DataTable dt = new DataTable();

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void btnupload_Click(object sender, EventArgs e)

    {

        if (fu.HasFile)

        {

            if (fu.PostedFile.ContentType == "application/vnd.ms-excel" || fu.PostedFile.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")

            {

                string fileName = Path.Combine(Server.MapPath("~/localization"), Guid.NewGuid().ToString() + Path.GetExtension(fu.PostedFile.FileName));

                fu.PostedFile.SaveAs(fileName);

                string conString = "";

                string ext = Path.GetExtension(fu.PostedFile.FileName);

                if (ext.ToLower() == ".xls")

                {

                    conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";

                }

                else if (ext.ToLower() == ".xlsx")

                {

                    conString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";

                }

                string query = "Select * from [Sheet1$]";

                OleDbConnection con = new OleDbConnection(conString);

                OleDbDataAdapter data = new OleDbDataAdapter(query, con);

                data.Fill(dt);

                int i = 0;

                File_Upload file = new File_Upload();

                for (i = 0; i < dt.Rows.Count; i++)

                {

                    string name = dt.Rows[i]["name"].ToString();

                    string email = dt.Rows[i]["email"].ToString();

                    string pass = dt.Rows[i]["Password"].ToString();

                    string mobile = dt.Rows[i]["mobile"].ToString();

                    string state = dt.Rows[i]["state"].ToString();

                    string city = dt.Rows[i]["city"].ToString();

                    string photo = dt.Rows[i]["Photo"].ToString();

                    string[] pathArr = photo.Split('\\');

                    string[] fileArr = pathArr.Last().Split('.');

                    string fName = fileArr[0].ToString();

                    Random rnd = new Random();

                    string fn = fName + "_" + rnd.Next(111, 999) + "_" + rnd.Next(111, 999) + ".jpg";

                    string path = "~/photo/" + fn;

                    string pat = Server.MapPath(path);

                    Wattermark w = new Wattermark();

                    Dal odal = new Dal();

                    System.Drawing.Image image = System.Drawing.Image.FromFile(photo);

                    Graphics graphics = Graphics.FromImage(image);

                    Font font = new Font("Times New Roman", 42.0f);

                    PointF point = new PointF(10, 10);

                    graphics.DrawString("Tusharsangani", font, Brushes.Red, point);

                    image.Save(pat);

                    odal.fetch("insert into Registeruser (name,E_id,password,mobile,state,city,photo) values('" + name + "','" + email + "','" + pass + "','" + mobile + "','" + state + "','" + city + "','" + path + "')");

                }

            }

        }

        else

        {

        }

    }

}