ASP.NET

Re: error in dataRelation in asp.net

27-Jul-10 3:08

Hi i am trying to use data relation in my program.I have two repeaters used one nested another.
part of code is shown below:

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

                Repeater2 = (Repeater)e.Item.FindControl("Repeater2");
                DataRowView drv = (DataRowView)item.DataItem;
                Repeater2.DataSource = drv.CreateChildView("categoryItem");
                Repeater2.DataBind();
            }
        }

the error is :
<pre>
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 121:                Repeater2 = (Repeater)e.Item.FindControl("Repeater2");
Line 122:                DataRowView drv = (DataRowView)item.DataItem;
Line 123:                Repeater2.DataSource = drv.CreateChildView("categoryItem");
Line 124:                Repeater2.DataBind();

This categoryItem is from this code:

objDA.Fill(ds);
            Repeater1.DataSource = ds;
            Repeater1.DataBind();
          
            DataColumn c1 = ds.Tables["category"].Columns["ID"];
            DataColumn c2 = ds.Tables["Item"].Columns["ProposalID"];
            dRel = new DataRelation("categoryItem", c1, c2);
            ds.Relations.Add(dRel);

Can anyone please figure it out why that error is there ?

suchita

modified on Tuesday, July 27, 2010 9:20 AM

Dhyanga27-Jul-10 7:19

27-Jul-10 7:19

well i thought its because the repeater1.bind() is before the datarelations. So I even put that after data relations as shown :

objDA.Fill(ds);
            DataColumn c1 = ds.Tables["category"].Columns["categoryID"];
            DataColumn c2 = ds.Tables["Item"].Columns["catID"];
            dRel = new DataRelation("categoryItem", c1, c2);
            ds.Relations.Add(dRel);
            Repeater1.DataSource = ds;
            Repeater1.DataBind();

Now the error is :

 Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 1222:            objDA.Fill(ds);
Line 1223:
Line 1224:              DataColumn c1 = ds.Tables["category"].Columns["categoryID"];
Line 1225:           DataColumn c2 = ds.Tables["Item"].Columns["catID"];
Line 1226:            dRel = new DataRelation("categoryItem", c1, c2);

suchita

REPOST

Not Active27-Jul-10 8:58

Problem not solved yet: error in using dataRelation in asp.net

27-Jul-10 8:58

You have already asked this, eventually, before. The answer is you need to learn to read the documentation and stop throwing things together hoping it will work.

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

Dhyanga28-Jul-10 4:23

28-Jul-10 4:23

i changed it little bit. I tried to use dataRelation before repeater get binded. that resolves the previous error but it gave different error says

Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 1222:            objDA.Fill(ds);
Line 1223:
Line 1224:            DataColumn c1 = ds.Tables["category"].Columns["ID"];
Line 1225:            DataColumn c2 = ds.Tables["item"].Columns["catID"];
Line 1226:            dRel = new DataRelation("categoryItem", c1, c2);

my code is:

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

               Repeater2 = (Repeater)e.Item.FindControl("Repeater2");
               DataRowView drv = (DataRowView)item.DataItem;
               Repeater2.DataSource = drv.CreateChildView("categoryItem");
               Repeater2.DataBind();
           }
       }

the changed code is in this block:

objDA.Fill(ds);
            DataColumn c1 = ds.Tables["category"].Columns["ID"];
            DataColumn c2 = ds.Tables["Item"].Columns["catID"];
            dRel = new DataRelation("categoryItem", c1, c2);
            ds.Relations.Add(dRel);
            Repeater1.DataSource = ds;
            Repeater1.DataBind();

the "ID" of table "category" is the foreign key in "item" table and that foreignKey name in the "item" table is "catID". But the error is something wrong with those IDs.

suchita

Jquery in asp.net

Satish_S27-Jul-10 2:16

Satish_S

27-Jul-10 2:16

how to find whether div style is already visible or hidden using jquery in aspx page.
i have now like

<pre>if( $('#obj').css('display') == "none" )
{
alert('hi');
}
else
{
alert('hi%');
}</pre>

Re: Jquery in asp.net

Yusuf27-Jul-10 4:12

Yusuf

27-Jul-10 4:12

