A small tutorial on linking C#.NET with MySql Database

Well,I was just trying out some stuff in ADO.NET , i.e. relating C#.net with databases.So here are some basic stuff you need to do before you get started with c#.net and database handling.

1. Get MySql installed on your computer and set the userid and password.

2. Get the MySql connector. get it @ http://dev.mysql.com/downloads/connector/net/6.0.html

So,lets’ get started.First create a windows form application(we will use it to view the tables ,when we do a query).

Step 1 : Right click the properties,and add reference.

Select MySql.Data

and include using Mysql.Data.MysqlClient

Step2 : Establish Connection
1.string connect = “DataSource=localhost;Initial Catalog=login;User ID=root;Password=admin;” ;
2.MySqlConnection con = new MySqlConnection(connect);
3.con.Open();

1. Create a connection string.Here,DataSource refers to the ip address where the MySql database is present,Initial Catalog being the Database you are connecting to, UserId being the Mysql userid and password ,the password for the same.

2. Create a new MySqlConnection object and pass the connection string.This creates an object and you are ready for connecting

3. It establishes the connection.

Step 3 :

string querystr = textBox1.Text;
MySqlCommand cmd = new MySqlCommand(querystr, con);
cmd.ExecuteNonQuery();

querystr takes a query from the text box in the form.

MySqlcommand cmd passes the query along with the connection string.

ExecuteNonQuery() method is necessary to execute the same.

You can execute any kind of MySqlstatement..All you need to do is type the exact statement in the TextBox

Sample MySQL query statements :

insert into marks_table (sl_no,name,marks) values ( 5,’xyz’,89);

this inserts a row into the table called marks_table with values 5 , xyz and 89 under serial no,name and marks

Hope this post was useful.Will continue on how to display later.Feelin sleepy.!

Cheerio

Redirect output to a file in linux

Its’ been kind of a while since I blogged on Linux.Sometimes we might require the outputs generated by a command to be stored in a text file for future use..This entry is all about dealing that.

There are essentially two different ways of doing it,depending on your requirement

1. commandname > filename

sample: ls > output.txt

The file is created in the current working directory.Upon usage of ‘>’,the previous contents are erased,and the new contents are written.

2. Sometimes you’ll need the contents to be preserved,In such a case use ‘>>’

eg: ls >> anerudh.txt

In this case,the file is updated,and your previous contents are unaltered.

Cheerio

Real madrid and the off-season sale

For those who know tamil,”ADI THALLUPADI” or “ADI-month SALE” .sums up what’s in store from madrid in the upcoming months.Stocked with goods: old,new,worn,torn and much more, Real madrid have brought in new display products (a.k.a. Kaka and CR9) to replace the old one.Sounds like their expiry date is nearing.But no one really expected Klass Jan Huntelaar to bite dust so early…What seemed like a fart-station(madrid,farting money),will now be plugged,probably will be suffering from constipation for a while.But hey!! all for the good…

Showing stingy Italian mentality,apparently Mr.Galliani has contaced Perez hoping for a discount on Huntelaar.According to reports , he went all the way to madrid and hoped for a reimbursement and a 10 million pound off on huntelaar.(they actually want him for 10 mil pounds)Mr.galliani,CR9’s piece of ass will cost you the entire club,so forget getting Huntelaar’s services.

Real Madrid can actually make superb profits this transfer season.One,they can start an agency just outside the club which can take registration of interests for a player.

Probably they can even start an offer like ,BUY ONE DUTCH PLAYER,and get DRENTHE @ 15 % OFF..

The scroll @ real madrid website reads:

THE REAL SUMMER SALE :

DUTCH PLAYERS @ CHEAPEST RATE EVER

SPECIAL OFFER FOR RIBERY HOLDERS: SNEJIDER + VAN DER WAART AT 45 MILLION ONLY.

SALE THROUGHOUT SUMMER @ REAL MADRID….WATCH OUT FOR THIS SPACE!

Explains Galliani’s 10 million bid.

Huntelaar’s on his part must be feeling like a cheap whore with the treatment rendered to him.Seems like he has met the wrong people in the railway station, who are planning to ship him out to mumbai for some money.Little do they know,the beauty they are going to ship is a pro with the balls.

Galliani:Allright , you wont’ reduce your price eh?

Perez:Pay up 20 and he’s all yours.For 10 million pounds,probably i’lll let you kiss Cr9’s boot.

Galliani:(With a hindi movie villain look)..PEREZ,I’ll come and get him,from you right under your nose.CR9,kaka and everyone else and show who MILAN really are,ofcourse after 10 years.Let them get mature,coz we always have room for age (+ talent ofcourse!)

