c# - Formatting GridView Columns by DataType -

hi i'm working on small winforms app, i'm more of web developer forgive me ignorance here.

basically have bunch of gridviews i'm binding code behind like:

        var con = new selectorderslineitembyorder() { connectionstring = constr, fk_orderid = id };         dataset ds = con.executedataset();         gvvendors.datasource = ds.tables[0]; 

currently formatting columns such:

        gvvendors.columns[5].formatstring = "{0:dd/mm/yyyy}"; 

for lack of better word pain in butt !!!

is there way hook event handler or iterate after fact , like:

        foreach (column c in gvvendors)         {             if(c datetime) { format accordingly ... }             if(c decimal) { format accordingly ... }         }             

any appreciated ...

you can write method of own formatgrid() formatting , call after assigning datasource. like

     var con = new selectorderslineitembyorder() { connectionstring = constr, fk_orderid = id };     dataset ds = con.executedataset();     gvvendors.datasource = ds.tables[0];     formatgrid(); 

you can use following property setup formatting.

datagridviewcellstyle.format 

no need loop through columns. know column names , not going change dynamically

   datagridview1.columns["yourcolumnname"] 

should enough.