Detailsview not visible

Question

majestic0110 187 Nearly a Posting Virtuoso

16 Years Ago

Hi, I have a DetailsView on my page that connects to a SQL server D/B and shows its data.However, It is not visible on my page when I launch my browser. Any ideas or past experience with this? Thanks for reading.

asp.net

4 Contributors
24 Replies
696 Views
1 Week Discussion Span
Latest Post 16 Years Ago Latest Post by majestic0110

ManicCW 3 Junior Poster in Training

16 Years Ago

Can you post some code from aspx and code behind?

SheSaidImaPregy 28 Veteran Poster

16 Years Ago

Careful, XP professional edition comes basically server ready, while vista home basic does not. And they actually prevent you from using vista home basic as a server.

SheSaidImaPregy 28 Veteran Poster

16 Years Ago

That's right.

They won't even "allow" you to install IIS.

SheSaidImaPregy 28 Veteran Poster

16 Years Ago

I use vista premium, works great.

Upgrade to that ^^

hollystyles 113 Veteran Poster

16 Years Ago

You don't need IIS if you have Visual Studio 2005 Express Edition (any edition 2005+) It includes a web server. When you run the app from VS (F5 to debug, or Ctrl+F5 to run without debugger) it starts up automatically on http://localhost:<some random port number> (you get an icon in your sys tray too showing it's running)

majestic0110 commented: very polite & helpful +1

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

majestic0110 187 Nearly a Posting Virtuoso · Answer 1 · 2008-02-20T17:21:57+00:00

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="page.aspx.cs" Inherits="Restricted_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD html 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<!-- saved from url=(0047)http://localhost:51704/DeaDtsAsp/LoginPage.aspx -->
<html xmlns="http://www.w3.org/1999/xhtml"><head><title>Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta content="MShtml 6.00.6000.16587" name="GENERATOR"/><link rel="stylesheet" type="text/css" href="demo.CSS" /></head>


<body runat="server">

<h1 runat="server" visible="true">You are logged in</h1>
    <h1 runat="server" visible="true">
        Sponsor with the following details:</h1>
    <p>
        &nbsp;</p>
   <p runat="server" visible="false">
        &nbsp;<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:demoConnectionString %>" 
            SelectCommand="SELECT [username], [role], [email], [tel], [fax], [organisation] FROM [users] WHERE ([username] = @username)"
            OnSelecting="SqlDataSource1_Selecting" ProviderName="<%$ ConnectionStrings:demoConnectionString.ProviderName %>">
            <SelectParameters>
                <asp:ProfileParameter Name="username" PropertyName="username" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"
            Height="0px" Width="0px" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="0px" CellPadding="4" 
            ForeColor="Black" OnPageIndexChanging="DetailsView1_PageIndexChanging" EmptyDataText="N/A">
            <Fields>
                <asp:BoundField DataField="username" HeaderText="username" SortExpression="username" />
                <asp:BoundField DataField="role" HeaderText="role" SortExpression="role" />
                <asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
                <asp:BoundField DataField="tel" HeaderText="tel" SortExpression="tel" />
                <asp:BoundField DataField="fax" HeaderText="fax" SortExpression="fax" />
                <asp:BoundField DataField="organisation" HeaderText="organisation" SortExpression="organisation" />
            </Fields>
            <FooterStyle BackColor="#CCCC99" />
            <RowStyle BackColor="#F7F7DE" />
            <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
            <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:DetailsView>
        &nbsp;
    </p>
</body></html>

majestic0110 187 Nearly a Posting Virtuoso · Answer 2 · 2008-02-20T22:07:36+00:00

interesting I added this code in the C# code behind file as I read that it would prevent the error message described below:

Code:

//public override void VerifyRenderingInServerForm(Control control)
    //{

    //}

the error msg was

Exception Details: System.Web.HttpException: Control 'DetailsView1' of type 'DetailsView' must be placed inside a form tag with runat=server

Thought that might help you all help me lol. Thanks

majestic0110 187 Nearly a Posting Virtuoso · Answer 3 · 2008-02-20T22:08:34+00:00

Forgot, here is the stack trace:

HttpException (0x80004005): Control 'DetailsView1' of type 'DetailsView' must be placed inside a form tag with runat=server.]
   System.Web.UI.Page.VerifyRenderingInServerForm(Control control) +2049759
   System.Web.UI.WebControls.DetailsView.Render(HtmlTextWriter writer, Boolean renderPanel) +37
   System.Web.UI.WebControls.DetailsView.Render(HtmlTextWriter writer) +30
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
   System.Web.UI.Page.Render(HtmlTextWriter writer) +26
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint

