Saji's Q&A profile

• Microsoft ISV Community Center Forums VBA to VB/Java

  I have created a form (using Word as a shell) that applies logic rules and outputs a series of text strings in a field of the same form. I no longer use the Word functionality in any fashion other than as a shell for VBA (i.e. a way to launch and run the VBA form. Is there any compilers/applications that will convert VBA to another language such as VB or Java or any common language that I can run stand alone I found one for Excel, but not Word. I am hoping someone has a suggestion. John I don't know of such a utility, but in general VBA code can usually be moved to VB.NET without much trouble. Since you say you're not using any Word functionality, you don't even have any interop issues to worry ...Show All

• Visual C# Adding a referance using a command line

  Hello All, Does anyone know how to add a referance (e.g. dll) to the project through a command line I tried using "csc /referance: " but i guess it just for compiling the code. I'm asking because I have created a batch file that creates a dll based on one of the cs files in my project, but i have to add it manulay to the project. Thanks, Eyal Hi, EyalRF. The switch is "/reference" not "/referance". The short-form is simply "/r". Example: csc.exe /reference:C:\WINDOWS\Microsoft.NET\Framework\v.2.0.50727\System.XML.dll /target:library MyClass.cs Here is MSDN documentation on the /reference command-line switch: "/reference (Impo ...Show All

• SQL Server Questions about memory based bulk copy operation(InsertRow count,array insert directly,set memory based bulk copy option)

  Hi~, I have 3 questions about memory based bulk copy. 1. What is the limitation count of IRowsetFastLoad::InsertRow() method before IRowsetFastLoad::Commit(true) For example, how much insert row at below sample (the max value of nCount ) for(i=0 ; i< nCount ; i++) { pIFastLoad->InsertRow(hAccessor, (void*)(&BulkData )); } 2. In above code sample, isn't there method of inserting prepared array at once directly(BulkData array, not for loop) 3. In OLE DB memory based bulk copy, what is the equivalent of below's T-SQL bulk copy option BULK INSERT database_name.schema_name.table_name FROM 'data_file' WITH (ROWS_PER_BATCH = rows_per_batch, TABLOCK); ------------------------------------------------------- My solution is lik ...Show All

• Windows Forms Hello, every one, wanner a suggestion

  I've develop a application(Using C#), and now i want add a new function, this function is burning CD. This is a new domain for me, Somebody can give me some suggestion to start this. I think there are some questions, 1) how to check CD (or dvd) Driver, 2) is there a disk in it and is disk a empty one 3) what's the type of this disk,(CD or DVD). i am do some preparations for this:) thanks. Probably the best start is working with Ahead Nero using their SDK: http://ww2.nero.com/nero7/enu/SDK_API.html But you need Nero installed for your application to work. Windows XP/2003 has a built-in functionality for CD/DVD burning, but I can't find documentations about the available APIs. If you found one, please post i ...Show All

• Visual Basic help, vb arrays?

  i'm trying to design a front end for a database and have no idea what im doing i have a form which is opened up several times and info needs to be stored somehow each time it is closed and then next time opened it is cleared and new info can be input then stored ready to upload in to the database, a guy i know seems to think creating some sort of array for each of the fields contained within the form will work however i have no idea where to start the feilds contain both numerical and text content. hope some one can help my boss has got me doing this as i finnished my original task early please help please do not duplicate post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=725775&SiteID=1 ...Show All

• Visual Studio Team System Extending Team Portal to have calendar...

  Hello, I'd like to try to extend a team portal to add a Calendar to the portal.  I thought there would be some type of Web part that did this i.e. mycalendar.  To my dismay I have not found that or any other web part that I could use.  My question is: Is there a calendar available for the Team Portals   If so, where can I find this calendar Thanks a million in advance. BJHop FYI we are using Conchango's Scrum for TFS process template. The Event's web part is part of the basic install of SharePoint 2.0 and 3.0. I'd be very surprised if you don't have it. Are you the WSS administrator If not, I would ask him/her about it. You should be able to see it by simply selecting 'Modify shared page/add ...Show All

• .NET Development Comboxbox Itemdata is not available

  I have a VS.net solution (multiple projects), created entirely within VisualStudio.Net 2002. I try to access and update ItemData property of a MS-form combobox, design mode, yet the property is not accessible under. NewItemID is not accessible either. I have queried from the internet and found an article saying similar problem when migrate VB6 application into .NET. However, for my scenario, the entire program is completely created within VisualStudio.NET 2002. Thank in advance. The ComboBox class doesn't have an ItemData nor a NewItemID member. Trying to convert FoxPro code ...Show All

