Davids Learning's Q&A profile

• SQL Server Delete Error of Dependent Row

  I am not able to delete a row due to the presence of its parent table. There is no circular relationship and the child has no dependencies when I verify the Delete trigger. Any advice See error msg below: Msg 30010, Level 16, State 1, Procedure tD_My_child_table_name, Line 43 Cannot DELETE last My_child_table_name CI because My_parent_table_name exists. Msg 3609, Level 16, State 1, Line 1 The transaction ended in the trigger. The batch has been aborted. This is probably a cusomt error you are catching here. Could you post the appropiate code snippet as well as the involved trigger implementation HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Software Development for Windows Vista Cannot uninstall WinFX Beta2 (April) error 1603

  Greetings. I have problem uninstalling the WinFX 3.0 Beta2. This is the latest beta before the current (June CTP) so I think it is Beta2 April CTP. I try to uninstall from Control Panel, and get this error: [06/26/06,09:50:58] Windows Communication Foundation Beta 2: [2] Error: Installation failed for component Windows Communication Foundation Beta 2. MSI returned error code 1603 [06/26/06,09:51:22] WapUI: [2] DepCheck indicates Windows Communication Foundation Beta 2 is not installed. [06/26/06,09:51:22] WapUI: [2] DepCheck indicates WinFX Runtime Components 3.0 - Beta 2 was not attempted to be installed. Ok, so it seems that I didn't have WCF installed , therefore I cannot uninstall WinFX So, I try to fnid the WCF Beta2 ...Show All

• Gadgets developers down rating other developers to get their stuff to the top not mentioning names (BAMKEE)

  Iv'e noticed that a couple of people are creating sidebar, live and myspace gadgets and spamming other gadget search tags with their own email addresses and gadgets and stuff. These people are also Down rating other live, myspace and sidebar gadgets to get their gadgets to the top of the lists. one person in particular is Bamkee who posted 3 gadgets almost identical and had 5 star average out of 20 ratings before he had even had 20 downloads. See for yourself: http://gallery.live.com/Author.aspx a=46ba5aeb-394c-4346-a7dd-e06825791322&l=1 This causes problems for people with genuine ratings. Me and my brother developed a sidebar gadget for ebay which has been downloaded 5100 times since november and had 56 genuine ratings unt ...Show All

• Visual C# Move form without titlebar

  Hello, How can I move a form without a titlebar Declare 2 Member variables in Form: private Point lastPoint; private bool mouseDown; Add Event handlers to 3 events of the form i.e MouseDown, MouseMove and MouseUP In MouseDown Handler put this code: this.mouseDown = true; this.lastPoint = new Point(e.X, e.Y); In MouseMove Handler put this code: if(this.mouseDown)      this.Location = new Point(this.Left - (this.lastPoint.X - e.X), this.Top - (this.lastPoint.Y - e.Y)); In Last Put this In MouseUP: this.mouseDown = false; That's it! Cheers ;) ...Show All

• Internet Explorer Development Hide part of address in IE7

  Is there any way to hide the entire address from the address bar or even just part of it I am developing a web application that includes another web application. That application uses the address bar to pass the user name and password, and I don't want that information to be shown. Thanks You should consider a different architecture. Anyone who watches their web traffic (say, with Fiddler from www.fiddler2.com ) will be able to trivially view the usernames and passwords. Simple encryption won't necessarily help you here, because the viewer can simply replay the encrypted credentials. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. kW X-port for 3ds Max 9 (X file exporter with XNA support)

  I have made a preliminary version of the kW X-port plug-in available for Max 9. The full Max 9 download from Autodesk is almost 3 GB and is still going, so I haven't been able to test it yet -- it's just re-compiled with their new SDK. I give it a good 90% chance of working fine, though :-) The version for Max 8 has been tested, of course, and is still available. It might work as far back as Max 6, because they are apparently version compatible from 6 through 8, but I have only tested on 8. kW has some features that might help with XNA usage, such as support for the Max Direct3D9 material with shader parameters; support for mirroring along Z and mirroring the V coordinate ; support for properly exported skinned meshes even if ...Show All

• SharePoint Products and Technologies Question about Sharepoint Security across domains

  Hey guys, I have a question about Sharepoint and how it implements security. In our sharepoint implementation we use NT Authentication to access several sites on the Sharepoint server. These users are in the normal form of Domain1\User. Each of those users were given individual access by the sharepoint admin (not me). We recently created a new domain which will supersede Domain1 and are moving users over to the new domain (Domain2). Now users on Domain2 are getting an NT Challenge window when trying to access sites and documents that they used to have access to. They can get around it by typing in the credentials for Domain1, but that isn't a good solution because that domain will be going away. I am not sure how to ...Show All

