.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

help with data loading? only does it once?

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :ASP.Net


i have a problem with my page. i can get it to function once, but then it wont do it again.

i have a datalist on the page, with an image button and a series of labels underneath it.

labels 1-3 are data from a table.

labels 34-36  are from a querystring.

on image button click labels 34-36 should add together with labels 1-3 and divide by label 50. also, label 55 should take label 50 and add '1' to it. then it should redirect to the page again with new querystring values of labels 34-36 (newly generated) and from label 55.

I can get this to work once, but then nothing happens again. Maybe i need to use something other than itemdatabound? or something to do with postback? i dont know, please help!

here is my code behind:

    protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)

            Label Label34 = e.Item.FindControl("Label34") as Label;
            Label Label35 = e.Item.FindControl("Label35") as Label;
            Label Label36 = e.Item.FindControl("Label36") as Label;

View Complete Post

More Related Resource Links

To prevent possible data loss before loading the designer, the following errors must be resolved: In

To prevent possible data loss before loading the designer, the following errors must be resolved: The class Form can be designed, but is not the first class in the file. Visual Studio requires that designers use the first class in the file. Move the class code so that it is the first class in the file and try loading the designer again. Instances of this error (1) 1. Hide Call Stack at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.EnsureDocument(IDesignerSerializationManager manager) at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager manager) at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager) at System.ComponentModel.Design.Serialization.BasicDesignerLoader.BeginLoad(IDesignerLoaderHost host) Thanks! This post is from Matthew Cenance.

XML Source (Data is not loading to Destination ,Package Runs sucessful)

Hi First I run execute SQL Task SELECT TOP(10) [Message],opportunity_Id  FROM SBP FOR XML PATH ('GS_Opportunity'), ROOT('GSOpportunities') That will make 10 different file into single file then i have assigned this output to variable and it will output as XML Now I put Data flow task ,in it I put XML task and in source i have put XML Data From Variable and I select XSD file location,now XML task is showing me different source table and i have selected appropriate destination table but when i run this package it will not transform data from source to destination,Can you suggest me what is the problem i try to put data viewer it is not transforming any data  while insted of if i select direct file location instead of variable it is running good    

Data loading from text file

Hi, I am loading the data from a flat file into a sql table. The values in one of the column have spaces at the end of the value. I want to remove those spaces and load into the table. I am thinking of using derived column and use rtrim on that column, how can I use that as an expression. Thanks.sqldev

Entity Framework POCO and WCF Data Service - Lazy-loading (expand?) related entities?

I've followed ScottGu article on creating an Entity Framework POCO classes for NerdDinners (right now there are only 2 classes, Dinner and RSVP. I then created a WCF Data Service class, which points to my EF class (NerdDinner), everything is working fine, except I can't lazy-load or expand related entities. For example, I want to get all load all the Dinners and their related RSVPs, something like this throw an error:var result = (from d in db.Dinners.Expand("RSVPs")                      select d);The error is a null reference error:at System.Data.Services.Serializers.SyndicationSerializer.WriteObjectProperties(IExpandedResult expanded, Object customObject, ResourceType resourceType, Uri absoluteUri, String relativeUri, SyndicationItem item, DictionaryContent content, EpmSourcePathSegment currentSourceRoot) at System.Data.Services.Serializers.SyndicationSerializer.WriteEntryElement(IExpandedResult expanded, Object element, ResourceType expectedType, Uri absoluteUri, String relativeUri, SyndicationItem target) ... ... ...Any idea why or what I need to do to load related contents?Thank you very much.

SSIS 2005 - XML Source no data loading to sql server database destination

Hello I am trying to load data from xml source to sql server destination, but the task executes with no data loaded to destination. i really appreciate any guidance in working and troubleshooting xml sources. Regards Harris

things to consider when loading a lot of data to a big table


What are the considerations when loading a large amount of data to a large table?

One thing to consider are the indexes because they need to get rebuilt. One advice I had from someone is to drop the index, load the data, and finally re-create the index. Is this faster than loading without dropping the index?

What other considerations or concerns are there? What about data isolation? If it take a while to load the data, are the users locked out from selecting from the table? I would try to test this, but not sure how I can come up with large enough data set to play with.

