Skip to main content

Posts

Showing posts from April, 2014

Convert Data Table into XML in Asp.Net and pass it to sql server database

Code : dt.TableName = "dt";                                 string XMLData = "";                                 using (StringWriter sw = new StringWriter())                                 {                                     dt.WriteXml(sw, false);                                     XMLData = ParseXpathString(sw.ToString());                                 }                                 SqlParameter[] param = new SqlParameter[2];                                 DataSet ds = new DataSet();                                 //param[0] = new SqlParameter("@RegistrationNo", login Name);                                 param[0] = new SqlParameter("@grouptag", previousloginname);                                 param[1] = new SqlParameter("XMLData", SqlDbType.Xml);                                 param[1].Value = XMLData;                                 ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, &qu

Solve issue of invalid IMEI code

warning: not for phones with valid imei[undamaged], if tried may permanently remove your IMEI. first note down the imei of your phone which is under the battery... open dialer and dial [mtk engineering mode] *#*#3646633#*#* under connectivity goto "CDS information" tab or directly goto "CDS information" tab. goto "Radio Information" select Phone1, you can see AT+ at the top, touch it, and type AT+EGMR=1,7,"xxxxxxxxxxxxxxx" type your 15-digit IMEI in the quotes in place of xxxx... it will show a message like sent successful.......[i dont remember it...] now reboot your phone.... for second sim follow same procedure but, select Phone 2 in radio, and type AT+EGMR=1,10,"xxxxxxxxxxxxxxx" type your 15-digit IMEI in the quotes in place of xxxx... it will show a message like sent successful.......[i dont remember it...] now reboot your phone.... It works for my Micromax A88 canvas MUSIC if It says the command sending i

Export Doc,Access,Image,CSV,Excel,Pdf,XML,HTML,Text,Print of Gridview in Asp.net

First import itextsharp.dll in the solution and use three namespces (basically for pdf) using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser;          Then Use the following code :- on each button  click  protected void Page_Load(object sender, EventArgs e)         {             if (!Page.IsPostBack)             {                 BindGridDetails(GridView1);             }         }                 protected DataTable BindGridDetails(GridView GridView1)         {             DataTable dt = new DataTable();             dt.Columns.Add("Student_ID", typeof(Int32));             dt.Columns.Add("Student_Name", typeof(string));             dt.Columns.Add("Education", typeof(string));             dt.Columns.Add("City", typeof(string));             DataRow dtrow = dt.NewRow();             dtrow["Student_ID"] = 1;             dtrow["Student_Name"] = "Musakkhir";   

Reset Bios Password

If you want to Recover Bios password.Try one simple step 1) If you have computer try to Remove jumper or change jumper pin location from 1-2 to 2-3. or 1)If you have laptop then try to enter password wrong then your laptop will generate one 5 digit code by saying that wrong password then copy that code and decrypt it HERE  . Thanks

Benefits of haldi for flawless skin

Turmeric or  haldi  is one of India’s most widely used spices. Not only is it used to add colour and taste to our food but is also a natural remedy for various skin ailments. It is also a part of Hindu rituals. One of the most important ceremonies of Hindu weddings is the  haldi ceremony where a paste made of turmeric is applied to the bride and the groom’s body and face to make their skin glowing for the wedding. Here are some benefits of turmeric that you can use to help with common beauty problems and get flawless looking skin.   Ageing Turmeric is an excellent exfoliating agent and can help you defeat the  signs of ageing . Take  besan  (gram flour) and turmeric powder in equal proportions and prepare a paste by adding water. You may alternatively prepare this paste in raw milk or even yoghurt. Apply it evenly on your body and leave it till it dries off. Wash it off with lukewarm water and scrub your face gently in circular motion.  Wrinkles You can use turmeric in combin

6 natural remedies for itchy skin

An itch is something that most people find hard to resist; there’s nothing that gives as much relief as scratching an itchy spot. Unfortunately, the relief does not last for long and soon, you find your skin begin to smart and if you’ve been quite rough, the skin may break, too. An itch is actually one of the body’s defense mechanisms against unpleasant irritants but if you make a habit of scratching, it can cause a lot of discomfort. Here are a few natural remedies you can try using materials available in your kitchen to relieve itching. Coconut oil Yes, your mother was indeed right when she said that coconut oil is good for itchy skin. Whether due to dry skin or an insect bite, whatever the cause of the itch, coconut oil can work wonders. The best way to use it is to rub a little coconut oil directly onto the affected area. If you suffer from a widespread itch all over the body especially during the winter, soak in a bathtub of lukewarm water; then just pat yourself dry and app

Top 10 home remedies for constipation

 Here are a few of them  that can work wonders: 1.  Triphala  powder  or  Triphala  Churna , consists of three fruits -  Amla  or Indian gooseberry ( read about the amazing benefits of  amla ) ,  Haritaki  (Chebulic Myrobalan) and  Vibhitaki (Bellirica Myrobalan). It is a great laxative and helps to regulate digestion and bowel movements. You can either have one teaspoon with warm water or mix the powder with honey. Having this mixture either before going to bed or early in the morning on an empty stomach can relieve constipation almost instantaneously. The advantage of this powder is that it is not habit forming and a completely natural alternative to chemical laxatives. Read about  other ways to beat constipation with triphla . 2. Raisins ( kishmish )  are packed with fiber and act as great natural laxatives. Soak a handful in water overnight and have them first thing in the morning on an empty stomach. This remedy also works wonders for pregnant woman, without the side effects

10 home remedies for acidity that really work!

All of us have suffered from acidity at some point in our lives. Either it is that extra  gulab jamun  at a family function or that spicy  samosa  during tea break. Whatever the reason may be, acidity can be quite an uncomfortable experience, and sometimes we are left with no option but to reach out for that bottle of antacid. But, did you know that there are alternative, n                        atural remedies that work just as well and don’t leave you with the ill-effects of too much medication? Read about the  new-age technique to relieve the symptoms of acidity .  Here are 10 things to treat acidity and its recurrence at bay:   Bananas : Are high in potassium which is an alkalizing mineral that has a high pH value. The higher the pH value, the lower the acidity, which is  why the banana is a formidable antidote for acidity. They also have a component that makes the stomach lining produce more mucous. This mucous protects the inner lining of the stomach, reducing the damage c

Feeling stressed? Try these natural remedies

Our physical health depends on several important factors such as the constitution we have inherited from our parents, the type of food we eat and the amount of exercise we give our body. Along with these, it is increasingly becoming obvious that the state of mind plays a major role in deciding how well the body functions. Stress can drastically reduce the ability of the immune system to defend the body against illness and therefore, it is vital to take steps to deal with stress. Here are a few natural remedies that can help you combat stress or deal with it in a healthy way. Eat the right food According to Ayurveda, food possesses three qualities or  gunas  –  sattva, rajas  and  tamas . Sattvik  food is light, fresh and nutritious,  rajasik  food is spicy and hot and fans emotions, and tamasik  foods are stale and promote the sense of inertia. Obviously, the consumption of a diet rich in  rajasik  and  tamasik  foods is bound to keep you in a state of mind that is most conducive