|
Try editing the project file and adding
<Reference Include="System.Management.Automation" />
with the other references. I think that may work.
Keep Clam And Proofread
--
√(-1) 23 ∑ π...
And it was delicious.
|
|
|
|
|
I have a c sharp dll that I can call a function within it, pass values and have it perform a task.
I would like to do this through a webpage by having a user fill out a few form boxes, press the submit button and have the button call the dll that is on the webserver and pass the values from the input boxes on the webpage, so the dll can then do its function.
I'd like to be able to write back to the webpage any success or failure messages as well.
Thanks.
|
|
|
|
|
The button doesn't call the DLL on the server. Supposing your web application is written in ASP.NET, you bind to the Submit Click event and in the code behind the web page, you create an instance of the class that you are interested in, and pass in the values. What happens next really depends on whether or not the operation is quick - if it is, simply return the value. If not, you would have to spin this off as an asynchronous operation and put logic in place to periodically check the values.
|
|
|
|
|
Thanks for the reply.
I'm going to try and create a wpf web application and work from there.
I've never done anything with c sharp and web related things, so this will be a first for me.
|
|
|
|
|
What do you mean by WPF web application? WPF is a desktop technology. If you are talking about WPF/E, I would avoid that at all costs - it's extremely limited.
Are you talking about Silverlight by any chance?
|
|
|
|
|
Not Silverlight. In Visual Studio, there is an option to create a WPF Web Application, so I've started writing something in that. Maybe it is wrong, idk, but it seems to be working so far in the IDE?
|
|
|
|
|
turbosupramk3 wrote: In Visual Studio, there is an option to create a WPF Web Application
I know. Good luck with that.
|
|
|
|
|
Ok, can you give me an alternative suggestion in Visual Studio?
|
|
|
|
|
Indeed. You can do it as a Silverlight project, or an ASP.NET project, or ASP MVC... There are many better alternatives (there's a reason that Microsoft dropped this as a type eventually).
|
|
|
|
|
Thanks for the reply Pete.
I'd like to try an ASP.NET project.
Do you have a simple working example I can download and learn from. This has turned out to be a lot harder than I thought it would be just to get a simple working example going.
I just downloaded this
http://www.microsoft.com/en-us/download/details.aspx?id=12888[^]
but it wants a bunch of prereq's that I don't have?
|
|
|
|
|
If you are going to go with ASP.NET, then I'd recommend having a look at this[^] site. Yeah, WPF is a hard skill to master - you should find ASP.NET a lot easier.
|
|
|
|
|
Ok, I really want the path of least resistance, so thank you for that.
|
|
|
|
|
Hi, I have been looking all over the web but kind seem to get anything to work so though I'd ask here:
I've created a custom TFS user control. It exists in a project which references another that holds a process which is used in the control. The user control inherits from a base user control and implements IWorkItemControl. This base user control inherits from the winforms user control. I have created a *.wicc file that has the same name as the control and points to the right complete control name and the .dll containing the control. How do I deploy this? I have put it in %ProgramData%\Microsoft\Team Foundation\Work Item Tracking\Custom Controls\10.0 on the TFS server but this does not seem to do anything? I create a custom Work item but I cant use the control in it?
Thanks in advance
|
|
|
|
|
Anybody have any sample code to take a SQLGeometry and use it to clip an image?
I have a SQLGeometry cell in the database that tells me the outline of a shape. I have a rectangular image that I want to clip to that shape.
I.e. I have an Image object A thats 100 x 100 and an Image object B thats 90 x 90. I have a SQLGeometry object that tells me the real shape of Image object B. I want to draw Image object B on Image object A, but clipped to the SQLGeometry object and have the ability to save it out as a b&w TIFF.
I don't care if its done with standard C# graphics or WPF graphics. Performance is most important, so if I can utilize the hardware acceleration of WPF to do it, that'll be great. The only requirements are:
1) Image object B comes from an HTTP stream
2) Need to be able to draw Image object B on Image object A
3) Need to be able to draw additional text on Image object A
|
|
|
|
|
First thing I would do is use the method described here[^] to get the geometry out. The clever thing to do would be then to create a brush (you choose whether you want a VisualBrush or ImageBrush) representing ImageObjectB from the stream, and then use that as the brush for your geometry.
modified 29-Oct-13 10:20am.
|
|
|
|
|
I have a csv file in which there are 20 million records, there can be duplicate records also in file.
There is a table with 17-18 million records. now i have to read from file and match records against table and if they match then store in other table.
I was thinking of creating a window service which will do these operation. But performance is of highest priority.
what can possibly be the best approach and fastest way to read and filter 20 mil records.
|
|
|
|
|
With that volume you are going to suffer but I would suggest using an ELT approach and an SSIS package
Extract - you have done
Load - I would BCP or bulk copy the lot into a staging table in SQL Server the staging data should exactly reflect your csv and all fields should be varchar.
Transform - write a stored proc that does the transforms (delete, match, validate formats, dedupe, copy to production table).
NEVER do your transforms in code, SQL is designed to chew through bulk data doing the transforms in c# is just wrong!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
that's good idea but then one concern would be error messages would be a problem plus to read file. Also would service execute the bcp. Because files will come every hour so we need someone to watch the files and pass latest for bcp.
|
|
|
|
|
You can schedule a job to run as often as required, you can either use a timed process or I think you can use a filesystemwatcher.
Error messages should go to a log file and emailed to an operator. How is the operator supposed to respond to the errors!
What you are looking for is a full blown ELT process, the last one I built had a winforms UI that displayed the log results, the files processed with timing, any error messages.
It archived the data files to a daily folder and allowed the operator to repeat a process.
It was not a trivial project.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i am planning to have asp.net web forms which will show logs and reports.
can you share architecture of the application you built.
do you have some performance stats as to how much time was consumed, transfer process etc..
|
|
|
|
|
nitin_ion wrote: you share architecture of the application you built
It was many years ago and proprietary to the organisation I work for, sharing would get me crucified!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
 no problem and thanks anyways for providing direction.
But only concern is that we'll then be mixing business logic with database layer as there is some business rules to be run so if we go with ELT then our rules will be in procedures.
Is there a way we can segregate?
We are also planning reports from this, i know SSRS but not sure if MS SQL can handle such volumes of data.
Do you think MS can handle it 20 million every month?
|
|
|
|
|
I see no problem with having business logic in the database, especially when dealing with the transform of such volumes. Id hate to loop 20m records in c#.
I would get a professional DBA to answer the volume question and then get them to set it up. Designing the DB infrastructure for such a volume is not a trivial matter. I would also consider Oracle, as much as I loathe the database it does a better job of serious volume. Caveat Oracle will cost - a bomb!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I agree with Mycroft. Write an import module of some sort that inserts the data from the CSV into the database.
If it is a possibility remove the succesfully imported rows from CSV afterwards (in case of updates later on). Then perform the magic through SQL queries instead.
I do something similar with 1.8 million to 8 million records in a file that is inserted in a table now counting >2x107 rows. For this the memory of the object I use to hold the data is too large for the java framework I use (don't ask  ) you need to read in the file and start inserting while you go. I usually do that in batch (1000 inserts at once) instead of reading it in at once or sending to the database one by one.
Hope this helps.
|
|
|
|
|
At least we do ours using connect direct so it is server to server, the UI only initiates the process, never actually touches the data.
Never underestimate the power of human stupidity
RAH
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
