C# – Refresh schema won’t retrieve columns

ado.netasp.netc

Can you give me some advice on how to enable refresh schema so I can use it to (re)generate GridView columns:

With ObjectDataSource controls refresh schema link works ( thus retrieves information from data source ) only when I change a property in a data source ( for example, if I make public property into private one ) and then re-compile the web page, and even then refresh schema will retrieve property names only the first time I click on it.
Thus if ( after I already clicked refresh schema link once ) I remove from GridView tags, but I then want to regenerate those columns using refresh schema link, it wont work!
Similary, with Sqldatasource refresh schema link works only if I change the SelectCommand string and even then only once.

thank you

Best Answer

If you are doing refresh schema, I think you are going to need to turn AutoGenerateColumns on

Related Solutions

GridView – Show headers on empty data source

ASP.Net 4.0 added the boolean ShowHeaderWhenEmpty property.

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.showheaderwhenempty.aspx

<asp:GridView runat="server" ID="GridView1" ShowHeaderWhenEmpty="true" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField HeaderText="First Name" DataField="FirstName" />
        <asp:BoundField HeaderText="Last Name" DataField="LastName" />
    </Columns>
</asp:GridView>

Note: the headers will not appear unless DataBind() is called with something other than null.

GridView1.DataSource = New List(Of String)
GridView1.DataBind()

C# – Which control performs the type conversion:GridView or data source control

The formatting (which includes the conversion) is done by the GridView. You can see that by looking at the per-column DataFormatString property. This uses the general .NET composite formatting, see for example string.Format() or Console.Writeline(). It defaults to ToString(). But DataFormatString will accept dd-mm-yyyy for a DateTime column.

Related Topic