Hi

Problem: when i select the item in DropDownList, the records are displayed but the "CreateDateTime" column is not displayed.
the Grid View Displays - Title,Authorized,Id,Delete. Displays "Id" instead of CreateDateTime" column.

Review.aspx code: ---------------------------------------


<%@ Page Language="C#" MasterPageFile="~/MasterPages/ManagementMaster.master" AutoEventWireup="true" CodeFile="Reviews.aspx.cs" Inherits="Management_Reviews" Title="Planet Wrox - Management - Reviews" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cpMainContent" Runat="Server">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>

<asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True"
AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="Name"
DataValueField="Id">
<asp:ListItem Value="">Please make a selection</asp:ListItem>
</asp:DropDownList>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="Id" DataSourceID="SqlDataSource2">
<Columns>
<asp:HyperLinkField DataNavigateUrlFields="Id"
DataNavigateUrlFormatString="AddEditReviews.aspx?I d={0}" DataTextField="Title"
HeaderText="Title" />
<asp:TemplateField HeaderText="Authorized" SortExpression="Authorized">

<ItemTemplate>
<asp:Label ID="lblAuthorized" runat="server" Text='<%# GetBooleanText(Eval("Authorized")) %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False"
ReadOnly="True" SortExpression="Id" />

<asp:CommandField HeaderText="Delete" />
</Columns>
</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:PlanetWroxConnectionString1 %>"

SelectCommand="SELECT [Id], [Title], [CeateDateTime], [Authorized] FROM [Review] WHERE ([GenreId] = @GenreId)"
DeleteCommand="DELETE FROM [Review] WHERE [Id] = @Id"
InsertCommand="INSERT INTO [Review] ([Title], [CeateDateTime], [Authorized]) VALUES (@Title, @CeateDateTime, @Authorized)"
UpdateCommand="UPDATE [Review] SET [Title] = @Title, [CeateDateTime] = @CeateDateTime, [Authorized] = @Authorized WHERE [Id] = @Id">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="GenreId"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="Id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter DbType="Date" Name="CeateDateTime" />
<asp:Parameter Name="Authorized" Type="Boolean" />
<asp:Parameter Name="Id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter DbType="Date" Name="CeateDateTime" />
<asp:Parameter Name="Authorized" Type="Boolean" />
</InsertParameters>
</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:PlanetWroxConnectionString1 %>"
SelectCommand="SELECT [Id], [Name] FROM [Genre] ORDER BY [SortOrder]">
</asp:SqlDataSource>

</ContentTemplate>
</asp:UpdatePanel>
</asp:Content>

-------------------------------------------------------------

code behind --------------file code--------------------


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class Management_Reviews : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected string GetBooleanText(object booleanValue) {
bool authorized = (bool)booleanValue;
if (authorized){return "Yes"; }
else
{return "No";}
}
}


please tell me why is it not displaying "CreateDateTime".

with regards
sandeep

spellings for "CreateDateTime" were wrong and i was feeding "(0:g)" instead of "{0:g}"