VB.NET Changing Database Column Header Names Using Datagridview

Question

I change the header name of a datagridview using the following code

Me.DataGridView1.Columns(0).HeaderText = "xxxx"

How can I apply this change to the Access database? Like when I rename first column in datagrid view I want the first column in database to be the same.

Charles · Accepted Answer · 2012-07-23 05:16:32Z

1

There isn’t a .Net API that allows changes to the gridview’s headers to propagate back to the database's columns. The gridview object supports binding to multiple sources (among those MS Access, Sql Server, Oracle, Object collections etc.) and does not contain the DDL logic required to update the SQL based data sources. Therefore, you will need to perform two separate actions: one on the access database and one within the asp.net code.

edited Jul 23, 2012 at 5:16

answered Jul 23, 2012 at 5:09

Charles

3421 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

FPGA Over a year ago

it is an access database i don't use sql, the database is on local drive, so no way to do it?

Charles Over a year ago

You would have to write the data definition language SQL in order to programtically change the schema of the table; or look for an Access specific API that allows the change.

FPGA Over a year ago

how can i do the SQL command option in vb.net can you please show me a sample code

Charles Over a year ago

Here is link that should help: link

Collectives™ on Stack Overflow

VB.NET Changing Database Column Header Names Using Datagridview

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related