Hey Guys,
I've been working on this the last few days but I'm stuck! I have my listbox control added as a template to my detailsview, when I submit the form it comes up with 'Internet explorer can not display this page'. At first I thought it was a problem with a class I wrote that returned a datareader (thinking that the connection might not be closing) so I changed it to a dataset and closed the connection before I return it hoping that would sort out the problem - however it hasn't.
What I'm trying to do is allow the user to select multiple tags which I'm later using as tags for the page. I've deleted all my code for submitting the control to the database and I'm just now trying to get the thing to work at a basic level. Any idea's why?
Thanks,
Mike
1 <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> 2 3 <div id="contentmenu"> 4 5 <div class="tab" id="viewall"><a class="link1" href="headlines.aspx?action='viewall'"> View All</a></div> 6 <div class="tab" id="modify"><a class="link1" onclick="javascript:setopentab('modify');" >Modify</a></div> 7 <div class="tab" id="addnew"><a class="link1" href="javascript:setopentab('addnew');" >Add New</a></div> 8 <div id="fillercontainer"> 9 <div id="filler"></div> 10 </div> 11 12 </div> 13 <div class="opencontentpart" id="viewallc"> 14 <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 15 AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="headlineId" 16 DataSourceID="headlinesds"> 17 <Columns> 18 <asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" /> 19 <asp:BoundField DataField="headlineId" HeaderText="headlineId" 20 InsertVisible="False" ReadOnly="True" SortExpression="headlineId" /> 21 <asp:BoundField DataField="href" HeaderText="href" SortExpression="href" /> 22 <asp:BoundField DataField="headline" HeaderText="headline" 23 SortExpression="headline" /> 24 <asp:BoundField DataField="area" HeaderText="area" SortExpression="area" /> 25 </Columns> 26 </asp:GridView> 27 <asp:SqlDataSource ID="headlinesds" runat="server" 28 ConnectionString="<%$ ConnectionStrings:ifcreviewCS %>" 29 DeleteCommand="sp_headlines_deleteHeadlines" 30 DeleteCommandType="StoredProcedure" InsertCommand="sp_headlines_addHeadlines" 31 InsertCommandType="StoredProcedure" SelectCommand="sp_headlines_selectAll" 32 SelectCommandType="StoredProcedure" 33 UpdateCommand="sp_headlines_modifyHeadlines" 34 UpdateCommandType="StoredProcedure"> 35 <DeleteParameters> 36 <asp:Parameter Name="headlineId" Type="Int32" /> 37 </DeleteParameters> 38 <UpdateParameters> 39 <asp:Parameter Name="headlineId" Type="Int32" /> 40 <asp:Parameter Name="href" Type="String" /> 41 <asp:Parameter Name="headline" Type="String" /> 42 <asp:Parameter Name="area" Type="String" /> 43 </UpdateParameters> 44 <InsertParameters> 45 <asp:Parameter Name="href" Type="String" /> 46 <asp:Parameter Name="headline" Type="String" /> 47 <asp:Parameter Name="area" Type="String" /> 48 </InsertParameters> 49 </asp:SqlDataSource> 50 </div> 51 52 <div class="contentpart" id="modifyc"> 53 <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" 54 AutoGenerateRows="False" DataKeyNames="headlineId" DataSourceID="headlinesds" DefaultMode="Edit"> 55 <Fields> 56 <asp:BoundField DataField="headlineId" HeaderText="headlineId" 57 InsertVisible="False" ReadOnly="True" SortExpression="headlineId" /> 58 <asp:BoundField DataField="href" HeaderText="href" SortExpression="href" /> 59 <asp:BoundField DataField="headline" HeaderText="headline" 60 SortExpression="headline" /> 61 <asp:BoundField DataField="area" HeaderText="area" SortExpression="area" /> 62 <asp:CommandField ShowEditButton="True" /> 63 </Fields> 64 </asp:DetailsView> 65 </div> 66 <div class="opencontentpart" id="addnewc"> 67 <asp:DetailsView ID="DetailsView2" runat="server" Height="50px" Width="125px" 68 AutoGenerateRows="False" DataKeyNames="headlineId" 69 DataSourceID="headlinesds" DefaultMode="Insert" > 70 <Fields> 71 <asp:BoundField DataField="headlineId" HeaderText="headlineId" 72 InsertVisible="False" ReadOnly="True" SortExpression="headlineId" /> 73 <asp:BoundField DataField="href" HeaderText="href" SortExpression="href" /> 74 <asp:BoundField DataField="headline" HeaderText="headline" 75 SortExpression="headline" /> 76 <asp:TemplateField HeaderText="area2"> 77 <InsertItemTemplate> 78 <asp:ListBox ID="areas" runat="server" SelectionMode="Multiple" 79 DataSourceID="ListBoxDS" DataTextField="areaName" 80 DataValueField="areaId" ></asp:ListBox> 81 <asp:SqlDataSource ID="ListBoxDS" runat="server" 82 ConnectionString="<%$ ConnectionStrings:ifcreviewCS %>" 83 SelectCommand="sp_general_selectAllAreas" SelectCommandType="StoredProcedure"> 84 </asp:SqlDataSource> 85 </InsertItemTemplate> 86 </asp:TemplateField> 87 <asp:CommandField ShowInsertButton="True" /> 88 89 </Fields> 90 </asp:DetailsView> 91 </div> 92 </asp:Content>
1 using System; 2 using System.Collections; 3 using System.Configuration; 4 using System.Data; 5 using System.Web; 6 using System.Web.Security; 7 using System.Web.UI; 8 using System.Web.UI.WebControls; 9 using System.Web.UI.WebControls.WebParts; 10 using System.Web.UI.HtmlControls; 11 using System.Data.SqlClient; 12 13 namespace ifcreview2._0.admin 14 { 15 public partial class headlines : System.Web.UI.Page 16 { 17 protected void Page_Load(object sender, EventArgs e) 18 { 19 // DetailsView2.ItemInserting += new DetailsViewInsertEventHandler(DetailsView2_ItemInserting); 20 //dbtools dbt = new dbtools(); 21 //DataSet myds = new DataSet(); 22 //myds = dbt.getAreaNamesandIds(); 23 //((ListBox)DetailsView2.FindControl("areas")).DataSource = dbt.getAreaNamesandIds(); 24 //((ListBox)DetailsView2.FindControl("areas")).DataTextField = "areaName"; 25 //((ListBox)DetailsView2.FindControl("areas")).DataValueField = "areaId"; 26 //((ListBox)DetailsView2.FindControl("areas")).DataBind(); 27 } 28 29 30 31 32 33 34 35 } 36 } 37
Read Full article Here.
No comments:
Post a Comment
Post your comments here: