What is the syntax for datagrid and specifying columns ?
Answer Posted / venugopal
The DataGrid is a Web server control that is used for data
display. This control provides the easy way to bind the
data from the database to the user in a user-friendly
manner. The DataGrid control renders a tabular, data-bound
grid. The DataGrid control displays the fields of a data
source as columns in a table. Each row in the DataGrid
control represents a record in the data source. The
DataGrid control supports selection, editing, deleting,
paging, and sorting.
The datagrid has the following column types:
EditCommandColumn : Encapsulates the most common edit
commands (Edit, Update, Cancel) in a predefined column
type.
HyperLinkColumn : Creates a column with a set of
hyperlinks that are bound to the value of a data field. For
example, a grid that displays a list of orders can include
a hyperlink column where the OrderID field is rendered as a
hyperlink to a page that displays the details for the
order.
BoundColumn :Creates column bound to a field in the
data source and rendered in a table cell using styles. This
is the default column type for the DataGrid control.
BottonColumn : Creates a column that contains a user
defined command button, such as Add or Remove, for each
item in the column.
TemplateColumn : Creates a column that allows you to
define the layout of controls using templates for custom
HTML elements and controls.
The syntax for the datagrid and columns is as fallows
<asp:datagrid id="dgPopularFAQs" runat="server"
AutoGenerateColumns="False">
<Columns>
<asp:BoundColumn DataField="FAQID" ItemStyle-
Width="10%"
ItemStyle-HorizontalAlign="Center"
HeaderText="FAQ ID" />
<asp:TemplateColumn HeaderText="FAQ Information">
<ItemTemplate>
<table border="0">
<tr>
<td align="right"><b>Description:</b></td>
<td><%# DataBinder.Eval
(Container.DataItem, "Description") %></td>
</tr>
<tr>
<td align="right"><b>Category Name:</b></td>
<td><%# DataBinder.Eval
(Container.DataItem, "CatName") %></td>
</tr>
<tr>
<td align="right"><b>View Count:</b></td>
<td><%# DataBinder.Eval
(Container.DataItem, "ViewCount", "{0:#,###}") %>
</td>
</tr>
</table>
</ItemTemplate>
</Columns>
</asp:datagrid>
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Give an example of cookie abuse.
What is a user developed application?
How asynchronous call can be implemented using delegates?
What is query string in asp.net?
Write a code for sending an email from asp.net application.
Is web config mandatory?
What is a viewstate?
Explain the differences between clr & cts?
How you will handle session when deploying application in more than a server?
What are the advantages and disadvantages of session?
What is css and what is it used for?
Am not able to move the controls on the form freely in asp.net 3.5 even though I selected the position as relative or absolute for those controls. What should I do to overcome this?
They mostly asked difference between versions of technologies
Define the term Web Garden?
Hello, Using Visual Studio 2005 (VB) I am working to create a Web Site implementing the following: Within a gridView I have placed a dropdownlist control with a DataSourceID="SDSLkupList". SDSLkupList is a sqlDataSource used to store a lookup list for dropdownlist translation from ID to text. SDSLkupList contains the translation text and other fields related to the dropdown selection ID. (Thought it would be efficient to get everything at the same time.) I would like to provide the user the ability to select from the dropdownlist and, based on the selection, use labels to list related columns stored on the SDSLkupList in separate gridView columns. I have read that SqlDataSources are not meant to be used for individual controls. Since SDSLkupList contains all related information, is there a way to do a find using the dropdownlist selectedValue? (I was not able to discover one.) Otherwise, what should I use? It would need to set the labels on the gridView DataRowBound event as well as the SelectedIndexChanged events. Has anyone done this? Any help would be appreciated. Thanks in Advance. Neal