|
I got this error in my code:
Cannot add part for the specified URI because it is already in the package
At this line:
var chart = xlSheets.Drawings.AddChart(dataSet.DataSetName, OfficeOpenXml.Drawing.Chart.eChartType.ColumnClustered);
I am trying to create multiple sheets.
Anyone know how to fix this?
THANKS in advanced~
|
|
|
|
|
As this is a CodePlex project, the best place to ask would be the support forums for that package on CodePlex itself. When you post a question there, the developers will be notified.
|
|
|
|
|
Anyone know how to set title for Xaxis and Yaxis?
I can't find it.
|
|
|
|
|
I cannot figure out the syntax for using the LINQ extensions on IList (and other interfaces) to search for values that are in nested objects.
For instance, I have a List<foo>, where object foo contains two other objects, each of which have field "data".
How do I use List.Contains<foo>("hello") to search for a foo object where foo.nestedobject.data = hello?
|
|
|
|
|
Why not ask in the LINQ forum where the LINQ guru's hang out?
|
|
|
|
|
Thanks. I asked here because it's not obvious that object.contains() is actually a LINQ extension. Sadly, you can't do what I want with object.contains(), which does not let you compare nested values directly.
Turns out that what I need is
foo.Any(f => f.bar.data == "hello")
Which makes me a little sad, because
foo.Contains(nested value I was looking for)
would have been a lot simpler than having to break out my book and re-learn lambdas. Oh well, wave of the future 
|
|
|
|
|
How could Contains() have any "idea" in which properties of foo to look for some value?
For instance, should it look in all properties that are the same type as the value to find? What if it is nested arbitrarily deep?
The only rational behavior is for the developer to be responsible to structure the query.
Re: lambdas... they're not that hard!
|
|
|
|
|
How would Contains know to look inside its member items?
You can either use Any with a lambda as you've discovered, or you can implement equality checking on the class Foo and do
List.Contains(new Foo("hello"))
... if that makes any sense for the actual class you're using. I'd generally use the lambda, that makes it crystal clear what the test you're actually doing is.
|
|
|
|
|
Help with visual c# software developing? The first tab will deal with a persons details. The tab will havea combo box which will contain the names of people. The user will select a person and the drtails will be displayed in the relevent controls. A second combo box will allow the user to choose whther the person is an employee ir a client. If the person is a client, his/her name, surname, age and telephone number must be stored. The category must be stored or displayed as well.
The second tab will have a combo box which will contain the type or description of the product. The user will select type or description and the products details will be displayed. Details will be; type/description, quantity, price (these must be stored coming from textbox controls) and price including VAT (displayed in a text box)
Each tab must have add and remove buttons to remove and add new details.
Details will be stored in two separwte arraylists.
Create a product class, with constructors, properties for the type, quantity, price and a method to calculate the price including VAT.
Create a person class with properties for name, surname, age and category. Include relevent constructors.
Include two more classes (employee and client) which inherit from person class . The employee class will have a property for its position. The client class will have a property for its telephone number. Include constructors for both child classes.
Include error trapping.
Format the values displayed for pricing to a currency type.
Ensure that the price including VAT updates as the user types the price for the product
Ensure relevent comboboxes areupdated as you move from one tab to another.
I NEED HELP WITH THIS, i am doing a part time course, and i am confused on wat to do, and how to do it. I have an idea with working this, but i am confused by the above.
|
|
|
|
|
joy madalane wrote: i am confused
Okay I will bite... what exactly is confusing to you? Perhaps it is confusing because you are reading through this an thinking you have to do everything at the same time? Take one thing at a time and just do it. Nothing in your list is particularly difficult.
Probably what I would do it create your support classes first. Create a "product" class, mark it off your list. One thing down. Create the "person" class, another thing done. Just work through your list and pretty soon you will be done.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
Wes Aday wrote: Create a "product" class
How do you do that? Can you send an exa...SMACK ow ow all right I'm going
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
As with any task, the first thing to do is break it down into chunks, and then concentrate on each chunk at a time.
Fortunately, this is already done.
You have a form. Add a TabControl. The first page handle person details,. so name it appropriately, and set the TabPage Text to "People" or similar.
Now look at what it needs to contain:
1) A combo box.
2) Details about the person - this will depend on the data you have stored,. so that is up to you.
3) A second combo will select the type - employee or client.
...
And so forth.
Just take it in stages, it is only complicated if you try to do it all at once.
The only thing I would say is that you should be prepared to make some wrong decisions - we all do - so don't be fixated on what you have created so far, be prepared to bin it and start again with the benefit of hindsight. (But back it up first, so you can change your mind).
Personally, I would create a Person class, and a UserControl to display the Person detail, and add one of those to the panel instead of a pile of separate controls, but that assumes that your course has reached that point.
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
Thanx for the reply 
Can i skype or email you???? I wanna ask some novice questions, just 3 questions sir
|
|
|
|
|
No - I get enough paying stuff that way already! 
Ask them here - people won't be upset if you ask novice stuff, we all have to start somewhere. And you may well get multiple veiwpoints on it which can help.
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
I am trying to implement a multi page form on a site that will be used for 3 different types of applicant. Each of these 3 types will fill in their personal details before filling in different sections of the form depending on type.
I currently have a base class with the shared personal details and derived classes for the 3 specific types. In my form however I don't know how to create the correct object based on the type of applicant without having a lot of duplicate code.
Here is a cut down example of my code. This is an example of the classes
public class BaseApplication
{
public bool FirstName { get; set; }
public bool LastName { get; set; }
public virtual void Save()
{
}
}
public class StudentApplication : BaseApplication
{
public bool SupportNeeds { get; set; }
public override void Save()
{
base.Save();
}
}
And this the part of the page where I want to create the object.
?? app;
switch (courseType)
{
case "31":
app = new StudentApplication();
break;
case "32":
app = new AdultApplication();
break;
}
app.FirstName = FirstName.Text;
app.LastName = LastName.Text;
app.SupportNeeds = SupportNeeds.Text;
app.Save();
I don't know what to declare app as as it can be one of 3 types depending on the value of courseType.
|
|
|
|
|
Create it as the base type: that way it can hold all of the derived types:
public abstract class myBase {...}
public class derived1 : myBase {...}
public class derived2 : myBase {...}
...
myBase app;
app = new derived1();
app = new derived2();
...
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
Won't work I'm afraid. The OP has properties in the derived types that won't work here because they are more specialised.
|
|
|
|
|
The big issue you have here is that properties in the derived type aren't present in the base type, so you can't really declare app as BaseApplication. Well, you can, but you need to cast to the derived type to access the properties. What you could do is something like this though:
BaseApplication app = null;
switch (courseType)
{
case "31":
app = CreateStudentApplication();
break;
}
if (app != null)
{
app.Save();
}
....
private StudentApplication CreateStudentApplication()
{
StudentApplication app = new StudentApplication();
SetBaseInformation(app);
app.SupportNeeds = SupportNeeds.Text;
return app;
}
private void SetBaseInformation(BaseApplication application)
{
application.FirstName = FirstName.Text;
application.LastName = LastName.Text;
}
|
|
|
|
|
Psst.. strategy pattern!
..and you might want to program against a simple and small (or even multiple) interfaces
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
I thought of an interface but couldn't see how it would work.
Strategy pattern sounds like a proper programming thing and not something a hack merchant would be able to do 
|
|
|
|
|
suzyb wrote: I thought of an interface but couldn't see how it would work.
You can have them at property-level; considered an IFirstName?
Keep hacking, and you'll learn it as you go. Just a matter of time before you stumble over it
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
suzyb wrote: I don't know how to create the correct object based on the type of applicant
without having a lot of duplicate code.
Generic creation problems are often solved with the Factory Pattern.
Other than that I don't know what you mean by "duplicate" code. If the objects are different than they are different and you shouldn't attempt to generalize. If however the are the related (by design and NOT by your desire to avoid typing) then you should perhaps re-think your design/implementation.
|
|
|
|
|
i need to optimize all tables in a MySQL database automatically. can you please help to make programe c#.net
|
|
|
|
|
- What does optimize mean? What will you be doing with the tables?
- We got a database-forum
- Your question for help on C# is too broad; you make a C# app like all the others, and you can get help with specific questions. You'll have to do the writing yourself.
- Can you show us an example of a table before and after "optimization"?
Looking forward to your answers.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
In our data base have more than 150 tables available. In every day some table have delete and update operation is going. While after the delete memory is stored in temp. When I tried to open schema, it’ll take some time. I need to make faster in my schema. What can I do? That’s only I selected optimize all table in mysql.
Thanks,
P.Alagiri
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
