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
{
}
}
}
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
{
}
}
}
No comments:
Post a Comment