Jagan P's Q&A profile

• SQL Server How to Add an event to CRI controls

  Hi all, I am trying to develop a CustomReportItem similar to Matrix control. Is it possible to add some "OnClick" sort of events to a section of this CRI (As a drilldown button of matrix control allows to expand the respective column). Please help me if there can be any solution. Hi Robert, Thanks for ur response I am asking it for runtime. How can I encode the toggle state in parameter values and how will it help to solve my problem Please explain, as I am new to this tool. ...Show All

• Windows Forms String to Formula?

  I have a formula saved as a string, e.g "180/2+15" How can I process this formula to find the result (105) Here is a C# String Parser and Evaluator. ...Show All

• Windows Forms What is the syntax for DataView Filtering using Child Column?

  Hi. Given 2 related tables, parent and child, how would you write DataView Filter using child column. For example, if you have Customer and Order, and you want to find customers whom made orders in April-2006 - How to write a Filter for this I know that you can list the children and then go back to get the parents of each but it seams more natural to use Filter. Thanks for your help. Try changing #01/01/2001# to '01/01/2001' >> dataView.RowFilter = "Child.InvDate >= #01/01/2001#"; ...Show All

• Visual Studio Tools for Office Question re the CRM Integration Add-In Sample For Outlook 2003 (2)

  Earlier on I was questioning the UI/Data separation logic and John Durrant pointed me to the "CRM Integration Add-In Sample" - thankyou it is very useful. There are four custom items in this sample: Accounts, Activities, Opportunities, Contacts. As far as I can see, for each item stored inside an MSSQL database, an item is also created within the default Outlook store. I have deduced this because there is an 'OutlookID' column within each of the database tables. My question is this. What if I wanted to take the data/UI separation one step further for this model for an Outlook 2007 add-in What if I wanted to avoid the synchronisation issue between the Outlook and MSSQL data by saving only to the database. To achieve this I could ov ...Show All

• Visual Studio Team System How do you change Mail Server settings for notifications

  I setup TFS but my mail notifications have never worked. How do I bring up the mail server settings so that 1) I can verify them and 2) I can change them if they were entered incorrectly You can edit Web Services\Services\web.config to change these settings. Here are the ones from my server, for example <add key="emailNotificationFromAddress" value=" jmanning@microsoft.com " /> <add key="smtpServer" value="smtpHost" /> <!-- Optional Alert Settings AlertUseReplyTo: True, False (default: True). Specifies that the ReplyTo property of the email alert should be set. When false, the From property is set. <add key="AlertUseReplyTo" value="T ...Show All

• Windows Forms Performance And certified tests

  Hello all Are there any tools that could test visual studio 2005 windows forms application performence I have some carshes on my clients machine that I suspect occur due to low performance. Plus we need to authorize and test the application as part of the microsoft certified tests. Does any of you known a tool that simulate their test Itzik ...Show All

• Microsoft ISV Community Center Forums Detect visio shape double click

  Hello, i'm currently working on a school project in visio vba. It's about value stream mapping where the shapes (atoms) can have parameters. So I would like to create a parameter form where the user can define the parameter values. This form is triggered when a shape is double clicked. But since there's no such a thing as a standard shape_doubleclick event, how can I detect this event using VBA It's rather urgent, so any help is welcome!   PS I'm using visio 2003 ...Show All

• Software Development for Windows Vista Uninstall a program

  I have searched high and low for the answer to this question I have build 5600 install on my machine. I installed a few programs and with out luck they don't work now the question i have is how to i uninstall them. I go to control panel/programs and features. I click the program i want to uninstall and click uninstall/change. Nothing happenes is this feature disabled or am i doing something wrong (member840) I also have that issue i try to uninstall norton antivirus trial software and it wont let me. can you help me It would not let me get a uninstall tab or change or repair.and I also got a message pecific modul can`t be find. ...Show All

