is there a way to control where the DataGrid's <asp:TemplateColumns> appear under <Columns>? Say I want a template column to be displayed after the automatic generated columns. How do I specify that under <Columns>. Please advise.
YUBO

You can't do that. Autogenerated columns come after predefined columns.

well,dont use Autogenerated columns,you can use <asp:BoundColumn> instead and change the order of your columns manually.

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.

In order to use 'AllowSorting="True"', autogenerated columns has to be set to "true". <asp:BoundColumn> won't work in this senario.

This is not correct. You can allow sorting on your user defined columns (bound or other types of columns), you simply need to provide your own sort expressions for the columns you define.

hi all
i have created to template column.
if i put both temple column at last position then it works fine.
but if a change order of temple column then it gives error.
here is the code:
<asp:datagrid id="dgViewHedge" runat="server" Width="797px" BorderColor="#999999" BorderStyle="None"
                                        BorderWidth="1px" BackColor="White" CellPadding="3" GridLines="Vertical" AllowSorting="True" AllowPaging="True" AutoGenerateColumns="False"
                                        PageSize="3">
                                        <SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#008A8C"></SelectedItemStyle>
                                        <AlternatingItemStyle BackColor="Gainsboro"></AlternatingItemStyle>
                                        <ItemStyle ForeColor="Black" BackColor="#EEEEEE"></ItemStyle>
                                        <HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#000084"></HeaderStyle>
                                        <FooterStyle ForeColor="Black" BackColor="#CCCCCC"></FooterStyle>
                                        <Columns>
                                            <asp:BoundColumn Visible="False" DataField="intComplianceAccountID" ReadOnly="True"></asp:BoundColumn>
                                            <asp:BoundColumn Visible="False" DataField="intAccountTypeCodeID" HeaderText="Account Type CodeID"></asp:BoundColumn>
                                            <asp:BoundColumn Visible="False" DataField="intSecurityTypeCodeID" HeaderText="Security Type CodeID"></asp:BoundColumn>
                                            <asp:BoundColumn DataField="vchOrganizationName" SortExpression="vchOrganizationName" HeaderText="Organization Name"></asp:BoundColumn>
                                            <asp:TemplateColumn HeaderText="Invetment Type">
                                                <ItemTemplate>
                                                    <asp:DropDownList id="DropDownList1" runat="server"></asp:DropDownList>
                                                </ItemTemplate>
                                                <EditItemTemplate>
                                                    <asp:DropDownList id="DropDownList2" runat="server"></asp:DropDownList>
                                                </EditItemTemplate>
                                            </asp:TemplateColumn>
                                            <asp:BoundColumn DataField="vchInvestmentDate" SortExpression="vchInvestmentDate" HeaderText="Investment Date"></asp:BoundColumn>
                                            <asp:TemplateColumn HeaderText="Securities Type">
                                                <ItemTemplate>
                                                    <asp:DropDownList id="DropDownList3" runat="server"></asp:DropDownList>
                                                </ItemTemplate>
                                                <EditItemTemplate>
                                                    <asp:DropDownList id="DropDownList4" runat="server"></asp:DropDownList>
                                                </EditItemTemplate>
                                            </asp:TemplateColumn>
                                            <asp:BoundColumn DataField="mnyAmount" SortExpression="mnyAmount" HeaderText="Amount"></asp:BoundColumn>
                                            <asp:ButtonColumn Text="Delete" HeaderText="Delete" CommandName="Delete"></asp:ButtonColumn>
                                        </Columns>
                                        <PagerStyle HorizontalAlign="Center" ForeColor="Black" BackColor="#999999" Mode="NumericPages"></PagerStyle>
                                    </asp:datagrid>

When i execute the code it gives me "invalid cast error"?
but if change the order of both template column to last poistions then work fine!

how can put multiple template columns at different positions?
And how ro solve above error?

Where are you getting this cast error?

Hi

On page_load event i assigned a data source to Datagrid. I m getting this error on datagrid.DataBind() statement.

There doesn't appear to be anything wrong with your datagrid markup from what I can tell.