Brijesh Solutions: April 2014

Tuesday, 29 April 2014

Send Mail with Attachment in asp.net

MailAddress SendFrom = new MailAddress("brijesh.singh879@gmail.com", "Brijesh");
MailAddress SendTo = new MailAddress("brijesh.singh879@gmail.com");
System.Net.Mail.MailMessage MyMessage = new System.Net.Mail.MailMessage(SendFrom, SendTo);
MyMessage.IsBodyHtml = true;
MyMessage.Subject = "Send Mail with attachment ";
MyMessage.Body = "Body";
if (fupResume.HasFile)
{
string FileName = Path.GetFileName(fupResume.PostedFile.FileName);
MyMessage.Attachments.Add(new Attachment(fupResume.PostedFile.InputStream, FileName));
}
System.Net.NetworkCredential authentication = new System.Net.NetworkCredential("brijesh.singh879@gmail.com", "password");
SmtpClient client = new SmtpClient("smtp.gmail.com", 25);//587
client.EnableSsl = true;
client.UseDefaultCredentials = true;
client.Credentials = authentication;
client.Send(MyMessage);

Tuesday, 8 April 2014

Directly Bind Byte[] Type Image data to Image control asp.net

Use this code for display image on both asp Image control and html img tag

<asp:Image ImageUrl='<%# "data:image/jpg;base64," + Convert.ToBase64String((byte[])Eval("IMG_DATA")) %>' />

Friday, 4 April 2014

Re-sized Image of byte[] array type in asp.net

I found the solutions of image re-sizing at run-time in asp.net

use this code to obtain re-sized image:

SqlCommand cmd = new SqlCommand("select ProductPicture from ProductDetails where Id=" + pdctid + "", con);

byte[] product = (byte[])cmd.ExecuteScalar();

MemoryStream stream = new MemoryStream(product);

Response.BinaryWrite(ResizeUploadedImage(stream));

private byte[] ResizeUploadedImage(Stream streamToResize)

{

byte[] resizedImage;

using (System.Drawing.Image orginalImage = System.Drawing.Image.FromStream(streamToResize))

{

ImageFormat orginalImageFormat = orginalImage.RawFormat;

int orginalImageWidth = orginalImage.Width;

int orginalImageHeight = orginalImage.Height;

int resizedImageWidth = 150; // Type here the width you want

int resizedImageHeight = 90; // Type here the hight you want

using (Bitmap bitmapResized = new Bitmap(orginalImage, resizedImageWidth, resizedImageHeight))

{

using (MemoryStream streamResized = new MemoryStream())

{

bitmapResized.Save(streamResized, orginalImageFormat);

resizedImage = streamResized.ToArray();

}

return resizedImage;

}

Tuesday, 1 April 2014

Export GridView Data with Image in C#.net

Write this code on .aspx page

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">

<asp:BoundField DataField="Name" HeaderText="Name" />

<asp:BoundField DataField="Job" HeaderText="Job" />

<asp:BoundField DataField="Location" HeaderText="Location" />

<asp:ImageField DataImageUrlField="Image" HeaderText="Image">

</asp:ImageField>

</Columns>

</asp:GridView>

<asp:Button ID="Button1" runat="server" Text="Export" onclick="Button1_Click" />

</div>

</form>

</body>

</html>

copy & paste this code on .cs page....

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

FillGridview();

}

private void FillGridview()

{

DataTable table = new DataTable();

table.Columns.Add("Name", typeof(string));

table.Columns.Add("Job", typeof(string));

table.Columns.Add("Location", typeof(string));

table.Columns.Add("Image");

table.Rows.Add("JP", "XXX", "QQQQ", "http://localhost:10735/WebSite2/image/sub-menu-corner.png");

table.Rows.Add("HP", "TTT", "AAAA", "http://localhost:10735/WebSite2/image/sub-menu-corner-2.png");

table.Rows.Add("SQ", "YYY", "HHHH", "http://localhost:10735/WebSite2/image/section1-bg.jpg");

table.Rows.Add("XS", "EEE", "UUUU", "http://localhost:10735/WebSite2/image/form-bg.png");

GridView1.DataSource = table;

ViewState["dt"] = table;

GridView1.DataBind();

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;

DataTable dt = (DataTable)ViewState["dt"];

GridView1.DataSource = dt;

GridView1.DataBind();

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

{

GridViewRow row = GridView1.Rows[i];

//Apply text style to each Row

row.Attributes.Add("class", "textmode");

}

GridView1.RenderControl(hw);

//style to format numbers to string

string style = @"<style> .textmode { mso-number-format:\@; } </style>";

Response.Write(style);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

}

public override void VerifyRenderingInServerForm(Control control)

{

}

Result: