I have a dgv which is bound to a data source and the problem is that I changed the Fill method of the datatable because I needed a different view of the datetime columns(something like CONVERT(...)...). But the problem is that this way my columns are readonly beacause the source of the information is readonly is there a way to bypass this problem. I don't know maybe the columns are not bound correctly.

Thanks in advance.

Maybe you could find a way to do the conversion in your application instead of in SQL.

For example, the DataGridView columns have a Format property that you can set in the designer to do reformatting.

For bound fields outside of a DataGridView, you can implement custom Binding.Parse and Binding.Format events to control what is displayed in the bound field onscreen.

Maybe you could find a way to do the conversion in your application instead of in SQL.

For example, the DataGridView columns have a Format property that you can set in the designer to do reformatting.

For bound fields outside of a DataGridView, you can implement custom Binding.Parse and Binding.Format events to control what is displayed in the bound field onscreen.

Using the format property works like a charm when I set the the correct CultureInfo and had no point in converting the data in SQL. Thanks u pointed me in the right direction.