Vladox's Q&A profile

• Visual Studio Tools for Office Help with PDS communication with project server 2003

  Hi, I am a newbie and just wanted some more information for an excel add-in I am looking to create. The information seems to be out there somewhere but I am haviong trouble finding out exactly what I need. I am to build and excel 2003 add-in that looks at the timesheet information that is submitted by resources into project server. The add-in will then be used to create various reports. My intial idea was to log on remotely to the server and get a copy of the project files (.mpp), save them as xml files and then use this xml information in the add-in. Further investigation allowed me to stumble upon PDS which by my understanding would allow me to add SOAP commands in order to retrieve the xml information without having to create f ...Show All

• Windows Forms Problem with passing data from a form to another

  Hi , I have a .Net 2.0 windows application that requires authentication to proceed. I already set the start form as the MainForm and at the initialization of MainForm, I set the loginForm to show up as loginForm.ShowDialog(). public MainForm() { InitializeComponent(); FormLogin loginForm = new FormLogin(); loginForm.ShowDialog(); } Then, I put the code for user validation inside loginForm. User will press "Login" button. If the user is authentic, loginForm will close and MainForm will show up. The problem now is I want to send to the MainForm the Usertype (Usertype is a field in database, just like Password and Username) once he/she successfully logged in. I know how to retrieve the info from database but have no ide ...Show All

• SQL Server rationale to upgrade from SQL Server 6.5

  While providing more functional assistance to a SME, I came accross an application still run with a SQL Server 6.5...Although the database is small, I would imagine that they could benefit from upgrading to 2000 (or 2005). Especially for security reasons. I would appreciate if you could point to some docs pros/cons of upgrading such old databases. g a b r i e l. metz at club-internet.fr I think the pros are clear, using new features and getting support from microsoft for the product. The cons will be that you will have to test you application on the new platform. Old commands might be no longer supported on the new version (running out of the compatibilty horizon) HTH , Jens K . Suessmeyer . --- http :// www . sql ...Show All

• SQL Server Dynamically determine subtotal visibility in matrix?

  I'm using SSAS2005 SP2 as a data source, and RS2005 SP2 for reporting. With the upgrade to sp2, users assigned to an area in a sales location tree no longer get a value returned for AGGREGATE(MyValue.Value) when looking at a region higher than they are assigned. My MATRIX reports now look like: _______________________________|___|___| Region____Sub Region____Area1__|_5___3_| Sub Region Total_______________|_______| Region Total___________________|_______| Grand Total____________________|_______| Before sp2, they had the 5 and 3 values repeated in all total rows. My thought was to hopefully dynamically hide the sub region and region groupings and their related subtotals - but when trying to do this, only the grand total shows, and ...Show All

