Intazzz's Q&A profile

• Visual Studio Express Editions Urgent pls help!! All suggestions/help are welcome!!!

  Hi, how do i create a new excel workbook and write data into it cell by cell using a button Beside referencing Microsoft Excel object library are their other references needed   Thank you. Regards, SCK aka dragoncells To create a new workbook you can use the following code: Microsoft.Office.Interop.Excel.Application excelAPP = new Microsoft.Office.Interop.Excel.ApplicationClass(); Microsoft.Office.Interop.Excel.Workbook wbk = excelAPP.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); The way you're writing the data to the workbook can vary depending on how you are getting the data. If you want to write data into Range "A1" you would do the following: excelApp.Cells[1,1] = "INFO HERE" The f ...Show All

• Visual Basic How to create a web service that enable to comunicate with an exisitng window appliacation

  Hey Guys How can we convert a html report to an xml format with values.Is it possible Thanks. Ok, I apprieciate the effort, but this doesn't really help... What does that HTML report look like What does the XML document need to look like You should probably start by reading up on the System.XML namespace and learn how to first create an XML file. How difficult the HTML report will be to parse depends on how it is formatted. ...Show All

• Windows Live Developer Forums PostGIS, MSVE and alot pf Polylines/Polygons

  I've been hacking at this problem for a while, and I'm sure tis been doen a thousand times by now by others but I've only just started playing with both PostGIS and MSVE so Its really messing with my head. Basically we have a several databases full of statistics for geographical locations which could be represented as polylines or polygons and actually both will have to be used... I'm trying to figure out a way of fetching this data from the databases but I want it to remain as polys for future adaptability. I've figured out the code in VE that would select the area and hence the queries I need from PostGIS but I just cant figure out how to join the two things together. I've been pointed at doing some kind of Java servlet and I've had a go ...Show All

• .NET Development Problem with SQL Server 2005 and IIS 6.0

  Hello, I am having problems with my system configuration. I am trying to access a SQL Server 2005 database from a C# .NET web page, but I keep getting this error, " Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". I am using windows authentication. The SQL Server resides on one server and my web server is on a different server. If I run the both the web server and SQL Database from within the same server it works fine, the problem comes when I separate the servers. I am running Windows Server 2003 on both servers, MS SQL Server 2005, MS Visual Studios 2005, and IIS 6.0. Here is my Web.Config file: < xml version = " 1.0 " > < configuration xmlns = " http://schemas.microsoft.com ...Show All

