Comments by virusstorm

virusstorm 4-Aug-17 6:33am View

You are looking for their perspective APIs for each of them. Keep in mind, they all do security differently so you will have to authenticate the user differently for each of them.

OneDrive - https://dev.onedrive.com/items/upload_put.htm
Google Drive - https://developers.google.com/drive/v3/web/manage-uploads
Dropbox - https://www.dropbox.com/developers-v1/core/docs

virusstorm 4-Aug-17 6:28am View

Can you double check your sample data? Your query is working exactly as it should. The code "DAB" only exists in TableB so when you left join it to TableA, you are only getting the entries in TableA and any matches found in TableB.

virusstorm 3-Aug-17 15:17pm View

Two possibilities. First, you might be running the 32-bit JVM in which case try running the 64-bit JVM. Second, try taking a looking at the config and see what location it trying to use for the temp directory. Make sure the user this runs under can access it.

virusstorm 3-Aug-17 14:43pm View

The documentation uses www.contoso.com and marketing.contoso.com as examples. So you will either need to setup an additional domain or sub-domain. If you can't do this, your only other option is setup a virtual directory.

https://msdn.microsoft.com/en-us/library/bb763173(v=vs.100).aspx

virusstorm 3-Aug-17 13:12pm View

Your connection string is trying to use the OLE provider:
http://www.oracle.com/technetwork/database/windows/index-089115.html

This means you need to have the provider installed on any machine that the application will run on. As RyanDev said, check out https://www.connectionstrings.com/oracle/ for various ways to connect to an Oracle DB.

virusstorm 3-Aug-17 13:07pm View

Why is load balancing in quotes? Did you build a custom piece of software to do the load balance? Is the load balancer an appliance, if so, what kind?

I suggest going back and editing your question to give more details of your setup and application architecture to get a solution to your problem.

In general, you typically buy an appliance to load balancing (such as an F5 as an example) or setup a software one such as Microsoft NLB. The appliance or software monitors response times and number of request sent to each node in your load balance pool. Based on this and other various statistics, you can configure it to send traffic to the least busiest node. How to do this specifically depends on what you are using to load balance traffic.

virusstorm 3-Aug-17 13:01pm View

The way you've described the problem, it's unclear what you are trying to accomplish. You also didn't explain in enough detail your setup, making it difficult to offer advice or suggestions.

If I'm understanding you correctly, you have a SQL Server running on the same server as your web server, which is IIS, and now you want to add another application to it. You will need to setup another virtual directory or website inside of IIS. What is still unclear is who is your hosting provider, so I'm going to assume that you can RDP directly into the VPS. If that is the case, start here:
https://technet.microsoft.com/en-us/library/cc753729(v=ws.11).aspx

virusstorm 3-Aug-17 10:20am View

First, what version of Visual Studio are you using? There is no "2016" edition.

Second, you need to make sure you have the right version of SSDT installed. If you aren't keeping the tools up to date (Tools -> Extensions and Updates), you may find issues when trying to deploy.

Third, make sure you are running SQL Server 2016 Standard.
https://docs.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql

virusstorm 3-Aug-17 9:37am View

Who is your hosting provider? Is your VPS running IIS? Unfortunately, your question is very unclear and it will be very hard for anyone to help you out. You may want to ask your hosting provider if they have any documentation on hosting multiple sites on your VPS.

virusstorm 3-Aug-17 9:33am View

You may want to rethink what you are trying to achieve here. If you compress the image (meaning some sort of compression format like Zip or RAR), something inside of Amazon will need to decompress the file. S3 does not support such actions which means you will need another application in Amazon or some sort of Lambda function to decompress the image.

virusstorm 3-Aug-17 9:26am View

You might want to check out this thread:
https://social.msdn.microsoft.com/Forums/windowsapps/en-US/5ffb29a2-3bab-4395-a571-0fe1dc809f59/how-to-enable-unsafe-for-a-c-phone-8-project?forum=wpdevelop

Doing pointer manipulation doesn't guarantee fast code, you may want to take a step back and look for other performance problems that are forcing you into pointer manipulation.

virusstorm 3-Aug-17 8:55am View

I'm note sure I understand what you are looking for. If you are asking "can it be done" then the answer is yes. If you are asking how to do it, that's way too large of a question for this forum. If you are looking for ideas on how to get started, you might want to think about it as a paint application and recording the lines the user draws. This becomes your circuits. From there, you allow them to drag gates on to the screen and connect them. Then you trace your lines to your gates.

virusstorm 3-Aug-17 8:48am View

Is your Windows Server 2008 machine patched and up to date? I've run into similar problems and found that the way 2008 handles TLS is outdated (it is an eight year old OS). You may want to spin up a Windows Server 2012 or 2016 machine and try that. You might find it's simply an issue with 2008.

virusstorm 27-Aug-15 16:00pm View

How are you playing them and are the videos are locally stored on the IIS server?

virusstorm 27-Aug-15 15:57pm View

You are most likely running into a versioning issue. If all of your SQL Servers are 2008R2, and your script and tool is looking for assemblies for 2012, then there will be missing DLL's.

Without knowing what you are trying to with the 2012 tools on a 2008R2 machine, my only suggestion would be to install the SQL Server 2012 Client Connectivity Tools on your server and see if that provides the missing DLLs.

virusstorm 27-Aug-15 15:53pm View

Have you looked at this MSDN article yet?
https://msdn.microsoft.com/en-us/library/Hh710052(v=sql.110).aspx

virusstorm 27-Aug-15 9:29am View

Take a look at this link, it might help you.
http://rob.conery.io/2014/02/05/using-entity-framework-6-with-postgresql/

