/// <summary> /// Obtiene el valor de un atributo que se encuentra en el Request de la pagina. /// Si no se encuentra el atributo regresa una cadena vacia. /// </summary> /// <param name="Request">Objeto Request de la pagina.</param> /// <param name="attributeName">Nombre del atributo del cual se desea obtener su valor.</param> /// <returns>Regresa el valor del atributo, en caso de no existir retorna una cadena vacia.</returns> public static string getAttribute(System.Web.HttpRequest Request, string attributeName) { string attributeValue=""; try { attributeValue = Request.QueryString[attributeName]; if(attributeValue==null || attributeValue.Trim().Equals("")==true) attributeValue = ""; } catch{} return attributeValue; }
Exportar a Excel
public static void DT2xls(System.Web.HttpResponse Response, DataTable dt) { // exportar a xls Response.Clear(); Response.Buffer= true; Response.AddHeader("Content-Disposition", "attachment; filename=Export.xls"); Response.ContentType = "application/vnd.ms-excel"; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); System.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid(); dg.DataSource = dt; dg.DataBind(); dg.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter); Response.End(); }
Para consola
Public Sub htmlExport() Dim gvEx As New System.Web.UI.WebControls.GridView gvEx.AutoGenerateColumns = True gvEx.AllowSorting = False gvEx.AllowPaging = False Dim stringWrite As New System.IO.StringWriter Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite) gvEx.DataSource = Me.DataSource gvEx.DataBind() gvEx.RenderControl(htmlWrite) WriteFile(Me.FileName, stringWrite.ToString()) End Sub
Usando excel
Public Sub ExcelExport() Dim oexcel As Excel.Application Try If File.Exists(FileName) Then File.Delete(FileName) 'create new excel application oexcel = CreateObject("Excel.Application") oexcel.Application.DisplayAlerts = True 'add a new workbook 'obook = oexcel.Workbooks.Open(FileName) Dim obook As Excel.Workbook = oexcel.Workbooks.Add() Dim ws As Excel.Worksheet = obook.Sheets(1) ' Add each row of data to the sheet. ' The sheet cell row is incremented by one because the first row was used for the header. For rowIndex As Integer = 1 To DataSource.Rows.Count For colIndex As Integer = 1 To DataSource.Columns.Count TryCast(ws.Cells(rowIndex + 1, colIndex), Excel.Range).Value2 = DataSource.Rows(rowIndex - 1)(colIndex - 1).ToString() Next Next ' Create the headers on the sheet. For colIndex As Integer = 1 To DataSource.Columns.Count TryCast(ws.Cells(1, colIndex), Excel.Range).Value2 = DataSource.Columns(colIndex - 1).ColumnName TryCast(ws.Cells(1, colIndex), Excel.Range).Font.Bold = True TryCast(ws.Cells(1, colIndex), Excel.Range).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter TryCast(ws.Cells(1, colIndex), Excel.Range).EntireColumn.AutoFit() Next oexcel.Visible = False If Password <> "" Then obook.SaveAs(FileName, Excel.XlFileFormat.xlWorkbookNormal, Password, Nothing, False, False, Excel.XlSaveAsAccessMode.xlExclusive, False, False, Nothing, Nothing) Else obook.SaveAs(FileName) End If 'end application object and session obook.Close() obook = Nothing oexcel.Quit() oexcel = Nothing Catch ex As Exception Throw New System.Exception(ex.Message) Finally End Try End Sub
static System.Drawing.Image FixedSize(System.Drawing.Image imgPhoto, int Width, int Height) { int sourceWidth = imgPhoto.Width; int sourceHeight = imgPhoto.Height; int sourceX = 0; int sourceY = 0; int destX = 0; int destY = 0; float nPercent = 0; float nPercentW = 0; float nPercentH = 0; nPercentW = ((float)Width/(float)sourceWidth); nPercentH = ((float)Height/(float)sourceHeight); if(nPercentH < nPercentW) { nPercent = nPercentH; destX = System.Convert.ToInt16((Width - (sourceWidth * nPercent))/2); } else { nPercent = nPercentW; destY = System.Convert.ToInt16((Height - (sourceHeight * nPercent))/2); } int destWidth = (int)(sourceWidth * nPercent); int destHeight = (int)(sourceHeight * nPercent); Bitmap bmPhoto = new Bitmap(Width, Height, PixelFormat.Format24bppRgb); bmPhoto.SetResolution(imgPhoto.HorizontalResolution, imgPhoto.VerticalResolution); Graphics grPhoto = Graphics.FromImage(bmPhoto); grPhoto.Clear(Color.Transparent); grPhoto.InterpolationMode = InterpolationMode.HighQualityBicubic; grPhoto.DrawImage(imgPhoto, new Rectangle(destX,destY,destWidth,destHeight), new Rectangle(sourceX,sourceY,sourceWidth,sourceHeight), GraphicsUnit.Pixel); grPhoto.Dispose(); return bmPhoto; }
private System.Drawing.Image PutWaterMark(System.Drawing.Image imgPhoto, System.Drawing.Image imgWatermark, string Copyright) { int phWidth = imgPhoto.Width; int phHeight = imgPhoto.Height; //create a Bitmap the Size of the original photograph Bitmap bmPhoto = new Bitmap(phWidth, phHeight, PixelFormat.Format24bppRgb); bmPhoto.SetResolution(imgPhoto.HorizontalResolution, imgPhoto.VerticalResolution); //load the Bitmap into a Graphics object Graphics grPhoto = Graphics.FromImage(bmPhoto); //create a image object containing the watermark int wmWidth = imgWatermark.Width; int wmHeight = imgWatermark.Height; //------------------------------------------------------------ //Step #1 - Insert Copyright message //------------------------------------------------------------ //Set the rendering quality for this Graphics object grPhoto.SmoothingMode = SmoothingMode.AntiAlias; //Draws the photo Image object at original size to the graphics object. grPhoto.DrawImage( imgPhoto, // Photo Image object new Rectangle(0, 0, phWidth, phHeight), // Rectangle structure 0, // x-coordinate of the portion of the source image to draw. 0, // y-coordinate of the portion of the source image to draw. phWidth, // Width of the portion of the source image to draw. phHeight, // Height of the portion of the source image to draw. GraphicsUnit.Pixel); // Units of measure //------------------------------------------------------- //to maximize the size of the Copyright message we will //test multiple Font sizes to determine the largest posible //font we can use for the width of the Photograph //define an array of point sizes you would like to consider as possiblities //------------------------------------------------------- int[] sizes = new int[]{16,14,12,10,8,6,4}; Font crFont = null; SizeF crSize = new SizeF(); //Loop through the defined sizes checking the length of the Copyright string //If its length in pixles is less then the image width choose this Font size. for (int i=0 ;i<7; i++) { //set a Font object to Arial (i)pt, Bold crFont = new Font("arial", sizes[i], FontStyle.Bold); //Measure the Copyright string in this Font crSize = grPhoto.MeasureString(Copyright, crFont); if((ushort)crSize.Width < (ushort)phWidth) break; } //Since all photographs will have varying heights, determine a //position 5% from the bottom of the image int yPixlesFromBottom = (int)(phHeight *.05); //Now that we have a point size use the Copyrights string height //to determine a y-coordinate to draw the string of the photograph float yPosFromBottom = ((phHeight - yPixlesFromBottom)-(crSize.Height/2)); //Determine its x-coordinate by calculating the center of the width of the image float xCenterOfImg = (phWidth/2); //Define the text layout by setting the text alignment to centered StringFormat StrFormat = new StringFormat(); StrFormat.Alignment = StringAlignment.Center; //define a Brush which is semi trasparent black (Alpha set to 153) SolidBrush semiTransBrush2 = new SolidBrush(Color.FromArgb(153, 0, 0, 0)); //Draw the Copyright string grPhoto.DrawString(Copyright, //string of text crFont, //font semiTransBrush2, //Brush new PointF(xCenterOfImg+1,yPosFromBottom+1), //Position StrFormat); //define a Brush which is semi trasparent white (Alpha set to 153) SolidBrush semiTransBrush = new SolidBrush(Color.FromArgb(153, 255, 255, 255)); //Draw the Copyright string a second time to create a shadow effect //Make sure to move this text 1 pixel to the right and down 1 pixel grPhoto.DrawString(Copyright, //string of text crFont, //font semiTransBrush, //Brush new PointF(xCenterOfImg,yPosFromBottom), //Position StrFormat); //Text alignment //------------------------------------------------------------ //Step #2 - Insert Watermark image //------------------------------------------------------------ //Create a Bitmap based on the previously modified photograph Bitmap Bitmap bmWatermark = new Bitmap(bmPhoto); bmWatermark.SetResolution(imgPhoto.HorizontalResolution, imgPhoto.VerticalResolution); //Load this Bitmap into a new Graphic Object Graphics grWatermark = Graphics.FromImage(bmWatermark); //To achieve a transulcent watermark we will apply (2) color //manipulations by defineing a ImageAttributes object and //seting (2) of its properties. ImageAttributes imageAttributes = new ImageAttributes(); //The first step in manipulating the watermark image is to replace //the background color with one that is trasparent (Alpha=0, R=0, G=0, B=0) //to do this we will use a Colormap and use this to define a RemapTable ColorMap colorMap = new ColorMap(); //My watermark was defined with a background of 100% Green this will //be the color we search for and replace with transparency colorMap.OldColor = Color.FromArgb(255, 0, 255, 0); colorMap.NewColor = Color.FromArgb(0, 0, 0, 0); ColorMap[] remapTable = {colorMap}; imageAttributes.SetRemapTable(remapTable, ColorAdjustType.Bitmap); //The second color manipulation is used to change the opacity of the //watermark. This is done by applying a 5x5 matrix that contains the //coordinates for the RGBA space. By setting the 3rd row and 3rd column //to 0.3f we achive a level of opacity float[][] colorMatrixElements = { new float[] {1.0f, 0.0f, 0.0f, 0.0f, 0.0f}, new float[] {0.0f, 1.0f, 0.0f, 0.0f, 0.0f}, new float[] {0.0f, 0.0f, 1.0f, 0.0f, 0.0f}, new float[] {0.0f, 0.0f, 0.0f, 0.3f, 0.0f}, new float[] {0.0f, 0.0f, 0.0f, 0.0f, 1.0f}}; ColorMatrix wmColorMatrix = new ColorMatrix(colorMatrixElements); imageAttributes.SetColorMatrix(wmColorMatrix, ColorMatrixFlag.Default, ColorAdjustType.Bitmap); //For this example we will place the watermark in the upper right //hand corner of the photograph. offset down 10 pixels and to the //left 10 pixles int xPosOfWm = ((phWidth - wmWidth)-10); int yPosOfWm = 10; grWatermark.DrawImage(imgWatermark, new Rectangle(xPosOfWm,yPosOfWm,wmWidth,wmHeight), //Set the detination Position 0, // x-coordinate of the portion of the source image to draw. 0, // y-coordinate of the portion of the source image to draw. wmWidth, // Watermark Width wmHeight, // Watermark Height GraphicsUnit.Pixel, // Unit of measurment imageAttributes); //ImageAttributes Object //Replace the original photgraphs bitmap with the new Bitmap imgPhoto = bmWatermark; grPhoto.Dispose(); grWatermark.Dispose(); //save new image to file system. return imgPhoto; }
public static System.Drawing.Image Byte2Image(byte[] array) { System.IO.MemoryStream s = new MemoryStream(); s.Write(array,0,array.Length); System.Drawing.Image foto = System.Drawing.Image.FromStream(s); s.Close(); return foto; }
public static byte[] Image2Byte(System.Drawing.Image image) { // make a memory stream to work with the image bytes MemoryStream imageStream = new MemoryStream(); // put the image into the memory stream image.Save(imageStream, System.Drawing.Imaging.ImageFormat.Jpeg); return imageStream.GetBuffer(); }
[System.Runtime.InteropServices.DllImport ("shdocvw.dll")] private static extern int DllGetVersion (ref DLLVERSIONINFO pdvi);2º Definir la estructura que almacenará la información de la versión
struct DLLVERSIONINFO { public uint cbSize, dwMajorVersion, dwMinorVersion, dwBuildNumber, dwPlatformID; }3º Llamar a la función y obtener la información.
DLLVERSIONINFO dvi = new DLLVERSIONINFO (); dvi.cbSize = (uint)System.Runtime.InteropServices.Marshal.SizeOf (dvi); int resultado = DllGetVersion (ref dvi); if (resultado == 0) return string.Format ("{0}.{1}.{2}", dvi.dwMajorVersion, dvi.dwMinorVersion, dvi.dwBuildNumber); else return "?";
public void ExportarXML(string filename) { XmlTextWriter writer = new XmlTextWriter(filename, System.Text.Encoding.UTF8); //Usa indentación por legibilidad writer.Formatting = Formatting.Indented; //Escribe la declaración del XML writer.WriteStartDocument(); //Escribe el elemento raiz writer.WriteStartElement("persona"); //Escribe los elementos dentro de sus etiquetas writer.WriteElementString("nombre", "Emanuel"); writer.WriteElementString("apellido", "Lopez"); writer.WriteElementString("nacionalidad", "Argentino"); writer.WriteEndElement(); writer.Flush(); writer.Close(); }la salida sera la siguiente
<?xml version="1.0" encoding="utf-8"?> <persona> <nombre>Emanuel</nombre> <apellido>Lopez</apellido> <nacionalidad>Argentino</nacionalidad> <persona>