• SQL Server SQL Standard setup throws SEHException

  I copied the MSDN setup DVD content to a local drive from USB DVD drive. Started the setup process; accepted the EULA and setup installed the SQL Native Client and Setup Support Files successfully. During System Configuration Checks, the process raises the following dialog: --------------------------- System.Runtime.InteropServices.SEHException: External component has thrown an exception. at System.Windows.Forms.UnsafeNativeMethods.IntCreateWindowEx(Int32 dwExStyle, String lpszClassName, String lpszWindowName, Int32 style, Int32 x, Int32 y, Int32 width, Int32 height, HandleRef hWndParent, HandleRef hMenu, HandleRef hInst, Object pvParam) at System.Windows.Forms.UnsafeNativeMethods.CreateWindowEx(Int32 dwExStyle, String lpsz ...Show All

• Windows Forms drawing lines between controls

  Hi, My problem is,I am placing a usercontrol and on that again I am placing a another small usercontrol on the design surface this is A likewise there is another usercontrol of the sametype placed one above the other let it be B, now my requirement is I have to draw a line connecting the inner usercontrol of A with the inner usercontrol of B . Since there is no line control in C#.net if I use drawline() I am not able to connect these 2 usercontrols. Can anybody tell me a solution for it . Karthik I tried this one,  this works only if there is only one control but it does not work for multiple controls and also with labels you could not draw slanting lines. ...Show All

• Visual FoxPro Error massege: API library is not found when run program?

  Hi all! I use VFP9! My program was compiled to EXE file, but when run from EXE is error massege: "API library is not found when run program". But if start VFP9 before run program is normal not error! Thanks! Do you know which library you are using and is not found You may have to debug the EXE (can't use debugger step-by-step) by writing to a log or using Wait Window or MessageBox in strategic places, or debugout. Once you find the offending API call you may have a handle on the problem. Is this happening in the same PC Which OS Are there any permission problems Are there any path problems Is the user running the EXE the same user running the development APP in VFP (th ...Show All

• Windows Forms Properties from inherited interfaces bug in DataGridView binding

  In http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=71422&SiteID=1 , Joe Stegman (oh great provider of answers!) mentioned there was a bug with data binding to DataGridView's in that base interface properties were not picked up. Has this been fixed Is there a fix I can download from somewhere Can I track this bug anywhere If there is no fix, what's the best work-around Explicitely add all the properties from the base interface to the inheriting interfaces Thanks. I ended up filing a bug at http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=148549 Microsoft agrees it's a bug, but don't care to fix it unless more people vote on it... hint, hint! ...Show All

• SQL Server SQL Server 2005 - Scheduled jobs stop working

  Our system is using SQL Server 2005 SP1 running under Windows 2003 Server and database mirroring are adopted. Howerver, recently, we discovered that the all scheduled jobs in SQL Server stopped working suddently. The jobs had no errors and the SQL Server Agent was still running. All just fine but no jobs were working and they just like sleeping in SQL Server. Even database mirroring monitor job stopped running and it should run every two minutes. It is very annoying. Why this happen and how to fix it Thanks. There should be additional entries in the SQL Server log ot the event log of Windows. Please post the appropiate messages here. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms Finding the same word twice in a richtextbox

  Hi I need to find the same word twice in a richtextbox, but at different locations. The problem is I need to write to a file what is after the word. I can write the first part, but after that it just writes the same section again. Please help this is quite urgent. I need to do this for a project that needs to be finished today. Thanks post the code. search the text for the index of the word you want, make a copy of the string removing all char's upto and including where you found the first instance, search the new string. That should work, off the top of my head. but better to post the code ...Show All

• .NET Development Download data to excel

  Hi all: We're developing an ASP .NET application which get some data from SQL server and draw some graphs. We already have the queries to get the data and everything works fine with the graphs. The question is that we want the enduser to have the possibility of downloading these data used to build the graphs to an excel file. We have a code to do this in xml format but not in xls. Anyone could help thank you. Emerson If I understand your question, the following should help: How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET ...Show All

• Windows Forms Error when adding a user control to a form

  I've created a user control that consists of a text box and a list box. The listbox is populated by a data table that's created in the MDI parent and copied to each form as needed. In the load event of the user control, I set the datasource of the listbox to the tables defaultview, then add the sort, display and value properties. When I try to add the control to a form, I get a 'Failed to create component' white screen of death, with the message that the column name for the sort property can't be found. If I comment out the load code, I can add the control to the form. I can then uncomment the code and run the app, and the user control does exactly what it's supposed to do. First, why is the designer finding what would be a runtime e ...Show All

• Smart Device Development WM 5.0 + VS2005 + SQL Mobile Problem.

  Good morning. A few people in here have helped me out with various noob questions I've popped out while developing my first Mobile app. Now I seem to have hit a major stumbling block. I've been scouring the net for several days trying to find an answer but I can't seem to make sense of the wealth of information. (The abbreviated gist of my post is - "Why can't I run SqlCe classes under Windows Mobile 5.0 and Visual Studio 2005 ") The story is this: * I developed the app using VS2003 and CF 1.0, succesfully deploying it to a Windows Mobile 2003 SE device. The app used SQL CE 2.0 as part of its operation. * The device we have been given now (Symbol MC70) which will be the production model has just been catastrophically diagnosed as ...Show All

• Visual Studio Tools for Office Manual Page breaks vs automatic page breaks in WordML

  Hi, I have a scenario where I'm programmatically generating WordML documents based on data from a database table. Sometimes, because of the source data in the database table, the output WordML a <wx:sect> tag spans more than one page in Word. Is there a way to insert a manual page break in the WordML for this section whenever this happens This way, I can make sure that for every row in the database table, the output will start on a fresh page in Word. At the same time, I want to avoid having consecutive page breaks which seem possible if I get this working. Thanks, JGP Be sure to let me know if I'm boring you... :-) Mail merge letters do this so that you can have a "Differ ...Show All

• Windows Forms Stepping into Windows.Forms IL code...

  Dear Microsoft, I am trying to solve a tricky problem. The only way I can continue the investigation is to step into the IL of System.Windows.Forms and therefore see what is happening at the lowest level. This should give me enough of a clue to work out what is going on. But I cannot find anywhere in the docs or on the Internet a description of how to step into System.Windows.Forms IL code. The fact it is IL is not a problem. Can it be done and how (This is for Visual Studio 2005 and .NET2) Thanks Phil Wright http://www.componentfactory.com Free user interface controls for .NET2 You could use reflector to inspect the WF source code (this won't let you step through, but you can be a "human d ...Show All