ASP.NET

Not Active26-Jul-10 6:51

26-Jul-10 6:51

You have not bound the nested Repeater so of course it will not display anything.

<asp:Repeater ID="Repeater3" runat="server" DataSource='<%# ((SiteMapNode)Container.DataItem).ChildNodes %>'>

I know the language. I've read a book. - _Madmatt

Dhyanga26-Jul-10 7:06

26-Jul-10 7:06

Thank you for the reply but adding that line still couldn't recognize the Repeater3 .. Frown | :(

suchita

Not Active26-Jul-10 7:14

Re: nested repeater [modified]

26-Jul-10 7:14

SayamiSuchi wrote:
couldn't recognize the Repeater3

Please clarify what you mean by this.

The example was for a nested Sitemap, you will of course need to adjust it to your usage.

I know the language. I've read a book. - _Madmatt

Dhyanga26-Jul-10 7:40

26-Jul-10 7:40

I am taking datasource from the dataset which i passed it to the repeater1.I also tried like this:

<asp:Repeater runat="server" id="Repeater1">
    <HeaderTemplate>items<br /><br /></HeaderTemplate>
    <ItemTemplate>
     <b><%# DataBinder.Eval(Container.DataItem, "catagoryname") %></t>
     <br><%# DataBinder.Eval(Container.DataItem, "catagorydescription") %>
    
        <asp:Repeater ID="Repeater3" runat="server" DataSourceID="DataSourceMember">
        
                 <ItemTemplate>
                 <br>Items: <%# DataBinder.Eval(Container.DataItem,"ItemName")%></t></t></t><%# DataBinder.Eval(Container.DataItem, "Amount") %>
                 <br><%# DataBinder.Eval(Container.DataItem, "ItemDescription") %></br>
                  </ItemTemplate>
                 </asp:Repeater>
                 <asp:SqlDataSource ID="DataSourceMember" runat="server" ConnectionString="server=myComp;uid=sa;pwd=sa;database=ItemCat" SelectCommand="SELECT * FROM items where catID = '<%# DataBinder.Eval(Container.DataItem,"ID") %>'"  \>
   
    </ItemTemplate>
          <separatortemplate>
             <br />
             <br />
             <br />
           </separatortemplate>
        </asp:Repeater>

erros is :

Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: The server tag is not well formed.

Source Error:

Line 193: </ItemTemplate>
Line 194: </asp:Repeater>
Line 195: <asp:SqlDataSource ID="DataSourceMember" runat="server" ConnectionString="server=myComp;uid=sa;pwd=sa;database=ItemCat" SelectCommand="SELECT * FROM items [ACN] Where catID = '<%# DataBinder.Eval(Container.DataItem,"ID") %>'" \>
Line 196:

suchita

modified on Monday, July 26, 2010 2:10 PM

Not Active26-Jul-10 8:30

26-Jul-10 8:30

Now we finally get to the issue, "Parser Error Message: The server tag is not well formed". You could have saved a few steps and gave this information at the beginning.

This is not the best way to accomplish this. You understand you are going to create a new SqlDatasource for each item in the parent list? Handle the ItemDataBound event of the parent repeater and assign the datasource, perferably from a cached source.

I know the language. I've read a book. - _Madmatt

Dhyanga26-Jul-10 8:40

26-Jul-10 8:40

itemDataBound event is like this right:

void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
    RepeaterItem item = e.Item;
    if ((item.ItemType == ListItemType.Item) ||
        (item.ItemType == ListItemType.AlternatingItem))
    {

        Repeater3 = e.Item.FindControl("Repeater3");
        DataRowView drv = (DataRowView)item.DataItem;
        Repeater3.DataSource = drv.CreateChildView("category_item");
        Repeater3.DataBind();
    }
}

but if i do like this, it give error as below:

Repeater3 doesn't exits..

while ascx.cs code is

<asp:Repeater runat="server" id="Repeater1">
    <HeaderTemplate>items<br /><br /></HeaderTemplate>
    <ItemTemplate>
     <b><%# DataBinder.Eval(Container.DataItem, "catagoryname") %></t>
     <br><%# DataBinder.Eval(Container.DataItem, "catagorydescription") %>
    
        <asp:Repeater ID="Repeater3" runat="server">
        
                 <ItemTemplate>
                 <br>Items: <%# DataBinder.Eval(Container.DataItem,"ItemName")%></t></t></t><%# DataBinder.Eval(Container.DataItem, "Amount") %>
                 <br><%# DataBinder.Eval(Container.DataItem, "ItemDescription") %></br>
                  </ItemTemplate>
                 </asp:Repeater>
                 
   
    </ItemTemplate>
          <separatortemplate>
             <br />
             <br />
             <br />
           </separatortemplate>
        </asp:Repeater>

suchita

Not Active26-Jul-10 8:53

Re: nested repeater [modified]

26-Jul-10 8:53

Repeater3 = e.Item.FindControl("Repeater3");

Of course it doesn't exist, what type is Repeater3? All you have is a name. You also understand FindControl needs to be cast to something useful?

I know the language. I've read a book. - _Madmatt

