connection sting VISUAL BASIC .NET and SQL SERVER 2005

there are many types on how to connect VISUAL BASIC .NET and SQL SERVER 2005. I definitely suggest this type of connection string. whenever I'm connecting vb.net and sql server 2005 i create a class inside the class i create a public method, public method because you can access it anywhere in your project

Imports System.Data.SqlClient


Public Function ExecuteQuery(ByVal Query As String) As DataTable
        Dim sqlcon As New SqlConnection("Data Source=COMPUTER -NAME\SQLEXPRESS;Initial Catalog=DATABASE NAME;Trusted_Connection=True;")
        Dim sqlda As New SqlDataAdapter(Query, sqlcon)
        Dim sqlcb As New SqlCommandBuilder(sqlda)
        Dim dt As New DataTable
        sqlda.Fill(dt)
        Return dt
    End Function

in Data Source change the computer name to you computer name
initial catalog is your database name
trusted connection is optional you can use your username "sa" by default and password "what password did you enter" and done you have now your connection string.

let say that you want to gather some data on your database. first create a variable dt as new datatable

Dim dt As New Datatable
dt = executequery("SELECT * FROM tablename")

Read More

success

first of all what is success? success is a accomplishment of an aim or idea. Success is going from failure to failure without losing enthusiasm, Success in life could be defined as the continued expansion of happiness and the progressive realization of worthy goals Success is doing ordinary things extraordinarily well. all of us needed to work harder than before to accomplish our mission and gain success. after getting being successfully you have the right in bragging what have you done and share some story on what did you do before you became a successfully man or women. sharing of thought is the best way to educate and tell other people how should they work to gain the word SUCCESS

Read More

Fliptop Battle

Fliptop is a rap battle league that puts two people in a match to have them insult each other with the cleverest punch lines and sharpest rhymes.

You can say it's one of the biggest youtube sensations of 2010 because it has gone viral with several of their videos hitting a million views in just a couple months.

Last July 17, they had a gig at Freedom Bar in Anonas, QC. FHM checked it out, and put the man behind the league, Anygma, on the hot seat. 

Be sure to check out the gallery below as well, for a photo-by-photo account of what happened that night. You can also check out their Youtube page by clicking here.

How did Fliptop start?

It was as simple as applying some format from America to the Philippines. We’ve had battling ever since also in the Philippines, but when Grind Time was shown—the American league, probably the biggest in the world too—and when their format, the concept of it was introduced to the greater public, I picked up on it. I applied it here.  

How did you put it all together, from inspiration to execution?

Grind Time they have the exact same format, in the sense that, it’s free battles on Youtube. In a sense, you cut out the middle man, you don’t even have to look for someone to air this or think about making a DVD and selling it. Profit is really not the priority. 

I’m aware of the talent here in the Philippines. I just put two and two together, like “So, if we have this kind of talent, what would it take for it to work?”

Would it be wiser to divide the Filipino and English conferences? Would it be wiser to have these many divisions all around Manila? Like, would it be wiser to go with this or that? We just went with whatever works in the Philippines.

It’s an entirely different paradigm. I don’t even market anything, and that’s not to be cocky or anything. All we have is one Facebook, one Youtube, and one Formspring. I just go online, and answer questions, or post a poster if there’s an event coming up.  

When did this start?

Our first event was in February, if I am not mistaken. 

Are you the sole organizer of Fliptop?

Well, I guess, with the logistics and everything, and the actual organizing, yeah, I do majority of the work. I have some partners too, the cameraman, Kev, and DJ Umph from Miscellaneous, who is like my second-in-command. He takes the footage and edits it.

Of course, I get a lot of moral support, and brainstorming help from my camp from my homeboys and everything.

Read More

Boracay Get Away

Where you can the stretch out associated with high-end accommodations as well as victory hotels, Boracay Tropical isle isn't specifically known for as as abudget-friendly destination—after just about almost most, that troublesregarding money any time you’re throughout hedonistic heaven?

Aquatic sports and also island-hopping during the day, boat deep massage therapy with setting sun, cocktails through the night entirely until sunrise—thisis the perfect Bora plan. Needless to say, it doesn’t come with out a largeprice.

However a small budget doesn’t need to are available in the clear way of lifeexperiencing and enjoying the gifts vacation hot spot, especially throughout the off-peak season (Summer so that you can early October) when the ratesof everything coming via plane tickets in order to be able for you to helpaccommodations are reduced.

Acquiring there

Promotion fares are aplenty whenever that's off-peak , thus a few monthsbefore your vacation, look out for chair product revenue coming via budgetairlines just similar to Cebu Pacific cycles, SEAir, Liveliness Oxygen or perhaps Airphil Express, that provide a couple of Boracay-bound flights: so that you can Kalibo, approximately two hours as well as A quarter-hour from thetropical isle by alone through shuttle and banca; or Caticlan, which is only onebanca leave coming via Boracay’s white-colored coast line. With the chairsales, you can also rating a roundtrip ticket in order to be able for you to helpCaticlan for less than P1,000 if you're thus lucky.

For those who have the posh of time (18 so that you can Sixteen hours to beexact), you might like to prefer to visit the island by sea through the 2GoVacation Ferries, which usually cruise coming via Batangas for the CaticlanJetty Interface and back again for a little over P900.

A place to stay

Whether you’re staying upabout Whitened Seaside, the area's primary touristremove, or even Bulabog seaside on the reverse side, which can be loved bykite users as well as wakeboarders, there are many inexpensiveaccommodations, if you know where you can seem.

