carlp22's Q&A profile

• SQL Server Dates problem in SQL Server Everywhere edition.

  I have created a sample Database for the school project, After executing the query below, the Date column is supposed to have the dates I have entered before, However the dates shown are 1900. Any idea why is this happening I appreciate your help. Thank you. Query: Drop table AccountReceivable GO --BEGIN TRANSACTION Create table AccountReceivable ( AccountRecID int identity ( 1 , 1 ) not null, PatientID int not null, PresentCharges int default 0 not null, PaymentMade money default 0 not null, PreviousBalance money default 0 not null, BalanceDue money default 0 not null, LastPaymentDate datetime not null, PresentDate datetime default ...Show All

• .NET Development Nested XML Attribute Groups

  I had a quick question about nested attribute groups and the xsd.exe utility that comes with Visual Studio 2005 to generate a C# class from an XML Schema. From the following XML Schema: < xml version="1.0" encoding="UTF-8" > <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://www.test.com"> <xs:element name="Customer"> <xs:complexType> <xs:attribute name="Name" type="xs:string" /> <xs:attributeGroup ref="AddressAttributeGroup" /> </xs:complexType> </xs:element> <xs:attributeGroup name="MoreAttributes"> <xs:attribute name="State" type="xs:string" /> <xs:attribute name="Zip" type="xs:string" /> </xs:attributeGroup> ...Show All

• .NET Development Display autonumber

  I have a main form with an add new button that calls another form called frmNewBooking. My booking table has a primary key named bookingID that I want to display to the user every time he/she adds a new booking. Is there a way to display the generated bookingID in txtID on frmNewBooking when the form is 1st shown and everytime the user adds a new booking Note: Access DB used. Please do not refer me to: ms-help://MS.MSDN.vAug06.en/WD_ADONET/html/d6b7f9cb-81be-44e1-bb94-56137954876d.htm See the following: HOW TO: Retrieve the Identity Value While Inserting Records into Access Database By Using Visual Basic .NET The link you posted does not work for me so I don't know what it is about. ...Show All

• Windows Forms Need a Working Sample of DataGridView Link 2 Tables

  hello, I need working sample of a datagridview showing a relation between 2 tables as a link. I have 2 tables in my dataset. Table RNT_PETICIONES which has a COD_PERSONAL external key, and the RNT_PERSONAL table also has COD_PERSONAL as primary key. I have the DataSet in my project and the relation are corretly set. But when I bind PETITIONS to the datagrid I do not see the sub-link of the CLIENT table. I also tried doing this manually with no succes. Please post sample code here as I'm restricted to only microsoft.com -Thank You P.S. What I'm really interested in doing is getting varous columuns from different tables and showing them as 1 table in the datagrid, being able to edit the datagrid and saving the data to the cor ...Show All

• SQL Server Merge Replication not replicating updates

  I have an issue that is only occurring in a production environment. The architecture is filtered merge replication between two SQL Server 2000 SP4 databases. The publisher is standard edition and the subscriber is personal edition. The issue is that is I update certain rows on the subscriber the data is not replicated to the publisher. Inserts and deletes seem to replicate correctly. The issue is specific to certain rows in some tables. If I update other rows the updates replicate correctly. The subscription has been re-initialized once and it did not fix the issue. The replication process indicates that there was not data to merge and the subscriber updates remain and are at that point different form the publisher row values af ...Show All

• SQL Server Mirroring between Standard and Enterprise editions...

  Hi All, We are going to use database mirroring and database snapshots for reporting. The principal server runs SQL Server 2005 Standard Edition and mirror (reporting) runs SQL Server 2005 Enterprise Edition (64-bit). I failed to setup database mirroring trough GUI using SQL Server Management Studio and got this error: This mirroring configuration is not supported. Because the principal server instance, <server_name>, is Standard Edition, the mirror server instance must also be Standard Edition. But when I use T-SQL commands I was able to setup database mirroring and it works OK so far. SQL BOL says that one of requirements for database mirroring is to use the same SQL Server editions but I am wondering if it wor ...Show All

• Smart Device Development Virtual network not work with standalone emulator

  I downloaded and installed the netsvwrap.msi and the stand alone Pocket PC emulator. I verified that the virtual network device is displayed in the network properties. When I try to start the emulator, I get the error: Error. No VPC Network adapters enumerated or no host network adapter with provided MAC address found. I have selected the "Enable NE2000 network..." check box in the configuration but I still get the same error. Is there any thing special I need to do Thanks for the help. Saad What is your host OS There is a known bug on Windows Vista, where the emulator doesn't autodetect the virtual switch, but if you manually tell the emulator which netcard to bind to (by MAC ...Show All

• Visual C# equivlaent use of union in C

  I'm trying to use the equivalent of a union here. I'm getting the following error message - MissinngMethodException was unhandled. The code compiled OK but I get the exception. How should this be coded to work [StructLayout(LayoutKind.Explicit)] public struct DataType { [FieldOffset(0)] public string dstring; [FieldOffset(0)] public int dint; [FieldOffset(0)] public float dfloat; [FieldOffset(0)] public double ddouble; [FieldOffset(0)] public char dchar; [FieldOffset(0)] public byte dbyte; } public struct XMLData { public string Tag; public DataType Item; public XMLData(string tag, DataType item) { th ...Show All

• Visual Studio Integrating Leagacy Asp and Asp.Net(Framework 1.1) applications into VSS 2005

  Hi, I have a web application which uses both Legacy(Asp) website and Asp.Net(Framework 1.1) web application, both were using VSS 6.0. Currntly we are requested to define best VSS strucure by integrating both Legasy & Asp.Net applications under VSS 2005, nothing but upgrading from VSS 6.0 to VSS 2005. My request is to, are there any best practices for define some best VSS structure in VSS 2005 and how to integrate Legacy(Asp webstie) & Asp.Net(Framework 1.1) web applications into a single VSS 2005 Database. Thanks in Advance. Srinivas ASP and ASP.Net are different enough that branching & merging between them would probably not be useful. I'd just add them as separate folders (or "projects" as they're ...Show All

• SQL Server Do not delete things, it bites

  Hello, I noticed that when you delete things or substitute tables, you get in trouble. - Delete a named query used in a partition before deleting the partition - Delete a named Calculation from a table in the Ds view, whathever you do - Replace a table with another table which has less columns even if none of the lesser columns are used nowhere. The XML do not get updated accordingly leading in all kinds of errors, some requiring restore from an older version. Just a FYI. BTY, I do not know how to submit bug reports. Philippe Build 9.00.2175.00 Yes, the changes you made in DSV will not propagate to other linked ojects. Since you are deleting things from DSV, the related binding ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Index Buffers

  There doesn't seem to be a Help item on index buffers in XNA Studio, so I followed the Draw 3D Primitives item and I managed that successfully. I also implemented the Apply an Effect item that uses a simple shader, works as well. Then I followed the chapter about index buffers form Tom Miller's book Managed Dx9 Kickstart, and most of the stuff seems to be the same, however nothing gets drawn on the screen. Here's the code related to the drawing.. //indexed cube VertexPositionColor [] indexedCube = new VertexPositionColor ; //some vectors for the vertices of the cube Vector3 topLeftFront = new Vector3 ( -1.0f, 1.0f, 1.0f ); Vector3 bottomLeftFront = new Vector3 ( -1.0f, -1.0f, 1.0f ); Vector3 topRightFr ...Show All

• .NET Development Missing msvcr.dll -- FOUND!

  Greetings! I got tired of seeing the "missing msvcr.dll" for 10 files when I scanned Norton's WinDoctor & One Button Checkup.  www.dll-files.com   doesn't have, as recommended by other posts --  -- So, I decided to run SEARCH to see if it was on my computer -- somewhere else.  And, IT WAS!  I found in  c:\WINDOWS\WinSxS\..... folder So, I copied & dropped into the c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 NOW, NO MORE ERRORS OF MISSING FILES !! My question is -- WHY CAN'T MICROSOFT POST THIS MISSING .DLL FILE SO PEOPLE CAN INSTALL IT People are posting all over these boards about this missing file !!  They are having to go all over the internet to get a file tha ...Show All

• .NET Development COM Interop not co-op(erating)

  Could someone help me out on this For brevity I will try and keep this initial post short - cut right to the problem. Further detail will be added as requested. The problem I figure is a simple one, but one i cannot seem to crack....yet. I have a simple .NET control, the code is given below, and is self-explanatory. Simply cut and paste it into a new VS2005 Visual C# Windows Control Library project - call it ...say... XDotNetControl To make this control COM-accessible go to the project's property --> Application tab, click Assembly Information and check "Make assembly COM-Visible". Then on the Buid tab, scroll to the bottom and check "Register for COM interop". Now build it - it will have entered all the ...Show All

• Visual C++ why doesn't the cursor piont to the excuted line in single step debug?

  i use vc2005. when i debug in a function,the cursor doesn't piont to the excuted line. it piont to the third line before the excuted line.but in other functions , everything is normal.why Are you using C++ or C++/CLI   I opened a bug where yellow arrow, a.k.a. "next statement (not called the cursor), would point to the wrong line during single-stepping in C++/CLI code, but it was a relatively rare scenario that was apparently already fixed for SP1. ...Show All

• Windows Forms Ownerdraw tooltips

  This is my first post in any area here, so sorry if this is in the wrong area - if it is, can someone please redirect it to the right area Thanks. I am having trouble with "ownerdraw" tooltips. I have them working just fine - except that the window that is popped up containing my owner drawn text, is permitted to partially be offscreen. It looks as though the underlying .net code is positioning the window based upon the size of the tooltip.SetTooltip("junk string") call (which I had to do inorder to get tooltips to fire at all). I am returning the proper size of the tooltip via the tooltip PopupEventHandler PopupEventArgs.ToolTipSize - and the tooltip window *is* the correct size, it is just always positioned as tho ...Show All