EldoChem's Q&A profile

• SQL Server Cross Row Referential Integrity

  In SS05 XML typed columns, is it possible to have cross row constraints and referential integrity Say I have a column with two schemas: Author and Book. Each has an ID. Each row in the table has only one author or book. Can I enforce that all Author ID are unique across all rows and that there is an author for every book Is it possible now If yes, how If no, is there a plan to add this feature in the future Is there any work around now ...Show All

• SQL Server Using ExecutionInstanceGUID as query paramter

  Hi all, I'm stuck here trying to use the system variable ExecutionInstanceGUID. During a first DataFlowTask I store the ExecutionInstanceGUID in a Table. Further in my Control Flow I want to get all rows with the current InstanceGuid, my query is pretty simple: SELECT ColumnA FROM D_Data WHERE InstanceGUID = In the parameter mapping collection I have added a parameter which maps to System::ExecutionInstanceGUID When I execute ...Show All

• Visual C++ How to check my ODBC data connection open or not?, pls help

  VC ++ 6.0 CDatabase db; db.OpenEx(_T("DSN=DSNklse;UID=sa;PWD="";")); TRY { db.ExecuteSQL(sqlQuery); } CATCH(CDBException, pEx) { TCHAR buff[80]; pEx->GetErrorMessage(buff,80); AfxMessageBox(buff+sqlQuery); pEx->Delete(); } END_CATCH I need to execute an insert query atleast 3 seconds once in my program, i dont want to open ODBC connection everytime i excute the "sqlQuery" like above. if i ...Show All

• Smart Device Development why the same code have different result between PC and PPC?

  why the same code have different result between pc and ppc Sample Code (run as windows form ): create a form , add treeView control and add code as show following  in form_load method. bool isSelected = false;    treeView1.CheckBoxes = true;    TreeNode tn;    for(int i=0;i<40;i++)    {     if(i%2==0) isSelected = true;     ...Show All

• Smart Device Development Evolution Of Mobile Gaming Industry

  I had a couple of thoughts that I wanted to share and take inputs on the same. Its been a couple of years, when the Desktop PC’s had started penetrating/entering Indian customers. No wonders, no one really had an idea of what to do with it. And it looked people buy it for playing games, as it looked to be the most happening thing to do with home computers. From students to businessmen. No one was aware of that the Gaming Industry is the big ...Show All

• Smart Device Development Transfer files between PC and PPC.

  I've searched for this no doubt frequently asked question to no avail. I want to copy files programmatically from a PC to the PPC, and back again, usually to the storage card. I'm using VS2005 VB.NET, but can convert from C# or C++. ---Mike Sriram Krishnan MSFT wrote: How are you connecting to the PC Is it over ActiveSync or is it over the internet Also, do you have some server ...Show All

• Visual C++ error CS0229: Ambiguity between 'XX.Name' and 'YY.Name'

  I tried to implement the following scenario in VC++ 2005 beta2: an object implements 2 interfaces, one defining a property get and the other defining a property set. This works perfectly well when implemented in C#. However, in C++, I get the compiler error message transcripted below. Here is the C++ source code: namespace NS {  public interface class INamed  {  public:   property String^ Name   {   & ...Show All

• SQL Server Is there a way to bound a search within specific TOC items?

  Is there a way to bound a search that I'm missing Can't figure out why major types don't appear in the search tab's drop down for content types (e.g "Full Text Search", "Tools and Utilities Reference", SQL Server Programming Reference"). Seems anything appearing in the TOC should be a candidate for bounding a search. Also, anyway to perform subsequent search that is bounded to a prior search result. No, you're ...Show All

• Visual C# What is significance of upper and lower case intellisence words

  When using intillisence, if I type in a word like string, I see that I can type it in lower case and it comes up blue, or in proper case, and it comes in in light blue. What is the significance Are they both words that are acceptable to declare a string variable Why do they have different colors Rather than have different languages have their own custom types that no others can access, the CLR provides co ...Show All

• SQL Server What is the best way for users to view cubes?

  Hi, Our company is about to purchase SQL Server 2005 as an upgrade to running the reporting out of MS Access (so I am new to SQL Server). I have been trying out Analysis Services cubes and would like to know how others using SQL Server are allowing users to view cubes. I am using the Cube Browser from within an Analysis Services cube project which is excellent. This made me think that there must be an equivalent program that end users are able t ...Show All

• Architecture Information about Essential Unified Proccess

  There is some information available about Essential Unified Process, if not, when this could be from Ivar Jacobson's site: Ivar Jacobson International are pleased to announce an event to formally launch the Essential Unified Process . This will be held at the Natural History Museum in central London UK on 27th June 2006. Essential Unified Process . This will be held at the Natural History Museum in central London UK on 27th ...Show All

• Visual Studio 2008 (Pre-release) MS SoapToolKit 3.0 - SoapClient30 Client calling a WCF server

  I get a Run-Time error '5415' when I call a WCF service from VB 6.0 with the MS Soap Toolkit 3.0 Error : connector: connection time out. HRESULT=0x800A1527 Client: Sending the Soap message failed or no recognizable response was received.   Unspecified client error.   Const WS_URL = "http://10.3.10.7:860/WS/ wsdl" Dim oWS As SoapClient30 Set oWS = New SoapClient30 oWS.MSSoapInit (WS_URL) strResp = oWS.Hello("VB", "Pas ...Show All

• Smart Device Development Disabling or deleting system programs

  I have the pocket pc os vs (I think) 4.20. I want to disable or delete the system programs like the games and and calculator. I tried to delete but there seems that there are backup instalation files that restore all of the programs that I delete when it reboots. Does any one no a way to do this. Thanks Another option is to delete the shortcuts in the start menu (under Windows\Start Menu). But the success of thi ...Show All

• Windows Forms How to populate Combox box in Datagrid view.

  I have a datagrid view show address details. It is also a input datagrid. When a new record is create, the datagrid view is empty. It contains a state combo box. I have set the state combo box column datasource to a dataset control called "dsState" In form Load. I do the below, however, the state combox box is still empty. DataTable dt = new DataTable ( "state" ); //DataRow dr; dt.Columns.Add( &quo ...Show All

• .NET Development Using a single connection object

  Hi, Let me explain Say, we have an application which accesses data a lot from the database and for every DB call a connection object is being created and then destroyed after the work done or We have an application which has a data access layer which helps in talking to the database and rreturning the result. How can we make sure that only one connection object is there at any time That's relatively cheap (crea ...Show All