How to add table data to DataGridView columns

Question

Dear all I have a datbase named Dbase. it have a table named Customers and field names are- id namhnmphnpincodamtdat . I have already a DataGridView control. in it columns named cstnam csthnam cstamt. I want show table datas to  nam to cstnam  hnm to csthnam amt to cstamt. please give c# code for the above Madhukumar Haripad

Zoran Horvat · Answer

Your can change column names in the query like this: SELECT nam AS cstnam hnm AS csthnam amt AS cstamt FROM... Zoran

Madhukumar Viswanathen · Answer

Sir I use that code. But I cannot take the data on a correct DataGridView column possition . How I can change the the data under appropriate column headings

Vilas Gite · Answer

@Madhukumar please refer this for more details: http://stackoverflow.com/questions/3120852/sql-variable-column-name-depends-on-row-data Thanks!