Loading

How to add table data to DataGridView columns

Madhukumar Viswanathen

Dear all
I have a datbase named ""Dbase". it have a table named "Customers" and field names are-" id, nam,hnm,phn,pin,cod,amt,dat ". 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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Zoran Horvat15y ago
Accepted answer
Your can change column names in the query like this:

SELECT nam AS cstnam, hnm AS csthnam, amt AS cstamt FROM...

Zoran
0
Madhukumar Viswanathen15y ago
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
0
Vilas Gite15y ago
@Madhukumar
please refer this for more details: http://stackoverflow.com/questions/3120852/sql-variable-column-name-depends-on-row-data

Thanks!
0