C#

SELECT * FROM TABLE<br />
ORDER BY myDate DESC <br />
<br />
<br />
replace DESC with ASC for accending dates.

puttaraj wrote:

can I resize bitmap object at runtime?

int fixedWidth = sourceImageObj.Width + 20;
int fixedHeight = sourceImageObj.Height;
Image newImageObj = ImageWork.FixedSize(sourceImageObj, fixedWidth, fixedHeight, backgroundColor);

#region Class:  ImageWork
// public class ImageWork
//   public static System.Drawing.Image ClipImage(
//       System.Drawing.Image sourceImage, System.Drawing.Rectangle sourceRect, 
//       int targetWidth, int targetHeight)
//   public static System.Drawing.Image ClipImage(
//       System.Drawing.Image sourceImage, System.Drawing.Rectangle sourceRect, 
//       int targetWidth, int targetHeight, System.Drawing.Color bkgColor)
//   public static System.Drawing.Image ClipImage(
//       System.Drawing.Image sourceImage, System.Drawing.Rectangle sourceRect, 
//       int targetWidth, int targetHeight, System.Drawing.Rectangle targetRect, 
//       System.Drawing.Color bkgColor)
//   
//   public static System.Drawing.Image FixedSize(
//       System.Drawing.Image sourceImage, 
//       int fixedWidth, int fixedHeight, 
//       System.Drawing.Color bkgColor)
//   public static System.Drawing.Image FixedSize_EmptyImage(
//       int fixedWidth, int fixedHeight, System.Drawing.Color bkgColor)
//   public static System.Drawing.Rectangle FixedSize_ResizeRectangle(
//       int sourceWidth, int sourceHeight, 
//       int fixedWidth, int fixedHeight 
//   )
//   public static void FixedSize_ResizeRatios(
//       int sourceWidth, int sourceHeight, 
//       int fixedWidth, int fixedHeight, 
//       ref int targetMapOffsetX, ref int targetMapOffsetY, 
//       ref int targetMapWidth, ref int targetMapHeight, 
//       ref float targetMapRatio 
//   )
//   
public class ImageWork
{
	public static System.Drawing.Image ClipImage(
            System.Drawing.Image sourceImage, 
            System.Drawing.Rectangle sourceRect, 
            int targetWidth, int targetHeight)
	{
		// Return an Image object 
                // (of dimensions 'targetWidth' x 'targetHeight') 
                // clipped from a source Image object
		System.Drawing.Rectangle targetRect = new 
                    System.Drawing.Rectangle(0, 0, targetWidth, targetHeight);
		return ClipImage(sourceImage, sourceRect, 
                    targetWidth, targetHeight, targetRect, 
                    System.Drawing.Color.Empty);
	}

	public static System.Drawing.Image ClipImage(
            System.Drawing.Image sourceImage, 
            System.Drawing.Rectangle sourceRect, 
            int targetWidth, int targetHeight, 
            System.Drawing.Color bkgColor)
	{
		// Return an Image object 
                // (of dimensions 'targetWidth' x 'targetHeight') 
                // clipped from a source Image object
		System.Drawing.Rectangle targetRect = new 
                    System.Drawing.Rectangle(0, 0, targetWidth, targetHeight);
		return ClipImage(sourceImage, sourceRect, 
                    targetWidth, targetHeight, targetRect, 
                    bkgColor);
	}

	public static System.Drawing.Image ClipImage(
            System.Drawing.Image sourceImage, 
            System.Drawing.Rectangle sourceRect, 
            int targetWidth, int targetHeight, 
            System.Drawing.Rectangle targetRect, 
            System.Drawing.Color bkgColor)
	{
		// Return an Image object of dimensions 'targetWidth' x 'targetHeight' 
		// drawn from a clipped region of a source Image object
		// 1.  Create a new Bitmap of dimensions 'targetWidth' x 'targetHeight'
		// 1a. Clear the Bitmap to the Color given as 'bkgColor'
		// 2.  Clip a region of 'sourceImage' as defined by 'sourceRect'
		// 3.  Draw the clipped-region onto the Bitmap at a region defined by 'targetRect'
		// 
		System.Drawing.Bitmap returnImage = new 
                    System.Drawing.Bitmap(
                        targetWidth, targetHeight, 
                        System.Drawing.Imaging.PixelFormat.Format32bppRgb);
		returnImage.SetResolution(
                    sourceImage.HorizontalResolution, 
                    sourceImage.VerticalResolution);

		System.Drawing.Graphics grImage = 
                    System.Drawing.Graphics.FromImage(returnImage);
		grImage.Clear(bkgColor);
		grImage.InterpolationMode = 
                    System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;

		grImage.DrawImage(sourceImage, 
			targetRect,
			sourceRect,
			System.Drawing.GraphicsUnit.Pixel);

		grImage.Dispose();
		return returnImage;
	}