majestic0110 187 Nearly a Posting Virtuoso · Answer 4 · 2008-02-20T22:47:27+00:00

have realised that putting the details view inside <form runat="server"> tag has same effect as
//public override void VerifyRenderingInServerForm(Control control)
//{

//}

majestic0110 187 Nearly a Posting Virtuoso · Answer 5 · 2008-02-20T22:47:42+00:00

majestic0110 187 Nearly a Posting Virtuoso

16 Years Ago

i.e. the view is still not shown lol

majestic0110 187 Nearly a Posting Virtuoso · Answer 6 · 2008-02-21T18:46:28+00:00

the odd thing is when I try to run this code on an XP machine (as opposed to vista home basic) it works fine........odd. Any ideas?

majestic0110 187 Nearly a Posting Virtuoso · Answer 7 · 2008-02-21T21:46:24+00:00

i thought as much its because basic doesnt have IIS support I think

majestic0110 187 Nearly a Posting Virtuoso · Answer 8 · 2008-02-21T22:39:28+00:00

how generous! lol thanks mate for your replies. Do you have any suggestions? other than an XP installation lol

majestic0110 187 Nearly a Posting Virtuoso · Answer 9 · 2008-02-21T23:04:41+00:00

majestic0110 187 Nearly a Posting Virtuoso

16 Years Ago

ok lol thanks

majestic0110 187 Nearly a Posting Virtuoso · Answer 10 · 2008-02-21T23:04:58+00:00

majestic0110 187 Nearly a Posting Virtuoso

16 Years Ago

shrewd microsoft

majestic0110 187 Nearly a Posting Virtuoso · Answer 11 · 2008-02-27T19:08:22+00:00

interestingly, after downgrading to xp and using gridview I am able to display my d/b! Yippee! I wonder why that would not work in vista?! Trying to get update working now and delete

majestic0110 187 Nearly a Posting Virtuoso · Answer 12 · 2008-02-27T19:35:11+00:00

after hitting the auto generated update button:
You have specified that your update command compares all values on SqlDataSource 'SqlDataSource1', but the dictionary passed in for oldValues is empty. Pass in a valid dictionary for update or change your mode to OverwriteChanges.

any ideas?
thanks

majestic0110 187 Nearly a Posting Virtuoso · Answer 13 · 2008-02-27T19:48:37+00:00

its ok fixed it lol turned off optimistic concurrency then it worked. does anybody know why that might be ?

majestic0110 187 Nearly a Posting Virtuoso · Answer 14 · 2008-02-27T20:10:49+00:00

ok so I know gridview works with the edit/delete buttons that are built in with gridview, but how would I go about using my own (separate buttons) ?

SheSaidImaPregy 28 Veteran Poster · Answer 15 · 2008-02-27T20:24:51+00:00

Those buttons use commands, then based on those commands they use the datasources to update.

You would have to insert your own button with a new command argument. Then create a sub that it references where then reference the command arguments. Based upon which argument is passed, will tell you which performance is done.

majestic0110 187 Nearly a Posting Virtuoso · Answer 16 · 2008-02-27T20:27:56+00:00

so a user will select a row using the built in select (button on grid) then press edit, where i can redirect them to a new page to edit details and so forth. after edit is done, a save button throws back edits to d/b and returns user to original menu! lol is that do-able?

majestic0110 187 Nearly a Posting Virtuoso · Answer 17 · 2008-02-27T20:28:15+00:00

majestic0110 187 Nearly a Posting Virtuoso

16 Years Ago

btw thanks very much for the reply

SheSaidImaPregy 28 Veteran Poster · Answer 18 · 2008-02-27T23:59:27+00:00

yes it is doable. You will need to do an on Itemcreated event and search through for those buttons. Then reset the onclick function to trigger a new sub, which then will redirect based upon the command it receives. Also set a fake attribute to it to keep the current row id.

majestic0110 187 Nearly a Posting Virtuoso · Answer 19 · 2008-02-28T14:47:24+00:00

ok thanks for the help (again!) have got the data to fill in some text boxes now using SESSION. very handy tool! what I now need is changes that are made on this page to be sent back to d/b (update). I am going to battle this one now! thanks again!