C#

Create Procedure MultiTable
As
Begin
     Select Name, Email from A
     Select X,Y         from B
     Select J, K        from C
End

SqlConnection conn = new SqlConnection("Con String");
SqlDataAdapter da = new SqlDataAdapter("MultiTable",conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;

DataSet ds = new DataSet();
da.Fill(ds);

<br />
//sz1 = (800, 600)<br />
private Image resizeimage(Image my, Size sz1)<br />
        {<br />
            double ratio = 0d;<br />
            double myThumbWidth = 0d;<br />
            double myThumbHeight = 0d;<br />
            Bitmap bp;<br />
           int c;<br />
           int d;<br />
            <br />
                if ((my.Width / Convert.ToDouble(sz1.Width)) > (my.Height /<br />
                Convert.ToDouble(sz1.Height)))<br />
                    ratio = Convert.ToDouble(my.Width) / Convert.ToDouble(sz1.Width);<br />
                else<br />
                    ratio = Convert.ToDouble(my.Height) / Convert.ToDouble(sz1.Height);<br />
         <br />
            <br />
            myThumbHeight = Math.Ceiling(my.Height / ratio);<br />
            myThumbWidth = Math.Ceiling(my.Width / ratio);<br />
            Size thumbSize = new Size((int)myThumbWidth, (int)myThumbHeight);<br />
            bp = new Bitmap(sz1.Width, sz1.Height);<br />
            c = (sz1.Width - thumbSize.Width) / 2;<br />
            d = (sz1.Height - thumbSize.Height);<br />
            System.Drawing.Graphics g = Graphics.FromImage(bp);<br />
            g.SmoothingMode = SmoothingMode.HighQuality;<br />
            g.InterpolationMode = InterpolationMode.HighQualityBicubic;<br />
            g.PixelOffsetMode = PixelOffsetMode.HighQuality;<br />
            rect = new Rectangle(c, d, thumbSize.Width, thumbSize.Height);<br />
            g.DrawImage(my, rect, 0, 0, my.Width, my.Height, GraphicsUnit.Pixel);<br />
            if (f == false)<br />
            {<br />
                sz = bp.Size;<br />
                pictureBox1.Size = sz;<br />
            }<br />
            rect = new Rectangle(0, 0, 0, 0);<br />
            return (bp);<br />
// this will trigged when clicked on the picture box<br />
public void ZoomIn()<br />
        {<br />
            pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;<br />
            if (sz.Width >= c)<br />
                MessageBox.Show("Max ZoomIn");<br />
            else<br />
            {<br />
                sz.Width += 50;<br />
                sz.Height += 50;<br />
<br />
                pictureBox1.Size = sz;<br />
                pictureBox1.Invalidate();<br />
            }<br />
<br />

private void comboBox1_TextChanged(object sender, EventArgs e)
        {
            int j = 0;
            string str,strTemp,str1;
            str = comboBox1.Text; 
            comboBox1.Items.Clear();            
            for (int i = 0; i < List.Count; i++)
            {
                j++;
                string value = List[i] as string;              
                str1 = value.ToUpper();
                strTemp = str.ToUpper();
                if (str1.IndexOf(strTemp) != -1)
                {
                    j++;
                    comboBox1.Items.Add(value);
                }
            }
            
            int k = str.Length;    
            comboBox1.Select(k, k++);            
            comboBox1.DroppedDown = true;
           
        }