RecorteX

Obtiene el valor de un atributo que se encuentra en el Request de la pagina.

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

descargar
 
  		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

descargar
 
    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

descargar
 
    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
 

Redimensionar una imagen

descargar
 
		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;
		}
 

Poner marca de agua a una imagen

descargar
 
		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;
		}
 

Cambiar de []byte a Image para usar en app, es util cuando tenemos un atributo binario en la bd, y la queremos sacar para asignarla a una clase de tipo imagen

descargar
 
		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;
		}
 

Cambiar de Image a []byte para almacenar en DB

descargar
 
  		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();
		}
 

Internet Explorer, al contrario que otros navegadores, no almacena la versión actual de su navegador en el registro. La única forma de obtenerlo es accediendo a la función DllGetVersion presente en la librería "shdocvw.dll" que es la encargada de realizar el renderizado de las páginas.
Para ello tan solo debemos realizar los siguientes sencillos pasos:

1º Declarar la función y la librería en la que se encuentra dentro de la clase que va a utilizarlo.

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

descargar
 
struct DLLVERSIONINFO
{
  public uint cbSize,
  dwMajorVersion,
  dwMinorVersion,
  dwBuildNumber,
  dwPlatformID;
}
 

3º Llamar a la función y obtener la información.

descargar
 
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 "?";
 

El código para generar un documento XML es el siguiente:

descargar
 
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

descargar
 
<?xml version="1.0" encoding="utf-8"?>
<persona>
  <nombre>Emanuel</nombre>
  <apellido>Lopez</apellido>
  <nacionalidad>Argentino</nacionalidad>
<persona>