Perez  : Allright,get lost now.

So our Galliani comes back , dejected and makes Ambrosini the club captain…

Huntelaar...FOR SALE...10% OFF

A Real Prediction

My MY!

Dunno why so many posts on Madrid,but they seem to me like a topic with much more scope than Blondes.Probably humour sites will open up a new section for Madrid Jokes..Here is the scene for January 2010.

Scene in Madrid’s HQ :

Present : Perez,Ribery,Ronaldo(on crutches),Kaka,Higuain,Raul and other Madrid players

Perez:Ribery,you have been a disaster.All you were required to do was to serve clean water to Ronaldo ,Kaka and co.Look what you ‘ve done.Now Ronaldo is injured coz of you assole.I got a call from Aboomoslem Khorasan,a club in Iran.Half the Dutch contigent is there.Their wives will be the only ones showing their faces.Rest will be covered.

Ribery : Allright,get me out in May

Perez : Hone your water boy skills too.

Higuain becomes restless,since the world cup is approaching.He is giving serious thoughts about banging Maradonna’s daughter for a shot in the worldcup finals,when..

Perez : kaka,you clean the bench for a change,Higuain you ‘ve been good ,you are promoted.Now you shall start.Cristiano Ronaldo am sorry.All ribery’s fault.Guess you’ll have to wait for your chance.

Ronaldo : I can wink.Is that enough to play in the game??

Conversation ends.

In the meanwhile….All through the season,Hull city’sBenjani had been netting in goals.And surprise surprise..

January 14th 2010 ,

Real madrid bid 20 million pounds for Benjani.Hull,are all the more happy since they have never seen 20 million together in a suitcase.Perez sends a dog + 20 million for Benjani.A great deal claims the SPANISH PRESS.Poor madrid doesn’ spare even HULL!

January 20th 2010,

And its Higuain!!!!!HE Scoooooooooooooooooooooooooores…Agueros’ wife………………………………………..

He recieves the call for the argentian national team

The “Real” Deal..Times of Recession

Where Rea-ly does Madrid go after all these inquisitions?Kaka,Ronaldo,Raul Albiol and the French Hitman Karim Benzema.Houseful seems to be the board outside the training grounds,but Perez claims Two more vacancies.Apparently disappointed that Valencia removed David Villa from the market , they had to ’settle’ for benzema.I sound like a casualty of choice of words.”Settling” for Benzema?Perez!!!Money in the sac,in the hole,and god knows where,Real Madrid have literally been pooping Euros and Pounds. A sample Bidding war :

AC Milan : 15 Million that will be that.

manchester united : 20 million

Arsenal : I want to buy benzema,but……..Adebayor should stay.(clearly popper)

Liverpool : We will buy only Spanish people,even for washing toilets.

Along comes Mr.Perez ,

Fuck you lot,35 million pounds and I take Benzema.

Ferguson resorted to M.Owen after the assault,Ac Milan yet to recover,Arsenal seems to have convinced Adebayor and Liverpool have added two CeltaVigo staff to their yard.True to their words.

The Dutch contigent seems to be bustling with energy about the latest acquisitions.If rumours are to be believed,Van Nistelrooy is planning to start a bar outside Real Madrid,with Drenthe being the Incharge.Snejider will mostly start learning to play golf(early age) and Van der waart will probably be keeping boots for the players.Huntelaar plans to open an old-age home.Really honourable

And the shocking news is Real Madrid want to spend 50 million for a water boy by the name ‘Franck Ribery”.He is so desperate impress Madrid,that he skipped training for bayern just to watch Ronaldo on the news channel.Oh yes,wearing a pink cap !And not to forget Xabi Alonso is part of the ambitious bench cleaning project. Just for the record,we are in recession.Real Madrid players surely have the knack of  adapting!

Perez definitely knows to get the best out of his players….

Recession times !

220 V up my ass – The Michael Owen transfer saga

Blimley! The Anfield legend was reported to be in Carrington Avenue at Manchester for a medical.Well , when I first saw the news,220V went right my ass.Pretty strong reaction.Is it a master Stroke or a Disastrous one?Desperate times call for desperate measures they say.

The story that has unfolded has been nothing short of a rags to riches story , with Owen’s potential suitors being Hull city.Premier league football was the mantra according to them.Just when everything seemed to be bleak for the English Striker,along came a thursday evening,accompanied with the most unexpected of surprises.Manchester United calling Michael Owen to secure his services.