• SQL Server Error when browsing processed Cube

  Hi, I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM. i.e. if I change the following working piece of MDX in a calc Aggregate( { [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC T ...Show All

• Software Development for Windows Vista Power icon problem

  Hello, I've just installed the Windows Vista Beta 2 (Build 5384) and so far so good, except for one thing: somehow i can't activate the option to show the power icon on the "notification are" of the "taskbar". When i go to the properties of the "taskbar", and then go to the "notification area" options, i'm allowed to select to always show the clock, volume and network icons, but not the power icon. Do you know what can i do to fix this problem Because of this problem, i never know when the battery is low. Thanks for your help!! If your machine is battery-enabled, you should see the battery icon in the tray area by default. You should also see a checkbox in ...Show All

• SQL Server Microsoft.ReportingServices.Designer

  Hello all, After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error: Could not load file or assembly Microsoft.ReportingServices.Designer Version=9.0.242.0 .. or one of its dependencies. System cannot find the file. But it exists!!!What can I do Many thx! Thanks, The above link contains exactly the answer I was looking for. I have been using Windows for a long time and many years ago you couldn't have a system drive partition over 2gb (I forget which version this was) so since I had a bigger hard drive even then I got in the habit of creating a C:\ for the system files (2gb) and then on D:\ I put everything else. So the answer in the link ...Show All

• Windows Forms Why does the ClickOnce 'Install' button generate an xml page instead of starting download?

  Hello, I just published my application for ClickOnce deployment to my web site. When I click on the Install button on the publish\publish.htm page on my website, the browser returns the contents of an xml file and does not start the download. Does anyone know what might be causing this Any help or suggestions would be greatly appreciated. Thanks! Jason I have the exact same problem, on my pc running vista it works perfectly but on xp using IE 6 it doesn't work and i had it test on a few other people's computer they have the same problem they get the xml also the webhost have the mime types set and the dfshim.dll is also working as it should so it's strange, i hope somehow there will be a solution ...Show All

• SQL Server How "NOT" to expire the ReportSession and ControlID in the request

  This question is related to VSTS and above parameters in the request. Question is: A script created with VSTS for testers has hard coded values for ReportSession and ControlID in the requests, These IDs are expired after some time and scripts fails to run after few hours. Can some one tell me how to set the session expiration time on these ID's in the Report server so I can increase the value to 60*24*365 (1 year) this would solve my problem with hard coded values in the scripts for above mentioned IDs. Thanks for the comment Russell. After making the change to 525600 (1 year) if I set it back to defalt would that clean up the Temp DB for any sessions that were kept. Reason I need this value big is because these ID's are hard c ...Show All

• Visual Studio Express Editions Default Application

  Hello, I have a list of files in my app. I'm keeping track of thier URI and their name. I'm wondering how can I open the files using thier associated default reader. I realize that I can code this myself (either with if statements or introduce different FileTypes each with its own default application), but is there a way I can hookup into existing OS call Thanks Houman you can start an external process, giving it the filepath or link which should execute assuming that the type is registered in Windows: System.Diagnostics.Process.Start(" fileNameOrLink "); would this be something you are after you can also use the assistant class, ProcessStartInfo, to customize the wa ...Show All

• Visual Studio Express Editions how to retrieve data from a database and put it into a variable

  Hi all... I am trying to retrieve data from a database and put it into a variable. If the data in the databasetable looks as follows: Number Kredit 1 10000 2 99998 3 99996 4 99994 How do I retrieve the data "in red font", and put it into a variable Dim Variable as integer Private Sub Form1_Load Vaiable = (Last entry into collumn "Kredit") End sub Im sure this is fairly simple, but I just cant figure it out... so any help will be greatly appreciated.. I just started looking at sql-databases today, so if any of you have some links to good beginners guides, those would be appreciated too... Thanks... cmdString = "SELECT Kre ...Show All

• SQL Server overload function call

  Hi, I want to write one function like that dbo.function( number , 1 , 2 ) , but I would like to overload, and send char or number dbo.function( number, 'abx' , ' xpto' ). I would like to keep the same name, Can I do this or Do I need to write to differents functions thanks, Hi Alessandro, I think I understand what you want, and the below will let you do this: create function fntest2 (@one sql_variant, @two sql_variant) returns sql_variant as begin declare @ret sql_variant set @ret = 0 if (select SQL_VARIANT_PROPERTY(@one,'BaseType')) = 'int' begin set @ret = @one end else begin set @ret = @two end return (@ret) end; Is that what you were after, or did you mean something else Ch ...Show All