Chien-hao Wesley Wen's Q&A profile

• SQL Server Deploy Excel file that already exists on server - file isn't replaced

  Dear all, I am deploying programatically an Excel 2007 file to a SQL Server 2005 Reporting Server. The problem is that if a file with the same name already exists, that file isn't replaced. I would like the opposite to happen. I'm using the following code: --Executable set svr=http://w3sdwsqld1/reportserver set src_fld=" \\w3sdwsqld1\\deploy\\SAD\\ECRANS\\UPDATES_20061127_190000\\Ecrans\\AM\\Associados\\ " set dest_fld="Associados" set script=" \\w3sdwsqld1\\deploy\\SAD\ECRANS\\UPDATES_20061127_190000\\Ecrans\\AM\\Associados\\PublishReports.rss " REM Sample: deploy.bat http://w3sdwsqld1/reportserver " \\w3sdwsqld1\\deploy\\SAD\\ECRANS\\UPDATES_20061127_190000\\Ecrans\\AM\\Associados\\ " ...Show All

• Internet Explorer Development Drag and drop into I.E. from external source

  Hi, I would like to initiate a drag and drop from outside of Internet Explorer and have a javascript on a webpage being displayed in I.E. accept the drop. I don't see how the script can get access to the object which is being dragged though... I have found out how to do this for the Firefox browser here: http://straxus.javadevelopersjournal.com/creating_a_mozillafirefox_drag_and_drop_file_upload_script_p.htm Firefox has an XPConnect object which it uses as a bridge between javascript and Windows XP. Surely, I.E. has something like this also. Does anyone have any ideas Ultimately I would like to drag and drop a custom datatype, but for now I would be happy with an explanation of how to drag and drop a string or a file from an external sour ...Show All

• Visual Basic about copying info from a ".txt" file to a listbox

  This myt seem lyk a very stupid question for most of you people out there, so i apologise for my ignorance. I am learning computing at school this year, and i had to do a project at school. Anyways, i am really really stuck on this, i have been trying 2 do it for the past 3 hours and it seems like i really need some help. I have got this txt file with the info like this: "DEF $13.45" "ABC $12.95" "Cheese Lovers $11.90" "Vegie Supreme $11.90" "$50.20" I was wanting to copy the whole file into a listbox. So this is what i tried, but it never seemed to work. This is what i have thought of, i have tried alot of other methods but they dont work too. Fi ...Show All

• Visual C++ ** How to use IsNetworkAlive API **

  Hello all, I find this IsNetworkAlive API from the Sensapi.lib of Platform SDK. Basically, I just want to check the network status. The function looks like a very good one to be used. Do any of you have used it before Because I cannot make it to work. The function always gives me an unhandled exception "Object reference not set to an instance of an object". Any example Thanks you, Our sample console application seems to work well:   #include "stdafx.h"   #include <Sensapi.h> #pragma comment(lib, "Sensapi.lib")     int main(int argc, char argv []) {        DWORD dw;      & ...Show All

• Visual Studio How to register VSpackages

  Hi All, Can any one give me the detailed steps for registering the VSpackages Thanks in advance dseknat C:\Program Files\Visual Studio 2005 SDK\2006.06\VisualStudioIntegration\Tools\Bin\regpkg.exe /root:Software\Microsoft\VisualStudio\8.0 <fullpath>MyPackage.dll When you created the VSPackage VS added some attributes to your files, these are used by regpkg I think. Also for testing and debugging: If you wish to use the test Visual Studio registry it's called Visual Studio 2005 Experimental hive. I's useful for testing your package with and not corrupting your main VS registry. To register your package with the Experimental hive run C:\Program Files\Visual Studio 2005 SDK\2006.06\VisualSt ...Show All

• SQL Server Specific data extension question

  Hello, i've a data extension for reporting services which calls a webservice to retrieve data for the report. I'm caching the data for one report request in the HttpContext.Cache object. While debugging i found out, that the HttpContext.Current is null in 4 of the 6 instances of my dataextension. What can be the reason for this behavior. Because each request to the data extension should run with the HttpContext it's hard for me to understand it why the context is not available. regards Antilles > Because each request to the data extension should run with the HttpContext That assumption is incorrect. For example, if you execute the request in report designer preview there is no HttpCon ...Show All

• .NET Development Desktop Notification using Windows services

  Hi How to create Desktop Notification using .NET windows services,C# in Windows Vista Operato System Regards Govardhan Hi I am new to windows services,I am trying to create alets using windows service,But it is not working.The same code is working in windows applications,If any know pls give me replay my code is like System.Windows.Forms.NotifyIcon nty = new System.Windows.Forms.NotifyIcon(); nty.Icon = (System.Drawing.Icon)Properties.Resources.video; nty.Visible = true; nty.ShowBalloonTip(5000, "Match Cast", "Check for Match Cast Updates ", System.Windows.Forms.ToolTipIcon.None); Plz help me Regards Govardhan ...Show All