• Visual C# Capacity

  what is the capacity of Arraylist and the hash table in visual c#... There is no fixed size as capacity of all the collection classses in .Net whether it belongs to System.Collections or System.Collections.Generics namespaces inclduing both HashTable and ArrayList. As much as you add items in them its size is dynamically increased unlike normal arrays. Best Regards, Rizwan ...Show All

• Smart Device Development Invalid Cast Exception ... making me CraZZZy

  OrderDB.cs -------------------- public ArrayList GetOrderRowsByOrderID(int orderid) { conn = new SqlCeConnection(connstring); cmd = conn.CreateCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "select p.productid, p.productname,p.price, orow.quantity, orow.discount from orderrow as orow join product as p on p.productid = orow.productid where orow.orderid = @orderid"; cmd.Parameters.Add("@orderid", SqlDbType.Int, 4); cmd.Parameters["@orderid"].Value = orderid; ArrayList OrderRows = new ArrayList(); try { conn.Open(); SqlCeDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { ...Show All

• SQL Server Run Sql on multiple databases

  I need to run a same query on 15 different databases and union the results. Does any of the experts know how to do this with good performance Any help is appreciated. Thanks What are you trying to do You may get adequate performance just by executing the query: select column1, column2 from database1.schema.table union all select column1, column2 from database2.schema.table ... union all select column1, column2 from databaseN.schema.table The key is: 1. RAM - enough to work with the set in memory, if possible 2. Query plans - one slow query will run much slower than 15 fast ones (I just built a 26 query join on 15 million rows that runs in < 1 second.)) ...Show All

• Visual Studio 2008 (Pre-release) Using channel stack

  Hello! I am evaluating Windows Communication Foundation framework to discover, if it can be used to develop web service intermediary. I am trying to use a channel stack alone (without instantiating a service host, associating a contract, etc) for receiving and processing incoming messages. Here is an example of code which is running on the service side: ---CUT HERE using System; using System.Collections.Generic; using System.Text; using System.ServiceModel.Channels; using System.ServiceModel.Description; namespace WCFServer { class Program { static void Main(string[] args) { try { Uri address = new Uri("http://testserver:8080/EchoService"); CustomBinding binding ...Show All

• SQL Server Cannot Connect Remotely to HTTP EndPoint

  Dear all, I appologise that incarnations of this topic have been posted several times on this forum, however I cannot find a scenario that is the same as my own so I've resorted to starting a new thread. I can successfully create and connect remotely to an HTTP EndPoint on my Windows 2003 machine using Integrated security, the administrator username and password via my static IP address. I have read that Windows XP SP2 supports HTTP EndPoints, and it would be much more convenient for me to be able to create EndPoints in XP, and connect remotely. I have created the endpoint like so... CREATE ENDPOINT sql_tvr10 STATE = STARTED AS HTTP( PATH = '/sql/tvr10', AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR)) FOR SOAP ( WEBMETHOD 'Stor ...Show All

• Windows Forms Datagridview in MDI

  I created a form that housed a datagridview, handled all the datagridview events that I needed to handle and got everything working, when the form stands alone,SDI, however when I do this My .Forms.formWithDataGridViewthatwasworking.MdiParent = Me My .Forms.formWithDataGridViewthatwasworking.Show() where Me is the MDI form where I would like to house formWithDataGridViewthatwasworking,but the datagridview housed in formWithDataGridViewthatwasworking not longer behaves as expected, when, however I do this My .Forms.formWithDataGridViewthatwasworking.Show( Me ) everything works as expected. Just for clarity, In the above I specfiy the MDI form, Me, to 'own' formWithDataGridViewthatwasworking, I would however like to get ...Show All

• Visual Studio Express Editions VB 2005 Express + Crystal Report

  Hii All, Please help me I have installed Visual Basic 2005 Express Edition. But i can't see CrystalViewer (Crystal Report) controls in the toolbox. Can i make report in Visual Basic Express How to do it 2nd question, how long life time of Express Edition However, evaluation edition more help me I think the expiration is 30 days for the Express Edition. Crystal Reports 8.5 needs to be installed, I know that. Crystal Reports 8.5 needs to be the report development tool which connects to a dB. I don't know of any report creation abilities in the Express Edition. That's all I got. Z ...Show All

• Visual C++ Wow i am suprised i cant find this....

  I searched google i searched here and i searched mIrc and no one seems to know how to do this, they tell me to use a difrent compiler but i love microsoft and could not do that. I am sure you guys probably covered it some where but i can't find it so here goes. I use visual studio 2005 standard edition. I recently finished learning the core language of c++ and am moving on to implement that knowledge with win api in which i am trying to learn now. I am using this tutorial to learn win api http://members.fortunecity.com/harrycik/files/Forgers.htm. Obviously i cant use the old new >> console application >> empty project because it doesn't work, i tryed new >> win 32 project >> pre-compiled header and empty project but ...Show All