if(  $('#obj').is(":visible") == true )
{
  alert('div is visible');
}
else
{
  alert('div is hidden');
}

Yusuf
May I help you?

Re: Jquery in asp.net

Satish_S27-Jul-10 19:33

Satish_S

27-Jul-10 19:33

Thanks for your reply ,

my hidden is open but it still shows invisible.
pls advice me

function expandcollapse(obj,row)
{
debugger;
alert(obj+'expandcollapse');

var div = $('#obj');
var img = 'img' +obj;

alert($('div').css('display'))

}

Re: Jquery in asp.net

Not Active28-Jul-10 3:35

sql backup through asp.net in script format

28-Jul-10 3:35

Is this what you are trying to accomplish? http://jqueryui.com/demos/accordion/[^]

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

gautamamit827-Jul-10 1:22

gautamamit8

27-Jul-10 1:22

Hi all
I need to get backup of my database(sql 2005 & above) in script format not in.bak format.How can I do this?
I need all like tables,& table records,Store procedure etc in script format this is important.

Any help would be appreciated......

Amit

How to Load another web site page content into my Web Page Application

Sandilian26-Jul-10 20:37

Sandilian

26-Jul-10 20:37

Hi friends

I have defalut.aspx page in My web Application. I want to load dynamic content into this page.

for example if i have url "http://www.cricinfo.com" which contains html content right. so i want to load this content into my default.aspx page.

Please help me how to do it?

Re: How to Load another web site page content into my Web Page Application

Arun Jacob26-Jul-10 21:12

Arun Jacob

26-Jul-10 21:12

I think you can use iframe for achieving this.

Arun Jacob
My Technical Blog : Code.NET

Re: How to Load another web site page content into my Web Page Application

Sandesh M Patil27-Jul-10 6:46

Sandesh M Patil

27-Jul-10 6:46

You can use Streamreader to read the content and assign it to the control(Ex. Label) on your default.aspx page.

We successfully implent it. However we have the permission to access the data from another website. Smile | :)

get back vs2005 project?

Member 387988126-Jul-10 18:49

Member 3879881

26-Jul-10 18:49

hi guys very good morning to u all,

i have created vs2005 project and upgraded it into vs2008,

while convert its asked to take backup and i too did the same,and the project has been upgraded...,

now i like to get my vs2005 project back...,

its possible to get it same ?

Thanks & Regards,
Member 3879881,
please don't forget to vote on the post

Re: get back vs2005 project?

Arun Jacob26-Jul-10 19:12

Arun Jacob

26-Jul-10 19:12

If you selected backup option, then check for back up folder in the solution folder.

Arun Jacob
My Technical Blog : Code.NET

nested repeater

Dhyanga26-Jul-10 5:48

26-Jul-10 5:48

Hi,
I have question regarding using nested repeater. Can we use nested repeater in ascx file in asp.net ? Well I tried to use but the name of the child repeater is not recognizing. Can anybody has any idea on that ?

thanks

suchita

Not Active26-Jul-10 6:15

26-Jul-10 6:15

SayamiSuchi wrote:
Can we use nested repeater in ascx file in asp.net ?

It's an ASP.NET control, why couldn't you use it?

Why don't you show what you have done so we can help point out what may be wrong.

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

Dhyanga26-Jul-10 6:22

26-Jul-10 6:22

Sure. Thanks for the reply. Well these are the codes.

<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>

I have these in my ascx page.

suchita

Martin Jarvis26-Jul-10 6:47

Martin Jarvis

26-Jul-10 6:47

You won't be able to access the Repeater3 control from the ascx directly as a new one is created for each databound item.

If you handle the OnItemDataBound event on Repeater1 you'll be able to access the Repeater3 control using:

e.Item.FindControl("Repeater3")

Freestyle Interactive Ltd Martin on .Net Follow Me on Twitter

Not Active26-Jul-10 6:52

26-Jul-10 6:52

Martin Jarvis wrote:
You won't be able to access the Repeater3 control from the ascx directly

Why not? See below.

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

Dhyanga26-Jul-10 7:02

26-Jul-10 7:02

Thank you for the reply but still it didnt recognize Repeater3.. Frown | :(

suchita

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