DataGridView AutoGenerateColumns on Binding

Question

0.00/5 (No votes)

See more:

Hi, I'm trying to fill a DataGridView with the data taken from a Select.

I don't want the columns to be created automatically, I already defined some with styles and all that stuff. However, when defining the datasource, my DataGridView shows the expected number of rows, but empty.

If I set AutoGenerateColumns to true, I get all my predefined columns (empty) plus all the columns from the select sentence.

So, how do I match each returned column from the select, with my predefined columns on the datagridview?

Thanks.

VS2005, C#.

Posted 6-Apr-11 1:11am

garfield185

Updated 6-Apr-11 1:13am

Henry Minute

v2

Add a Solution

3 solutions

Solution 2

try this its an example
and use dataField same as you database table columns

XML

<asp:GridView ID="grd_InterviewCategoryList" AllowPaging="true" PageSize="10" DataKeyNames="iID" runat="server" Width="60%"
                    GridLines="none" AllowSorting="true" AutoGenerateColumns="False" EmptyDataText="No Records Found"
                    EmptyDataRowStyle-ForeColor="red" EmptyDataRowStyle-HorizontalAlign="Center"
                    AlternatingRowStyle-BackColor="#F7F7F7" CellPadding="4" CellSpacing="4" OnSelectedIndexChanged="grd_InterviewCategoryList_SelectedIndexChanged"
                    OnRowDeleting="grd_InterviewCategoryList_RowDeleting" OnPageIndexChanging="grd_InterviewCategoryList_PageIndexChanging"
                    OnSorting="grd_InterviewCategoryList_Sorting">
                    <HeaderStyle HorizontalAlign="Center" />
                    <Columns>
                        <asp:TemplateField HeaderText="SR.NO.">
                            <ItemTemplate>
                                <%# (grd_InterviewCategoryList.PageSize * grd_InterviewCategoryList.PageIndex) + Container.DataItemIndex + 1%>
                            </ItemTemplate>
                            <ItemStyle Width="20%" HorizontalAlign="Center" />
                        </asp:TemplateField>
                        <asp:BoundField DataField="strCategoryName" HeaderText="Name" SortExpression="strCategoryName">
                            <ItemStyle Width="30%" HorizontalAlign="Center" />
                        </asp:BoundField>
                        <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date">
                            <ItemStyle Width="20%"  HorizontalAlign="Center"/>
                        </asp:BoundField>
                    </Columns>
                </asp:GridView>

Posted 6-Apr-11 1:20am

Mahendra.p25

Comments

garfield185 6-Apr-11 7:25am

Sorry, I didnt say it was for winforms... Thanks anyway

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Accepted Answer · 2011-04-06T01:17:00

Solution 1

When you define your columns set the DataPropertyName property to the required column from the dataset. MSDN Example[^].

Posted 6-Apr-11 1:17am

Henry Minute

Comments

Ankur^\m/ 6-Apr-11 7:21am

Correct, 5!

garfield185 6-Apr-11 7:24am

Thanks a lot. That made it.

Toniyo Jackson · Accepted Answer · 2011-04-06T01:20:00

Solution 3

Goto Datagridview Properties --> Columns.

Then you will get small window. In the right side you can see 'DataPropertyName' in column properties.
For each column set the database column name.

Then give AutoGenerateColumns = false.

Posted 6-Apr-11 1:20am

Toniyo Jackson

Comments

Toniyo Jackson 6-Apr-11 7:21am

This solution is for win forms

garfield185 6-Apr-11 7:24am

Thank you very much. That was the thing.

Toniyo Jackson 6-Apr-11 7:26am

Welcome