The actual northern-most section of White Beach will be Station One, that hasthe actual widest shore, the best possible fine mud and more costly areas,though fairly inexpensive beach accommodations are still accessible below.

Close to Train stop Two there is a Boracay Garden Vacation holiday location,that offers specific promotion deals for the trim season, which includes hotelsfor 2 evenings, an everyday self serve smorgasboard breakfast (to take inback again the money's really well worthy of) and hang meal, and also terrainas well as sea transactions via Caticlan, regarding P1,628 per particular man or woman.

The particular less expensive accommodations are to be found at StationSeveral, the much a smaller amount commercial area of Whitened Beach,with areas opting for as low as P1,000 a night as well as cheaper if you areready to postpone the particular luxuries of air-conditioning. With StationSeveral, as an example, fan areas from Orchids Hotel might want to use as little as P500 a night.

At the same time, alongside Bulabog seaside, additionally a well-likedwindsurfing location, enthusiast areas best for two can be only P660, like at the Isla Kitesurfing Guesthouse, located right on the particular beach.

Book a room in advance and also twenty-four hours a day function your tawadbracelets around the resort managers/owners, who're likely ready to give you the greatest cost in the event that they’ve got room in order to be able for you to help extra. In the event that you’re driving a big group, all the better—everything, especially area and panel, cost less whenever discussed.

Where you can take in

No one will certainly determine you if someone makes baon several canned foods as well as cup crackers from your home, if not maintain stocks of these people in the closest grocery store. Foods could be costly around the White-colored Seashore remove, though there are some conditions.

Smoke cigarettes, from D’Mall for instance, presents filling up foods such asinihaw na pusit having hemp for just a P100. Big Mother's with Place One also provides meals like inihaw Na liempo with hemp regarding P95, as well asresidence expertise just similar to pig dish having rice regarding P80.

Obviously, there’s usually Andok’s, which serves their own well-knownPorkcharap as well as Dokito Frito at under P60, and also the endlessChoriburger, which you'll want to get at the actual footpath barbecue smokerrepresents around P40, marketed alongside the less-famous-but-certainly-just-as-yummy-especially-if-you’re-Boracay-drunk barbequed exhibitionists(furthermore P40) as well as grilled isaw (P10 every stick).

What direction to go

An important feature about Boracay will be, absolutely simply zero financesbarely means a pain. Sure, you might have to accomplish without island-hopping, cliff-diving, paraw sailing, or perhaps kiteboarding which usually manycost you a lot of money. But on this bustling tropical isle, are's lots else to accomplish even for many who don’t have sufficient funds.

With regard to P299 (off-season), you may enjoy the beach therapeutic massage therapy. Regarding P50, you can rise D’Wall with D’Mall. For P35, you can blast as numerous containers that you can at the Boracay Series.However make sure you, on your own reason, regardless how cheap it's, do not allow these people cornrow hair.

Regarding practically nothing in any way, stroll the length of White-coloredBeach and the ones view, formulate your own sarong and also go to sleep in the sunshine or finally finish that book. Leap into the water and go swimmingin order to be able for you to help famed Willy’s Rock, permit your body ride the particular ocean, share secrets together along using your “bestest” friendswhile you move in the water. Take tacky leaping shots, get sand withwith yourhead of curly tresses, become a member of any Frisbee game making brand fresh friends although you’re at this.

Observe the sun change pink and people diminish directly straight in shapessince the sunlight models, be reminded that our own the world is great, as well as realize that when people state how the finest things in life have the freedom to, this is exactly what they suggest

Read More

Cops kill 6 hijackers in Cavite clashes

Six suspected hijackers, including three Metro Manila policemen, were killed in back-to-back encounters with policemen in Dasmarinas City, Cavite, early Friday. Two of the slain suspects were identified through their ID cards as PO2 Robert Santos, who went Awol from the National Capital Region Police Office last August, and PO1 Junjie Jun Liangco, an active member of the NCR Regional Public Safety Battalion, Cavite provincial police director Senior Supt. John Bulalacao said. The third suspect is believed to be PO3 Jessie Villanueva of the Manila Police Station 8 (Sta. Mesa), Bulalacao said in a phone interview. Three other slain suspects remain unidentified as of this writing, but police believe these had been involved in other hijacking incidents in the Southern Tagalog area. Recovered from the suspects were a K-9 sub-machine gun, two caliber-.9mm pistols and a caliber-.45 pistol with PNP markings, and two caliber-.38 revolvers. The clashes occurred around 2 a.m. in Brgy. Lankaan 2 and Brgy. San Agustin 3. Bulalacao said members of the Dasmarinas City Police and Cavite Provincial Police intelligence branch conducted an operation in the two areas after they were tipped off by five other suspected hijackers arrested on Thursday. “Ang nag-lead sa amin eh ‘yung unang lima na nahuli kahapon, tatlong lalaki at dalawang babae. Sila ‘yung nagturo kung nasaan tinago ‘yung goods na nakuha sa hijacking noong Martes,” he said. On Tuesday, hijackers stole some P1.9 million worth of grocery items from a delivery van along Aguinaldo Highway in Brgy. Salitran 1. Yesterday’s encounter resulted in the recovery of the stolen goods, as well as a Mitsubishi Adventure with no registration plate, and a Toyota Vios. (John Roson)

Read More