virusstorm 26-Aug-15 10:20am View

Can you clarify what you mean by "but i am not getting PostgreSQL Database in change Data Source"?

virusstorm 25-Aug-15 15:03pm View

You have a lot of questions here making it really hard to give you an answer to anything. What I can tell you, because I think they all relate back to this, is you should not build async/await wrapper around a DLL import. The async/await pattern in .NET runs with in the .NET world. There are internal structures that get created and manged internally by .NET. When you perform a DLL import, you are leaving managed code and going into unmanaged code. When you do this, .NET no longer has the ability to control the task/thread the work is being done. It is highly recommended and advised that you use the async/await pattern with .NET objects that are designed to use this pattern. Hybrid approaches typically with have undesired effects.

virusstorm 25-Aug-15 14:55pm View

When you say "common", where any of them touched or changed in any way?

The documentation says "For service contracts, compatibility means new operations exposed by the service can be added but existing operations cannot be removed or changed semantically."
https://msdn.microsoft.com/en-us/library/ms731060(v=vs.110).aspx

virusstorm 25-Aug-15 14:51pm View

Your options are limited because .NET does not implement SSH. You will need some sort of 3rd party library (like WinSCP) to achieve this. Take a look at this for some other options:
https://social.msdn.microsoft.com/Forums/vstudio/en-US/bee2ae55-5558-4c5d-9b5c-fe3c17e3a190/c-code-to-do-sftp-of-files?forum=csharpgeneral

virusstorm 25-Aug-15 13:41pm View

You either need to optimize the SQL so that it runs faster or increase the execution timeout. Take a look at this:
https://msdn.microsoft.com/en-us/library/ms155782.aspx

virusstorm 25-Aug-15 13:40pm View

Have you looked at this:
http://codebetter.com/petervanooijen/2010/03/22/a-simple-wcf-service-with-username-password-authentication-the-things-they-don-t-tell-you/

virusstorm 25-Aug-15 13:38pm View

I suggest posting this in the Telerik forums. They would able to help you better.

virusstorm 25-Aug-15 13:37pm View

Make sure you hit the "Reply" button next to the person's name, otherwise they won't know you've responded.

As to your error, "e.NewPageIndex" has a value less the zero or has a value greater then the number of pages in "DataGrid1". Set a break point there and see what the value is and also how many pages are in "DataGrid1".

virusstorm 25-Aug-15 13:35pm View

You might want to consider using another library instead of the Word Interop. If you search for "C# Word to PDF", you will find a lot of open and closed source libraries that will work better then Word Interop one. I find they do a better job at preserving the text.

virusstorm 25-Aug-15 12:48pm View

What is the exception?

virusstorm 20-Aug-15 11:04am View

The easy solution, manually add the configuration settings into the web.config. The hard way, setup build and publish scripts to copy the configuration file into the bin folder of your web application. How to do this greatly depends on your build and deployment process.

virusstorm 20-Aug-15 10:28am View

Can you clarify what you mean by "transfer"? Are trying to copy data to another server so you have two servers with the same data or are you simply trying to move the database to another server?

virusstorm 20-Aug-15 6:55am View

Now I understand your problem. Give me a few minutes to type up the solution.

virusstorm 20-Aug-15 6:40am View

http://lmgtfy.com/?q=.NET+MVC+Repository+Pattern

virusstorm 20-Aug-15 6:38am View

Setting that to false will not give you the details you are looking for.

Did you wrap your database operation in a try/catch and log the message so you can see what the true error is?

virusstorm 20-Aug-15 6:37am View

Have you tried running SQL Profiler to make sure you are connecting to the correct server and database?

virusstorm 20-Aug-15 6:09am View

So this is the exception details from the client side, correct? I would suggest wrapping your database call on the server side in a try/catch and log the exception that takes place. Unless you setup fault exceptions correctly in WCF, you tend to loose a lot of underlying details for security reasons.

virusstorm 19-Aug-15 20:32pm View

Microsoft XPS Printer -> http://windows.microsoft.com/en-us/windows/print-to-xps-document-writer#1TC=windows-7

virusstorm 19-Aug-15 20:31pm View

We need more details. There should be an inner exception or a stack trace in the event viewer which has more details.

virusstorm 19-Aug-15 20:27pm View

I believe you are seeing a hidden file. Depending on the version of Windows, there are two types of hidden files; hidden files and system files. If you run this code below, it will tell you what the file is.

