Detailsview not appearing

markhh · September 30th, 2014, 05:38 PM

Hi Imar and many thanks for your reply. Is there another option I could look into to insert the date on an updatecommand eg can it by inserted from the updatecommand "UpdateCommand="UPDATE Main SET Line_Manager_Comments = @Line_Manager_Comments, Date_Authorised = Date.TimeNow, WHERE (ID = @ID)">",

Regards
Mark

Imar · September 30th, 2014, 05:49 PM

You could use SQL Server's getdate in your query for that, or you can handle the DetailView's ItemUpdating event: http://msdn.microsoft.com/en-us/libr...vs.110%29.aspx

Hope this helps,

Imar

markhh · October 1st, 2014, 05:36 AM

Thanks Imar, I will have a look,

Regards
Mark

markhh · October 1st, 2014, 11:57 AM

Hello again Imar, I have had another go using the itemupdating event handler but it still appears to be not firing. Any help would be greatly appreciated,

Regards
Mark

Code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="LineManager.aspx.cs" Inherits="LineManager_LineManager" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:DetailsView ID="DetailsView1" runat="server" DefaultMode="Edit" 
            Height="50px" Width="275px" AllowPaging="True" AutoGenerateRows="False" 
            DataKeyNames="ID" DataSourceID="SqlDataSource1LM" HorizontalAlign="Center" 
            onitemupdating="DetailsView1_ItemUpdating">
            <Fields>
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" 
                    ReadOnly="True" SortExpression="ID" />
                <asp:TemplateField HeaderText="Requested_By" SortExpression="Requested_By">
                    <EditItemTemplate>
                        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="RequestedBy" 
                            DataTextField="Expr1" DataValueField="ID" 
                            SelectedValue='<%# Bind("Requested_By") %>'>
                        </asp:DropDownList>
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Requested_By") %>'></asp:TextBox>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("Requested_By") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Nature_of_Request_Repair" 
                    SortExpression="Nature_of_Request_Repair">
                    <EditItemTemplate>
                        <asp:DropDownList ID="DropDownList2" runat="server" 
                            DataSourceID="NatureOfRequest" DataTextField="Nature_of_Request_Repair" 
                            DataValueField="ID" SelectedValue='<%# Bind("Nature_of_Request_Repair") %>'>
                        </asp:DropDownList>
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server" 
                            Text='<%# Bind("Nature_of_Request_Repair") %>'></asp:TextBox>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" 
                            Text='<%# Bind("Nature_of_Request_Repair") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="Room_Number_Location" 
                    HeaderText="Room_Number_Location" SortExpression="Room_Number_Location" />
                <asp:TemplateField HeaderText="Details" SortExpression="Details">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox4" runat="server" Height="150px" 
                            Text='<%# Bind("Details") %>' TextMode="MultiLine" Width="250px"></asp:TextBox>
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Details") %>'></asp:TextBox>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("Details") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="Date_Opened" HeaderText="Date_Opened" 
                    SortExpression="Date_Opened" />
                <asp:BoundField DataField="Line_Manager_Comments" 
                    HeaderText="Line_Manager_Comments" SortExpression="Line_Manager_Comments" />
                <asp:BoundField DataField="Date_Authorised" HeaderText="Date_Authorised" 
                    SortExpression="Date_Authorised" />
                <asp:CommandField ShowEditButton="True" />
            </Fields>
        </asp:DetailsView>
        <asp:SqlDataSource ID="SqlDataSource1LM" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionStringV4 %>" 
            SelectCommand="SELECT ID, Requested_By, Nature_of_Request_Repair, Room_Number_Location, Details, Date_Opened, Line_Manager_Comments, Date_Authorised FROM Main WHERE (Date_Authorised IS NULL)" 
            UpdateCommand="UPDATE Main SET Line_Manager_Comments = @Line_Manager_Comments WHERE (ID = @ID)">
            <UpdateParameters>
                <asp:Parameter Name="Line_Manager_Comments" />
                <asp:Parameter Name="ID" />
            </UpdateParameters>
        </asp:SqlDataSource>
    
        <br />
        <asp:SqlDataSource ID="RequestedBy" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionStringV4 %>" 
            SelectCommand="SELECT ID, Title + ' ' + Name + ' ' + Surname AS Expr1 FROM Users"></asp:SqlDataSource>
    
        <br />
        <asp:SqlDataSource ID="NatureOfRequest" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionStringV4 %>" 
            SelectCommand="SELECT * FROM [Nature of Request]"></asp:SqlDataSource>
        <br />
        <br />
    
    </div>
    </form>
