Simple DataGrid Display Using BoundColumns

This simple demo lists the ID and Description of the 10 most viewed FAQs on ASPFAQs.com. The BoundColumn control is used to display each column in the DataGrid.


IDFAQ Description
181How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency.
161How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset?
115I am using Access and getting a 80004005 error (or a [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem?
83How can I quickly sort a VBScript array?
190How do I display data on a web page using arrays instead of Do...While...MoveNext...???...
106How can I find out if a record already exists in a database? If it doesn't, I want to add it.
118When I get a list of all files in a directory via the FileSystemObject, they aren't ordered in any reasonable way. How can I sort the files by name? Or by size? Or by date created? Or...
30For session variables to work, must the Web visitor have cookies enabled?
14Can I send emails without using CDONTS?
149How can I remove multiple spaces between words in a string? That is, if I have: Hi    there how can I get: Hi there?


Source Code:
<% @Import Namespace="System.Data" %>
<% @Import Namespace="System.Data.SqlClient" %>
<script language="C#" runat="server">
  void Page_Load(Object sender, EventArgs e)
  {
    BindData();
  }
	
	
  void BindData()
  {
    // 1. Create a connection
    SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);

    // 2. Create the command object, passing in the SQL string
    const string strSQL = "sp_Popularity";
    SqlCommand myCommand = new SqlCommand(strSQL, myConnection);

    // Set the datagrid's datasource to the datareader and databind
    myConnection.Open();
    FAQs.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
    FAQs.DataBind();
  }
</script>

<form runat="server">
	<asp:DataGrid id="FAQs" runat="server" 
		AutoGenerateColumns="False" CellPadding="2"
		HeaderStyle-BackColor="Black"
		HeaderStyle-ForeColor="White"
		HeaderStyle-HorizontalAlign="Center"
		HeaderStyle-Font-Bold="True">
	<Columns>
		<asp:BoundColumn HeaderText="ID" DataField="FAQID"  />
		<asp:BoundColumn HeaderText="FAQ Description" DataField="Description"  />    
	</Columns>
  </asp:datagrid>
</form>


[Return to the article]