Archive for March, 2009

Cold Immersion Bath

Tuesday, March 31st, 2009

This may be taken for four seconds to 20 minutes at a temperature ranging from 100C to 23.80C. Before entering the bath, cold water should be poured on the patient’s head, chest, and neck and the head should be protected with a cold moist towel. During the bath, the patient should vigorously rub his or her body. After the bath the body should be quickly dried and wrapped up in a blanket. If the climate is favourable, moderate exercise should be undertaken.

This bath helps to bring down fever. It also improves the skin when taken for five to 15 seconds after a prolonged hot bath, by exhilarating circulation and stimulating the nervous system.

This bath should not be given to young children or very elderly persons, nor be taken in cases of acute inflammation of some internal organs such as acute peritonitis, gastritis, enteritis, and inflammatory conditions of uterus and ovaries.

To learn more about the energy principle in healing, please read:

Cost-free Miracle Asthma Cure
Overcome Type I Diabetes and Type II Diabetes Naturally
Alternative Treatments for Incurable Diseases made easy

Latest Gadgets of 2009

Monday, March 30th, 2009

Gadgets make great gifts for all the family but are especially loved by boys and men of all ages alike, what man does’nt love to tinker around with something technical, fiddly or interesting. Thousands of gadgets are available, with new gadgets becoming available in the UK each and everyday.

The term gadgets is quite a broad term and can be used to refer to electrical items of all sizes (from TV’s to pocket calculators), including more novel items such as pocket and handheld games, or novel static games, such as a rubix cube.

Some of the newest gadgets available in 2009 include:

  • MP5 Players – MP5 players offer yet more functions over MP3 Players, MP4 Players and Ipods. Essentially, just the same features as the other but usually with the addition of a Digital Camera function, Dictaphones and other features, much like you might find on the above average mobile phones these days.
  • Flexi-Keyboard – Flexi Keyboards are cool, a keyboard for your laptop, PC or Mac, you can literally throw anything at these keyboards, or even throw them around, yet plug them in and they’ll still be functioning no matter how much of a battering you give them, a perfect keyboard for anyone with ‘active’ children or anyone prone to knocking your keyboard around.
  • iKaraoke - IKaraoke allows you to turn your iPod into a full blown karaoke machine, this nifty little plugon device makes the pefect partner for an inpromptu karaoke party.
  • Micro Spy Digital Camera – The perfect camera for the budding private investigator, the camera is concealed as a cigarette lighter, so with the smoking ban you’ll cover will be blown if you try and use it indoors!

Home Remedies From Parsnip

Monday, March 30th, 2009

The parsnip has been cultivated in Europe for centuries. It was especially popular before the arrival of the potato and was used as a valuable source of carbohydrate.

Parsnips contain natural sugars which impart a sweet taste to the vegetable. The Elizabethans used parsnips as a sweetmeat with honey and spices as well as serving the root as a vegetable. The carbohydrate in parsnips is stored in the form of natural sugars. This contrasts with the potato where the carbohydrate is 90% starch. Parsnips are considered sweeter than carrots. With almost three quarters of the sugar in parsnips as sucrose, the sugar we extract from sugar cane. By comparison, sucrose accounts for only one third of the sugar in carrots. Sucrose is not at all damaging to health when consumed in its natural form in its parent plant.

Culpeper (1653) writes that ‘the garden parsnip nourisheth much and is good and wholesome, but a little windy whereby it is thought to procure bodily lust; but it fatteneth the body if much used. it is good for the stomach and reins (kidneys) and provoketh urine’.

Today we appreciate that the parsnip is not fattening, with a mere 20Kcal per 100g. Compare this to fats and oils at around 900Kcal per 100g.

Kevin Pederson has been managing a number of natural home remedies websites which have information on home based natural cures and remedies by some of the common itmes in house as well as parsnips.

Prostate Gland Well-being – the Herbal Way

Sunday, March 29th, 2009

The healthcare industry call an enlarged prostate benign prostate hyperplasia, or BPH. This entails that the prostate, a mass which wraps around the urethra and lies beneath the bladder, enlarges this can impair or maybe stop the stream of urine. The prostatic gland grows as the years pass and may engender symptoms such as difficulty passing water, a weak flow, and even the holding of urine inside the bladder. Night time frequency and even inflammation of the urinary pathway are some other problems which may arise due to prostatic engorgement.

BPH – Medical Therapies

