Text

From DB to datagridview, no wizards allowed


I was looking for an easy way to populate my datagridview, keeping my column headers and without playing around with the properties too much. Here i wrote a method that grab data from a DB, and I used it here to pass it through the screen.

First, I get the data from the DB to a Dataset, so I use a Datatable to order my data and then I used a double for-loop to fill the DGV up.

The only thing missing here is the method inside ConnTool that I used to run my query, here I add a pic of it.

Photo
Well, I just started to work for the government this week (INTA - Nicaraguan Institute of Agro-Technology ). It is not my first experience working for the Nicaraguan government, I used to work for DGI. DGI is the Nicaraguan version of the IRS (When I use my DGI T-shirt sure as hell I still get very good service at restaurants :) ). So, everything is going nice at my new job: Friendly ppl, small department, and everything is done from scratch! Now, I will be upgrading and updating some of the systems. Did you see the little and cute icon in the top of the screen? That´s  a Foxpro 2 program ppl! We are talking 1991, I was like 11 years old at that time. So, I have to migrate this systems to .NET. I like it: redesign, implement and test, and everything in between. Very cool projects!

Well, I just started to work for the government this week (INTA - Nicaraguan Institute of Agro-Technology ). It is not my first experience working for the Nicaraguan government, I used to work for DGI. DGI is the Nicaraguan version of the IRS (When I use my DGI T-shirt sure as hell I still get very good service at restaurants :) ). So, everything is going nice at my new job: Friendly ppl, small department, and everything is done from scratch! Now, I will be upgrading and updating some of the systems. Did you see the little and cute icon in the top of the screen? That´s  a Foxpro 2 program ppl! We are talking 1991, I was like 11 years old at that time. So, I have to migrate this systems to .NET. I like it: redesign, implement and test, and everything in between. Very cool projects!

Photo
Emancipate yourselves!! I love tattoos. I had been thinking about getting one, actually I’m thinking about it too much. Maybe a religious tattoo like a David’s star or something like that, maybe something (like a quote) in hebrew.
I found this pic browsing at Flikr, and just loved the expression on her face, so confident… The colors on the tattoos are amazing also, well her skin is very beautiful, nice canvas.

Emancipate yourselves!! I love tattoos. I had been thinking about getting one, actually I’m thinking about it too much. Maybe a religious tattoo like a David’s star or something like that, maybe something (like a quote) in hebrew.

I found this pic browsing at Flikr, and just loved the expression on her face, so confident… The colors on the tattoos are amazing also, well her skin is very beautiful, nice canvas.