Dhyanga26-Jul-10 9:14

26-Jul-10 9:14

yes.

i did like this:

Repeater3 =(Repeater) e.Item.FindControl("Repeater3");

now i have another error shown.

The relation is not parented to the table to which this DataView points.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: The relation is not parented to the table to which this DataView points.

Source Error:

Line 120: Repeater2 = (Repeater)e.Item.FindControl("Repeater2");
Line 121: DataRowView drv = (DataRowView)item.DataItem;
Line 122: Repeater2.DataSource = drv.CreateChildView("CategoryToItem");
Line 123: Repeater2.DataBind();
Line 124: }

suchita

modified on Monday, July 26, 2010 4:38 PM

Not Active26-Jul-10 10:31

26-Jul-10 10:31

RTFM

I know the language. I've read a book. - _Madmatt

Dhyanga26-Jul-10 10:35

26-Jul-10 10:35

Sorry, I couldn't get that. Can you explain that please ?

I even included below code:

SqlCommand objCmd = new SqlCommand(query, cnx);
           SqlDataAdapter objDA = new SqlDataAdapter(objCmd);
           DataSet ds = new DataSet();
           objDA.Fill(ds);
           Repeater1.DataSource = ds;
           Repeater1.DataBind();

           DataColumn c1 = ds.Tables["category"].Columns["ID"];
           DataColumn c2 = ds.Tables["Items"].Columns["CatID"];
           dRel = new DataRelation("CategoryToItem", c1, c2);
           ds.Relations.Add(dRel);

suchita

Localizaing the data populating from database

Adam R Harris28-Jul-10 9:14

Adam R Harris

28-Jul-10 9:14

ROFL A+ man A+ ... Big Grin | :-D

If at first you don't succeed ... post it on The Code Project and Pray.

dev_asp_shreshtha26-Jul-10 5:20

dev_asp_shreshtha

26-Jul-10 5:20

I am doing localization in my application.
How can I localize data, which is populating from database.
That is, If I am putting some values in database which are predefined and is set explicitly .If I am populating this data in my Chinese culture, English characters are appearing.

Please help in same.

Thanks.

Re: Localizaing the data populating from database

Yusuf26-Jul-10 6:30

System.Security.Policy.PolicyException: Required permissions cannot be acquired.

26-Jul-10 6:30

Well, did you look at the Globalization and Localization[^] help yet?

Yusuf
May I help you?

Post Alert Issue

dev_asp_shreshtha26-Jul-10 5:14

dev_asp_shreshtha

26-Jul-10 5:14

Hello All,

I am doing Localization in my application, and using following script for Post Date Alert for making sure user does not select date earliar than today..

Problem is if I login as Chinese culture or other except English, I choose date from calander which is greater than today, it gives popup and then display Todays date in English.

I am using EnableScriptGlobalization= "true" in ToolkitScriptManager so as calander will display in respective culture.

function checkDate(sender, args) {
if (sender._selectedDate > new Date()) {
alert("Alert");
sender._selectedDate = new Date();
sender._textbox.set_Value(sender._selectedDate.format(sender._format));
}
}

Thanks.

Shreshtha

antony beula26-Jul-10 4:42

antony beula

26-Jul-10 4:42

Afer I moved my code to new machine am getting this error "System.Security.Policy.PolicyException: Required permissions cannot be acquired."

Re: System.Security.Policy.PolicyException: Required permissions cannot be acquired.

Yusuf26-Jul-10 4:50

Re: System.Security.Policy.PolicyException: Required permissions cannot be acquired.

26-Jul-10 4:50

Do any of these[^] apply to you?

Yusuf
May I help you?

antony beula26-Jul-10 5:05

antony beula

26-Jul-10 5:05

thanks for your reply.

still am facing the same issue.

Re: System.Security.Policy.PolicyException: Required permissions cannot be acquired.

Yusuf26-Jul-10 5:08

Re: System.Security.Policy.PolicyException: Required permissions cannot be acquired. [modified]

26-Jul-10 5:08

what have you tried? When do you get the error? how does it exhibits?

Yusuf
May I help you?

antony beula26-Jul-10 5:14

antony beula

26-Jul-10 5:14

<trust level="Full" originUrl="" />
is already available in my application and am getting this error only on some of the pages in my application.

Error Message:

[PolicyException: Required permissions cannot be acquired.]
System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission) +7606807
System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission) +57

[FileLoadException: Could not load file or assembly 'WebChart, Version=1.1.1.4, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +43
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +127
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +142
System.Reflection.Assembly.Load(String assemblyString) +28
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +46

[ConfigurationErrorsException: Could not load file or assembly 'WebChart, Version=1.1.1.4, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +613
System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +203
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +105
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +178
System.Web.Compilation.WebDirectoryBatchCompiler..ctor(VirtualDirectory vdir) +163
System.Web.Compilation.BuildManager.BatchCompileWebDirectoryInternal(VirtualDirectory vdir, Boolean ignoreErrors) +53
System.Web.Compilation.BuildManager.BatchCompileWebDirectory(VirtualDirectory vdir, VirtualPath virtualDir, Boolean ignoreErrors) +175
System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) +86
System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +261
System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +101
System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +126
System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +62
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +33
System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path) +37
System.Web.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +307
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

