OLE72's Q&A profile

• Windows Forms Include the parent control when a child is cut / copied and pasted.

  Hi all, This is the final step in what became a rather involved process. The big picture is that I need to present a container control at design-time which does NOT clip its children. So yeah, I want for instance a child button control to be able to draw beyond its parent's bounds. I've gotten it to work by implementing an "envelope / hub" mechanism, where the hub is the above-mentioned container, and the envelope is its parent, another container which sizes itself to envelop the hub. When the user needs to "float" (ie. un-clip) the child button, it gets re-parented to the envelope and now has free reign to paint over the hub's bounds. All that to say, I have one final problem: when the hub is cut to clipboard, ...Show All

• .NET Development How to Close Connection When Using Data Reader

  In a Windows app, C#, VS 2005 I have a generic class which opens and returns a data reader to the calling class where the data is processed. The generic class, get DataReader, opens a connection and generates the reader as follows: cn = new SqlConnection(strConn); cmd = new SqlCommand(strSQL, cn); cn.Open(); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); In the calling class, after the data is processed, I have no way to close the connection cn, and the CommandBehavior.CloseConnection parameter does not seem to close it either. I have Max Pool Size = 3 in the connection string, and I get a timout error when I try to open the data reader the fourth time. The calling class's code is: dr = sqlClass.getDataReader(strSQL); ...Show All

• .NET Development how to install sql server based application on different computer

  hi, i am new with vb.net and sql server, i have just made an .net vb application with connectivity to sql server. The server was installed on the local machine at the time of development. As now i have build the application, i installed it on a different machine on LAN. but its giving error "The 'SQLNCLI.1' provider is not registered on the local machine." I think something else i need to install to get rid of it. Please suggest how do we make sql server based applications running on LAN connected machines. thanks Nitin The SQL Server Native Client is the runtime components that include the provider that you are trying to use... It is availible as a seperate download fro ...Show All

• SQL Server Format date in a Stored Procedure

  Dear friends, I have a stored procedure that returns some fiels. One of the fields is a datetime type. The field return in the follow format : 2006-11-13 0:00:00 How can I return only 2006-11-13 How can I use the format function regards!!! For example: I want to create the follow stored procedure: CREATE PROCEDURE TEST @ID INT AS UPDATE TABLE1 SET MyFieldTime=@MySystemTime WHERE MyFieldID=@ID Understood I want to save in my database th system time... Thanks!! ...Show All

• Software Development for Windows Vista Window Focus Issues

  ok, here goes....I'm running into some window focus issues in a couple places. Here is the scenario - I have an outlook COM addin that runs fine on Windows XP/Office 2003 (and earlier versions). One thing that this addin does is create an object housed in an ActiveX EXE (so it runs in a separate process). This object is commanded by the outlook addin to display a dialog box. By using an ActiveX EXE, this dialog runs in a separate process and is modeless to Outlook, yet the outlook addin can communicate with it. Under Vista and Outlook 2007, the dialog box presented by the ActiveX EXE Always appears behind outlook. I also have a similar issue where the addin may launch a URL in a browser by calling the ShellExecute command and p ...Show All

• SQL Server Transforming Tables in Sql 2005

  Does anyone know how i can transform the following table: ID Name StartQuantity EndQuantity Price 1 Title1 1 10 2.55 1 Title1 11 999999999 1.35 2 Title2 1 10 2.55 2 Title2 11 35 1.55 2 Title2 36 999999999 0.55 3 Title3 1 999999999 5.55 4 Title4 1 10 2.32 4 Title4 11 999999999 2.00 5 Title5 1 999999999 1.99 Into multiple tables like so: ID Name 1-10 11+ 1 Title1 2.55 1.35 1 Title4 2.32 2.00 ID Name 1-10 11-35 36+ 2 Title2 2.55 1.55 0.55 ID ...Show All

• SQL Server [264] An attempt was made to send an email when no email session has been established

  [264] An attempt was made to send an email when no email session has been established is the error I get when I try to send mail on the database. It is a SQL Server 2005 Standard edition. I have configured database mail and tested it and it works there, then I configured a database operator. then I just created a test job to notify the operator of the job completion, and the email fails. Any ideas Ryk I had the same problem but was able to make it work using tips from this web site. I have W2k3 Standard Server SP1, SS2K5 Standard SP1. Both SS (SQL Server) and SSA (SQL Server Agent) run with Local System account, automatic start up. 1. Configure Database Mail. Create the profile, specify your ...Show All

