|
If you want to pass data from Form2 to Form1. Add static string or DateTime field in Form1 then in Form2 get the value of that datepicker and assign it Form1.staticvariable.
|
|
|
|
|
I want to write a PowerPoint addin that adds a button to the screen during the actual presentation time (rather than editing time) and then draws output on top of the presentation over top the presentation. The point is to pick a random person from a registered audience and display their name.
1. Is this kind of thing possible?
2. I know there are interop pages available online. Does anyone have any quick pointers as to what part of these documents I should look at for presentation event handlers (such as a slide change) and stuff like that? Perhaps how to draw a GDI+ object to a slide? (and remove that drawing upon a button click)?
|
|
|
|
|
|
No... actually this is the correct forum. I am interested in C# addons. Not whatever that is about. There is already a tutorial on basic .NET addons but it doesn't quite cover the areas I am interested in learning about:
PowerPoint timer (addin)[^]
|
|
|
|
|
I'm trying to create a query with And and Or predicates.
My question is how to form it so that I have all the ANDS, PLUS the ORs:
If this was SQL, I would do
SELECT *
FROM ValidityRules
WHERE InstrumentId = 1 AND
BaySerialNumber = 'ABC123' AND
AssayType = 'MyType' AND
(ValdityCode = 'Code1' OR
ValdityCode = 'Code2' OR
ValdityCode = 'Code3')
Note that the codes are in parens.
Here's what I have so far:
var predicate = PredicateBuilder.New<ValidityRulesEntity>();
predicate = predicate.And(x => x.InstrumentId == entity.InstrumentId);
predicate = predicate.And(x => x.BaySerialNumber == entity.BaySerialNumber);
predicate = predicate.And(x => x.AssayType == entity.AssayType);
foreach (var validityCode in entity.ValidityCodes)
{
predicate = predicate.Or(x => x.ValidityCodes.Equals(validityCode));
}
What's the right way to do this?
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Hi,
This article C# 7.0 in a Nutshell - PredicateBuilder[^] seems to explain it well. Look for
"The answer is to build the parenthesised expression first, and then consume it in the outer expression ".
|
|
|
|
|
That did it.
Thanks for the book ref
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
you're welcome.
|
|
|
|
|
I have a asp form what I want if the form validation is true then the page should be refresh and all the fields should be clear and if the validation is not true the page should not be refresh and the form data should not be cleared.
|
|
|
|
|
You still "refresh" on error; except, you "return" all the data, with appropriate "error info", so the user can correct.
A favorite seems to be to say there are errors and to return an empty screen so you can start over (sloppy banks and insurance companies). Oh, and don't forget to timeout in a ridiculous short amount of time; like, too short, to check some papers (the first time).
The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.'
― Confucian Analects
|
|
|
|
|
If I make a new project in Visual Studio and give it the name Welcome Program, then I see this in the code window:
namespace Welcome Program
Okay I am aware that a namespace helps organize things better and helps keep things separate, but this is not needed in a console program. But if I delete this line in a GUI program the program will not build. Is this just simply something Microsoft decided to build into their language? It has to be there when making a GUI?
And my second question is about this line:
Public Partial Class MainWindow:Window
All I know about this is that a partial class allows you to split the class definition among more than one file. This line also has to be there. What does MainWindow:Window mean? What is the purpose of the colon?
|
|
|
|
|
All of your code goes into classes. Classes ALWAYS go into a namespace. You cannot have a class without it being in a namespace, even in a console app.
MainWindow is the name of your class. The ": Window" part means the class inherits from a class called "Window".
|
|
|
|
|
'NameSpaces [^] control semantic scope: the context in which specific names (Classes, Methods, Fields, Properties, etc.) have meaning. They are a tool you can use to organize your code, and, when using different libraries that have duplicate names, to ensure isolation of one meaning from another (prevent name clashes).
Going a little "deeper:" we can view NameSpaces as an abstraction of an underlying code base that involves Assemblies; see this to explore this further: [^]
C# allows multiple NameSpaces in one file; other languages (ex. Java) do not.
It is very typical to use 3rd. party tools, or code libraries (dll's), and typical that you need to import code which will have their own NameSpaces. In C# Visual Studio you do this from the Solution/Project/References/Add Reference menu in the Solution Explorer.
Then, you enable the imported code to become available by adding a 'using statement with the name of the NameSpace. Member 12974235 wrote: Public Partial Class MainWindow:Window
This is the default declaration of a newly created WPF app.Quote: <global.microsoft.visualbasic.compilerservices.designergenerated()> _
Partial Class Form1
Inherits System.Windows.Forms.Form
This what the Designer.vb file in a VB app uses.Quote: public partial class Form1
C# declaration.
«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot
|
|
|
|
|
Namespaces: Dave and Bill have covered that comprehensively.
public partial class MainWindow:Window (Note that I corrected your typecase: C# is case sensitive, and "public", "partial", and class" are keywords, "Public", "Partial", and "Class" are not so you would get compilation errors with your original code).
public says that the class can be used inside and outside the containing class or namespace: if I reference your Assembly file once you have built it, I can use your class in my code.
partial you know about.
MainWindow:Window You are declaring a class: public partial class starts that, and MainWindow gives it a name. Without a name, you couldn't create an instance of the class which means you (pretty much) can't use it at all. The colon character ':' tells the compiler that this class called MainWindow is derived from an existing class - in this case the base class is called Window. This is called inheritance and you will meet this later in your course or book as it is very much fundamental to C# (and in fact to all OOPs languages). For the moment, just think of it as saying "MainWindow is a Window and I need to specify that if anything is going to work" - inheritance is one of three very important class "attributes" that you will need to learn, probably together, and they are all rather too complicated to cover in a little text box like this!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
modified 10-Jul-19 3:27am.
|
|
|
|
|
fyi: my students have responded well to the idea of a "library of blueprints," where you check out a Class (or, whatever) blueprint (declaration), and build it (instantiation). using this metaphor, you can describe the internal components (Fields, Properties, etc.) of a Class declaration as a "bill of materials and/or required tools, building skills).
mmmm ... what would a language running in .NET be without its own syntax ? a carnival ride with no admission fee ?
i'm grateful that the abomination of 'let has not snuck in to C#'s pantry, except in that execrable dialect of LINQ. :omg for that, i'll put up with the Elvis operator (#6), and new weirdness' in pattern matching now marching towards us (#7, #8).
«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot
|
|
|
|
|
APL, I suspect! 
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Just the sight of the three letters "APL" gives me an immediate cold chill: I was in the first year of a doctoral program at UC Berkeley (long ago, as in the early '80's), and the required research component for the year ... which was supposed to make us masters of statistical inference, wizards of qualitative social science research, etc. ... was taught by a person who decided we (the doctoral students) should grok all his lectures that he chalkboarded using APL. None of us had any prior programming experience ... remember this is back in punch-card jobs and terminals connected to mainframe days; you had to go over to a building to get your print out.
The amount of mental bandwidth I wasted pretending the teaching and the APL was intelligible ! I quit the program at the end of the first year: having stuck it out to prove I was not a "quitter."
Interestingly enough, a year later I got deep into Lisp, and assembly language.
Perhaps I should thank APL for curing me of an academic career ?
«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot
|
|
|
|
|
I know the feeling - I was working for a Terminal manufacturer, just before the advent of the PC and they bought an APL company (they made APL interpreters if I recall correctly). So they wanted a APL terminal, which meant I had to sit down with these guys and work out what they actually needed. Took forever to get it all up and running on a Z80 (with 8K RAM and 32K ROM) but it worked pretty well, I think. Don't think we actually sold any, or at least I never got a single bug report ...
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
You programmers seem to think and speak in the most peculiar, esoteric terms I've ever heard in my life.
|
|
|
|
|
Nah, we actually make sense when you understand the terms - just there is a lot of complexity and a need to be precise about what we are saying so there are a lot of technical terms.
Compare that with doctors, where the technical terms are there to make it hard for non-medical staff to understand: "Clavicle" for "Collar bone"; "Sphenopalatine ganglioneuralgia" - "ice cream headache"; "Synchronous diaphragmatic fluttering" - "Hiccups"; "Sternutate" - "Sneeze"; "Borborygmi" - "Tummy rumbles"; "Horripilation" - "Goose bumps"; and so on ... they aren't there to make things any clearer!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Perhaps one day you'll take a course in Computer Science.
«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot
|
|
|
|
|
Name spaces help to avoid "name collisions" when you start creating "solutions" that have multiple "classes", in multiple "projects". A "console app" can easily wind up becoming something "bigger" where the benefits of name spaces become more obvious.
Besides allowing one to "split" a "partial" class across multiple source files, partial classes also allow you to "extend" a 3rd party or "generated" source code (class) file without modifying the original. (e.g. Entity Framework "entity" classes)
The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.'
― Confucian Analects
|
|
|
|
|
xlApp.Workbooks.Open(filePath, 0, false, 2, " ", " ", false, XlPlatform.xlWindows, " ", true, false, 0, true,
xlWorkSheet = (Worksheet)xlWorkBook.Worksheets.get_Item(1));
System.Runtime.InteropServices.COMException: 'Exception from HRESULT: 0x800A03EC'
Thank You in Advance for your kind consideration  ![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif) 
|
|
|
|
|
This code won't even compile. You're making an assignment in an argument being passed to Open. That's not going to work.
Also, are you opening a password protected workbook? You're supplying a password, a space character, when opening the workbook. That is NOT the same as leaving the password parameter as empty or having "no value".
You didn't specify what type of app you're writing, Windows Forms, Windows Service, WPF, ASP.NET, MVC, ... Yes, it matters. You cannot use Excel interop in a web application, like ASP.NET or MVC, or a Windows Service app.
|
|
|
|
|
Yes Thank You! I also was wondering about the password parameter! Your information is helpful and Thank You for your Time
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
