Erik Castañeda's Q&A profile

• Visual Basic question about Long data type in VB 2005 Express

  Why is (2^63) - 1 not a constant expression not representable in type Long. Because the long datatype is "signed" meaning that i can express both positive and negative values. The highest bit, the sixty-third, sometimes referred to as the hi-bit, is a "sign-bit", used to describe whether or not the value is positive or negative. ...Show All

• SQL Server Is there something like a referer report to use for navigation

  Is there something like in HTTP - a REFERER - which names the report called the current report or do I need to implement this on my owne by hidden report parameters Thanks HANNES No, the referer report is not available. You would need to pass through the information with hidden report parameters. -- Robert ...Show All

• Smart Device Development Keep program ontop

  Hi, Could anybody tell me please how to make my program forms ontop of any other running program even when it loses focus i am using C# thanks Thanks for replay but this property keeps one form on the top of the other forms of the same program, but i want the whole program to be always on top of any other program Word, Excel ..... etc. ...Show All

• SQL Server Parameter Mapping in an Execute SQL Task

  I am trying to assign the same package variable value to three different parameters in a query. The variable contains the name of a database which the user will input during package execution. First I check to see if the database exists (if it does I drop it), then in either case I create the database. See code: if exists ( select name from sys.databases where name =   ) begin drop databas ...Show All

• SQL Server About Login Account

  Hi everyone, I have a simple question for you which is too important for me. My question is about logins in my own(local) server. I know that my local server(my computer's server) has to default login account which are called sa and BUILTIN/ADMINISTRATOR. While I am using my own server, I do not know which default login account is used by my Server since I use windows authentication while connecting to the Server. Another question is that while ...Show All

• SQL Server Manipulating SQL server databases dynamically

  Hi friends, I have problem in sending my T-SQL statements, which i generate dynamically with the help of "user entered attributes", to SQl Server. I need my T-SQL statements to get passed to the SQl Server ,which i enter in a "Rich text Box " in my appication that i develop using Vc# .net 2005,when i click a button which i placed in my "winform".And the queries Should be executed exectly as i ...Show All

• .NET Development catch (Exception) slow

  hi, I try to make the sum of a Sql column : if there is nothing i want the sum to be null (zero) try{ ......select sum (price) ...... } catch( System.invalidcastException ) { sum=0; } but it is very slow . How can I make it fast In fact each time I have an excpetion it is very slow . Some of them can  happen often and I need a mean toi accelerate those. Thanks for any help Another option is to actually m ...Show All

• Visual C++ Error While Executing Following Code

  Hai all, // Following is the code taken from MSDN #include <stdio.h> #include <windows.h> #include <winable.h> #include <winuser.h> #include <oleacc.h> #include <winver.h> void main () { // For this example, assume that the g_szName variable // is defined as a global LPTSTR variable. // Get the current cursor location. POINT ptCursor; LPTSTR g_szName; // I had declared this o ...Show All

• Visual Studio Tools for Office Insert HTML text in a Word document

  Hello: I'm trying to insert a HTML text in a word document. I have an action pane with a few controls. With theses controls, i call to a remote web service and get some information in HTML format. After this, i want to insert this HTML information in the document, but i don't know how to do it. I have a very few time, next thursday i have to give in the software. I'm using Visual Studio 2005 Beta 2 and VSTO 2005. Please help me. Thank you very m ...Show All

• .NET Development Parsing HTML with no UI context

  I'm trying to retreive and parse an HTML document from a website. I've succesfuly done so in a WinForms app using the web browser control. The problem is that I'd really like to create command line utility which just dumps the results to a file with no UI (and at some point migrate it to a service) - something akin to the "curl" linux utility. The issue is that webbrowser seems to insist on a UI context being present. Anyone ...Show All

• Smart Device Development Why ? in the String Table is ERROR CODE From code Sample-phoneime

  hi: i use Visual Studio 2005 Team open the Phoneime Code Sample, but when i look at the Resource /String Table IDS_MTAP_CHARS and IDS MTAP_SHIFTCHARS there are ERROR CODE ,i can  not see the correct chars. i know the chars is the Key map to digit and ABC. why it is bug thanks ! Thanks,Tao Ma You are right. I open the rc file in "View Code " or with Text mode , i can see the correct chars, and  i can modify it without any warning ...Show All

• Windows Forms How to get a value from BindingSource?

  Hi all, I have a DataSet connected to Access database and CarsBindingSource where datasource is set to DataSet and represents table Cars. So, is there any way to get a value from database via BindingSource (like recordset) E.g. I want to put a value from database - table: Cars - column: Type (at actual BindingSource position) to ComboBox. Something like: Cbo.items.add (CarsBindingSource.Items("Type").Value) doesn't exist ...Show All

• Windows Forms Docking Problems

  I have a form with a menu and a toolbar, a splitter panel and other controls in the splitter.  If I dock the splitter, it slides up under the toolbar and the menu bar. I put the menu and toolbar into a panel and docked that panel to the top. then dock the splitter to fill or to the left. Fill puts the splitter under the top panel and left moves the top panel to the side.  Is there an attribute I am missing to prevent this   S ...Show All

• SQL Server Report and Images on Interanet

  Hi - I wonder if anyone has tried to display images from a intranet site when I try to do it the images doesn't get render and ends up as [x]. And the same report executed in VS gives me the following error: The value expression for the image ‘image1’ contains a URL reference, which is not supported. Any ideas IS it looking for a .com ... Limitation The URL is constructed as follow: http://servername/folder/imagefile Thanks   ...Show All

• SQL Server SSRS Question?

  Q1: Is there any utility available to convert Access reports -> SRS Reports Q2: Does SSRS support DB2 Thanks, Q1: In Report Designer, you can find an Access report importer that converts Access reports. http://msdn2.microsoft.com/en-us/library/ms156375.aspx Q2: Yes. SSRS supports any standard .NET data providers. ...Show All