LPATTERSON's Q&A profile

• Visual Studio Tools for Office Pivot table using c#

  Hi, I am trying to create PivotTable in Excel from c#, I get to the point of creating the table but I am not able to specifi what will be the RowField or ColumnField etc. and format those data, I have written it earlier in VBA but I want to convert all my application into VSTO using c#, is there any example code for creating Pivot Table using C# by opening up an instance of Excel and then a particular workbook and then a particular worksheet in ...Show All

• SQL Server user info in fn_dblog with SQLServer 2005

  Hi, I've notice that in SQLServer 2005 "select * from ::fn_dblog(null, null)" and "DBCC LOG(mydb, -1)" always return -1 or NULL for the column UID which is supposed to return the id of the user. I've been using those statements with previous version of SQLServer with no problem so far. Does anybody know if there is any option to enable SQLServer 2005 to save the user info in the log Thanks. ...Show All

• Windows Forms Reading from MS Word tables with .NET

  In my project I need to get data from MS Word tables and insert it to database. I found on the net how to open word document to get tables. But when I start to read table row by row it gives me an exeption 'Cannot access&nbs ...Show All

• SQL Server Error on security property page

  i had deploy the reporting server with machine to a new domain, but the security property page cannot load due to existing old domain user is still exist. Reporting services cannot validate that old domain user and cause the page cannot load. then i try to delete that user from reporting services database, but it was unsuccessul to do so. Reporting services seems cache the user somewhere although i had delete the user from database How i  m ...Show All

• .NET Development How to access webservices using soap protocol from javascript?

  I cannot access web services using http get and post so only option isto use soap Please help in this regard.. Thanks in advance If the web service will ONLY support the Soap Protocol then you'll need a client that makes these soap requests. You're right, the XMLHTTP and ServerXMLHTTP objects use HTTP Post or HTTP Get requests to call the web service. We have a few more options for you: 1. Use the SoapTool K ...Show All

• Visual Studio Team System TF26000 problem when creating a new global/project group

  I got an error message when i query a work items. (TF26000). My TFS is installed in single server and using workgroups. Let me show what i have done in Team explorer. create a global group named "Developer". assign an user "jobria" to that group (The account is local account). then i grant full right to that group in server and project. However, when i login the account "jobria" and query the work items, i show me the error mes ...Show All

• Visual Studio Team System What version of TFS is installed?

  Rather sheepishly admitting I've kind of lost track with which version of TFS I have installed it is definately either beta 3 or beta 3 refresh, could you tell me a way I could check Click Help/About Visual Studio, select "Team Explorer" and see what version is reported (it should be something like 8.0.50727.147). I don't know off hand which build number corresponds to which release, but if you pos ...Show All

• SQL Server Variables in the four naming conventions

  Hi I am running SQL Server 2000 and have two different databases with different names on two different machines. The servers (machines) are linked and I want to use a single set of stored procedures on both databases. I want to know if and how I can use variables in the four naming conventions in a stored procedure. This way I do not have to write an if statement and rewrite the code for each database. Example: Select * from SE ...Show All

• Visual Studio Express Editions Forms Inheritance

  In vs.net 2003 when you inherit from a form local to your project, or anywhere else for that matter, it will display the original form with an additional icon in the upper left corner of each control - the controls on the base form. My problem is this - when inheriting a form in vb 2005 express it is just displaying a dashed outline of the form, I cant add controls to the inherited form and the controls on the base dont show nor do the controls ...Show All

• Windows Forms Bound DatagridView not refreshing

  I have a DataGridView bound to an array of objects.  When I change values in the objects the DatagridView does not show the change.  I have to do a .refresh.  Also the event CellValueChanged does not get triggered when values are changed by the program to the object values (they are exposed as public properties). Thanks for any help, Luis C. Uribe Thanks Scott for you help and your clear example.  My grid is now working ...Show All

• Windows Forms Install Prerequisites On Demand Using ClickOnce

  Hi, I have a question regarding how to on-demand install additional prerequisites using ClickOnce. (I think this can be done by using the default publish.htm page from web browser). For example, my version 1.0 application do not need reporting feature. So, in this version, I do not configue it download the reporting runtime as prerequisite. But when come version 2.0, my application comes with the reporting feature which require th ...Show All

• SQL Server How to Store System Variables in DB?

  Hi, I want to store the System::StartTime in my Integration Table Log. Please guide how can I use this in my Execute SQL Task Block. I write this SQL Statement: INSERT INTO CMN_tblIntegration VALUES ('HRM_tblParty', ) Which the is for the parameter. I go to parameter mapping tab and map the System::SatrTime to parameter0, but the package fails to run. I also changed the to @IntDate and also changed the parameter name but the error was the ...Show All

• Visual C++ plotting graphs library

  hello everyone, im doing a program that does circuit and matrices analysis.. i was wandering if i can call matlab plot functions from my C++ program or where can i get a library that plots data thx OMAR I have no idea about matlab, but if you want some free plotting classes, see http://www.codeproject.com/miscctrl/#Charting+Controls sab7a wrote: hello everyone, im doing a p ...Show All

• Visual C++ fatal error LNK1104: cannot open file 'LIBC.lib'

  I'm trying to compile a C source code project with Visual Studio 2005.  I'm linking in 2 libraries that were built using Visual Studio 2003.  When I build my project, I get 1 error: fatal error LNK1104: cannot open file 'LIBC.lib' I know libc.lib is not included with Visual Studio 2005.  How can I overcome this problem Thanks, Mike You might still have one of your older libs that weren't rebuil ...Show All

• Smart Device Development What is the event in the Form when theForm.Show() gets Called?

  hi, guys I have a tab control in my pda c# form. And there are three pages. What I did is, I put a panel in each tab, and then will put a other Form to that panel later in the code. In this way, I can keep the code separately in different three Forms. The question I have is, when we switch in these three tabs, I call the corresponding Form's Show(), in that Form, what is the event to tell right now, the form is being shown Coz everytime, when us ...Show All