These events were probably the consuequences ofManchester united’s reported top target Karim Benzema being lapped up by the free spending Spanish Giants Real Madrid.Papers called it a bitter blow,and naturally a list of high profile strikers were linked with manutd ,starting from the confedrations cup King Luis Fabiano to Jose Mourinho’s ass-saver Zlatan .Sir Alex Ferguson has known to be a keen admirer of Owen,and surprise surprise he was called forth!

Being a free agent,manutd have nothing to loose except a few quid.Ofcourse,the statement holds true given United continue to press in the transfer market.With atleast 70 million pounds left in their wallets,surely no player is impossible to get.What United stand to gain through Owen is the experience of a proven goal scorer in the premier league .Being no stranger to the European circuit , Owen can prove to be quite a handful for defenders , whether from the bench or from the start.And ofcourse he will be willing to play a second fiddle to Berbatov and Rooney.With games aplenty for the english champions,Owen will have loads of chances to prove his mettle. The only constraint to the above lines being his injury record.More known for his injuries than his goals in recent times , Owen has struggled to keep himself fit.But with an excellent medical team and with lesser pressure to handle (than at newcastle) , he can turn to be a good signing.With a pay-as-you-play deal in place,united have more or less increased his appetite.Interestingly,if the  6(homegrown)+5 rule is invoked,United have enough in their ammunition to be a side with substance.If it backfires,Owen will be joining Owen Hargreaves in the treatment room.

What this presents before Owen is the golden chance to thump few across the goal and get noticed by Fabio Capello.More importantly he will be playing with Rooney,probably the first name in the England Team sheet.The lure of OldTrafford ,and the sight of Champions league,must have egged him on.AndWhat remains to be seen is how injury free he remains through the season , and if his hunger for goals and competition is still huge.

As i write this,the Anfield legend is completing his medical with Manchester united.A calculated gamble,but a shocking one.The impact of the shock however,remains to be seen!

Michael Owen

A key note on apt

Just felt like writing something useful…I’ve been checking out on packaging for a while now,and came up with some couple of interesting(and not so interesting details)

1. apt-get and apt-cache are exclusively for .deb packages.But now they have come up with apt-rpm too for rpm packages.

2.The sources.list file present @ /etc/apt can be modified .What do we gain? In case you find a great repositary for .deb packages and others,then you can list them out there.I’ll just paste the contents down here..

#deb cdrom:[Ubuntu 9.04 _Jaunty Jackalope_ - Release i386 (20090420.1)]/ jaunty main restricted
# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.

deb http://in.archive.ubuntu.com/ubuntu/ jaunty main restricted
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://in.archive.ubuntu.com/ubuntu/ jaunty-updates main restricted
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://in.archive.ubuntu.com/ubuntu/ jaunty universe
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty universe
deb http://in.archive.ubuntu.com/ubuntu/ jaunty-updates universe
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team, and may not be under a free licence. Please satisfy yourself as to
## your rights to use the software. Also, please note that software in
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://in.archive.ubuntu.com/ubuntu/ jaunty multiverse
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty multiverse
deb http://in.archive.ubuntu.com/ubuntu/ jaunty-updates multiverse
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty-updates multiverse

## Uncomment the following two lines to add software from the ‘backports’
## repository.
## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
# deb http://in.archive.ubuntu.com/ubuntu/ jaunty-backports main restricted universe multiverse
# deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty-backports main restricted universe multiverse

## Uncomment the following two lines to add software from Canonical’s
## ‘partner’ repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
# deb http://archive.canonical.com/ubuntu jaunty partner
# deb-src http://archive.canonical.com/ubuntu jaunty partner

deb http://security.ubuntu.com/ubuntu jaunty-security main restricted
deb-src http://security.ubuntu.com/ubuntu jaunty-security main restricted
deb http://security.ubuntu.com/ubuntu jaunty-security universe
deb-src http://security.ubuntu.com/ubuntu jaunty-security universe
deb http://security.ubuntu.com/ubuntu jaunty-security multiverse
deb-src http://security.ubuntu.com/ubuntu jaunty-security multiverse // ADD IN THE FOLLOWING FORMAT ONLY.
root@ubuntu:/etc/apt# clear

root@ubuntu:/etc/apt# cat sources.list
#deb cdrom:[Ubuntu 9.04 _Jaunty Jackalope_ - Release i386 (20090420.1)]/ jaunty main restricted
# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.