Men in their sixties frequently develop an enlarged prostate. It’s suggested that men over 50 undergo an examination by their physicians on an annual basis, irrespective of the occurence of symptoms, for the maintenance of prostate health. Look For medical intervention straightaway if blood appears in the urine or you are unable to urinate.

Surgical operations and drug therapy are routine interventions for prostatic enlargement. Nevertheless, erection difficulties and even loss of bladder function can be observed as a result of a surgical operation. An alpha blocker and drugs that reduce the swollen prostate gland can also be prescribed for better prostatic function, however, medicines often lead to negative side effects. What herbal choices are available? Troubled with an Enlarged Prostate Gland? Discover Alternative Treatments to Gain Improve Prostate Wellness

To promote improved prostate gland health and also allay the many symptoms connected with an enlarged prostate gland, a few alternative remedies will offer relief. Swelling is greatly reduced by the treatment Afican pygeum, relieving a lot of the symptoms. A derivative of the fruit of a tree native to southern Africa, African pygeum has been prescribed on a regular basis by the Europeans as a holistic formula for improved prostate gland health.

Reducing the fats in the diet may improve symptoms, so will excercising more frequently, pressure in the prostate gland should also be lessened thru ejaculating often, it is also best to avoid sitting for a long time. Use of over-the-counter antihistamines or decongestants may increase any symptoms of an enlarged prostate gland, take these medicines with this in mind. Cut back on caffeine and alcohol intake, do not drink within a couple of hours of going to bed this can keep down nighttime bathroom visits.

There’s also a multitude of further natural supplements taken for better prostatic function – these include saw palmetto, Borago officinalis oil capsules, selenium, and also lycopene, which can be found in tomatoes. Before you commence any which holistic treatment regime make sure you discuss your plans with a physician.

Sound Healing with Tibetan Bowls

Saturday, March 28th, 2009

Sound healing is rapidly gaining recognition internationally as an integral part of the healing process for cancer patients. It has also been effective in relieving pain and in the treatment of stress related afflictions such as chronic fatigue syndrome, fibromyalgia, insomnia, pain and depression. Mainstream medical teaching facilities like Duke University and the University of North Carolina have added programs that link body/mind and spirit to the treatment of cancer. Cancer Prevention centers are utilizing sound as a vital part of the healing process for patients with astounding results.

I, like many healers believe that illness is a manifestation of dis-harmony within the body; an imbalance in the cells or a given organ and that healing can be achieved by restoring the normal vibratory frequencies of the diseased, out-of-harmony parts of the body. Vibrational healing, especially with sound is a potent way of restoring the body to its’ normal vibratory frequency.

All matter is energy vibrating at different rates and by altering the rate of vibration we can change the structure of matter. In this case the healing process is initiated by entraining our brainwaves and creating sympathetic resonance with the perfect vibrations of the bowls. When we add intention to the frequency, the healing potential is increased even more. That intention can be through prayer, chanting, and even silent focused attention, but declaring it in an audible manner is best.

Another way of saying that is the fundamental state of the universe is a state of absolute harmony. Our core state, because we are part of the natural universe is also one of harmony and great ease. When we disconnect from our core state through stress, distraction, illness and the challenges of daily life, it creates dis-ease: spiritual, physical and mental. Sound from the Tibetan bowls gently nudges us back to our natural state of blissful tranquility and alignment.

Dr. Mitchell Gaynor, director of Medical Oncology and Integrative Medicine at the Cornell Cancer Prevention Center in NY has been using sound, including Tibetan Bowls, Crystal bowls and Chanting in work with cancer patients for many years. “If we accept that sound is vibration and we know that vibration touches every part of our physical being, then we understand that sound is heard not only through our ears but through every cell in our bodies. One reason sound heals o n a physical level is because it so deeply touches and transforms us on the emotional and spiritual planes. Sound can redress imbalances on every level of physiologic functioning and can play a positive role in the treatment of virtually any medical disorder.”

According to an article in Spirituality and Health magazine Dr. Gaynors’ research shows that the sound vibration of the bowls affects the disrhythmic motion found in cancer cells and cause a harmonious transformation. In a blind study he found that there was a 50% shorter recovery time from chemo patients for those who used the bowls regularly and that when bowls were used in the early stages of cancer, during consultations with patients, their level of anxiety and stress was greatly reduced.

Imagine how making a solid, well thought out decision about ones future would be improved in a context void of stress and anxiety. Imagine also how the ability to repeatedly connect with that sense of tranquility during the discomfort of chemotherapy increases the quality of life for cancer patients.