var files = Directory.GetFiles(@"C:\Users\William\Documents\H\");

foreach(var file in files)
{
Console.WriteLine(file);
}

virusstorm 19-Aug-15 20:11pm View

What kind of projects are the other two (class library, console, etc.)?

virusstorm 13-Aug-15 10:05am View

That is because the domain's group policy overrides the local policy. So when you disconnected from the domain, you were using the local policy.

virusstorm 12-Aug-15 13:10pm View

Talk to your instructor.

virusstorm 12-Aug-15 13:05pm View

First, this site is meant for professionals that are having issues. This site isn't meant for students to get answers to their homework. You should be talking to the instructor for your class if you need help.

Second, there is no error, your program is running fine. Your program writes the value to the console window and then terminates. There are no additional instructions after your switch statement.

virusstorm 12-Aug-15 12:57pm View

The namespace name makes this seem like a homework assignment.

virusstorm 12-Aug-15 12:45pm View

What tool window are you referring to?

virusstorm 12-Aug-15 12:44pm View

Have you looked at the Task Parallelism Library?

https://msdn.microsoft.com/en-us/library/dd537609%28v=vs.110%29.aspx

virusstorm 12-Aug-15 12:41pm View

No one here will help you with your homework. It is designed to be challenging so you can learn something. As a part time college professor, my advice is to talk to the instructor of the class.

Also, if you are horrible with coding, why are taking a programming class?

virusstorm 11-Aug-15 12:32pm View

That is a Mozilla only feature
https://developer.mozilla.org/en-US/docs/Web/API/NavigatorOnLine/onLine

But I still don't understand why you need this? I only ask because I might be able offer a better approach if know what the need is.

virusstorm 11-Aug-15 11:43am View

I think you are over complicating things. I would look at using a distributed source control system like Git. You can setup schedules and scripts that will pull code and execute builds as needed. Trying to manually copy things between the servers will cause headaches and nightmares.

http://betterexplained.com/articles/a-visual-guide-to-version-control/

virusstorm 11-Aug-15 11:39am View

Make sure you hit "Reply" to the user's comment otherwise they won't see your post.

If the internet connection goes down, the browser will tell the user the page is unavailable if they try to navigate away from it. If you have any Ajax type calls being made, the call will simply timeout and exception will get raised in your JavaScript.

What is your goal by setting a flag or wanting to redirect them to the logout page?

virusstorm 11-Aug-15 11:34am View

If I understand this correctly, you want JavaScript that execute a method inside a Windows Form application that is running on your local computer? This opens up a lot of security issues, you might want to rethink your solution.

virusstorm 11-Aug-15 11:31am View

What exactly is your issue?

virusstorm 11-Aug-15 7:38am View

First, make sure that the runtime you installed is the same version you are referencing. Microsoft has many versions of this viewer as they have patched and made improvements.

One last thing I would try is locate the DLL reference in your solution explorer. Right click on the assembly and click properties. Make sure "Copy Local" is set to true. This will ensure that when your application gets deployed, the DLL will exist in the bin folder and your application will load.

The only time you need to really worry about the GAC on the web server is when the DLL is used amongst multiple websites on the server or you have sub applications that need to use different versions of the same library.

virusstorm 2-Aug-15 14:55pm View

SignalR actually uses several different technologies, depending on what the client can support, to achieve push notifications. It would take far too long to explain then what was available here. The link I gave you does have a pretty good tutorial to get it working. There are also several books out on it. My suggestion would be look at the tutorial and build a small prototype and if meets your needs, invest in one of the books.

virusstorm 30-Jul-15 13:39pm View

Can you define session?

virusstorm 30-Jul-15 13:21pm View

Are you trying to backup the database from within your solution, no applications running or by launching an application in the solution and click the button to backup the database?

virusstorm 30-Jul-15 12:59pm View

Client/Server communications in Silverlight should be done using WCF. You should not be passing a Stream object directly to the server.

virusstorm 30-Jul-15 12:57pm View

How are you executing this script? You say C# in SQL, but there are many ways this can occur. To solve your error, you can't run the "ALTER TABLE" and then execute a stored procedure, they need to be separate calls. To achieve this in Management Studio, we use the "GO" keyword. This might solve your issue, but it will depend on how you are actually executing the SQL.

virusstorm 30-Jul-15 12:54pm View

If you are using .NET platform, take a look at SignalR
http://www.asp.net/signalr

virusstorm 30-Jul-15 12:31pm View

No one on this site is going to give you the "procedure". Both services are well documented and provide a great deal of code examples. If you are stuck on something specific, please post a question about that.

virusstorm 30-Jul-15 12:30pm View

Is your webpage serving up ad content? It honestly sounds like their computer is infected with malware.

virusstorm 24-Jul-15 11:50am View

If you actually Google "linq left join", the first link is the MSDN article that walks you through it.

Just out of curiosity, does your requirement actually say "do a left join in linq to find invalid records"?

virusstorm 23-Jul-15 10:50am View

Can you clarify what you mean by "expose it's methods through port forwarded internet router"?

virusstorm 22-Jul-15 12:09pm View

Have you looked at using OData? I believe this will solve your issue.

virusstorm 21-Jul-15 11:12am View

Is there a reason why you can't use a "JOIN"?

virusstorm 14-Jul-15 18:28pm View

All depends on what your application does. This is a very vague question. You will need to be more specific.

virusstorm 10-Jul-15 13:10pm View

Just making sure I understand the issue. So in VS2008, when you export the report to Excel, the equation is in the excel file. The cell in question would have a value like this "=(A1 + B2) - C3".

When you export it using VS2013, the cell in question has a value of "123" instead of the equation.

Am I describing the problem right?

virusstorm 10-Jul-15 12:22pm View

Where and how are you assigning this equation?

virusstorm 10-Jul-15 12:19pm View

Your question does not make any sense. Can you explain what your are doing and what the end goal is?

virusstorm 10-Jul-15 7:56am View

I'm curious about what you are trying to achieve. What is the goal of having two applications read from a single queue?

virusstorm 10-Jul-15 7:54am View

Can you clarify what you mean by "apply roles from SQL"? This is very vague.

virusstorm 10-Jul-15 7:53am View

What exactly are you trying to do?

virusstorm 10-Jul-15 7:39am View

Find out what version of Entity Framework you are using. Easiest way is to right click on the reference in your project and select "Properties". The version number is critical as that will dictate the solution that you can use.

virusstorm 9-Jul-15 13:18pm View

What version of EF are you using?

virusstorm 9-Jul-15 12:10pm View

Make sure you have added reference to the System.Data.Entity.dll
https://msdn.microsoft.com/en-us/library/system.data.entitystate%28v=vs.110%29.aspx

virusstorm 7-Jul-15 14:44pm View

Basically, you need to parse the XML document, either by using the solution I gave or by using Sergey's solution, find your node, extract the value and assign it to the text box. There are a lot of examples here, give it a try and if you are running into a new problem, post a new question.

virusstorm 7-Jul-15 14:42pm View

+5I use the XMLReader on any file where I don't know what the size will be or if the file size is over a few megabytes. The solution I gave was more in reply to the user's comment to RyanDev. I think this user is still struggling with all of this based on some of the comments.

virusstorm 7-Jul-15 13:47pm View

Where exactly are you getting this error?

virusstorm 7-Jul-15 13:42pm View

Are you trying to implement the AES algorithm your self or are you just trying to understand how it works?

virusstorm 7-Jul-15 11:59am View

I'm assuming you want to perform a unit test and need to be able to simulate a FileInfo class. To do this, you need use a mocking framework. I personally like to use Moq (available on NuGet). Take a look at this thread:

http://stackoverflow.com/questions/10177363/mock-concrete-fileinfo-object

virusstorm 7-Jul-15 11:54am View

Make sure you reply to the person's comment so they know there is a response waiting.

Did you try exactly what is in the article that Wes Aday provided?

virusstorm 7-Jul-15 8:35am View

Refer to my first issue then. Either way, profiling will help you find the root cause.

virusstorm 7-Jul-15 7:46am View

Are you trying to use URL rewrite to simulate a single page application?

virusstorm 6-Jul-15 17:58pm View

Looking at your code, I'm not sure how the variable "results" will ever have the the values you are looking for. Try going to http://regexlib.com and input your RegEx and your tmpURL there. You will find that your RegEx isn't working or you are not supplying enough information in your tmpURL.

virusstorm 6-Jul-15 17:46pm View

First, JavaScript isn't a program per say. It doesn't compiled down to a traditional executable (there are some tools out there that will let you do this). It is a run time language that the browser interprets and executes commands based on it. If you are looking to write an actual program and not a web application, you will want to look at a language like C# or VB.NET.

If you are looking to build a web application, try this link out:
http://codetheory.in/parse-read-excel-files-xls-xlsx-javascript/

A few other tips, Google is your friend. Try typing various phrases of what you are trying to accomplish into the search engine and see what comes back. You will be shocked to find how often you don't find something related to what you are looking for.

Happy coding!

virusstorm 6-Jul-15 17:28pm View

I'm not sure what your issue is. Your WCF project produces an assembly which has your WCF service in it. You simply need to use Ngen.exe on that assembly.

virusstorm 6-Jul-15 17:12pm View

You need to explain to us what your code is doing and what issue or error you are running into. We need more details to better understand what your issue is.

virusstorm 6-Jul-15 17:08pm View

What do you mean by "storyboard"? Your question is rather vague.

virusstorm 6-Jul-15 15:09pm View

Your best option is to use a BackgroundWorker with call backs. It isn't documented very well but the async and await keywords do not work well with console applications. I was at a conference last year and a Microsoft MVP demonstrated the problems with it. A lot of it has to deal with how .NET pipes messages to the console window.

virusstorm 3-Jul-15 19:16pm View

Is it always fixed as a 4x3 table?

virusstorm 2-Jul-15 13:52pm View

How are you opening the database connection? Do you get an exception? Your "database closed" comment does not make a lot of sense.

virusstorm 2-Jul-15 13:51pm View

Take a look at this thread:
http://www.codeproject.com/Questions/189082/Is-there-any-word-viewer-plugin-available-for-NET

There are controls out there that will let you do what you want, but you might have to merge a lot of controls or technologies together to achieve your end goal.

virusstorm 2-Jul-15 13:48pm View

All of your insert, update, and delete commands would be in a stored procedure. So your clients and applications would all use the procedures and inside those procedures, you would have the SQL that would update the tables in the affected databases.

Save the stored procedure option as a last resort. Take some time and seriously investigate SQL Server Replication technologies and SQL Server Integration Services. These tools are way more reliable then a stored procedure.

virusstorm 2-Jul-15 12:46pm View

I can give you some sample code to do this. Give me about an hour to put something together and I'll post it as a solution.

virusstorm 2-Jul-15 12:31pm View

Do you need to do this via SQL? Could you simply parse the file using something like C# or VB.NET and search the table that way?

The OPENROWSET wasn't really designed for what you are trying to do in this example.

virusstorm 2-Jul-15 10:39am View

The tree examples you provided, are they the only acceptable inputs? You say all kinds of inputs, but you need to specify the boundaries.

virusstorm 2-Jul-15 10:38am View

Are you trying to build a way or are you looking for a tool? A proxy server or firewall will blow any traffic you specify.

virusstorm 2-Jul-15 10:35am View

Are you trying to pass a temporary table into a stored procedure?

virusstorm 2-Jul-15 10:33am View

So this is doable, you will need to use dynamic SQL to achieve this, but I have to ask why on earth would you need to do this? The solution can quickly grow out of control and cause a great deal of issues. Assuming your table is only four columns, after 30 rows you are returning 120 columns!

virusstorm 2-Jul-15 10:25am View

We can't help you unless you provide a lot more details. What does your database look like? How are you saving the invoices? Explain to us what your problem is.

virusstorm 1-Jul-15 14:29pm View

Can you define "actions" a little more?

virusstorm 1-Jul-15 14:28pm View

Does it error only from the stored procedure or does it error when you try to manually run the SQL that is generated?

virusstorm 1-Jul-15 10:23am View

For this, try debugging it with Fiddler. It will capture all of your requests and responses in better detail (I think) then the IE Network Tools.

virusstorm 1-Jul-15 10:21am View

I'm not sure I follow what your issue is. As long as the value can be parsed by DateTime, all you need to do is format it to the desired style.

virusstorm 1-Jul-15 10:19am View

You can, but you need to add activity for every table which obviously isn't ideal. You do have a few other options. To point you in the right direction, I need to know if the dev database is used for active development or this is purely to copy down test data for developers to debug with. I won't want to give a technique that messes up your development and deployment process.

virusstorm 1-Jul-15 10:08am View

What are you trying to accomplish using PowerCLI? VMware does have services and other APIs that you can use with C#.

virusstorm 1-Jul-15 8:06am View

If you are showing the "trimmed" version, then it sounds like we missing something and the problem may not be in segment you posted.

virusstorm 1-Jul-15 7:54am View

How big of a file are we talking? I'm wondering if your issue is the FileStream object hasn't finished flushing the stream to disk. I noticed that you always use the same file name. I don't recommend this as two users making the same request will generate an error for one of them. Every time the button is clicked, generate a unique file name (a Guid is quick and easy). To clean up the files, if needed, simply add a clean up routine that looks for old files safe to delete or write a service that keeps the directory clean.

virusstorm 1-Jul-15 7:47am View

Can you provide the URL you are using? You can mask the domain name for security reasons.

virusstorm 1-Jul-15 7:45am View

They are libraries that are other open source or commercial that provide ways to interact with Microsoft Office files. Google each one, compare the pros and cons to your situation and select one. They all have sample code to show you how to work with the files and the commercial products usually have a trial so you can see if it will work for your needs.

virusstorm 1-Jul-15 7:35am View

There are lots of ways. Stored procedures are still an option, but ideally, you should take a look at SQL Server Replication. SQL Server has built in tools and technologies to keep multiple databases in sync with each other. If the databases are not an exact copy (in both data and structure), you could also look at using SQL Server Integration Services (SSIS).

virusstorm 30-Jun-15 15:03pm View

Do you mean IntelliSense?

virusstorm 30-Jun-15 15:02pm View

What version of EF are you using?

virusstorm 30-Jun-15 14:41pm View

Your best bet is to have your clients do their operations async.

https://msdn.microsoft.com/en-us/library/ms730059%28v=vs.110%29.aspx

virusstorm 30-Jun-15 12:49pm View

I'm trying to understand your exact problem here. Are you trying to develop an application to allow you to view and edit a Word document in a web browser? Further more, you don't want the solution to depend on SharePoint, correct?

virusstorm 30-Jun-15 12:31pm View

+5

virusstorm 30-Jun-15 12:28pm View

C# is not a front end language, it is the backend language. To do what you are looking for, you need to use JavaScript, Silverlight, or Flash. A language that is designed to run in the browser. JavaScript would be your best bet in my opinion. There are lot of frameworks, like JQuery and Angular to name two, that will allow you do such actions. I don't know of any good solutions out of the box that can help you. You may need to do a great deal of reading and piece things together on your own.

virusstorm 30-Jun-15 12:24pm View

How is _sOAPNoteRepository defined?

virusstorm 30-Jun-15 12:23pm View

This is a fun one I've run into many times and it is pain to debug. Take a close look at all of the child controls, specifically inside your control's constructor or load event. If you are doing any action that requires an object to exist, but won't until run time, you will get this error. Take a look at using this:
DesignerProperties.GetIsInDesignMode(this)

virusstorm 30-Jun-15 12:19pm View

Your issue is your static delegate. Because it is static, it exists once on the heap inside .NET. All of the clients that subscribe to it will be notified. To offer a suggestion on how to fix it, I need a better understanding of what you are trying to do.

virusstorm 30-Jun-15 11:48am View

SharePoint is a very large application, what data are you trying to read and write? Also, what version of SharePoint are you using? This is very important as not all editions of SharePoint support REST services.

virusstorm 30-Jun-15 11:47am View

How are you packaging everything into the installer?

All of the installers I know of perform a checksum or hash on all of the files it will deploy. If anyone one of those files is touched after the installer was built, it will throw an error, like the one you are seeing, for security reasons. One of the files the installer wants to deploy has modified in some way between the time you made the installer and the time the installer tried to use it.

virusstorm 30-Jun-15 11:43am View

I don't believe BCP was meant to import from Excel. Ideally, you should be using SQL Server Integration Services (SSIS). There are native components that can access and work Excel with a great deal of ease.

virusstorm 30-Jun-15 11:37am View

Without knowing what your logic is, I can't say if it is doable or not. Depending on what you are trying to achieve, a MERGE statement might give you the functionality you are seeking.

Personally, I would avoid the trigger route at all cost and write stored procedures. Anytime a trigger performs actions on another table, you can get your self into bad race and blocking conditions. We won't even talk about the headaches of trigger recursion. I urge you to strong reconsider using triggers.

virusstorm 25-Jun-15 15:53pm View

I suspect you are running into a security problem. What account is your .NET application running under? When you run it locally, it uses your local account to access the resources. If you didn't change the account the application runs under, the default account will not have the necessary permissions. Take a look at your event viewer on the server that is hosting the application, you should see some additional information.

virusstorm 25-Jun-15 15:41pm View

Instead of using arrays, why not create an object that represents the data in grid? You can bind the grid to this object and I suspect it will be far easier to debug.

virusstorm 25-Jun-15 15:30pm View

The account your code is executing under does not have permission to add user.

virusstorm 25-Jun-15 15:29pm View

Have you looked at their SDK?
https://developer.mozilla.org/en-US/Add-ons/Thunderbird/Building_a_Thunderbird_extension

virusstorm 25-Jun-15 15:25pm View

Have you executed the stored procedure in management studio and verified that it is working as expected?

virusstorm 22-Jun-15 16:41pm View

While that is a solution to the user's problem, you still aren't directly instantiating a Java object inside of C#. That library looks like it is building a proxy to sync or marshal the data to between the two run times. At the heart of it, the Java object doesn't live in the C# world. Depending on what the needs is for it, these types of solutions scare me. The potential for performance problems, buffer overflows, security risks (the list could go on) are huge red flags for me. My personal opinion is that you should build a SOAP or RESTful service to pass data between the two run times.

None the less, still a neat tool for the toolbox.

virusstorm 22-Jun-15 8:43am View

You only option is to write dynamic SQL. Here is a link to get you started working with dynamic SQL on the SQL Server side.
http://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/

If you have really good SQL skills, you can achieve the same thing in code. Keep in mind that anytime you use dynamic SQL, you need to make use of parametrized queries in order to avoid SQL Injection Attacks.

I would also considering upgrading from .NET 2.0 to .NET 4.5 (if you can) and make use of Entity Framework. This will handle such scenarios with less effort on your part.

virusstorm 22-Jun-15 8:39am View

This is not possible. C# and Java work in two completely different fashions that do not work together in any way.

virusstorm 22-Jun-15 8:15am View

Is this a code first or model first approach?

virusstorm 22-Jun-15 8:03am View

Can you clarify if you are using JavaScript or C#? The code example you have here looks more like C#.

virusstorm 22-Jun-15 8:00am View

What data provider are you using? The error is saying that a component could not be located. I've had issues where certain components get deploy to the GAC on my local machine but are not there on a clients machine. The easiest way to resolve this is to right click on the reference and go to properties. In the properties window, for "Copy local", select "Always". This will ensure the DLL is there when you publish.

virusstorm 20-Jun-15 7:53am View

Make sure the target PC has the same version of .NET installed all of the dependencies for application are installed or included in your publish profile.

virusstorm 20-Jun-15 7:50am View

Ignoring the performance problem, what are you trying to distribute? On a personal computer, you can setup separate processes to mimic the distribution. If you need the full stack (hardware, OS, application), then you need some sort of software to run virtual machines. Which software greatly depends on what you are trying to accomplish.

virusstorm 19-Jun-15 13:48pm View

There may be another option. If this is a .NET application and you are unable to get the source code, for what ever reason, then you could try to decompile it. There are many tools out there that allow you to this.

ILSpy (open source)
Reflector (commercial)
dotPeek (freeware)
JustDecompile (freeware)

These tools could help you recover the source code (or a functional equivalent) that you could use to update the application and stabilize it.

virusstorm 19-Jun-15 12:33pm View

Can you clarify what is not work?

virusstorm 19-Jun-15 12:17pm View

First, your "time" column should be a "DATEIME" type, not a string.

Second, can you provide some sample data of your table will have and what output you need? I'm not sure I follow what you are trying to count.

virusstorm 19-Jun-15 12:11pm View

We need to clarify the exact edition you are using. You mention that you are using enterprise, which has a database size limit of 524,272TB. If you are using SQL Server 2008R2 Express, that has a limitation of 10GB.

virusstorm 19-Jun-15 11:23am View

Look in the bin folder of your ASP.NET application. There will be a DLL with the name of the web application. This has all of the complied code for your web application and ILSpy will have no issues reading it. I just did this two months ago for a rogue production application we didn't have source code to. :)

virusstorm 19-Jun-15 11:17am View

Your best approach will probably be to write a RegEx that will extract the table name from your stored procedure.

I'm hoping you have the procedures in a database project (consider doing so if you don't). You simply need to run your RegEx against the stored procedure files to find all of the tables.

