|
You're welcome - you could, of course, use a combination of booleans if you wanted - this was simply a quick example of how you could do this.
This space for rent
|
|
|
|
|
Hi there!
I'm just trying to use dtsearch desktop/engine on my website and I was told to use C# to program it into php or sth....
I Dont know how to do programming for dtsearch to apply to my website/host so that people can use my database search engine....
and in years to come, I'm gonna turn it into android progrm
please help me, I could give you some 25 $......I'm not rich enough
thanks a million ways to die in the west juno!
|
|
|
|
|
We don't charge for help here: if you want to pay, thn go to vWorker.com and ask there. $25 should get you a complete Android app if you don't give a damn if it works at all...
But I'd start by asking the people who wrote dtsearch (whatever that is) as they will probably have a much better idea and possibly even tutorials...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
As you were told when you posted this in QA two days ago[^], if you have questions about the code in an article, use the forum at the bottom of the article[^]. The person who wrote the code is the most likely to be able to help you.
Reposting your question in a general forum will only serve to annoy the people who answer questions here, because you're duplicating work. Particularly so when you have completely ignored the advice you were given in response to your previous post!
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
So I wasn't sure whether to post this here or in the database section, but here it goes. I have a 'logbook' that I'm developing which is basically a simple message board. Where I'm drawing a blank is how to format the data coming out of the database for the printable report. The database is set up so that all the messages are stored with various headers and a parent/child structure in a single table. You can have multiple child replies to a single parent, but only 1 level deep. Where I'm drawing a blank is how to structure the data for use in the printable reports. Any help would be massively appreciated as I'm drawing a blank as to which direction to go with this.
Here's the desired report structure[^] and the current data format[^]
modified 11-Jan-16 10:53am.
|
|
|
|
|
From your post it is difficult to understand what you want to achieve or what the problem is.
If it is a single table, I'm unsure what you mean with "how to structure the data". Linking the records seems (from your text) easy enough. What's the report for? What data should be on there? For whom is it? You're not asking for a report structure, or are you?
|
|
|
|
|
Thanks for the reply. I updated the original post with some pictures to see if that helps explain it.
|
|
|
|
|
Hello,
Much clearer, thank you.
I'm not sure what everyone has against Crystal Reports, I worked with it and never had any issues.
I think from the other answers a quick tutorial is indeed a good idea. Many report builders allow grouping/summaries and even graphs on the fly. Playing with it is the best way to learn.
Not sure about other reporting tools, but Crystal Reports allows basically two ways of fetching data. You select data from .Net and pass it to the report document allowing more dynamic control or (my favorite) you build a template and just pass some parameters from .Net to it. The report document will fetch the data itself and build the report. (advantage is that you can test the report outside your application)
Concerning the report format I can only give the advice what I always do. That's asking yourself what is important. I use the 7 seconds rule. The first thing any user asks himself when seeing a webpage, a report, a document, ... is "What am I looking at". Attract their attention with showing what the report is about. The next 7 seconds are navigation. The user passed the first 7 seconds and now wants to know how the thing is constructed. (layout, where is which data, etc ...) After that you have their attention and only then will they look in detail.
(PS: I say 7 seconds, it could be 3 or 5 or 2.45, but you get my drift)
Hope this helps.
|
|
|
|
|
|
I suggest you consult the documentation for the (Sql Server / Visual Studio) Reporting Services and do one of the "walk-throughs".
That will take you through:
1) Starting the report designer / builder
2) Specifying a data source (I.e. database tables)
3) Selecting records
4) Fields to report on
5) Sorting
6) Formatting
7) Grouping
8) Parent-child reporting
etc.
Reporting Services Tutorials (SSRS)[^]
Once you have something going, you can ask more specific questions.
|
|
|
|
|
Thanks! I didn't know they covered Parent-Child grouping.
|
|
|
|
|
|
I'm with Gerry on this, pick a report builder and use that, anything except Crystal Reports. We us SSRS and it does all you need but then so do ALL other reporting tools. Parent/Child structure are the bread and butter of reporting.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Apologies if this has been answered before.
I have a C# program that calls various PowerShell scripts as it runs. If I run the program as an administrator, it doesn't seem to pass on the elevated rights to the runspaces used for executing the scripts.
Is there any way to do this? The code I am using to run the scripts is below:
string mScriptPath = "Project.Resources." + mScriptName + ".ps1";
Assembly _assembly = Assembly.GetExecutingAssembly();
StreamReader _psStreamReader = new StreamReader(_assembly.GetManifestResourceStream(mScriptPath));
Runspace runspace = RunspaceFactory.CreateRunspace();
runspace.Open();
string powerShell = _psStreamReader.ReadToEnd();
_psStreamReader.Close();
var shell = PowerShell.Create();
shell.Commands.AddScript(powerShell);
shell.Invoke();
Any help would be appreciated
|
|
|
|
|
Would this help - Passing credentials ? (note, obviously its dangerous to store the password plain-text, Im not suggesting that as a long-term thing, but test it, if it does what you want, think about handling the password 'securely' - maybe there's a similar way of getting and using the local credentials if you're already signed on as Administrator)
(this is the guts of what you need to do to your code)
var credentials = new PSCredential(username, ConvertToSecureString(password));
var connectionInfo = new WSManConnectionInfo(false, computername, 5985, "/wsman", "http://schemas.microsoft.com/powershell/Microsoft.PowerShell", credentials);
var runspace = RunspaceFactory.CreateRunspace(connectionInfo);
Ref : WSManConnectionInfo Constructor (Boolean, String, Int32, String, String, PSCredential) (System.Management.Automation.Runspaces)[^]
[Edit] needs
using System.Management.Automation;
using System.Management.Automation.Runspaces; [/Edit]
|
|
|
|
|
I'm having some issue with my code in my Windows Service not releasing memory.
In short my Windows Service basically created about 8 timers that elapsed every X minutes which called a method that queried data from Exchange and stored in the database.
What I have noticed is the memory always climbed to the point it would crash the service when it reached maximum (32-bit process)
I switched from using timers to using the Quartz library but experienced the same results.
Here is an example of one of the timers jobs:
public class Get_MailboxDatabaseSizesTask : IJob
{
private static readonly ILog logger = LogManager.GetLogger("Get_MailboxDatabaseSizesTask");
public void Execute(IJobExecutionContext context)
{
CloudPanelDbContext db = null;
ExchActions powershell = null;
int processedCount = 0;
try
{
db = new CloudPanelDbContext(Config.ServiceSettings.SqlConnectionString);
db.Connection.Open();
powershell = new ExchActions();
var mailboxDatabases = powershell.Get_MailboxDatabaseSizes();
db.StatMailboxDatabaseSizes.InsertAllOnSubmit(mailboxDatabases);
db.SubmitChanges();
processedCount = mailboxDatabases.Count;
mailboxDatabases = null;
}
catch (Exception ex)
{
logger.ErrorFormat("Failed to retrieve mailbox database sizes: {0}", ex.ToString());
}
finally
{
if (powershell != null)
powershell.Dispose();
if (db != null)
db.Dispose();
logger.InfoFormat("Processed a total of {0} mailbox databases", processedCount);
}
}
}
As you can see I am disposing of my context and my ExchActions class... I solved the memory issue by adding this to the end of each Execute method:
GC.Collect();
GC.WaitForPendingFinalizers();
Its not ideal but its working.... but why do I have such a memory problem without it? Where should I look?
|
|
|
|
|
Take out the GC crap. It's really not helping that much and, by the description you gave, will actually hide the problem, not fix it. From what you've said, it sounds like there's some other object you have to Dispose, but haven't, before it goes out of scope or you're constantly adding to a collection. There really isn't that much code here. I don't know where that logger is going to but it may also be the problem.
Get a memory profiler[^]. It'll tell you what type the objects are that are taking up all that memory and give you a clue as to what to look for.
|
|
|
|
|
I will look into the memory profiler.
The powershell commands i'm using is the same code I'm using in a web application and haven't noticed any problems.
I thought it was the timers but I think its more LINQ to SQL since I swapped out the timers for the Quartz library.
The GC.Collect didn't actually help because when it ran I could see the memory go up and go down... however after a couple days i'm seeing i'm at 1.5GB now.
So it is possible that 1 timer is causing all this.... the logging is log4net and it logs to a text file
|
|
|
|
|
Could it be the timer itself? Nope.
But, it will most likely be in the code the timer executes.
|
|
|
|
|
Hmm. Applying explicit GC operations is not supposed to make much of a difference.
And actually context is the one item you are not disposing, and probably the caller of Execute() should take care of that, not Execute() itself.
BTW: rather than finally, I prefer the using pattern for disposable objetcs; example:
using (ExchActions powershell = new ExchActions()) {
...
}
No matter how the using block is exited (normally, return, exception) the newly created object will always be disposed of correctly; and you can nest them as much as needed.
I see you open a DB connection but never close it. There too you should be able to apply a using construct.
DB connections get pooled, i.e. recycled, very well assuming you close or dispose them in time. Otherwise the system may exhaust the default pool and try to create large numbers of connections...
|
|
|
|
|
Luc has returned!
Where the hell have you been for the last, oh, 3 years? Nothing bad I hope!
|
|
|
|
|
Hi Dave,
I switched to a more passive mode a couple of years ago; I'm still reading a few CP articles each week, but I stopped my forum activities, lacking a sufficient number of decent questions since mediocrity introduced by QA started infecting the forums too. However, when I see something worthwhile in C# or algo forums, I occasionally post a bit. So, no, not really a return, just passing by.
|
|
|
|
|
Luc Pattyn wrote: lacking a sufficient number of decent questions since mediocrity introduced by QA started infecting the forums too.
I hear that! The number of "questions" where the OP doesn't know what a computer is let alone how to write code for one just keeps growing and growing. The Copy'Paste'n'PrayItWorks coders are outnumbering the good questions by a large margin now-a-days. Too many people find it easier to ask someone to do their work for them or fix their code for them and won't even bother to set a breakpoint let alone look at variables in the debugger. It's really sad.
It's wearing pretty thin on me too. I weep for the future of software development.
|
|
|
|
|
I'm disposing of "db" which should close the connection shouldn't it?
I can try using but I usually steer away from it because I can't really catch exceptions without putting another try/catch inside the finally which is in effect making it a nested try/catch isn't it?
|
|
|
|
|
Quote: I'm disposing of "db" which should close the connection shouldn't it?
I don't know as I'm not familiar with CloudPanelDbContext.
And I wouldn't rely on it unless (a) it is stated explicitly in trustworthy documentation and (b) I put in a comment repeating such fact.
Quote: I can try using but ...
Yes you can nest try/catch/finally blocks, however it doesn't look good and most often there is no need to do so.
Actually you often don't need an explicit finally block if all disposable objects got created with using constructs, that is the beauty of it: it is hard to get it wrong, as the code is much simpler (the compiler automatically translates it to something similar to what you have, but readability is much better, so error probability goes down).
Your method, without corrections for the possible connection issues, would be simplified to:
public void Execute(IJobExecutionContext context) {
int processedCount = 0;
try {
using (CloudPanelDbContext db = new CloudPanelDbContext (Config.ServiceSettings.SqlConnectionString)) {
db.Connection.Open();
using (ExchActions powershell = new ExchActions()) {
var mailboxDatabases = powershell.Get_MailboxDatabaseSizes();
db.StatMailboxDatabaseSizes.InsertAllOnSubmit(mailboxDatabases);
db.SubmitChanges();
processedCount = mailboxDatabases.Count;
mailboxDatabases = null;
}
}
} catch (Exception exc) {
logger.ErrorFormat("Failed to ...");
}
logger.InfoFormat("Processed a total of {0} mailbox databases", processedCount);
}
I'm also not familiar with Entity Framework, however assuming your CloudPanelDbContext is derived from System.Data.Entity.DbContext a quick google session told me such context knows how to deal with open connections; it seems you can open a connection and keep it associated with your context, see e.g. some of the constructors here[^].
May I suggest you read up on that topic.
PS: the same webpage also describes Dispose() with "The connection to the database ( DbConnection object) is also disposed if it was created is by this context or ownership was passed to this context when this context was created." I don't think your situation satisfies those conditions.
My intuition tells me you're nearing the solution!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