</body>
</html>

Page Behind

Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class LineManager_LineManager : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
    {
        e.NewValues["Date_Authorised"] = DateTime.Now;
    }
}

markhh · October 1st, 2014, 12:08 PM

Update on the above, there is currently a NULL value in the Date_Authorised column in question.

Mark

Imar · October 1st, 2014, 03:27 PM

I don't see the field you're updating in the code behind in your SQL statement. You need to add that for the update to work.

Imar

markhh · October 2nd, 2014, 03:54 PM

Hi Imar, I have some sort of result by adding Date_Authorised = GetDate() on the command control. I was really hoping to get at least one of the events working on the Details view as they look very handy.

Anyway, the column I am updating is in the page behind

Code:

 protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
    {
        e.NewValues["Date_Authorised"] = DateTime.Now;
    }

I thought this would do the trick, as it is the same format as your example on page 472 (although that one is an ItemInserting)

Regards
Mark

Imar · October 6th, 2014, 03:18 PM

>> I thought this would do the trick, as it is the same format as your example on page 472

Yes, I believe that should work. Did you try debugging the code by putting a break point in that method with F9 and then running the site by pressing F5?

Imar

markhh · October 7th, 2014, 08:24 AM

Hi Imar, no I haven't tried debugging but I will and post the results,

Regards
Mark

markhh · October 8th, 2014, 10:49 AM

Hi Imar, I have created a basic page with single table to test what is going on. The code is as follows

Code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Test.aspx.cs" Inherits="Test" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" 
            AutoGenerateRows="False" DataKeyNames="ID" DataSourceID="SqlDataSource1" 
            DefaultMode="Edit" Height="50px" oniteminserting="DetailsView1_ItemInserting" 
            Width="125px">
            <Fields>
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" 
                    ReadOnly="True" SortExpression="ID" />
                <asp:BoundField DataField="First_Name" HeaderText="First_Name" 
                    SortExpression="First_Name" />
                <asp:CommandField ShowEditButton="True" ShowInsertButton="True" />
            </Fields>
        </asp:DetailsView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            DeleteCommand="DELETE FROM [Main_Table] WHERE [ID] = @ID" 
            InsertCommand="INSERT INTO [Main_Table] ([First_Name]) VALUES (@First_Name)" 
            SelectCommand="SELECT [ID], [First_Name] FROM [Main_Table]" 
            UpdateCommand="UPDATE [Main_Table] SET [First_Name] = @First_Name WHERE [ID] = @ID">
            <DeleteParameters>
                <asp:Parameter Name="ID" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="First_Name" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="First_Name" Type="String" />
                <asp:Parameter Name="ID" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>

Page Behind

Code:

page behind
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Test : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
    {
        e.Values["Your_Age"] = 22;
    }
}

I have inserted a breakpoint on the starting line of the item_inserting method, pressed F5 which renders the page in the browser. From here I can insert a new Name but the Your_Age column is not updated via the
DetailsView1_ItemInserting method. When I try pressing F10 to advance the code nothing happens in the browser and I am not returned VWD. The breakpoint has moved down one line but its colour remains red with no arrow. Pressing F10 does nothing here also.

the web.config page looks like this

Code:

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
 <connectionStrings>
  <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
  <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
 </connectionStrings>
 <system.web>
  <compilation debug="true" targetFramework="4.0"/>
  <authentication mode="Forms">
   <forms loginUrl="~/Account/Login.aspx" timeout="2880"/>
  </authentication>
  <membership>
   <providers>
    <clear/>
    <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/"/>
   </providers>
  </membership>
  <profile>
   <providers>
    <clear/>
    <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>
   </providers>
  </profile>
  <roleManager enabled="false">
   <providers>
    <clear/>
    <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/"/>
    <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/"/>
   </providers>
  </roleManager>
 </system.web>
 <system.webServer>
  <modules runAllManagedModulesForAllRequests="true"/>
 </system.webServer>
</configuration>

Any pointers
Mark