Showing posts with label asp.net using c#. Show all posts
Showing posts with label asp.net using c#. Show all posts
Monday, 10 March 2014
Tuesday, 4 March 2014
Save Image From Database to File/Folder in Your PC
Save Image File From Database to File/Folder in Your PC Using "ASP.NET"(C#)
The below some lines of code (using C# programming) will help you to save any image file from database to your Computer :
//Write this code on Event Handler
private void button1_Click(object sender, EventArgs e)
{
con.Open();
dt = new DataTable();
adp = new SqlDataAdapter("SELECT ID,PICTURE FROM GOOGLEAPITEST", con);
adp.Fill(dt);
con.Close();
con.Dispose();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
byte[] data = (byte[])dt.Rows[i]["PICTURE"];
MemoryStream ms = new MemoryStream(data);
pictureBox1.Image = Image.FromStream(ms);
SaveFileDialog sfdlg = new SaveFileDialog();
sfdlg.Title = "Save Dialog";
sfdlg.Filter = "Bitmap Images (*.bmp)|*.bmp|All files(*.*)|*.*";
if (sfdlg.ShowDialog(this) == DialogResult.OK)
{
using (Bitmap bmp = new Bitmap(pictureBox1.Width, pictureBox1.Height))
{
pictureBox1.DrawToBitmap(bmp, new Rectangle(0, 0, bmp.Width, bmp.Height));
pictureBox1.Image = new Bitmap(pictureBox1.Width, pictureBox1.Height);
pictureBox1.Image.Save("c://cc.Jpg");
bmp.Save(sfdlg.FileName);
MessageBox.Show("Saved Successfully.....");
}
}
}
}
That's IT
Monday, 24 February 2014
Here you'll learn how to create a PDF File using C#
learn how to create a PDF File using C#
steps are as below:
void CreatePDF()
{
try
{
string path = Server.MapPath("Attatchment PDF");
/*Logo Path*/
string Invoiceid = ;
string strLogoPath = Server.MapPath("Image") + "\\jayendra.jpg";
Document doc = new Document(PageSize.LETTER, 25F, 25F, 50F, 25F);
PdfWriter.GetInstance(doc, new FileStream(path + "/Font.pdf", FileMode.Create));
doc.Open();
iTextSharp.text.Rectangle page = doc.PageSize;
iTextSharp.text.Font Verdana = FontFactory.GetFont("Verdana", 10F, iTextSharp.text.Font.NORMAL,iTextSharp.text.Color.BLACK);
PdfPTable table = new PdfPTable(2);
table.TotalWidth = page.Width;
PdfPCell cell = new PdfPCell();
cell.Colspan = 3;
cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right
iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(strLogoPath);
AddImageInCell(cell, image, 200f, 200f, 1);
cell.Border = 0;
AddtextCell(table, cell, 0, 0, 0);
PdfPCell cell2 = new PdfPCell();
PdfPTable table2 = new PdfPTable(1);
PdfPCell line_2 = new PdfPCell(new Phrase("Name: Gohil Jayendrasinh F", Verdana));
AddtextCell(table2, line_2);
PdfPCell line_3 = new PdfPCell(new Phrase("Email: jayendrasinhgohil@gmail.com", Verdana));
AddtextCell(table2, line_3);
PdfPCell line_4 = new PdfPCell(new Phrase("Compny Name: SIGMASOLVE LLC", Verdana));
AddtextCell(table2, line_4);
cell2.AddElement(table2);
cell2.Border = 0;
AddtextCell(table, cell2, 0, 0, 0);
doc.Add(table);
doc.Close();
}
catch (Exception)
{
throw;
}
}
private static void AddImageInCell(PdfPCell cell, iTextSharp.text.Image image,float fitWidth,float fitHight,int Alignment)
{
image.ScaleToFit(fitWidth, fitHight);
image.Alignment = Alignment;
cell.AddElement(image);
}
private void AddtextCell(PdfPTable table, PdfPCell cell)
{
cell.Colspan = 3;
cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right
cell.Border = 0;
table.AddCell(cell);
}
private void AddtextCell(PdfPTable table, PdfPCell cell, float paddingLeft,float paddingRight)
{
cell.Colspan = 3;
cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right
cell.PaddingLeft = paddingLeft;
cell.PaddingRight = paddingRight;
cell.Border = 0;
table.AddCell(cell);
}
private void AddtextCell(PdfPTable table, PdfPCell cell, float paddingLeft, float paddingRight,int hAlign)
{
cell.Colspan = 3;
cell.HorizontalAlignment = hAlign; //0=Left, 1=Centre, 2=Right
cell.PaddingLeft = paddingLeft;
cell.PaddingRight = paddingRight;
cell.Border = 0;
table.AddCell(cell);
}
private static void AddtextCell(PdfPTable table, PdfPCell cell, int Colspan, int HorizontalAlignment, int Border)
{
cell.Colspan = Colspan;
cell.HorizontalAlignment = HorizontalAlignment; //0=Left, 1=Centre, 2=Right
cell.Border = Border;
table.AddCell(cell);
}
After write these methods and events call these where you want to create PDF file.
Check out my other Blogs Here:click on this link:
http://integratedskillsofdotnet.blogspot.in/
http://computerknowledgehacking.blogspot.in/
Subscribe to:
Posts (Atom)