Research by Dr. David Simon, medical director of neurological services at Sharp Cabrillo Hospital in San Diego and medical director at the Chopra Center found that chants are chemically metabolized into ‘endogenous opiates’, that act on the body as internal painkillers and healing agents.

In my own research with sound using biofeedback equipment I found that the harmonics produced by the Himalayan (Tibetan) Singing Bowls have transformative abilities (brain activity, heart rate and body temperature have diminished during sessions) creating a deeply peaceful state of being while energizing the brain.

Biofeedback is a scientifically valid measurement devise used to help individuals gain voluntary control over several different Autonomic Nervous System functions. Research has shown that when breathing and heart rate are in synch this produces a resonant frequency in the body (similar to the resonance being produced by the Tibetan bowls). This is extremely beneficial for the heart and the entire body. Stress related disorders, pain, and many other disorders are predicted by whether or not a person is achieving cardio-respiratory synchrony. During sessions of Tibetan bowl sound therapy, cardio-respiratory synchrony increased dramatically as measured by J&J Engineered Biofeedback equipment. Data showed that during the sound therapy sessions there was an increase in Parasympathetic Nervous System activity and decrease in Sympathetic Nervous System drive. The relaxation response was initiated and the stress response was inhibited. This means the Autonomic Nervous System was balanced for the majority of the session. The resonance of the bowls produced slow breathing of approximately six breaths per minute which produced beneficial effects on the heart and whole body.

These results are promising in that Tibetan bowl sound therapy increases cardio-respiratory synchrony and resonance within the body. Therefore, there are many disorders that can greatly benefits from the use of Tibetan bowl sound therapy.

My clients have supported the scientific findings with reports of everything from relief from pain and discomfort, clearing of sinuses, shifting out of depression, ability to sleep (for those with insomnia), re-vitalization and clarity, feeling of well being, great connectedness and deep personal transformation. Clients report a fundamental shift in their view of phenomenon space, accentuated clarity of mind and body, enhanced creativity, vigor, joy and sense of peace.”

It is important to look at what healing really is and what the difference is between healing and curing. A cure is the “complete biological resolution of a diseased state”, according to Dr Gaynor in his book “The Healing Power of Sound”. Healing, however has more far reaching implications that occur on emotional, spiritual and physical levels. It is a regenerative process married to a spiritual awakening that can have profound consequences on illness, disease and all aspects of our lives.

Himalayan or Tibetan Singing bowls have been traced to the shamanistic Bon tradition which predates Buddhism by thousands of years. Dr. Gaynor mentions in an article in Shamans Drum magazine that the reason sound (and chanting) are still used in shamanistic cultures is that the sound induces trance states of consciousness conducive to healing. The ancient Himalayan Bowls are made from a consecrated seven metal alloy which, when skillfully stimulated, produce five individual and simultaneous tones, each at its own consistent frequency, which vibrational-ly dance with each other. The raw materials were collected, smelted and purified, cast, reheated and hammered into shape and tone. Mantras or sacred chants were sung and infused intent into the bowls. Their sound synchronizes sentient brain waves and creates a therapeutic effect upon the mind/body realization. .

Singing Bowls, produce the primordial sound of ‘AUM’: The fundamental utterance of energy metamorphosing into matter. They alter space, mind and time; awakening cellular memory and healing the energy body. The act of listening to their captivating overtones effectively stops one’s internal dialog, the ‘Monkey Mind’. The individual is transported into a space of tranquility and balance where the ‘Universal Chord’, found within each self, is touched, joined with and understood. The Universal Chord if you will, that is the primordial substance from which our whole reality is made and from which our Universe originated. Although the vibrational energy of the bowls can be directed to a specific area for healing purposes, they work more on a fundamental level.

These instruments are used within meditations and physical vibrational healing techniques. Their harmonic resonance is used to:

- reduce stress and pain
– balance energy

– create vitality synchronization and spontaneous healing.

- effectively alter consciousness into a peaceful and expansive meditative state. (trance induction)
- meditation

Diane Mandle is a Certified Sound Healer based in Southern California. She maintains an integrated Body/Mind private practice and conducts presentations and concerts nation wide on healing using the Himalayan bowls. She can be reached at 760-944-3441 or info@soundenergyhealing.com. Her CD “Return to OM” is available on her website at www.soundenergyhealing.com

References
Spirituality & Health, Aug 2003
Shaman’s Drum, Number 63, 2002
Richard Rudis (Sacred Sound Workshops)
Johathan Goldman, “Sound Healing”