If you don't, you can query the "sys.syscommentsview" for your stored procedure definition. You can write a quick console application that can run your RegEx against the "text" column.

virusstorm 19-Jun-15 10:38am View

Your problem is you are binding 3000 records. This is a lot of data to bind and display. You need to implement paging.

virusstorm 19-Jun-15 9:16am View

It is telling you that line 4 has an unrecognized attribute "type". We would need to see your configuration file in order to help you.

virusstorm 19-Jun-15 8:14am View

My experience with Telerik controls is you should Telerik controls with Telerik Controls. Take a look at this:
http://www.telerik.com/help/sitefinity/developer-manual/radgrid.net2-telerik.webcontrols.gridbuttoncolumn.html

Also, Telerik has excellent support forums and you can create an account for free. You might want to post this question there if you haven't already. They tend to take a day or two, but someone usually gets back to you.

virusstorm 19-Jun-15 7:42am View

Can you post your Telerik RadGrid definition?

virusstorm 19-Jun-15 7:37am View

Looking through your code, I think your issue might be at the database level. I wonder if you are running into a race condition where two calls are made at the exact same time, so the stored procedure call ends up working with the exact same data set. Try wrapping your SQL in a transaction. This would cause a table lock making sure each execution of the stored procedure is working a clean data set.

virusstorm 19-Jun-15 7:24am View

