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

Tushar Sangani

9y19.6k1025Blog

10 Comments

Join the conversation! Your thoughts help the community grow.

Keval Thummar8y ago
Provide me your DAL class file code
- Tushar Sangani8y ago
  Check This in this link contain dal file Https://tusharsangani.blogspot.in/2016/09/upload-multiple-image-with-thumbline-in.html
Uday Krishna8y ago
Ya nice code but how can i remove duplicate id by uploading excel to sql in asp.net web applications.i have an idea plz tell me whether it is right or wrong.i will follow ur code and i will add submit button and in button click event i will write code to remove duplicate entries by idtell me is that correct or wrong
- Tushar Sangani8y ago
  Can you tell me brief like column name and which purpose u upload ?
Navneet Srivastava9y ago
File_Upload file = new File_Upload(); Wattermark w = new Wattermark(); Dal odal = new Dal(); . How do you get this
- Tushar Sangani9y ago
  This is my class file function
- Tushar Sangani9y ago
  File_Upload file = new File_Upload(); this function is not use this code
Chiranjeevi Aripaka9y ago
Please help me in downloading datagridview data (which contains images ) to pdf or excel in winforms using c#
- Tushar Sangani9y ago
  Sorry this type code is not available this time
Chiranjeevi Aripaka9y ago
PLEASE HELP ME IN UPLOADING IMAGES FROM EXCEL INTO DATABASE USING WINFORMS USING C#

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
{
}
}

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
<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>