v_seyedan's Q&A profile

• Visual Basic Automating Excel - code doesn't execute on 2nd loop iteration

  Hello all. I have written code in VB.NET to automate Excel. This portion will copy a range on 1 sheet, find the last cell in a particular column on a 2nd sheet, paste the range and then sort the data so to remove any empty cells. The problem is that the code executes the first time in the loop (index = 0) but not the 2nd time although while stepping through it, it appears that it should work fine. It works for the 3rd iteration on to 15 or ab ...Show All

• Visual C++ ActiveX Control in a Scripting Environment

  I'm trying to build an ActiveX control to expose properties and methods to a JavaScript environment under Internet Explorer.  Despite having studied COM basics and am going through a tutorial on building ActiveX controls under Visual Studio version 5, I'm having an awefully hard time making this work.  I believe there MAY be something left out of my list of what is done that causes (for instance) a property to be exposed (assignable an ...Show All

• SQL Server Shared hosting, SQL 2000 & 2005, Visual Studio 2003, DotNetNuke

  (read the first reply below before you wade through this) Setup information here, questions below: 1) My website hosting service is Network Solutions.  They use SQL Server 2000 and .NET 1.1 and they say there are No plans to upgrade either at this time. 2) I just downloaded SQL Server 2005, 180 day evaluation edition. (I'm supposed to get a free version of SQL and Visual Studio 2005 at the Roadshow on December 8th.) 3) I set up (" ...Show All

• SQL Server connecting to sqlexpress from classic asp

  hi, i'm using classic asp to try and connect to a sqlexpress database on a development server. i get the following error: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /dbtest.asp, line 8 I'm using the following script which runs fine against a regular SQL server (version 8) on the network. <%@LANGUAGE="JAVASCRIPT"%> <% var strCon ...Show All

• Windows Forms combobox help

  I have a windows form with a combo box, a text box, and a button.  When the form load, I bind the combo box with a default dataset from SQL query. Everything goes well so far and I can see the results in the combo box.  ...Show All

• SQL Server How do you Implement Percent of Group in Report Builder?

  Dear Anyone, How do you Implement Percent of Group in Report Builder We've implemented this in RS2005 but are unable to do this on Report Builder. Any Ideas on how to implement this on RB I've included a sample below. Geo Unit Operating Group Total Open Demand Open Demand Past Start Date Overdue Demand Thanks, Joseph Canada Bus Con Srv Lin 1 1 1 ...Show All

• Windows Forms How do I get clients machine to automatically register .application file type?

  Hi I have recently upgraded my program to use the new features of VB 2005 and Dot Net Framework 2.0. I have set my server up according with the .application file type and so I do not get the xml page showing when I click the install button anymore. However I gave the link to a friend and when they click on the install button they are asked if they wish to download myprogram.application, they have selected yes and tried to run the progra ...Show All

• SQL Server SQL Authenfication

  Hi, i m trying to connect to msssql 2005 with SQL Authentication .but without success. "Server authentication is set to SQL Server and Windows Authentication mode". on connect i recive this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT:]" any help would be nice Luka How are you trying to connect Programmaticall ...Show All

• Visual Basic Retrieving Hard Drive Temperature (S.M.A.R.T)

  Hi,  Does anyone know how to retrieve the temperature of a hard drive in Visual Basic 2005 The temperature can be retrieved from the S.M.A.R.T information, but I don't know how to do that in Visual Basic 2005. There probably is a way, but unfortunately, I don't know. If anyone could help me with this, it would be great! --daniel15 http://www.dansoftaustralia.net/ - DanSoft Australia http://www.frihost.com/ - Free Reliable Internet ...Show All

• Visual C# Print Data Grid View

  Hi there, I am trying to print contents of Data Grid View (including header in VS.NET 2005). I have found some samples for Data Grid but they don't work for DataGridView. I was wondering if someone had any ideas and possibly code samples. Appreciate any response. Thanks JGIS Take a look at this article: Printing the DataGridView . ...Show All

• SQL Server SQL Server Diagrams?

  hey, i have been looking for information out there in google but i only found programs that create sql diagrams, but im not looking that. im looking information of how sql server diagrams works whats their job and what will change if i create diagrams :s thx and sorry for this noob question mig16 Same reason you diagram anything else, to help you visualize what's going on.  The ability to do it in sql serve ...Show All

• Visual FoxPro foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.

  foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc. I was given a foxpro program and i would like to see the code (the formulas)... i'm not sure how to do this... thank you...   modify command <insert your prg file here> modify form <yourformname> use <yourdatabasename>   ...Show All

• Visual Studio Team System Solution.vsscc files

  I get a "Checkout error or user cancellation" dialog box when I attempt solution level operations like adding a new or existing project.  It usually complains about <solution>.vsscc not being under source control.  So does TFVC require a VSSCC file or not I manually added/checked in the .vssccc and VS appears to be happy now when I check out the solution file.  Thanks. ...Show All

• Visual Studio Team System Why does drop location have only the buildlog.txt file afterm Team Build builds a website successfully?

  I'm using the Workgroup Edition of TFS in a Single Server configuration. I have VS team Suite with Team Explorer and Team Build on my client machine. I do not have the new template for ASP.NET Web Application which compiles the code of the website to single dll (VS 2003 Model). I then follow the exact process set here to create a single page website which displays "Hello, world" using a Label control the Text property of which is s ...Show All

• Windows Forms How to display text in picturebox?

  Hello! My picturebox's name is 'picDisplay'. My textbox's name is 'txtText'. And my button's name is 'btEnter'. Does anyone know how can I make my picturebox display the text in my TextBox after clicking the button use the PaintEventArg graphic object to draw the string <code> e.Graphics.DrawString("Some string", myFont, myBrush, x, y, drawFormat); myBrush.Dispose(); </code> ...Show All