• Community Chat Calculating Man Hours

  Is there a good way to calculate how many man hours it would take to add about 1000 lines of code to a Visual Studio MFC program This would include a dialog or two and a class. My way of calculating is to guess that it would take x hours and then multiply those hours by 4. I know. Just keep the jokes to a minimum. sure there is. having done a course on software engineering (for structured aproach to S/W development), I can suggest some popular methods. You can use functional point analysis for calculating man-hours without even knowing actual no of lines in your code. Another method would be to use CoCoMo analysis where one has to know no of lines in the code. further can is available at ifpug.com or en ...Show All

• Visual Studio Team System Communicating in TFS

  Within our development process during the completion of a particular task, we might have a great deal of communication between our project managers and programmers to help clarify the exact functionality that is required. Most of this communication would be carried out via e-mail. Is there a way to use TFS to capture this email communcation effectively and efficiently. I could not see how this was done. I can see how checking in code and relating that to a work item could send an alert to the project manager that a task has been modified, however, this seems like a strange and cumbersome way to initiate communication. Much faster to simply send an email. Or is there a better way using TFS Thanks Luis ...Show All

• Visual Studio Team System how do i make Domain groups into global groups

  Hey everyone ok well im in a situation where i want to have some groups that can ONLY read status's and not change it and some that can change the status for different stages of the defect.. my problem is that i created a couple different groups which were domain groups, when i go to the list of groups that i can read only or whatever there are only the global groups, how do i switch my domain groups to global lists thanks Here is how-to article on creating server level groups: http://msdn2.microsoft.com/en-us/library/ms252479.aspx . There is good information on how to manage groups and permissions at http://msdn2.microsoft.com/en-us/library/ms253047.aspx ...Show All

• Windows Forms combobox index

  This is on a WIndows Form... I have a SQL query that returns ID & Grade I want the Grade to be displayed in a combo box, but I want access to the ID so I can run a second query based upon which Grade is selected. In the form load event I have... cmbGrade.Items.Add ( "Select Grade" ); Con.Open (); SqlDataReader dr = null ; dr = cmdGetGrades.ExecuteReader (); int i = 0; while (dr.Read ()) { i = cmbGrade.Items.Add (dr.GetString (1)); }dr= null ; Con.Close (); cmbGrade.SelectedIndex=0; That puts the grade in the box OK, but how should I handle the ID How can I get the ID, to use in another query So how do I get the data into the combobox I have dropped a conection and ...Show All

• SQL Server Understanding cube

  Hi, I am new to OLAP and was reading on this area on the web. I come across this statement like: "while the relational database (OLTP) updates...the OLAP database will not be updated. " I am not sure of the above statment. In that case the data in OLAP is not the latest and how is it going to be updated Thanks. Regards Alu Is there a way to update/process automatically or must it be manual How is it possible/feasibility to update the cube very close to immediate time :) Regards Alu ...Show All

• Visual Studio Team System URL Encoding of Location property in FxCop Properties window

  When I view a warning in the properties window in FxCop it shows the location as an URI like file:///c:/temp/foo.cs This works nicely for directory/filenames without spaces or encodeable characters. Unfortunately the project I'm working on is in a directory with 2 spaces in its name and therefore doesn't work correctly (a file not found error) I've noticed that in the details window (double clicking on a warning) it shows the correct (unencoded) value for the location. Is this likely to change in a future version or will this remain the same ...Show All

• SQL Server AMO - measure numeric Value

  I'm building a cube dynamically and i want to list just the columns in the fact table that are numeric in order to make Sum's, AVG's and so on. How can i do this using AMO , i'm wondering if i can do this from the FactTable's (Data Table) DataColumns, but there is no metadata that tells me if the values there are or not valid numeric measures. Regards Lisber. Hi Chris !, exactly i was thinking in the solution you described before , but i was having some troubles, here is the code that i use to figure out if a data column is or not a measure ( ie, if its numeric ). // 1o I make a loop through all the columns of my fact table ("FactResellerSales"), here is the ...Show All

• Windows Forms Treeview doesn't show full node text

  I have treeview on a Windows form and it doesn't show full text for items (nodes). Nodes are static. It does the same thing for short names (15 charachters) or long (25 charachters). Has anyone any idea why does this happen or what should I do to prevent this. I am using VS 2005. I would really appreciate any help on this issue! ...Show All