Take a look at this:
http://dba.stackexchange.com/questions/10657/call-a-stored-procedure-from-a-trigger

virusstorm 19-Jun-15 7:22am View

You don't add references to a solution, you add them to a project. I'm trying to understand what project type you are using and how you are getting your error. From what I'm hearing, it sounds like you are not using the SQL I gave you correctly.

virusstorm 18-Jun-15 21:08pm View

Agreed with Ben. You should be using replication for this. Doing this through triggers is going spell lots of trouble for you. Take a look at this MSDN article and let us if you have any questions.

https://msdn.microsoft.com/en-us/library/ms151198%28v=sql.120%29.aspx

virusstorm 18-Jun-15 21:04pm View

What is the project type (database, forms, web, etc.) that is causing the reference error? I don't think we are on the same page.

virusstorm 18-Jun-15 13:29pm View

The IF statement is only if you were in a query window. You have to understand out the SQL Server Data Tools (SSDT) works behind the scenes. Under the hood, the tool is building a model of your database. It uses this model to resolve references and compare your model to a target database for deployment/publishing purposes. When you throw extra statements like the IF in front of a CREATE statement, the tool doesn't understand what you are trying to do. The whole point of that IF statement is to ensure that the stored procedure doesn't exist. In Visual Studio, SSDT is taking care of this for us, so we don't need it.