• SQL Server The AcquireConnection method call failed with error code 0xC0202009.

  I've seen the previous threads on this (although maybe not all of them). However, i don't think I'm getting the error for the same reason. The full error I'm getting is: - Pre-execute (Error) Messages Error 0xc0202009: {F1B3B35C-FAE3-48F6-A169-4E4D8D99F9B6}: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "Microsoft JET Database Engine"  Hresult: 0x80004005  Description: "Unspecified error".  (SQL Server Import and Export Wizard)   Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009.  (SQL Server Import and Export Wizard)   Error 0xc004701a: Data Flow Task: ...Show All

• SQL Server Report from prcedure that return multiple recordsets

  Hi there, I am creating a report from a stored procedure that returns multiples record sets. For an example, my stored procedure is as follows CREATE PROCEDURE MYPROCEDURE AS BEGIN SELECT * FROM TABLE1 SELECT * FROM TABLE2 SELECT * FROM TABLE3 END Now lets say I want to create a report that will display the result of the query no 2 (which is SELECT * FROM TABLE2 in this example). How can I do this Is there any way to bind the second record set to the report dataset with out changing the stored procedure I will appreciate any kind of suggestions on this Thanks Moim Moim, Unfortunately, SSRS doesn't support multiple recordsets being returned from ...Show All

• Visual Studio 2008 (Pre-release) Debugging WCF server on Vista RC1 (x64)

  I'm having trouble debugging a WCF server on Vista. It seems that you are not allowed to bind to an adress without elevated privileges, this I fixed (when running *without* a debugger) using e.g http://mark.michaelis.net/Blog/WindowsCommunicationFoundationWithWindowsVistaAndUAC.aspx that is adding a manifest to exe requesting elevated privileges. The problem is, it seems this does not work under the Visual C# (Express) debugger (even though there is a exename.vshost.exe.manifest) with the correct content. I do not get a dialog asking to OK elevated privileges, it just behaves like the the manifest is not there ! ! How do I fix this The thing is, my account has admin privileges, I just don't have them by default. Is this really the pr ...Show All

• Visual Basic Loops and Timers question?

  Hello, Can someone explain why this bit of code won't produce the result expected Private Sub Timer1_Tick( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Dim var1 As Integer = 1 For var1 = 1 To 4 Timer1.Enabled = True PictureBox1.Visible = True PictureBox1.Image = System.Drawing.Image.FromFile _ ( "C:\vb05sbs\chap07\Pic0" & var1 & ".jpg" ) Timer1.Enabled = False Next MsgBox( "Finished" ) End End Sub I was expecting this to display a new picture every couple of seconds until the variable hits 5, but instead I get no picture until the time elapses and then only get picture #4.  Seems weird to me, but I'm sure I'm wron ...Show All

• .NET Development TransactionScope promotes to DTC when connection is reopenned!!

  The transaction scope gets promoted when two or more connection objects gets opened and enlists in the scope. This also applies when using the exact same connection string against a single SQL Server 2005 database to open the connection multiple times within the transaction scope. It is the number of sqlConnObject.Open() calls that count, not the number of connection strings used. How can I solve this !! I can't pass open connections to data access layer methods in order to prevent them from opening and closing new connections. I had the same problem. But I was able to solve it by using DbConnectionScope() class. Refer to http://blogs.msdn.com/dataaccess/archive/2006/02/14/532026.aspx for ...Show All

• Visual Studio Team System Is there a tool to create the Methodology template ?

  I wanna create my own template of a projects or modify others temaplates , is there a tool to do that easily hi there, my team and i have been doing this and unfortunatley there isn't a tool to do this yet that we know of. You can download the extensibility kit for VSTS which has very good documentation on how to do it manually. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mesh Alpha chennal problem?

  Hi All, I tried to draw few meshs in game. But i has some textures problem. The problem is a meshs collistion another mesh, textures alpha chennal has some problem. Below is capture screen. Who can tell me why How to fix this problem http://hk.geocities.com/brian_tsim/error.PNG Best regards, Hi Inaki Ayucar , Sorry, I not very understand how to set alpha ref using c# Can give few example to me Below is my enable alpha test codeing. renderer.Device.RenderState.AlphaTestEnable = true; renderer.Device.RenderState.AlphaFunction = Compare.NotEqual; Best Regards, ...Show All