can any one help me how to create charts by connecting to database.

my need is that i have to group by a column in database and represent it in a chart in visual basic. the values after groupby may have 10 values. how can i do it in pie charts and bar charts.

You can use MSchart as long as it is a simple type of graph that you are after. It will allow you to use a bar graph, I'm not sure about the pie graph tho

There is alot of help about programming it, and even microsoft have some good information about this

http://msdn.microsoft.com/en-us/library/3ks53324(VS.71).aspx