Andres Aguiar's Q&A profile

• Visual Basic "hello world" won't run

  I am a newbie who just downloaded visual web developer 2005 express on my xp home system.  It installed without errors as far as I can tell.  Is express really stripped-down, and they don't tell you what is missing Like this "hello world" program example:  I can't paste the example page here, Right-click WON'T LET ME! Anyway, the page says "create visual basic console application project".  The closest I could find was a ...Show All

• Visual Studio Express Editions Converting String to Double or Int

  I am working on creating a program that calculates the area of a rectangle. The program has two textboxes and a button. When the button is pressed, I need to convert the strings to numbers according to type (ie if it's a double, i need it to be a double...integer to int) In my class file, I have three constructors 1. Takes two integers <-returns integer 2. Takes two doubles <-returns double 3. Takes an integer and a double <- returns do ...Show All

• SQL Server SQLiMail - Database Mail

  Hi I am trying to send a mail using database mail. I have enabled it using Surface Area Config for Features and and set up a default public profile usind Management studio. When executing USE AdventureWorks go DECLARE @QueryResult varchar ( 100 ) SET @QueryResult = 'Number of contacts: ' + CONVERT ( varchar ,( SELECT COUNT (*) FROM Person . Contact )) EXECUTE sendimail_sp @profile_name = 'SQLS ...Show All

• SQL Server I can't add a new Reporting Services server registration of a remote server.

  I need a help. This is the scenario: I have installed on my machine SQLServer 2005 Developer but not reporting services because I don't have IIS. Now there is server: W2003 + SQL Server 2005 Developer (Complete) + II6. From the SQL Server Management Studio I can connect to the DatabaseEngine on the server but I cannot connect to Reporting Services or Integrated Services. On particularly when I try to create a new Server Registration ...Show All

• SQL Server the clustered pk index not being used with pk search

  I have an update statement like: declare @P1 bigint, @P2 varchar(8000), ... @P30 bigint update mytable set col1=@P1, col2=@P2 , .. where table_id=@P30 (this query was extracted from the trace file) The table_id is the PK of the table. However, the execution plan is NOT using an index seek on the clustered pk index. Instead, it's doing a "range scan" on a separate index on the table with &quo ...Show All

• SQL Server replication component missing error while installing Sql Mobile2005

  Hello i installed sql2005,first when I install it,it dont show SqlMobile option in available component lists,second when i install sqlce MSI file seprately,it searches for SQl Replication service and says its not installed,though its already installed on machine,i can install it anyway but why this message comes up did anyone else experience this thanks Yes SQL 2005 install does not show option but it install SQL Mobile. You should se ...Show All

• SQL Server can i directly use a variable on this?

  on the PARAMETER SOURCE box (figure 1), can i use a variable and not a particular control what i tried is i put the variable into a control and select CONTROL on the PARAMETER SOURCE. that works but i guess there's a way i can directly access the variable using this wizard. pls tell me. thanks figure1 >> www.geocities.com/fbi_file01/figure1.jpg ...Show All

• Visual Studio IDEBuildLogger

  I'm logging messages in my custom Task using the built-in TaskLoggingHelper object Log. When I call Log.LogError and Log.LogWarning I get the opposite in the output window. The error's say they are warning's and the warning's say they are error's. It seems that the suspect code is in the AddToErrorList method of the IDEBuildLogger class on line 181 where IsWarning is being set. It's being set to true if the priority is High which is only set to ...Show All

• Visual Studio Toolbox Images no longer showing up transparent

  For some reason the code that we used to use from 2003 for adding toolbox items with transparent images no longer works in 2005.  We are using the latest release of 2005 with the latest SDK. Here is our code: Bitmap bmp = new Bitmap ( typeof ( MyClassName ), "Resources.mybitmap" ); uint clrTransparent = ( uint ) Color .Fuchsia.ToArgb(); // Declare toolbox item structure TBXITEMINFO [] tbxInfo; tbxInfo = new TBXITEMINFO [1]; tb ...Show All

• Windows Forms How to prevent selected row go down when pressing enter in datagridview?

  I have a datagridview set to FullRowSelect as its selection type.  I find that when I press Enter, the selected row move to the next row, how can I prevent this   Please note that datagrid don't have this problem. Thanks There is no out-of-the-box way to do this. One solution is to inherit from the DataGridView, and override DataGridView::ProcessDialogKey and DataGridView::ProcessDataGridViewKey. In these methods you can ...Show All

• Windows Forms MDI with new SplitContainer

  Hi, I have an MDI WinForms app that has a splitter to the left with a tree control in it and the MDI child windows show up on the right hand side of the splitter. I would have coded it with the Splitter control using .NET 1.1 In .NET2.0, the Splitter has been changed to SplitContainer. How would I get the MDI child windows to show up when the whole body is filled up with the splitcontainer Do I keep using the Splitter for this purpose Nitin ...Show All

• Windows Search Technologies Limit results set in a query?

  Hello, Is there a way within the plain search syntax to limit the number of returned rows from a query Using the WDS front-end the optimized query (i.e. from the query.log) it looks like there is a: CMD-PROP=\"Maximum Rows=100;\" annotation on the SQL Select. Is there anything I can use in terms of the non-SQL query syntax, i.e. something like: "foo date:last month returnmax:100" Or should I be doing this ...Show All

• Visual C++ Problem when i compile a simple program

  I type the following code: #include <stdio.h> #include <conio.h> void main() { printf( "hello" ); getch(); } and this is the error message after i compile it: ------ Build started: Project: c++, Configuration: Debug Win32 ------ Compiling... Inthu.c d:\documents and settings\bui huy hoang\my documents\visual studio 2005\projects\c++\c++\inthu.c(7) : warning C4996: 'getch' was declared deprecated d:\program files ...Show All

• SQL Server Simulating ORACLE SEQUENCES

  In order to replace an Oracle DB with SQL-Server 2005 i've to find a substitute for the DB-Object "SEQUENCE" used in ORACLE. I tried it with a trigger and a stored procedure. But in both cases the stress-test failed. In case of the trigger the requests blocked each other. In case of the stored procedure "unique" numbers have been assigned twice to the requestors. Main problem may be the fact, that i can't read and w ...Show All

• Visual Basic setup.exe question

  I created windows app with vb 2005, ready to install on a user machine by running application’s setup.exe, I get application warning Application Install Security Warning – Publisher can not be verified. Don’t know any other way to get publisher name to appear. Was using solution’s property window – Publish/options to set up publisher name and product name, it takes product name, but not publisher name, anybody has an answer for that. ...Show All