• Visual Studio 2008 (Pre-release) video example not working

  public Scene1() { this.InitializeComponent(); MediaPlayer player = new MediaPlayer(); player.Open(new Uri("pack://application:,,/rock.wmv")); VideoDrawing aVideoDrawing = new VideoDrawing(); aVideoDrawing.Rect = new Rect(100, 100, 100, 100); aVideoDrawing.Player = player; player.Play(); I took this from the msdn page but changed the Uri as I had added a .wmv to the project. All I get is a blank screen. Any help would be great - thanks Hi, I've uploaded my project : http://files.filefront.com/VideoDrawingTestzip/;6304937;;/fileinfo.html Compile it and run, it should work. The Video.wmv file properties are set to copy it to the output directory on each build. Guillaume ...Show All

• Visual Studio Express Editions Having difficulties with a timer and an if-then statement

  Hi, been spending a lot of time on timers and they finally make some sense now. In my program there's this button. When it's clicked a shell command is executed and right after that the program needs to wait until some folder is created (by an external process). It enabled the timer and the timer2_tick sub is executed... But the other process keeps running as well. I need to figure out how to pause everything except the timer that checks every 5 secs if a folder exists until the folder actually exists... Many thanks! Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick ICounterCount = ICounterCount + 1 MessageBox.Show(ICounterCount) If System.IO.Directory.Exists(HomeDirec ...Show All

• Visual Studio Tools for Office Excel Format Change Notification

  I need to be notified when the format of a cell is changed. I know Worksheet_Change event will not help me. Is there a way to do that Thanks, Try asking this of the specialists in the excel.programming newsgroup . If anyone knows of a way, they will... ...Show All

• Visual Basic Dates in VB 6.0 !!!!

  I had developed a custom date control which accepts dates in the way I wanted. Now the problem is that the software will be running on multiple computers & each have their different settings for the dates (i.e. mm/dd/yyyy or dd/mm/yyyy) now I want input in form of only dd/mm/yyyyy so when the system date is 19th Feb, 2007 then the software & even VB can convert it into 19/02/2007 (using Format(Date(), "dd/mm/yyyy"), but when the system date is 5th June, 2007, neither software nor even VB can understand in which format the given date is......... How to solve this problem........... How to determine the System Date is in which format (dd/mm/yyyy or mm/dd/yyyyy) Please help me out....................... I am read ...Show All

• Silverlight (formerly WPF/E) Differences between WPF/E and Flash

  Hi, I searched a lot on topic "Flash Vs WPF/E" but I could hardly get any concrete information. Can anyone suggest any useful information, URLs on "Comparative study between Flash and WPF/E". Regards, Santosh Kalkeri I doubt very much that the first release of WPF/e will have anything like as much functionality as Flash - unless it's not going to ship for about 5 years - which is quite possible knowing Microsofts track record :) In it's present form WPF/e is so far removed from Flash in terms of functionality that you can barely do anything useful with it at all other than create yet another media player. ...Show All

• Visual Studio Tools for Office VSTO Outlook 2007 Architecture Problems - Please Help!

  I am developing my first VSTO Outlook 2007 add-in and I have hit some problems. I would be very grateful if somebody could provide me with some helpful answers as I've been wrestling with this for ages. The ultimate goal of my add-in is to extend the Outlook 2007 UI by presenting my customers with a range of additional forms that meet their particular business needs. These forms will use a local database to store their information. So far I am concentrating on just one form called "Clients", and I have taken the following steps: 1. I have opened a Contacts form and created a Clients form region from it, implementing the 'replaceAll' formRegionType. 2. I have created an additional MAPIFolder called "Clients" wit ...Show All

• Windows Forms Datagridview column header color

  I want to change datagridview column header color maintaining visual style enable. Thanks. Hi Danilo80, Is there a statement "Application.EnableVisualStyles();" in your Main function The header visual style is not enabled if the application's visual style is not enabled. ...Show All

• SQL Server Performance difference

  Hello, i'm running 7 same HW&SW configured servers with the same load with SQL Ex 2005 SP1 installed. I'm executing SP over 200.000 times a day. And here comes the problem, every server got different average response time, the quickest executes the SP in 1 ms, the slowlest in 50 ms, that's 50x slower! Have you any performance hint, please Thank you. There are numerous layers between C# and execution in the server. SqlClient must consume the results and produce datasets, there are protocols that must be negotiated in both the client app and the server before the query is submitted and the results are produced. To get real execution time for each query run it from sqlcmd. The format ...Show All

• Software Development for Windows Vista Args from WorkflowRuntime.CreateWorkflow

  Where (in the workflow) can I reference the arguments passed in on the WorkflowRunTime.CreateWorkflow( Type, Dictionary<string,object>) ) Thanks, Clay Clay, in the technology samples of the sdk, take a look at the "SequentialWorkflowWithParameters" sample: for each parameter passed as part of the Dictionnary, you need a corresponding property in the workflow. Hope this helps Serge ...Show All

• Windows Forms cust_id column to hide in gridview

  I am working on a web project to display data in a gridview and I would like to hide the cust_id column in the grid, which is index [3]. I have an Edit (index[0], and two Template columns (index [2] and [3]). The first field being displayed is the cust_id (index[3]). Here is the code I have and the error message I receive is " Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" protected void Page_Load( object sender, System. EventArgs e) { //calls the dgResults_DataBound method to hide the cust_id column dgResults.DataBound += new EventHandler ( this . dgResults_DataBound ) ; } protected void dgResults_DataBound( object sender, EventA ...Show All

• Windows Live Developer Forums MSAJAX 1.0 conflict with V4 API. Sys.InvalidOperationException. V3 API is fine.

  Hi Guys, Been trying to use the new V4 API in my application but I get this error when I call the LoadMap method function GetMap() { map = new VEMap( 'myMap_myMap' ); map.LoadMap( new VELatLong(53.278353017531821 , - 2.153320312500008) , 5 , 'h' ,false ); ***** Get the error here when I call LoadMap. Microsoft JScript runtime error: Sys.InvalidOperationException: Object Microsoft already exists and is not a namespace. Can anybody please help me to find the problem. V3 of the API still works fine without any problems. If I remove AJAX references from my page the error goes away. Unfortunately, I make heavy use of MS Ajax 1.0 and can't get around it. thanks, SoS ...Show All