Diane Mandle is French/American who has lived and traveled worldwide. She has a background in performing arts from Stephens College where she graduated in 1972. It was there that she was introduced to Buddhism, and her interest in this has taken her to Nepal and Sikkim several times where she was able to deepen her understanding of the cultures where the Sacred Sound instruments were created and utilized.

She has been working in the healing profession for over 6 years with an integrated body/mind practice that includes focused dialog, energy balancing and Sound Healing. She is the only State Certified Tibetan Bowl Sound Healer in the country. In addition to her private practice, she conducts concerts, workshops and educational programs nationally, is a regular presenter at the Chopra Center and is a featured performer on a new CD, “Turning Pain into Serenity” by Clinical Psychologist Michael Samko, Ph.D. Diane’s own CD “Return to Om” received critical acclaim in the San Diego based “Light Connection” magazine.

Home Drug Test

Saturday, March 28th, 2009

Home Drug Test

Drug examine has grown into a common phenomenon around the globe. Some companies perform drug screens on freshly working individuals or active employees to guarantee a drug-free environment at work.

Insurance offices and courts direct drug trials on a normal ground on suspected individuals. The important question that comes to your brain, when you go for such test is how to beat the drug exam?

Cyber sites much like How To Pass A Urine Drug Test provides the most advanced detox products including perm cleansers, imitation weewee products, and saliva cleansing products, health drinks and home drug test kits.

Tip On How To Pass A Drug Test

Pass The Drug Test offers up pro support for every product, with support catered by drug test people all are highly knowledgeable with various types of drug testing ways and results. Support is available by e-mail and phone. Shipping is streamlined, with complete secrecy assured, using plain and discrete boxing materials to preserve entire client privacy.

Pass Urine Drug Test

Enclosed on the new site is a humongous order of products for detoxification and testing intents. Permanent cleansers are proposed in 3, 5 and 7, 10, 14, 21 and 30 day systems, with a variety of herbs, roots, barks and minerals that are best-known lipoids destroyers which act to break down fat cells and extinguish toxins altogether. Simulated weewee is proposed, which contains all elements normally acquired in weewee, specially balanced for pH with specific gravity, creatin and other urine characteristics. A saliva cleansing mouthwash is tendered will destroy toxins from your mouth with only 3 minutes of use. We provide a range of detox drinks, for each one bearing the most working herbs and fiber to help rid the body of toxins that may have gathered.

If you use Ask to lookup the internet for us here are 10 Strategic words to utilize to observe our website.

Home Remedy To Pass Drug Test

Creatinine Drug Testing besides proposes drug testing kits including saliva, hair and piss based tests to verify that detox programs are effective. For more information, visit On Site Drug Testing If you have any questions, please call us at: 866-679-7277

DrFloras Cleanse Works Fast

Friday, March 27th, 2009

DrFloras Cleanse is a Professional Colon Cleanse

A highly toxic colon works inefficiently because the residing chemicals interfere with its classifying activity. Toxic waste build up in your body can be very unhealthy for you. When your colon is filled with toxic waste build up, your body produces excess gas. When the colon is so backed up, the excess gas will not be able to pass as easily or as quickly as it should be able to. There is absolutely no way around it, for toxins have proven to be practically everywhere. drfloras cleanse can help you by removing the toxic material from your body.

Colon cleansing has been going on for ages. In fact, the practice of colon cleansing has even dated back to as early as 1500 B.C. in Egypt, and it is no wonder. Many medical practices have come and gone throughout history; however, colon cleansing has managed to stick around and is widely practiced today, becoming more and more popular each year. This is simply because colon cleansing truly works to improve your vitality. The benefits of colon cleansing are immense.You should allow colon cleansing such as drfloras cleanse to purify your body, to make you much more healthier.The benefits of colon cleansing are truly hard to ignore, for colon cleansing can immensely improve your bodys health and general well being.

Your Whole System Gets Cleansed With DrFloras Cleanse

