Brent Newbury's Q&A profile

• Visual Studio Express Editions Problem with SQL query

  Hi I'm trying to write a query ---------------------------------------------- SELECT field1, field2, field3 FROM table WHERE field1=form.textfield ----------------------------------------------- Where form.textfield is a link to textbox in form. It doesnt understand this link. In previous versions (VB6) it works. Is there any changes in syntax in new VS Do not concatenate user input to a sql statement! Use parameterized query instead. This will avoid sql injection attacks. Something like this if you use the sql client. Dim strQuery As String = "SELECT field1, field2, fiel ...Show All

• Visual C++ Problem compiling a program

  Hi all, recently i had to work on a program which was running ok on VC++ 6. Due to certain restrictions i only can work with visual studio 2005 express beta 2. When i tried to compile the program in VS 2005 express beta 2, i got these errors which never occurred in VC++ 6: Compiling... STDAFX.CPP Compiling... Database.cpp DatabaseMarpos.cpp DataCom.CPP DBMarpos.cpp EBlockEntry.cpp EBlockLabel.cpp EdcsSettings.cpp EDCSSetupDialog.cpp extendedEBlock.cpp fileDB.cpp FisApiInterface.cpp c:\hsanew\datacom\fisapiinterface.cpp(400) : warning C4996: 'sscanf' was declared deprecated c:\program files\microsoft visual studio 8\vc\i ...Show All

• Windows Forms Detecting changes in nested properties using a PropertyGrid

  I have a control that I created a designer for.  One of the control attributes is padding, which I created a class for. It basically works similar to dockpadding.  I created a typeconverter for my padding class so it would show up correctly in the property grid when I use it in design mode.  [-] Padding  -  0, 0, 0, 0 All  &nbs ...Show All

• Windows Forms Create Form from Async-Callback

  Lo All I'm trying to create a Form from an AsyncCallback. The Form creates well but after that it doesn't react in any way. It's rather clear that the Form was created on another Thread (the callback Thread) and so it doesn't have a MessageLoop where it can catch Messages. So I somehow need to call the "Form-Creation-Code" in my Main-Thread where the MessageLoop is running. But I can't figure out how to do it. I played around with ExecutionContext, BackgroundWorker, SynchronisationContext, the Tread Namespace and and and... Here's a very very simple examle of the behavior: using System; using System.Net.Sockets; using System.Net; using Sys ...Show All

• Visual Basic Need help with serial communication project

  Hello, I'm using VB 2005 on a serial port project and need some general guidance on how to get started. I need to make a program that has no user interface and runs as a background process that will listen to a specific serial port, and when data is recieved interpret it and act accordingly. I am familar with VB and object oreiented programming, and have found the SerialPort class that I will use as the core of the program. My main question is how should I structure the program to achieve the desired function Thanks for any help in advance. ...Show All

• Visual C# Tips on posting

  Here are some tips on posting, so that your questions could likely be answered quickly. 1. Make your Title as significant as possible . Compose it in a way that you would ask an expert. example - "How could I change a Buttons Background " instead of "button background problem" 2. Explain in detail the nature of your dillema . But please make it short, straight to the point but descriptive. 3. Provide steps on reproducing your problem . So that other posters could replicate this on their pc's and thus find a quick solution. 4. Also, provide a Code Snippet where you think is causing the problem . This is a common situation that ...Show All

• Windows Forms Dynamic Data Entry Control

  Hi We are going to migrate a VB application to Windows Forms. The current application uses DataView Control from Green Tree. This is a kind of dynamic data entry control. We can specify the field type (Text Box, Check Box etc), data source (Table, column name etc), and positioning (width, height etc) and then, the control will generate all fields durin ...Show All

• Windows Forms DataGridView:Drag & Drop columns header to group by those columns

  Dear all, My application develops on DataGridView so I want to make it more convenient. One of requests of DataGridView is drags and drop columns header out of DataGridView to group by those columns . I think this is a challenging for DataGridView. On the other hand, this function is supported by a lot Microsoft Application (Ex: Outlook…). Therefore I think VS.NET 2005 will support this function in last version of DataGridView. However, I haven't found out this function in DataGridView yet, please help me to get it.   I am looking forward to hearing from you as you as possible. Thanks for your help.   ...Show All

• Windows Forms Problem with treeView - Object not set an instance to an object...

  I always have a problem when working with treeview. I have a treeview that looks like this: Root name - First node - First's node child1 - First's node child2 - Second node - Second's node child1 - Third node When I click on treeview this is code that is in treeView1_AfterSelect event private void treeView1_AfterSelect( object sender, System.Windows.Forms.TreeViewEventArgs e) { TreeNode tn = treeView1.SelectedNode; if (tn != treeView1.TopNode) { if (tn != treeView1.TopNode.Nodes[e.Node.Index]) { xml.ReadCodeContext(Convert.ToInt32(tn.Tag)); textBox1.Text = XmlContext.CodeText; ...Show All

• Visual C++ Does anyone know how to convert a *PWSTR to a char*?

  Hi, I'm writing a C++/COM applicaiton in V.S.2005 but I'm not using CLR for the managed code extension. I need to use strtok() that requires source to be a pointer to characrter string but I have it as PWSTR that is defined in the winnt.h as typedef __nullterminated WCHAR *NWPSTR, *LPWSTR, *PWSTR; It's been a while since I've done C++ code (I have been doing C#). I appreciate it if someone can help me out with this. Thanks, Alpha You would do much better to use TCHAR and the associated character independent macros such as tcscmp. Then any const strings should be defined as _T("MyString"). If you then need to ...Show All

• SQL Server Error with setup of SQL Server 2005 Express

  I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express. I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is: The setup has encountered an unexpected error in datastore. The action is RestoreS ...Show All

• Visual Studio Express Editions Using multiple data bound items

  Hello! Im very new to programing in VB. I have a database with info about some persons. I've managed to let the user select the name from the listbox and other info apeears on the form. Now I want to build in a search. I want to let the user to select gander, hair color, eyecolor etc. But if i use data bound items on gander I get gander info of every person (of course :P). So how to get in the gander combo box only 2 options (male/female) and get the result - info about all males/all females. I've tryed building querys, using DISTINCT command after SELECT but nothing seem to work. I have another little problem. I update an image allways w ...Show All

• Windows Forms Protecting methods from being resued after distribution

  Hi, I am using VB.Net. How do I create DLL files that contain function that perform various operations, like it is done in Win32 APIs.   In other words I want that once after my desktop app is distributed, some programer who gets hold of the DLL files adds them in their porject reference and start using the various methods that have been declared& ...Show All

• Windows Forms MSHTML event in VB works great but not so well in C#

  The problem is that code developed in VB to identify when a textarea click event has been raised work as expected. But having a very difficult time getting the same functionality in C#. The web page simply has a javascript to take the text from a input text element and places it in a text area element and raises the text area click event. Here's the vb code: Public Class Form2 Inherits System.Windows.Forms.Form Public doc As mshtml.HTMLDocumentClass #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeCompone ...Show All

• Visual C# How to convert an integer number to alphabet

  Is it possible in .NET to convert an integer number to alphabet Like this: 1 ---> One 2 ---> Two .... I don't want to create a mothod for this, I need a .NET module, like Int32.Parse(). Thanks for any help. Check this article http://www.codeproject.com/samples/number_to_text_converter.asp ...Show All