K_L's Q&A profile
SQL Server Logical XOR operator in T-SQL (SQL Server 2000)
Hi all.... I was wondering why SQL Server 2000 lacks a logical XOR operator. Do you have a ready to use function that implements it How can I program one by myself I know that A XOR B is equivalent to NOT A * B + A * NOT B. So I tried to create this function : CREATE FUNCTION XOR ( -- Add the parameters for the function here @A BIT , @B BIT ) RETURNS BIT AS BEGIN RETURN NOT @A AND @B OR @A + NOT @B END But it didn't compile. How can I pass boolean values as parameters any other hint Thanks Jaime There is no boolean data type in TSQL and there are only few system built-ins like CONTAINS that can be used directly in a WHERE clause. So you need to use the XOR ...Show All
Windows Forms dfsvc.exe has encountered a problem and needs to close
I am getting the "dfsvc.exe has encountered a problem and needs to close" error when trying to install a clickonce app for a user that does not have admin rights. It works fine for admin users. I know other people have had this issue but I have not seen a clear cut solution. Does anyone know what is going on. Also, is there a log file that might have more information. I checked the event viewer on the machine and I see .Net errors with the following text: EventType : clr20r3 P1 : dfsvc.exe P2 : 2.0.50727.42 P3 : 4333af20 P4 : mscorlib P5 : 2.0.0.0 P6 : 4333ab80 P7 : 3450 P8 : 29 P9 : system.argumentnullexception Thanks I get the following error when attaching a debugger to dfsvc ...Show All
Smart Device Development The remote connection to the device has been lost.
Hi, I get the following message when I run my application on my pocket P.C. It happens randomly. Sometimes it works fine. Other times I get this message. I am not using any breakpoints. At the moment it is happening when I try to add data to a database from information got from a form. The con.executenonquery line causes this error. "The remote connection to the device has been lost. Please verify the device conection and restart debugging" Does anyone know why this happens, and if so, how to fix it Michael Michael Carty wrote: Hi, I get the following message when I run my application on my pocket P.C. It happens randomly. Sometimes it works fine. Other times I ge ...Show All
Visual Studio Express Editions Access a DLL C++ 2005
Hi guyz, it seems like im lost now, since, i ve been fighting with vc++ 2005 express for good few hours.... I have created a dll (MyDll) with C++ Expess and now i want to create and application using same C++Express that will be accessing the function MyDll in the earlier created dll file. I have tried many ways, even this link: http://goffconcepts.com/techarticles/development/cpp/calldll.html but no luck :( It seem to not work out for me, so if you guyz can tell me how to call dlls from c++ 2005 express application , i would be very gratefull. Or maybe sm1 knows some links where i can look up real examples of how to call dll's created in C++Express from C++Express console applications... many many thnks ...Show All
Visual Studio Team System Deleting Team Projects
How can I delete a team project from my TFS I can remove it, but it still exists on the server. I would like to delete it completely. Thanks. The same thing happened to me... how on earth do I delete the project from source control now The command line tool cannot see the project so there's no way to delete the source files that way it seems... *sigh* Also, try to create a new project with the same name - it will fail: Error Project already exists on the report server Explanation The name you typed for the new team project is already in use as a site on the SQL Server Reporting Services at {0}. The team project name must be unique on all Team Foundation server ...Show All
Visual Studio Team System Merging: How is the target branch determined (or: how to merge)
Hi, I am trying to merge a changeset into another branch. I'd like to know how Team Foundation Source Control determines what target branches are possible to choose. Let me explain by examplifying. My branch setup is this The root is branched into 2 separate branches, A and B A is later branched once more, so we have A and A.a. Now, I'd like to merge a changeset from the branch A.a directly into B without merging the change into branch A. Is this possible The target branches I get when I choose the A.a source tree is only A, not B. For the simple case this is true but I am going to write a blog post that shows how this fails for a lot of the complex scenarios and why we decided not to do it. Now that does ...Show All
.NET Development Accepting multiple requests in server socket
Hi, I want my server socket to accept mutiple requests arriving simultaneously. How can I acheive this Thanks very much Feel free to have a try with my network framework, I think you might do what you need with it kind of easily! http://metasharp.net/index.php title=MetaSharp.NET_framework ...Show All
.NET Development problem to access web services via isa server
Hi, I have the problem to access web services. The machine is behind the ISA 2000 server. When I try to add web reference, it will pop up the screen to enter the username and password. However, I enter the the username and password for our domain, it comes up the following message "The request failed with HTTP status 403: Forbidden ( The ISA Server denies the specified Uniform Resource Locator (URL). )." Should I configure the ISA to allow the traffic or Can I program the system to invoke web service via our proxy server. Advanced Thanks for people who replies. Cheers Fazul hi i am new to web service can u please guide how to create a proxy class using wsdl.exe the exact problem is i have already hosted the webservic ...Show All
Windows Forms DataGridViewImageColumn refresh issues
Howdy ladies and gents, I was working on a .NET module today that creates a DataGridView at runtime, docked at the top of the parent form, and populates it with a mix of Image columns (containing Icons rather than Images), TextBox columns, and Link columns, and I noticed that when the form is redrawn, the icons aren't rendered properly. The masked space from the "transparent" portions of the Icons are being rendered with whatever data was present in the previous frame. I've set the background color of the cells individually, in addition to setting it in the template for new records. Possible tip: if I minimize and then restore the parent window, the "transparent" portions of the Icons are painted in the normal ...Show All
Windows Forms Increase Winforms open performance
I have designed a main winform with some controls (from Infragistics presentation layer). When I run the application, it paint the windows very slow. Hoy can I improve the performance (I have tried ngen) i think this article may help you Practical Tips For Boosting The Performance Of Windows Forms Apps ...Show All
SQL Server PDF EXPORT
Dear All I use sql server reporting services..in visual studio 2005.. when exporting report to pdf in the report viewer alignment varies.. single table report split up in to two pages not in proper manner.. how to tackle this export to pdf event in report viewer.. did anyone can help me in this. Regards Senthil Thnx jhaberer its working fine!... ...Show All
Windows Forms How do I get these buttons to work?
I have made a simple form and have two buttons at the bottom. One of them I would like to be a reset button, the other I would like to set up to be a submit button to either send me the info in an email or to save the into to a file that I can access. I am using Visual Basic. I have 5 textboxes and 1 listbox. When the submit button is clicked I would like the form to send the info to my email address( charlie2163@fbcom.net ) and to then to close the form. As for the reset button I just won't put one. ...Show All
.NET Development Update a access db's with VB express
I have an access 2003 db's but no of the methods of the help index can insert an element to the database. I've tried with data adapters. The dataset of the db's try to update but no can do. help following the code Dim lect As IDataReader = Me .SistemasDataSet1.CreateDataReader sistemasDataSet.EstadisticasDataTable.Item(1).Rows.Add( "otros" ) 'sistemasdataset.tables("nombretabla o el indice de la tabla).row(i).colum("importe").tostring() + suma Me .EstadisticasTableAdapter.Insert( "joya" , "no ug" , "12 / 12 / 2006" , "tigre" ) other code on other button Dim dt As New DataTable( "tblDemo" ) Dim coche As DataRow Dim i As Integer Dim j As Int ...Show All
Visual C# Versatility/Practicality of C#?
Hey all, new to posting but ive been reading here for a few weeks. Anyway, on with my question (which probably has been asked in some way already)- How versatile is VC# compared to VC++ All I generally see are simple (*duck/cover* ) desktop applications. I've read that its possible to do game dev (including DX and OpenGL), but I have yet to find any engines done in C#. I have just looked at API's/engines/SDK's for games, but I have not gotten actually into manipulating/programming in them yet. I've done some basic reading on C# and I sort of want to get into it, but I plan on in a few years down the line working for Lockheed (or a defense contractor of some sort) or EA-Tiburon. I've been programming since I was probably around 10, ...Show All
.NET Development DirectoryServices 2.0 and DirectoryEntry.New(...)
If I do this: dim de as new DirectoryEntry("LDAP string", Nothing, Nothing) Will the constructor use the current user's credentials I'm having an issue concerning the problem listed here: http://forums.asp.net/thread/1343670.aspx It should. This is a link to how I authenticate against the active directory with vb 2005. ...Show All