modified on Monday, July 26, 2010 11:28 AM

displaying problem

Dhyanga26-Jul-10 4:35

26-Jul-10 4:35

I am using asp.net with c# and sql server. well I have some syntax error problem. my code is:

  <asp:Repeater runat="server" id="Repeater1">
  <HeaderTemplate>Items<br /><br /></HeaderTemplate>
  <ItemTemplate>
   <b><%# DataBinder.Eval(Container.DataItem, "CatName") %></t>

               <asp:HiddenField  ID="HiddenField1" runat="server" value='<%# DataBinder.Eval(Container.DataItem,"ID") %>' />
               <asp:Repeater id="Repeater2" runat="server" DataSourceID="AccessDataSourceMembers">
               <ItemTemplate>
                  <tr>
                  <br><%# DataBinder.Eval(Container.DataItem, "ItemName") %></br>
                  </tr>
               </ItemTemplate>
              </asp:Repeater>
<asp:SqlDataSource ID="AccessDataSourceMembers" runat="server" ConnectionString="server=myComp;uid=sa;pwd=sa;database=catItem" SelectCommand="SELECT * FROM items Where cat_ID = ?">
  <SelectParameters>
      <asp:ControlParameter Name="ID" ControlID="HiddenField1" PropertyName="Value" Type="string" />

  </SelectParameters>

</asp:SqlDataSource>

  </ItemTemplate>
        <separatortemplate>
           <br />
           <br />
           <br />
         </separatortemplate>
      </asp:Repeater>

and the error it is showing is:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '?'.

Source Error:

Line 1197: objDA.Fill(ds);
Line 1198: Repeater1.DataSource = ds;
Line 1199: Repeater1.DataBind();
Line 1200:
Line 1201:

Note:If I do not use the nested repeater, it is working fine. So Can anyone tell me why is that error and how to get out of it??

suchita

Yusuf26-Jul-10 4:48

26-Jul-10 4:48

SayamiSuchi wrote:
SELECT * FROM items Where cat_ID = ?

it is complaining about your query. Are you sure that is what you want.

Yusuf
May I help you?

Dhyanga26-Jul-10 4:53

26-Jul-10 4:53

isn't the query was right ? I am new to repeater template tool and i am trying to use nested repeater. it gave those errors.

suchita

Martin Jarvis26-Jul-10 6:51

Martin Jarvis

26-Jul-10 6:51

SELECT * FROM items Where cat_ID = ?

Is an Oracle format query not TSQL.

How you go about fixing this depends on what database your using. If it's SQL Server, then you'll need to amend the query to use the proper format (named parameters). If it's oracel then you'll need to swap out the datasource for the Oracle equivelent

Freestyle Interactive Ltd Martin on .Net Follow Me on Twitter

Stoffy197226-Jul-10 9:16

Stoffy1972

26-Jul-10 9:16

Maybe this is not the easiest solution, but it works for me...

<asp:Repeater runat="server" ID="Repeater1" DataSourceID="dsLocations">
    <HeaderTemplate>
        Items<br />
    </HeaderTemplate>
    <ItemTemplate>
        <b><%# DataBinder.Eval(Container.DataItem, "City") %></b> <b><%# DataBinder.Eval(Container.DataItem, "State") %></b>
        <asp:HiddenField ID="HiddenField1" runat="server" Value='<%# DataBinder.Eval(Container.DataItem,"LocationID") %>' />
        <asp:Repeater ID="Repeater2" runat="server" DataSourceID="dsUserData">
            <ItemTemplate>
                <p>
                    <%# DataBinder.Eval(Container.DataItem, "LastName") %>,
                    <%# DataBinder.Eval(Container.DataItem, "FirstName") %></br>
                </p>
            </ItemTemplate>
        </asp:Repeater>
        <asp:SqlDataSource ID="dsUserData" runat="server"
            ConnectionString="server=.\SQLEXPRESS;Initial Catalog=LinqTest;Integrated Security=true"
            SelectCommand="SELECT * FROM UserData Where LocationID = @LocationID"
            OnSelecting="dsUserData_Selecting">
            <SelectParameters>
                <asp:Parameter Name="LocationID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    </ItemTemplate>
    <SeparatorTemplate>
        <br />
        <br />
        <br />
    </SeparatorTemplate>
</asp:Repeater>
<asp:SqlDataSource ID="dsLocations" runat="server" ConnectionString="server=.\SQLEXPRESS;Initial Catalog=LinqTest;Integrated Security=true" SelectCommand="SELECT * FROM Location"></asp:SqlDataSource>

Code 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 _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    protected void dsUserData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        HiddenField hf = Repeater1.Controls[1].FindControl("HiddenField1") as HiddenField;
        if (hf == null)
            return;

        e.Command.Parameters[0].Value = hf.Value;
    }
}

Not sure if it works for oracle. Tested with mssql 2005.

Dhyanga27-Jul-10 2:53