I was asked about a project that doesnt currently use WCF. Where do I even begin!
The object is to allow the application to make a secure call to a database. I've not the foggiest where to begin.
View Complete Post
I encounter a problem that I cannot solve. I hope to find an answer here. I need a listbox to hide half way when a certain listboxitem is selected. I setup a storyboard with opacity mask animation which work fine in blend. My problem I cannot initiate BeginStoryboard.
I tried numerous ways and no success. I need to hide the listbox to reveal the content behind it. I generate listboxitems from XML data file and based on the name node I planned to initiate storyboard playing.
Here what I have. I created DataTemplate which I set via Setter in ListBoxItem Style:
Sorry for the basic question here but when is it best to create new BEGIN, END, and GO blocks for SQL Statements? In my case, I have a stored procedure that I created, below is a snippet:
I have something like this:
CREATE PROCEDURE p_Test
SET NOCOUNT ON;
INSERT INTO etc, etc
I've created a prototype application which uses WCF and MSMQ to send simple "hello world" messages from a client app to a server app. I was able to get it successfully working on my machine.
However, being a client/server technology, I need to get this prototype working across a network.
So, I got a second PC, installed MSMQ on it and my client application. When I run the client app on this second PC, it does not work correctly. I don't get any run-time exceptions, however, the messages are not received on my server. If I go into my client PC's Computer Management console, I can see the messages in its outgoing queue. So, it appears that the problem is that my client app is not connecting to my server app.
Both machines are on the same domain and can see each other in Windows Explorer. I'm able to copy files back and forth from both PCs. If I execute MessageQueue.GetPrivateQueuesByMachine() on my client PC, I can see my server's queues. I should note that my server's queue is private.
I'm using Visual Studio 2008, .NET 3.5. My server machine is running Windows 7. My client PC is running Windows Server 2003 R2. My binding is netMsmqBinding.
To create my prototype, I am using Michele Bustamante's QueuedServices example from chapter 6 of her &q
I need a way to call a function at begin of execution of the report, and to call another function when execution ends.
I need to connect to SQL to call a stored procedure.
I'm currently trying to optimize my mobile application by consolidating a collection of update and insert statements into a single stored procedure (or transaction) on my mobile device. However, when I issue the SqlCeCommand, I consistently get an
error stating that the first parameter is a mistype (this is a stored procedure). I tried issuing the same command in the SQL CE Query Browser and it would fail in a similiar fashion.
Any tips on how to go about this without making a direct SqlCommand to the main SQL Server 2008 servers? (I'm using replication.)
Why are my query windows now saying "BEGIN TRAN ROLLBACK"? How do I turn that off? I am sure I must of done something to do this, but I know just a few short weeks ago it didn't come up.
I have the following code. The UI thread is blocked by code below when EndAdd gets called. Then what is the advantage of calling a method using Begin and End in example below? Is it that the UI thread does not consume extra resources for calling the new method ? So if the method was called synchronously then the UI thread or the main thread would consume whatever resources would be required by the Add method.
IAsyncRsult result = calculator.BeginAdd(x,y,null,null);
int sum = calculator.EndAdd(result);
I am getting following Error:
Oracle linked server in SQL server 2005 to update tables in Oracle database.
I have used OPENQuery to update tables in Oracle from a SQL Server 2005 Stored procedure.
If we run query from sql management studio for inserting or updating table of linked server then it runs fine. But if we use Begin distributed transaction then its gives error -
Server: Msg 7391, Level 16, State 1, Procedure sp_test, Line 105
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
I installed SSMS ToolPack and now in every query I have it would show
What does these do? Like If I run a select query within them, it runs fine, I didn't try to do anything else. I read online about this a while ago and I remember that you have to set a TRAN for begin part, but I don't know what is the use for these
as they are right now. Any help would be appreciated
I am working on stored procedure and all update statements are inside "BEGIN TRAN" and COMMIT..now i expect if all statement runns succesfully then to return 1 else from catch block it should return error message..
i wrote stored procedure mentioned below ...
when i execute this stored procedure i see three output ..including return value..
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
-- Author: <>
-- Create date: <19 March 2010>
-- Description: <Update FPA_CLAIM_MAN ,FPA_CLAIM_DETAIL ,
ALTER PROCEDURE [dbo].[SP_UpdateFpaByFiAdmin](
-- Add the parameters for the stored procedure here
@COMMENT VARCHAR(1000) = ' ',
@CREDIT VARCHAR(50) ,
@BU_GLCODE VARCHAR(15) ,
@total_bal bigint ,
@STRING_Employee_Limit_distribution VARCHAR(MAX) = '',
@STRING_Employee_FPA_distribution VARCHAR(MAX) = ''
DECLARE @ECODE AS VARCHAR(15)