• SQL Server my problem also not solved yet

  Upper case sentece in normal case sentence Michael Hotek wrote: Of course you have to figure out what to do with exceptions such as O'Malley, acronyms, any sort of name and a variety of other things. There isn't a routine for doing this simply because there are a virtually unlimited set of exceptions to "proper casing" something. Thats what he was told in the other thread also... But I guess thats not what he wants to hear. He wants to convert a whole lot of CV text into propper cases, and the input is "only" uppercase. But i think the Word solution mentioned here is one of the best aproaches. (At least for a start... The result would still have to be proof read/edited) But if you want the text ...Show All

• Visual C++ debugger error

  It's called "No Debugging Information" error. It says "Debugging information for 'name.exe' cannot be found or does not match. Binary was not built with debugging information." I get this when ever I hit the debugging button. Can anyone help me with this Hi patio87, you must enable debug info in your VC++ project properties: C/C++ - General: Debug Information format. Use /Zi in release and /ZI in debug builds Linker - Debugging: Generate Debug Info: Choose Yes Rebuild your project and find a .pdb file next to your .exe file. That is needed by the debugger. Copy it next to your exe when you want to debug a crashed app. -- SvenC ...Show All

• Visual Basic Correctly exit application

  Which is the right way of exiting an application by clicking on an exit button I used the following code but someone is complaining that my application hangs out when he clicks the exit button. Private Sub btnExit_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles btnExit.Click End End Sub TaDa wrote: > I thought END was the main way or is that only okay for a single FORM project Anyone using "End" should be bound, beaten, tared and feathered, IMHO. Interesting view :P Seeing as the keyword "END" appears in many languages and has been doing so for a long time =\ ...Show All

• Visual Studio Express Editions Any other Controls like DataGrid?

  Are there any other Controls like DataGrid I know that textBoxes and lables,list boxes etc can be binded to show a value from the database,But are there any seperate Controls like DataGrid hi, dataGridView or any UI controls is just object to display data as you bind it, the problem could be in your SQL statment to retrieve data or in using different System.Text.Encoding, .net FrameWork 2.0 uses UTF8 as text encoding by default , so if you used different encoding some charachter might appear in funny way or show you some strange charachters i don't think the problem in DataGridView, to test create a project and from data menu add you database to your project, and from your datasource tab select your table chang ...Show All

• SQL Server Inserting with UpdateGrams

  Hello. I'm triing to use UpdateGrams to save data: XML: <updg:sync> <updg:before> </updg:before> <updg:after> <Image ProductList="11" ObjectType="3" MimeType="image/png" Content="AAAAAAAAAAQAC" EditDate="08/31/2006 14:27:16" AuthorID="5"></Image> </updg:after> </updg:sync> XSD: < xml version="1.0" encoding="utf-8" > <xsd:schema xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> <xsd:annotation> <xsd:appinfo> <sql:relationship name="ImageProduct" parent="Images" parent-key="ID&q ...Show All

• SQL Server Sending SQL Mail

  Hi, I am using SQL Server 2005. I have configured my email on Database Mail. when I am trying to send email using xp_sendmail I am getting problem error as: Msg 17925, Level 16, State 1, Line 0 xp_startmail: failed with mail error 0x80040111 I am using following sql statement master . dbo . xp_startmail 'myaccount' , 'mypwd' master . dbo . xp_sendmail 'tomail1@mail.co.in' , 'test' where myaccount and mypwd is my password on my email profile. 'tomail1@mail.co.in' is the destination email address.. thanks I had the same problem. It turns out my network administrator had changed the userid and password in Enterprise Manager, Management|SQL Server Agent|Properties and had failed to change the userid and pas ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Looking for suggestions on protecting game assets

  In my development I typically purchase royalty free content for meshes, music, etc. Although the content is royalty free I am bound by the terms of use to protect the content from re-use by others through reasonable means. In developing C++ based games for Windows I typically encrypt the data on the CD or in the distro and decrypt at load-time. My question here is, do you have any suggestions on how to protect content and still use the content pipeline and the XNA C# based game studio The code examples in the XNA docs should work just fine. NodeContent is definitely in Microsoft.Xna.Framework.Content.Pipeline.Graphics. Did you forget a using directive Sorry, I don't have any code examples handy. ...Show All

• Connected Services Framework WS-Disovery, WS-MetadataExchange, and UDDI

  What is the best way to catalog and publish all the disparate web services in my organization We have lots of different environments and platforms (C, PHP, COBOL, Java, C#, SOAP, XML-RPC) and I'd like to centralize a catalog of these services. UDDI has been around a long time, and I wanted to know if it were still the best practice, or should I be implementing WS-Discovery and WS-MetadataExchange for this purpose, or something else If WS-* is the way to go, and not UDDI, how do I create my service catalog using WCF Thanks, Mark Mark - MEX support is something you will be building in each service you are developing. However Service catalog (repository of services) is something we will be b ...Show All