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
{
}
}
}
Comments
Post a Comment