virusstorm 18-Jun-15 13:23pm View

What are you trying to do?

virusstorm 18-Jun-15 13:19pm View

Take a look at this:
http://raynux.com/blog/2008/03/12/a-c-program-to-add-two-large-number/

virusstorm 18-Jun-15 13:14pm View

This will do the trick for you:
http://sqlserverselect.blogspot.com/2012/08/ssdt-unresolved-reference-to-object.html

virusstorm 18-Jun-15 13:12pm View

I need to throw out a disclaimer first. This is design will lead to a great deal of trouble long term. First recommendation is not do this at the database level, but in the business layer of your application. If you can't do that, I would use a stored procedure. Lastly, and only as a last resort, I would use a trigger.

With the disclaimer out of the way, I need to know if these databases are on the same server and will always live on the same server.

virusstorm 18-Jun-15 13:01pm View

Are you doing this inside a SQL Server Database Project? If so, what version of Visual Studio are you using?

virusstorm 18-Jun-15 8:43am View

What version of .NET are you using?

virusstorm 18-Jun-15 7:35am View

Take a look at this tutorial:
http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/

The "IF EXISTS" part is to make sure the stored procedure doesn't exist, other wise you would have to replace the "CREATE PROCEDURE" with "ALTER PROCEDURE".

The "AUTHORIZATION" keyword simply says who owns the schema. I usually do "dbo" so that the owners of that schema also own the new schema.