	public static System.Drawing.Image FixedSize(
            System.Drawing.Image sourceImage, 
            int fixedWidth, int fixedHeight, 
            System.Drawing.Color bkgColor)
	{
		// Return an Image object (of dimensions 'fixedWidth' x 'fixedHeight') 
		// drawn from a proportionally re-sized source Image object, 
		// with the "undrawn" regions of the new Image cleared to the Color given as 'bkgColor'

                // Compute the target Image offsets/ratios
		System.Drawing.Rectangle sourceRect = new System.Drawing.Rectangle
                    (0, 0, sourceImage.Width, sourceImage.Height);
		System.Drawing.Rectangle targetRect = FixedSize_ResizeRectangle
                    (sourceImage.Width, sourceImage.Height, fixedWidth, fixedHeight);


                // Create the new Image
		return ClipImage(sourceImage, sourceRect, 
                    fixedWidth, fixedHeight, targetRect, bkgColor);
	}

	public static System.Drawing.Image FixedSize_EmptyImage(
            int fixedWidth, int fixedHeight, 
            System.Drawing.Color bkgColor)
	{
		return FixedSize(new System.Drawing.Bitmap(1, 1), 
                    fixedWidth, fixedHeight, bkgColor);
	}

	public static System.Drawing.Rectangle FixedSize_ResizeRectangle(
		int sourceWidth, int sourceHeight, 
		int fixedWidth, int fixedHeight 
	)
	{
		int targetMapOffsetX = 0;
		int targetMapOffsetY = 0;
		int targetMapWidth = 0;
		int targetMapHeight = 0;
		float dummyMapRatio = 0f;
		FixedSize_ResizeRatios(
                    sourceWidth, sourceHeight, 
                    fixedWidth, fixedHeight, 
                    ref targetMapOffsetX, ref targetMapOffsetY,  
                    ref targetMapWidth, ref targetMapHeight, 
                    ref dummyMapRatio);

		return new System.Drawing.Rectangle(
                    targetMapOffsetX, targetMapOffsetY, 
                    targetMapWidth, targetMapHeight);
	}

	public static void FixedSize_ResizeRatios(
		int sourceWidth, int sourceHeight, 
		int fixedWidth, int fixedHeight, 
		ref int targetMapOffsetX, ref int targetMapOffsetY, 
		ref int targetMapWidth, ref int targetMapHeight, 
		ref float targetMapRatio 
	)
	{
		targetMapOffsetX = 0;
		targetMapOffsetY = 0;
		targetMapWidth = 0;
		targetMapHeight = 0;
		targetMapRatio = 0f;

		float targetMapRatioWidth = ((float)fixedWidth/(float)sourceWidth);
		float targetMapRatioHeight = 
                    ((float)fixedHeight/(float)sourceHeight);
		if (targetMapRatioHeight < targetMapRatioWidth)
		{
			targetMapRatio = targetMapRatioHeight;
			targetMapOffsetX = System.Convert.ToInt16(
                            (fixedWidth - (sourceWidth * targetMapRatio))/2);
		}
		else
		{
			targetMapRatio = targetMapRatioWidth;
			targetMapOffsetY = System.Convert.ToInt16(
                            (fixedHeight - (sourceHeight * targetMapRatio))/2);
		}

		targetMapWidth = (int)(sourceWidth * targetMapRatio);
		targetMapHeight = (int)(sourceHeight * targetMapRatio);
	}
}
#endregion 

Osama123 wrote:

i have to assign {1,2,3} to bye object ....

Osama123 wrote:

and also (str.length-1) to a byte type object in c sharp....

		System.Collections.Hashtable hStrings = new Hashtable();
public YoureConstructor()
{
	hStrings.Add("tommy", "tommy bunny");
	hStrings.Add("mary", "mary bunny");
	hStrings.Add("honey", "honey bunny");
}


private string GetTextOutOfHashtable(string key)
{
	if(hStrings.ContainsKey(key))
	{
		return hStrings[key].ToString();
	}
	else
	{
		return "";
	}
}

private void SomeMethod()
{
        string mytext = GetTextOutOfHashtable("tommy");
        //mytext=="tommy bunny" now
}