I can't see the columns in Master table

[Stavros]

When I go to Property Builder --> Master table --> Columns I can't see my database columns neither in Available columns pane nor in Selected columns pane.
Any idea why is this happening?

[Darren]

check to make sure "AutoGenerateColumns" is set to false. Then you'll have to setup your own columns by adding them using the Property Builder or in Source between <Columns></Columns>.

If AutoGenerateColumns is true then it would generate your columns at runtime which is why your not able to see them now.

[Stavros]

AutoGenerateColumns

 

="False" in MasterTableView tag but if you see this example 
http://www.telerik.com/help/aspnet-ajax/grdgettingstarted.html
the user can see his database data in selected columns pane.

 

[Darren]

If you currently run your project now, does your radgrid populate properly in your browser?

When you run your app for the first time it will generate the columns and you'll be able to see the columns in your source and should be able to see them in your prop builder. If i remember sometimes it does this and asks whether you want to refresh the schema in Visual Studio.

If you can't i'd just goto Column in Property Builder and select a Bound Column, add it then set it up myself. It should also work it's just a little more work. The important properties not to forget would be your DataField and UniqueName which must be exactly the same as the Column in your database.

[Stavros]

I can easily enter the columns manually but how can I enter the correct data type?
(in the database I am using nchar, nvarchar, int, datetime)

[Darren]

here is an example:

<Columns>

        <telerik:GridBoundColumn DataField="ReportId" DataType="System.Int32" 

            HeaderText="ReportId" ReadOnly="True" 

            SortExpression="ReportId" UniqueName="ReportId" Visible="False">

        </telerik:GridBoundColumn>

</Columns>

[Stavros]

Thanx for the answers.
What type should I use for nchar and datetime?

[Darren]

nvarchar you'd use:

DataType="System.String" 

datetime you have:

DataType="System.DateTime"

there is also: 

DataType="System.TimeSpan" 

intellisense can show you whats available.

[Stavros]

Thanks a lot!
Btw what exactly does this visible attribute you used?

[Stavros]

I suppose that if you set visible to false the column does not appear at the web page?

[Princy]

Hello Stavros,

The Visible property for columns in the grid returns a Boolean value, indicating whether the cells corresponding to the column, would be visible on the client, and whether they would be rendered on the client. For more information on this property, refer to this link as well.

Thanks
Princy.

[Stavros]

Thanx Princy.
One last question.
What about ReadOnly attribute?
When does this attribute is used?
Thank you all for your time.

[Princy]

Hello Stavros,

Tha ReadOnly property of a column gets or sets a value indicating if this column's items will be visible/available for edit during EditMode of the grid, but will be visible in the NormalMode of the grid. Also refer to the following link for information on this attribute.
ReadOnly Property

Regards
Princy.