virusstorm 16-Jun-15 17:33pm View

+5

virusstorm 16-Jun-15 17:22pm View

Your printer driver is most likely not a 64-bit driver, thus you will not be able to print on a 64-bit system.

virusstorm 16-Jun-15 17:19pm View

Why not just try it and see if it works?

virusstorm 16-Jun-15 17:16pm View

It is a huge miss conception that you cannot debug a published web application. In reality, you can. Take a look at this:
https://msdn.microsoft.com/en-us/library/233w9kd4.aspx

virusstorm 16-Jun-15 17:06pm View

Deleted

The answer to this is very subject and person dependent. You might want to pose this question in the discussion forums.

virusstorm 16-Jun-15 14:45pm View

What login are you referring to?

virusstorm 16-Jun-15 14:42pm View

Can you provide any code to help us understand what you trying to accomplish?

virusstorm 16-Jun-15 14:41pm View

Typically, people that do this are trying to do something like this are usually doing something illegal.

virusstorm 16-Jun-15 14:30pm View

I don't do a great deal of Java development, but if you Google "java read excel file", you should find something that will get you going.

virusstorm 16-Jun-15 14:29pm View

I have used Crystal Reports in a long time, but I think it has the same limitation. I suggest either change your approach or update your question to better reflect what you doing, bind a Crystal Report to two result sets from a stored procedure.

virusstorm 16-Jun-15 14:18pm View

You will need to upload the file to the server and read the data out of the file. What language are you using?

virusstorm 16-Jun-15 14:00pm View

If you are using SQL Server Reporting Services, then what you are trying to do is not possible. Your only option would be to add your second statement as part of the column list in the first select. All of the rows would then have that value and you bind the report to the first row of the result set. This could have undesired effects if the report is empty.

virusstorm 16-Jun-15 13:50pm View

I'm having trouble following you on that. What do you mean store the second select statement in a parameter? How do you plan on accessing/consuming this value?

virusstorm 16-Jun-15 13:23pm View

Do you me two (2) results?

virusstorm 16-Jun-15 13:22pm View

Can you clarify "not storing"? Do you get an error message or is the data simply not making it into the database?

virusstorm 16-Jun-15 12:03pm View

I'm having a hard time understanding your problem, but if I'm reading everything correctly, the variable @msg doesn't have all the data from @Stringarray.

If that is correct, I believe simply changing this:
SELECT CONCAT(@msg, @valu) INTO msg;
To this:
SET @msg = CONCAT(@msg, @valu);

virusstorm 16-Jun-15 11:56am View

I'm not sure I'm following what your issue is.

virusstorm 16-Jun-15 11:55am View

This is very general error that is often very confusing and misleading. Typically when I get that error, it is usually the wrong password, wrong format of the certificate, or you didn't have access to the store or it doesn't exist.

virusstorm 16-Jun-15 11:51am View

Can you provide some table structures? When you say "classic solution", this is how all relational database work. Just because you use a column in a "WHERE" clause does not mean you need an index. There are also other techniques to include additional column information with an index so your query's performance doesn't suffer.

Also, the way you describe the other criteria that could be used, this makes me wonder how your tables are designed and if they are properly normalized.

I have built many systems that use "dynamic criteria", as we'll call this, and never once ran into performance problem that we could not resolve with proper database design, optimized queries, and physical architecture that could scale. This was all done with the "classical solution".

My suggestion is to build a proof of concept of your service (not go too crazy with elaborate design) and fill it with the amount of data you suspect you will have. Then run performance tests against it, you might be surprised just how much it can actually handle, but keep in mind the hardware you are using for test vs your production hardware.

