September 28, 2018 11:17 by
PeterIn this blog, I will show you how to Insert Data using Uploading Excel file and upload image and set water mark. Let's write the code below.
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
DataTable dt = new DataTable();
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
{
}
}
HostForLIFE.eu ASP.NET Core 2.2.1 Hosting
European best, cheap and reliable ASP.NET hosting with instant activation. HostForLIFE.eu is #1 Recommended Windows and ASP.NET hosting in European Continent. With 99.99% Uptime Guaranteed of Relibility, Stability and Performace. HostForLIFE.eu security team is constantly monitoring the entire network for unusual behaviour. We deliver hosting solution including Shared hosting, Cloud hosting, Reseller hosting, Dedicated Servers, and IT as Service for companies of all size.