deb http://in.archive.ubuntu.com/ubuntu/ jaunty main restricted
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://in.archive.ubuntu.com/ubuntu/ jaunty-updates main restricted
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://in.archive.ubuntu.com/ubuntu/ jaunty universe
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty universe
deb http://in.archive.ubuntu.com/ubuntu/ jaunty-updates universe
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team, and may not be under a free licence. Please satisfy yourself as to
## your rights to use the software. Also, please note that software in
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://in.archive.ubuntu.com/ubuntu/ jaunty multiverse
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty multiverse
deb http://in.archive.ubuntu.com/ubuntu/ jaunty-updates multiverse
deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty-updates multiverse

## Uncomment the following two lines to add software from the ‘backports’
## repository.
## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
# deb http://in.archive.ubuntu.com/ubuntu/ jaunty-backports main restricted universe multiverse
# deb-src http://in.archive.ubuntu.com/ubuntu/ jaunty-backports main restricted universe multiverse

## Uncomment the following two lines to add software from Canonical’s
## ‘partner’ repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
# deb http://archive.canonical.com/ubuntu jaunty partner
# deb-src http://archive.canonical.com/ubuntu jaunty partner

deb http://security.ubuntu.com/ubuntu jaunty-security main restricted
deb-src http://security.ubuntu.com/ubuntu jaunty-security main restricted
deb http://security.ubuntu.com/ubuntu jaunty-security universe
deb-src http://security.ubuntu.com/ubuntu jaunty-security universe
deb http://security.ubuntu.com/ubuntu jaunty-security multiverse
deb-src http://security.ubuntu.com/ubuntu jaunty-security multiverse

Cheerio!

A letter to Carlos Tevez….

Dear Carlito,

Hope you have picked up little english in your stay at the epl to comprehend this.Firstly thank you for your services.Please sign for Manchester City.Manchester United has too much competition among their ranks with players like Wayne Rooney,Dimitar berbatov,Federico macheda and Welbeck.Backed by a loser of a manager(legendary),not only have you lost half your eye for the goal,you have lost your nuts in the process.Definitely winning the Champions League,English Premier League twice,Carling Cup,Club World Cup and earning 80,000 pounds a week is far more demeaning than earning 200,000 pounds and losing week in and week out(probably drawing),with an end of season report indicating the progress in the table(i.e.finishing 8th). Your fifteen goals a week and your cry baby Argentine attitude is no longer warranted.Hopefully you come over to OT and your team gets their balls whacked as always.Hopefully,mancity gets to see some silverware,before you retire,else pack your bags to the Turkish / Greece league or ofcourse if your are 33+ or more when you make this decision,dont’ loose hope.There is a old age home available in Italy,popularly known as AC Milan.

Loads of love,

A Manchester united fan

The Real Race

Blooming flowers,chirping birds and a glowing sun.Withering leaves ,orange skies and a beautiful wind.A dull overcast,a drawn blanket with two toes outside.Textbook definitions of season.Forget polo,I like the pole.Black Jack.My fair lady.’Hey there,Mr.Soldier.Attention!!’.Seasonal again.The toast of every season changes.Right from Sexist to Racist,the taste buds of the pepole have been changing.Faster than diapers,they say.To act like a responsible citizen of the blue planet,cracking racist jokes in a social gathering over a drink has become an essence.Shame well lost..A gentle laugh never hurt anyone,rather never any race.Mr.Russel Peters will know it better.Right from mocking Spanish with his “Essay” and “Senour” to his snubbing remarks on Indian names(Suk-deep Singh),he is by far the biggest Race Freak you can ever come across.Push off Bhajji.Our tongues cant’ be held responsible for their seasonal variation.So who is to be blamed for all this?Seeking an answer to this question might be the least in a priority list,that might even include taking a bath in a severe winter morning..I firmly believe that the grass roots for this discriminative behaviour lies in the behavourial patterns of human beings right from time immemorial.
Chess,one of the most ancient games known to mankind can be cited as an example.Ever wondered why the chess squares are black and white?So are the pieces.Forget all that,why does the white piece have to start first and not the black ones?The rift doesn’t end here.Racism just grew over the year.You play a game “ Fair and Square” ,and you end up beating up your opponent’ Black and Blue ‘! It is shocking to see English language playing fiddle to such discrimination.The white dove,a symbol of peace,the black band ,a cause for mourning.What a shame!Enter the world of food,it gets groovier.Black Pepper,Black coffee,Black Tea,Red tea too! & Brown sugar.Finally we have a third entrant!Why isn’t it White Sugar?White Salt?Enter Cafe Coffee day,our eyes are gretted with ‘Black Forest’(pun not intended) and Green apple soda!This is really eerie…
Hollywood adds to our long culprits list,”My fair Lady” followed by “The Dark Knight” and not to forget “ Donnie Darko” .A big generalization. The illustrious list continues with Grammy award winners “ Black Eyed Peas “ and “fade to Black”, a song by Metallica. If we scan through with a ‘Red’ eye,even miniscule details appear coloured, suprisingly not red always! Red alert says the danger sign,which has a white skull over a black background.Thats inter-racial for you! Science and Technology are not exactly the hostile neighbours,Resistors have ‘colour codes’, aeorplanes have “Black Boxes” and so on and so forth.
The list just goes on and on,and suprisingly keeps growing.So why is there a fuss about colour nowadays? From hairy brown creatures, we are now black, white, brown and much much more.The hairy stays on of course. So much for diversity.