The all natural dietary supplement, drfloras, can thoroughly cleanses your colon. An unclean colon will definitely lead to a toxic waste build up in your colon, increasing your bodys toxin level. Not only does this colon cleansing system remove the nasty, unhealthy toxic waste build up from your colon, but it also boosts your metabolism, renews energy and vitality, relieves bloating and constipation, contains Pro-Biotics that create a hostile environment for harmful bacteria, parasites, and worms, causing them to flee from your system, and lowers your risk of getting a chronic disease and colon cancer. This colon cleansing system not only removes the harmful toxic waste build up that has been residing in your colon, but it also removes harmful parasites, worms, toxins, and chemicals, relieves bloating and constipation, contains Pro-Biotics (which create a hostile environment for harmful bacteria, worms, and parasites, causing them to flee from your system), lowers your susceptibility to getting chronic diseases and colon cancer, boosts your metabolism, and renews your energy and vitality. As it contains only all natural ingredients, this amazing colon cleansing system will not harm your body in any way whatsoever, but can only help you.

Finding the Ideal Engineering Vacancy

Friday, March 27th, 2009

Be sure you go to this extensive trusted resource for mechanical engineering university advice…

Graduating with a degree in this discipline which is usually thought to be the most comprehensive of all the engineering science fields of study a sizable selection of mechanical engineering jobs will be accessible anytime. Engineering work covers numerous industrial applications including power, heating systems, cooling systems, and also air conditioning design; the automobile industry, plant engineering and upkeep; highly pressurized vessels and piping. Vacancies may include employment in technical sales, clerical or managerial positions, further alternatives could be production processes in agriculture or manufacturing.

Just how much of a wage should I hope for?

Information from a mechanical engineering survey carried out by the National Association of Colleges and Employers, mechanical engineering positions may often extend an income ranging from 40,000 dollars annually to as much as $93K, training and of course experience are determining elements. An additional factor which may affect your mechanical engineering remuneration is the engineering sector you choose.

How can I easily find a position in my chosen field? An up-to-the-minute and well-rounded CV is absolutely essential. When you have produced a CV which highlights your education, you need to be proactive and begin hunting. So, how can I find vacancies? Job fairs: Pertinent local job fairs will usually be displayed somewhere in the engineering science faculty of your college. You will have a fantastic chance to acquaint yourself with the individuals recruiting. Internships: Your university can provide assistance with obtaining the correct internship. Graduating students are on a regular basis hired by businesses in which they had an internship, and can additionally improve significantly your chances of a good mechanical engineering salary. Join groups: Involvement in groups or going to group meetings presents the chance of not just discovering much more concerning the industry, but also opens up networking possibilities.

Use the newspapers: Businesses that require engineers place advertisements in the newspapers in the same way as any other employer. Check Out the newspapers often; apply and always to follow up. Perseverance is a must. Utilize cyberspace: Look for the big recruitment sites online and submit a curriculum vitae. Build up a portfolio on the LinkedIn web site and network. Use the power of the net to ramp up the quest for the perfect job. Persistence in combination with building up business contacts are key to finding a role. Keep your resume and name out and circulating; follow through on each application; utilize the internet for making new contacts, make time to submit a personal profile. These measures can help you get the job of your dreams.

Betting Room Taking a Risk: Betting Games Gamblers like to Contend in

Friday, March 27th, 2009

Assuming that you haven’t yet had an opportunity to really learn about gaming room games of luck, then you’re invited to learn more about it here…

casino free money no deposit

Generally speaking a gambling house is a house that offers games of chance. At such a place, patrons will hopefully take chances by challenging the slot machines or another pastimes. Gaming hall games on the whole include logically derived balances informing them that make sure the gambling organization keeps possession of the upper hand versus the betters. Many betting hall games can get you hooked quickly. For example the quintessential slotmachine, a mechanical contraption with three cogs that pivot if a handle affixed to it is pushed. The machine regularly pays out corresponding with a set arrangement of pictures presented on the dials on the appliance. Sadly, gaming establishment games suggest the appearance of control, hoodwinking the betting aficionado: the punter is given options, but actually these will never truly level the customer’s odds. This is precipitated by the gaming establishment not paying up the full stake as expected. This modus operandi is again and again noticeable in well known casino games like five-card stud poker, craps, roulette or blackjack.

Stud poker is truly a very fashionable casino pastime. The gamers, closely guarding their fully concealed hands, wager into a principal pot which is then granted to the last player holding the best combination of cards. (Of course, the coolest bluffing hand may actually win too…) Commensurate with five card stud, blackjack is also an immensely trendy casino game. A good part of its acclaim is caused by the mix of chance and competence & choice making, as well as a system identified as “counting”. This is a very sophisticated strategy in which gambling fans can significantly force the arm of chance of the game in their interest both by betting and strategic decisions correlating with the hands shown. Craps is the name of a famous gambling hall pastime where you may wager on the roll of 2 dice. Bettors wager stakes on the outcome of of 1 spin, or on a succession of rolls on two dice. Very much unlike blackjack, there just isn’t any possible long term winner tactics players can exercise to boost the chances. Roulette is another insanely popular casino based gambling pastime — a croupier will turn a roulette wheel holding exactly thirty-seven (European roulette) or 38 (Vegas roulette) distinctively marked slots in which a white pellet will settle, marking the winning number Supposing that a gamester has bet on a number and actually makes it so it’s their lucky day, the repayment is 35:1, the bet proper will be returned. Hence in totality it is increased by 36.

