maverick_majnoo's Q&A profile

• Visual Studio Tools for Office Cached Data from Website to Word Doc

  Hello, I am having an issue with cached data in a Word document that is getting setup by a web page, but it only has an issue on the web server. I have a word document report that is being triggered to open from a web page and it is auto populating based on cached data and a web service. The code is very similar to the Benefits Registration Sample:http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOBenefitsRegistration.asp When I run the code locally, the cached data is populated correctly and the report generates fine. When I deploy it to the server, the cached data is coming up null. I have coded around the null and found that the document is running correctly and generating the report data co ...Show All

• SQL Server OLE DB Destination

  I am proceesing a file and using a OLE Db destination for inserting the rows present into a file to the table. As of now OLE db destination points to the table and having the fileds mapping of input column and destination column. now i want to perform some calculation and want insert the rows into table based on the value of some other column for ex. if (column2 == 1) { column1 = column4 - column5 } if (column3== 1) { column1 = column4 - Column6 } Please let me know how to do this. I want to implement all this four condition in one derived column expression. if (Column1== 1) { OutputColumn = ColumnA- Column1RATE } if (Column2 == 1) { OUtpu ...Show All

• Visual Studio 2008 (Pre-release) Popup

  Hi, How do you make a PopUp follow the form when the form is dragged Thank you, Jaco if you have a handle on the control and a handle on the grid, you can use TranslatePoint. e.g., Point pt = ctl.TranslatePoint( new Point(0,0), grid ); will give you the upper-left corner of the control relative to the upper-left corner of the grid. ...Show All

• Visual Studio Tools for Office Adding Dynamic Data points to the Excel at runtime.

  Hi All, I want to develop a VSTO - Excel based application Which, will have dynamic data points.I want to have data points and related data based on customer selection. Pls suggest me how to approach for this kind of application design. Regards, Uma Kadagi. Hi Im not sure I understand dynamic data points in this context. If you are referring to data which is being linked to the database, I would strongly urge you to have a look at Data Binding in VSTO. Hope this helps! Thanks, Nikhil ...Show All

• SQL Server Better way to filter dimension members?

  I have a dimension hierarchy that has several thousand members (it's a geographical one). We often times want to answer questions for a particular city or zip code in the hierarchy - has anyone found a better filtration mechanism in either BI studio's OLAP browser or Excel 2007 Basically, I'd love to just type "Seattle" or "Seattle, WA" and have it choose the Seattle geographical member (instead of navigating the full hierarchy to select it). Better design practice in case of having hierarchy containing many members is pretty simple, but is not often simple to implement. Unfortunately there arent that many alternatives. Anyhow. You need to try and create additional levels in your hierarchy so your user ...Show All

• .NET Development HttpWebRequest.GetResponse gives HTTP 502 error in Framework 2.0

  When trying to access a URL on a remote server over a VPN, HttpWebRequest.GetResponse throws System.Net.WebException: The remote server returned an error: (502) Bad Gateway. The same application runs fine in Framework 1.1. Any ideas Sounds like your proxy settings for the VPN are either wrong or getting picked up incorrectly. V2.0 also supports auto proxy detection which v1.1 did not. It could be a problem with automatic detection of the proxy on the vpn connection too. Can you try disabling auto proxy detection in your Internet Explorer connection settings Also, can you get a network sniff of your V1.1 app and your V2.0 app for comparison If you don't know how to use a network sniffer ( ...Show All

• Smart Device Development Is there any Microsoft product for In-Memory Database System?

  Is there any Microsoft product for In-Memory Database System like Oracle's TimesTen database System.Data.DataSet class is essentially in-memory database. ...Show All

• SQL Server Cursor

  hello; I have an error on the level of declaration of cursor for update: Sqlstate 37000: the clause update is authorized only for DECLARE CUSOR. which is the solution I don't know French, but did you declare your cursor FOR UPDATE If you try to update columns that are not allowed, you will get an error. I can tell you error says something about clause UPDATE. Also make sure that your syntax is correct on the cursor. http://msdn.microsoft.com/library/default.asp url=/library/en-us/tsqlref/ts_de-dz_31yq.asp ...Show All

• SQL Server SQL Server 2005; Unique Constraint, Covering Index Question

  Hi, When I create a unique constraint, SQL Server automatically creates an index on this constraint. So when I run the following... ALTER TABLE PersonsProjects WITH NOCHECK ADD CONSTRAINT NoDupes UNIQUE NONCLUSTERED (PersonID, ProjectID) ...SQL Server will create a composite index on PersonsProjects called NoDupes on PersonIDand ProjectID. Thing is, I need this index to include a third column Status since most queries use this column in conjunction with PersonID and ProjectID. If there was no index on this table, I would have created it as follows: CREATE UNIQUE INDEX NoDupes ON PersonsProjects (PersonID, ProjectID) INCLUDE (Status) WITH IGNORE_DUP_KEY But this won't enforce the unique constraint on PersonID and ProjectID wh ...Show All

• .NET Development sql problem inc#

  INSERT SomeOtherTable (SomeColumn) SELECT SomeColumn FROM SomeTable I want to take the data from one field in table 1 and insert it into a field in table2 in c#. So Database1.InsertCommand = "INSERT INTO TABLE2 (field1) VALUES (@ then I loose it there Following should help you http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson03.aspx ...Show All

• Visual Studio Team System FxCop spell checking and Office 2007

  Its seems that spell checking is not running even when Office 2007 is installed with proofing options enabled... I tried several misspelling in a sample code and FxCop did not notice it. Is it a compatibility problem between FxCop 1.35 and Office 2007 or is there something special to do to enable the feature Unfortunately, Office 2007 does not redistribute the English spellers that FxCop requires. The next version of FxCop will redistribute these spellers, thereby reducing the need to have Office installed to get the spelling rule working. ...Show All

• Visual Studio Team System Client side installations required for Custom Controls.

  Hi, I am planning to create a custom control. I have installed " Visual Studio 2005 Team Foundation Server SP1 " at my server. I would like to know if I need to do any client side installations, for my custom controls to work. I have confusion on whether I should install the Service Pack for Visual Studio " Visual Studio 2005 SP1 " at client machines, for the custom controls to work. Please clarify. Thanks, Laxmi. ...Show All

• .NET Development Is it possible to get method's parameter values in runtime?

  Hi all. I want to get method parameter's value in runtime. It's for debugging and error handlering purpose. How can I implement GetMethodValue() method below System . Reflection . ParameterInfo contains meta data not value of param. Is it possible or not Please help me with any comment. private void Test( string s, int i) { object[] values = GetGetMethodValue(); //values[0] is value of string s //values[1] is value of int i Utils . GetMethodName( 0 ); } public static object[] GetMethodValue() { } public static string GetMethodName( int stepBack) { System . Diagnostics . StackTrace stackTrace = new System . Diagnostics . StackTrace (); //use 1 to return parents method. //us ...Show All

• Software Development for Windows Vista ActivityCondition without "Code Condition"

  Hello, everybody. I've got a CustomActivity , which has Property of type ActivityCondition. For me it is necessary to edit just Declarative Rule Condition in my designer. How can I remove possibility of editing and selecting Code Condition TIA, Nikolay Unfortunately, I've got the error when I’m trying to visit your link :( " Critical Error: Data Store Unavailable The data store used by Community Server cannot be opened. " ...Show All

• Windows Forms I have to inserting the picturebox in particular DatagridviewCell

  Hi to all I am facing the problem to adding the picturebox control in datagridviewcell in vb.net 2005 please any help me, how to add the picturebox control in datagridview. If any solution please send the information to following email id, plz plz plz plz help me. irshad.don@gmail.com The following post might be useful http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1076886&SiteID=1 ...Show All