virusstorm 16-Jun-15 11:41am View

Are you trying to email someone the results of your tests that you executed in Test Explorer?

virusstorm 16-Jun-15 11:40am View

What you are attempting to do goes way beyond what the TPL (maybe even C# all together) was built for. The library is designed to scale it self across the available logical processors. The CPU usage will always spike to 100% when you use this library. The better question here is to ask, why do you need to stop all your tasks when the utilization hits 100%? Do you need to allow another process to take higher priority? Now we are taking task scheduling and process affinity.

virusstorm 16-Jun-15 11:31am View

I'm not sure I follow what your issue is, but if you need to change the SQL server you are using, simply replace "sajid-pc" for the "Data Source" attribute of the connection string with the desired SQL Server IP or name.

Check out this for more details:
https://www.connectionstrings.com/sql-server/

virusstorm 12-Jun-15 16:31pm View

Understood.

So your issue is actually self explanatory. Your "adapter" object that you are passing into SqlCommandBuilder is null. You never actually instantiated or set it to value.

Looking your code, there is a sequence that needs to take place. You need to for "adapter" to have a value. The value in "comboBox1" needs to change in order for the correct event to fire to set the value. I see bigger problems with your code, however. What is the goal you are trying to achieve? I might be able to put together a better prototype for you that could put you a better path.

virusstorm 12-Jun-15 16:19pm View

Which statement? We are willing to help, but you got to be able to describe the problem in detail.

virusstorm 12-Jun-15 14:54pm View

What is your exception?

virusstorm 12-Jun-15 14:50pm View

You might be better off at using a framework designed for such things. Have you look at using Bootstrap CSS? It is an open source CSS framework with a lot of cross browser compatibility built into it.

virusstorm 12-Jun-15 14:48pm View

Take a look at this open source project:
http://trotinet.sourceforge.net/

That should help to give you a starting point.

virusstorm 12-Jun-15 14:22pm View

I think you are looking down the wrong path. Your error message says it can't load an SAP assembly or one of it dependencies. I don't believe MVC is your problem, I believe you are missing a reference.

virusstorm 12-Jun-15 14:19pm View

You need to post more code for us to help you. How is the code you posted being executed?

virusstorm 12-Jun-15 14:01pm View

Simple answer, don't use a DataTable. The DataTable object was not designed to do what you are doing. I'm having a hard time following the code you posted, so I'm going to make a few assumptions here in hopes it helps you.

First, I'm assuming that every record in the table represents an entity. My first action would be to create an object that represents that entity. I would then write a validation method for the entity so that it can verify it is in the proper state. You can have it set a flag so you know it is or is not clean. From there, you can use the .NET parallel libraries to to attempt to speed up processing. Please not that this library attempts to scale the operation based on the system's resources. A system with a single core won't see an performance increase like that of a quad core. Even then, depending on the operations, you aren't guaranteed a performance increase.

virusstorm 12-Jun-15 13:58pm View

First, with the relationship now showing, can you clarify that a little bit or provide some code to show what is missing?

Second, you will need the EntityFramework.dll added to the other project. There are extensions to the System.Data.Entity.dll in that library that Entity Framework needs.

virusstorm 12-Jun-15 13:54pm View

What is your problem?

virusstorm 12-Jun-15 13:49pm View

I suggest contacting the vendor that makes VERACODE and ask them what it means. It could be a case of a false positive because of the way you are building the connection string.

virusstorm 12-Jun-15 13:45pm View

You may want to look at another option. SQL Compact is no longer supported by Microsoft. With SQL Server 2012, they introduced a new concept called LocalDb. Take a look at this: https://msdn.microsoft.com/en-us/library/hh510202.aspx

virusstorm 12-Jun-15 13:43pm View

An IDENTITY column would also do the trick.

http://www.sqlteam.com/article/understanding-identity-columns

virusstorm 12-Jun-15 12:40pm View

While there is nothing wrong with your approach, you find that debugging your service may get difficult. From what I see in your code example, you have made a very dynamic solution which has its pros and cons. Another con you will run into is the structure KeyValuePair will result in a complex JSON object which can make it harder to consume.

My personal recommendation is to make your RESTful service action specific. For example, if you have a procedure that gets and entity, you would want something like this:
"json/{entity}/{id}" to get by Id
"json/{entity}/{name"} to get by name

The idea of RESTful service is to allow clients to consume and send data without the need for a WSDL or proxy class.

virusstorm 12-Jun-15 12:30pm View

Wes Aday is right, use the C# implementation of Bouncy Castle. Your verification should not fail. While the code to do the action is different between C# and Java, the algorithm it uses to perform the action is identical.

virusstorm 12-Jun-15 12:24pm View

I would suggest looking at implementing an MVVM pattern. Take a look at this article, it might help give you a starting point.

http://www.codeproject.com/Articles/364485/MVVM-Model-View-ViewModel-Patte

virusstorm 22-May-15 13:50pm View

See if this helps:
https://technet.microsoft.com/en-us/magazine/2008.08.pulse.aspx

virusstorm 22-May-15 13:46pm View

What you are asking for is no simple task.

Take a look at this link:
http://www.codeproject.com/Articles/90143/Mapping-Network-Drive-using-C

And this thread:
http://www.codeproject.com/Questions/524048/ReadplustheplusXMLplususingplusXElementplusinplusC

If you are running into specific issues, let us know and we can try to help.

virusstorm 22-May-15 13:40pm View

Those are for VS 2012 & VS 2013, you are using VS 2010.

virusstorm 22-May-15 13:39pm View

What is your question?

Comments by virusstorm (Top 200 by date)