Attempt to be careful though, because these gaming hall games of chance can be very habit forming. So many lives have probably been damaged thru uncontrolled gambling and albeit it indeed seems entertaining, do please try to exert some self-control.

How to Use SQLXML to Retrieve Data from SQL Server Database?

Thursday, March 26th, 2009

Using SQL Server 2000 and above versions you can retrieve data from SQL Server in XML format directly from the database. Many XML related features were incorporated in the SQL Server database. This enables the development of XML enabled applications very easy and it makes exchange of data over internet easy. In this article we will discuss about how to use SQLXML to retrieve data directly from SQL server database in XML format.

There are some SQL commands and clauses that help you to retrieve data from the SQL Server in the XML format. Syntax for such is given below:

SELECT … FOR XML mode [, XMLDATA] [, ELEMENTS] [, BINARY BASE64]

There are different modes and that take the values of

AUTO – In this mode every row of the result of the query forms an element in the returned XML document.

EXPLICIT – This mode defines how to map the columns of the results returned by the query to the XML elements and the attributes.

RAW – All the fields of the result are identified as attributes of an element.

NESTED – The result of this mode is the same as the AUTO mode but the formatting has to be done at the client side.

A simple example of using the above syntax is given below:

SELECT TOP 3 *
FROM (SELECT FirstName+’ ‘+LastName as Name FROM Employees)
FOR XML AUTO

The query produces this result:

Employees Name=”John Peter”
Employees Name=”Andrew Dixon”
Employees Name=”Tom Hanks”

There are optional parameters in the ‘FOR XML mode’ clause. The XMLDATA option adds an XSD schema which describes the XML format of the result returned. The ELEMENTS options make the fields of the tables in the database to be returned as child elements. If the ELEMENTS option is not there the fields of the tables are returned as attributes instead of child elements of the XML document. The ELEMENTS option is allowed only in the AUTO mode. The BINARY BASE64 option is used to retrieve any binary data. The returned binary data is returned in BASE64 encoded format. The binary data can be retrieved in the RAW or EXPLICIT mode.

An example of the RAW mode is given below:

SELECT EmpName, EmpCity from EMP for XML RAW

The above code returns a result like,

row EmpName=”John” EmpCity=”New York”

In the above result you can note that the fields of the resultset are returned as attributes of the element.

.Net provides with managed classes for interacting with SQL Server. The managed classes of SQLXML provided by .Net are:

SqlXmlCommand – This is used to perform queries that are stored in XML documents which are also called XML templates. This class also provides support for client side XML processing.

SqlXmlParameter – this is used to provide parameterized values and is used along with SqlXmlCommand object.

SqlXmlAdapter – this is the adapter class for SQLXML provider. This is used to fill the dataset.

SqlXmlException – this is used to trap the error information from the SQL Server.

A sample code using the managed classes is given below. For detailed information on the usage of the above managed classes you can refer to the MSDN documentation.

static string cstr = “Provider=SQLOLEDB;Server=(local);database=EmpPersonal;”;
public static void testingSqlXml ()
{

Stream oStr = Console.OpenStandardOutput();

SqlXmlCommand sqlcmd = new SqlXmlCommand(cstr);

sqlcmd.Root = “Employees”;

sqlcmd.CommandType = SqlXmlCommandType.Sql;

sqlcmd.CommandText = “SELECT EmpName, EmpCity FROM Employees FOR XML AUTO”;

strm = sqlcmd.ExecuteToStream(oStr);

oStr.Close();
}

Thus we have seen that SQLXML can be used to retrieve data directly from the SQL Server in XML format. It is easy to handle and transmit data through the internet if it is in the XML format and this can be easily achieved using the SQLXML.

Want to stay current with the latest technology developments realted to XML. Visit Free XML Tutorial to get your FREE subscription now!

** Attention Webmasters / Website Owners ** You can reprint this article on your website as long as you do not modify any of the content, and include our resource box as listed above with all links intact and hyperlinked properly.