About loading data onto a Mysql database

I am in the process of transferring data and contacts onto a Mysql database.
I have had some help and am trying to get a software solution.  

So main features would be to migrate large amounts of data and contacts every day. The migration would be done manually. 

Thanks for the help.

Loading data from SQL 2008 to AS400


Using SSIS I am trying to load data from a table in SQL server 2008 to AS/400 file, like we have in DTS called "Other Connection" I do'nt see such task in SSIS. I created ODBC DSN to connect to AS/400. Please let me know what task I should use to load data from SQL server 2008 to AS/400. Thanks.


Loading Data into Datawarehouse(SSIS)


I am Beginner to SSIS, but this question is all about Data warehousing.

When I load the data to dimensions Do I need to have constraints off(referential integrity).

Is there any best practices before & After loading data into DW on SSIS ?



steps for loading data into a dimension table


Hi Experts,

Can anyone give me the steps for loading data into a dimension table from a SQL database table? An explanation as to why the objects are used will be very helpful.

Thanks in advance

package not loading data


 Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.

I tried to run as adminstrator. package runs and warning disappears but not showing how many rows passed through pipeline. thnx in advance


[SSIS.Pipeline] Warning: The output column "CustomerID" (98) on output "Lookup Match Output" (49) and component "Lookup" (47) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Loading Data without Duplicates using ssis


   The data needs to be logged. Any duplicate data from previous day will not be updated. -- How to achieve this using SSIS


Loading Data through List Object dynamically Using SSIS



How to load data through list object (in.net)(Through list object the data is populating dynamically) using ssis....?

Can any one help me....ASAP...?




SSIS data flow task not loading all rows from sybase server



Using a data flow task I am trying to load data from a table in sybase server to sql server. There are approx 10000 rows in the sybase table, however for some reason which I am not able to find out, at random certain no of rows are getting inserted. e.g. in one run 800 rows then 200 rows etc.

Can somebody please guide me on this?

WCF Ria Services data loading issue


 Hi, here is my problem: I need to load some set of data. I wrote following code(I use Linq2Sql as ORM):


var query = from sensors in Context.GetWCM_SensorsQuery() where sensors.DeviceID == 1 select sensors;
            Context.Load(query, OnMeasLoaded, null);

  private void OnMeasLoaded(LoadOperation<WCM_Sensor> obj)
            var tmpStore = new List<WCM_Sensor>(obj.Entities);


After this code execution i see situation below:

I found the reason of incorrect queries execution. I have services endpoints dclaration in web.config file. There looks like this:


      <service name="StreamEase.Web.Services.AuthenticationService"
        <endpoint address="" binding="wsHttpBinding"
        contract="StreamEase.Web.Services.AuthenticationService" />
        <endpoint address="/soap"
        contract="StreamEase.Web.Services.AuthenticationService" />

Loading rtf with image gives "Unrecognized structure in data format 'Rich Text Format'.\r\nParamet


I'm trying to load this rtf into a RichTextBox:

{\rtf1\ansi\ansicpg1252\uc1\htmautsp\deff2{\fonttbl{\f0\fcharset0 Times New Roman;}{\f2\fcharset0 Segoe UI;}}{\colortbl\red0\green0\blue0;\red255\green255\blue255;}\loch\hich\dbch\pard\plain\ltrpar\itap0{\lang1033\fs18\f2\cf0 \cf0\ql{\f2 {\ltrch >> -----------------------------------------------------}{\ltrch \line }{\ltrch >> 19-10-2010 11:22}{\ltrch \line }{\ltrch >> -----------------------------------------------------}{\ltrch \line }\li0\ri0\sa0\sb0\fi0\ql\par}
{\f2 {\ltrch {\*\shppict{\pict\picwgoal1020\pichgoal1035\pngblip

showing Wrong Data while loading excel sheet, need help urgent



I am trying to load data from an excel sheet to a table in sql server. in the excel-source when i press preview button data for one column in the excel sheet is coming as null. the column has numbers and the format of the cell is 'general'..? what could be wrong and how could i resolve.? need help urgently..?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend