C#

Member 11166318 wrote:

in asp.net

foreach( DataTable table in _ds.Tables ) {
   this.comboBox1.Items.Add( table.TableName );
}

Rectangle rect_ctrl = panel_controls.Bounds;

            image_rect = new Rectangle(0, 0, rect_ctrl.Width, rect_ctrl.Height);

            drawing_point = new Point(50, 0);
            str_rect = new Rectangle(0, drawing_point.Y, image_rect.Width, drawing_point.Y + 50);
            
            int color = Screen.PrimaryScreen.BitsPerPixel;
            PixelFormat pf;
            pf = PixelFormat.Format32bppArgb;

            Bitmap BM = new Bitmap(image_rect.Width, image_rect.Height, pf); 
            
            Graphics g = Graphics.FromImage(BM);

g.DrawImage(Photo_LB.Image, rect_pic);

and 

draw string for all text control

than

g.Dispose();

            ImageFormat My_Image_Format = ImageFormat.Jpeg;

            BM.Save(Application.StartupPath+"\\test.jpg");

g.DrawString(value, heading_font, C_Brush, str_rect, SF_TEXT);

select '-' + item_id + '-', '-' + @ItemsIDS + '-' from q_Warehouse80_OOS_ItemsNeedingNotification where item_id  = 'B30-244-595-CB-B001'

-B30-244-595-CB-B001- and -B30-244-595-CB-B001-

cmd = new SqlCommand();

cmd.CommandText = SQL;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = conn;

var myparams = new SqlParameter("@ItemsIDS", DbType.String);
myparams.Direction = ParameterDirection.Input;
myparams.Size = 40;
myparams.Value = ItemsToBeChecked;
cmd.Parameters.Add(myparams);

cmd = new SqlCommand(SQL, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@ItemsIDS, ItemsToBeChecked);