Stephen Inglish's Q&A profile

• Visual C# select statement

  Hi all, I would like to use select statement where something is "". For example, SELECT * from alm_history where userAck is "" how can I put this into a select string You have to escape the quote character. To read more about escaping, see this page, this page, this page and this page. Here is a little escape sequences table: Escape Sequences (Special Characters in C# St ...Show All

• SQL Server How can i debug triggers in a SQL Server Project?

  Hello, where can i read about using .Net language triggers in SQL-Server 2005. If i try to set a breakpoint in VS-Studoio and choose Debug/Attach to Process i get the Message "The breakpoint will not currently be hit. No symbols habe been loades for this doucument." And what is the correct syntax for the SQLTrigger Attribute Partial Public Class Triggers   ' Enter existing table or view for the target and uncomment the attribute ...Show All

• Visual C# Interaction between main program and dll

  Hi all! Could anybody give me an example of following: 1) Main program in C# that calls function Foo(Handle_of_My_Form) declared in my dll. 2) Dll in C++ with implementation of Foo that just calls PostMessage(Handle_of_My_Form, WM_USER, 0, 0). 3) Finally, main program catches this messages and show MessageBox "All right! I've caught it!". Please, help - I need to do this task as soon as possible. -- Sincerely, Dmitri ...Show All

• SQL Server Grabbing the Top Nth Records based on another table per group

  Hi All, I am trying to perform a SQl query that I have never attempted before. I have a table with records such that would look like this GroupField1 GroupField2 Field1 Amount AAA BBB Field1Data 23.00 AAA BBB Feld2Data 24.00 AAA BBB Field3Data 8.00 BBB CCC Field1Data 25.00 BBB CCC Field2 Data 23.00 DDD BBH Field1Data 232.00 I have a second table that is like GroupField1 GroupField2 NumberOfRows AAA BBB 2 BB ...Show All

• Windows Forms How do i pass control to another form in a button click event

  Hi I am new to windows forms. How do I pass control to anohter from in a buttons click event.  eg  When you click on a button located on form 1. It then shows form 2.  how do you do this.  Thanks  OOPS I th ...Show All

• Windows Forms MDI Childs

  Hi All, How to get the number of childs form was opened in MDI parent Thanks a lot Laputa MdiChildren.Length http://msdn2.microsoft.com/en-US/library/system.windows.forms.form.mdichildren.aspx ...Show All

• Visual Studio BUG: Add-In registration in VS2005 Beta 2 still not working

  Hi! I have installed VS2005 Beta 2 (Version 8.0.50215.44) and the latest VS2005 Beta 2 SDK (VSIP) and the registration of addins is still not working!!! The behaviour was already described in this thread "http://forums.microsoft.com/msdn/ShowPost.aspx PostID=15546#15546". It was announced in this thread that this problem should be solved with an installed VS2005 Beta 2 SDK. But it doesn't work and I have to stop my development after migrating ...Show All

• .NET Development System.Collections Related: Shared Data Storage in Memory

  Hi,      I am trying to use 2 memory storage blocks, such as 2 queues or 2 hash tables. And am trying to synchronize data between them by using the clone method but in seperate threads. i.e. q1.enqueue is continuous in thread1 q2=q1.clone() is again continuous in thread2 and I am clearing q1 after cloning. I tried locking q1 to give asynchronous access to thread1 & thread2, but seems like none of the locking mechanisms or ...Show All

• Architecture N-tier layer separations and connection/interaction

  I happen to be experimenting based on some examples I've found on the net but I want to be directed to the right path, those samples tend to be incomplete or misleading. In a typical N-tier scenario, which should reference which And is the use of Data Transfer Object in accordance to any best practice that maybe existing Accordingly, how does those layers supposed to connect/interact with one another eg. what does BLL passes to the DAL and w ...Show All

• Windows Forms call windows form from com class

  Hi, I have class library project with com classes and I need to add windows form to this project and able to open this form from one of com class procedures (like MyForm.Show). I add windows form to the project. when i compile my project with blanck (without controls on it) windows form, it is compiled and registered (automaticaly) in windows and another software can see it and use. if i add any controll (textbox for example) to the form i ...Show All

• Visual C# Visual Studio Tools for Office Startup Query

  Just starting with this technology, got a book and entered the first program: using System; using Excel = Microsoft.Office.Interop.Excel; using System.Windows.Forms; namespace ConsoleApplication { class Program { static bool exit = false ; static void Main( string [] args) { Excel.Application myExcelApp = new Excel.Application(); myExcelApp.Visible = true ; myExcelApp.StatusBar = &qu ...Show All

• Smart Device Development Painting on form outside OnPaint

  In .NET Framework I can do this: Graphics g = Graphics.FromHwnd ( Handle ); Pen mypen = new Pen ( Color.Black ); g.DrawLine ( mypen, 1, 1, 100, 100 ); But what I should do in .NET Compact Framework ( I write a program for my Pocket PC 2003). You can use code similar to the following. Graphics g = this .CreateGraphics(); Pen p = new Pen ( Color .Black); g.DrawLine(p, 1, 1, 100, 100); g.Dispose(); ...Show All

• Visual C++ Can I make just plain exe, no dll-s in VS 2005?

  I just finished my project in VS 2005. When I compiled a release version, it doesn't work on machines without VS 2005 installed! Is it even possible to make a exe file and distriubute it without an installer or, God forgive me, .NET framework How do you do that Solution Properties -> References ...Show All

• SQL Server Installing SQL Server 2005 Integration Services

  I tried removing and reinstalling SQL Server 2005 Developer Edition for three times, including "all-at-once" component installation and "component-by-component" and I just can't get Integration Services to install. Here is the setting: - I have WinXPPro SP2 - I had SQL2K and removed it - I installed SQL2k5 (as described above) I am getting the following error: Microsoft SQL Server 2005 Integration Services -- A component that you have specified ...Show All

• Visual C++ Just one more conversion question, please.

  I need to get the lResut into _bstr_t type so I can concatenate with other _bstr_t type string to form the DN for creating an Active Directory object. Please help me with this and I hope this is the last conversion I need for this code. Thanks a million! p.s. I assme the lResult in the 2nd SendDlgMessage points to a string of the name of the item selected in the comboBox. Is this correct typedef LONG_PTR LRESULT;//From windef.h LRE ...Show All