The great debate – Tevez or berbatov ?

I know this post is actually quite a little late,and is rather inconsequential now that Tevez has left Manchester United for good.But is Tevez that good , for his loss to be mourned like that of a national hero?Or is Berbatov of that essence to really knock the winds of confidence out of Tevez’ sails?

Carlos Tevez,signed from West Ham on loan & a complicated deal,is  a Duracell bunny who can smash home goals.Critics were skeptical about the Tevez-Rooney combination since the both of them offered nothin much different to the other.A real dynamite no doubt,with his energy and enthusiasm he won over millions of Red Devil supporters’ hearts with his sterling performances in the 2007/08 season.At the same time,in North London a man named “Dimitar Berbatov” was the celebration of Tottenham with his goals and elegance.The Bulgarian target-man had an eye for goal and commentators absolutely fell in love with his stylish display of football.

Carlitos enjoyed a brilliant first season @ united,winning the EPL and the Champions League.In an attempt to bolster his squad SAF signed Dimitar Berbatov on a club record transfer fee of 30.5 million pounds.A Huge price indeed…Berbatov started off in a real hurry,creating a flurry of assists and occasionaly netting home a few.In the meanwhile,the argentine was benched,and his services were called upon only in Carling cup games and against lesser teams.Tevez lack of oppurtunities contined to frustrate him and Maradonna(yes,the fraud yet legendary Argentine coach)called upon him to quit United.And the rest is history they say….

Why Berbatov over Tevez?

* Berbatov is an ideal target man,which makes rooney play just behind him.Proven affection for goal scoring ,with a few tricks up his sleeve,the bulgarian forward is essentialy your replacement for Ruud van nistelrooy.Definitely loads of Mindless manutd fans(no offence) will go on to say he doesnt run,he is lazy,he is laidback.Answer: If everyone played the same way,then no need to buy no players.Berbatov might be slow on the ball,but is a real handful for defenders.He doesn’t need to run fast to score goals,unlike Tevez who knows only to run in some cases.Some people argue saying Berbatov has been a flop.14 goals and no.2 in the league for no.of assists doesn’t indicate failiure.So does winning the EPl and the carling cup in your debut season.Lazy he might be,but elegent he is.

Carlos Tevez has numerous reasons to understand why he wasn’t chosen.Primarily , berbatov gives united a variation.He is a goal scorer,energizer and all dat no doubt,but 1 goal in every 365 minutes is a poor record by any standards.So is the no goals scored record in the months of January-Febrauary when Rooney was injured.Squandering sitter after sitter ,yet complaining about lack of chances.Very poor indeed.

And secondarily,he is a player on loan.why would I play a player who is on loan ,when I have a better choice bought.I can always use the guy on loan whenever needed.That could have been the mentality too.But all said and done,Tevez can run and defend , take the ball away and might be a fan favourite,but he definitely is not the missing piece in the manutd puzzle.Probably Berbatov was,they say.

Lastly,his poor attitude citing berbatov as a reason for his departure,reflects cheaply on the argentine forward.First henize,next Tevez.Is it a problem with the country’s players or is it a simple case for money.Definitely he is going to get more money,more chances at mancity.Competitive football?European league?Definitely No.A clear degradation in his standards.berbatov elevated himself from Tottenham to united,whereas tevez went back from top to city.Added to this is the fact that Tevez has played the most number of matches among the 3 strikers.Very Very laughable decision indeed.

Definitely manutd has lost a stellar performer,a fan favourite ,a crowd puller,but it is a loss they can cope up with.Macheda and Welbeck are growing quickly in the ranks and Berbatov all set for his second season (&even better performaces),fire power doesn’t seem a problem for United (ofcourse they need a winger tho!).

Dimitar Berbatov and Carlos Tevez?Who's the one