I need to update 4 fields of a 20-field table. The table has no primary key. I need to cycle thru each of the four fields for each record to manipulate the data before writing it to the DB. In VB6, we used recordsets which were always connected to the DB, but for some strange reason, MS decide...more >>

Have you successfully added a custom form and then retrieved the paper size using VB. I tried GetDeviceCaps(Hdc, PHYSICALWIDTH) GetDeviceCaps(Hdc, PHYSICALHEIGHT) and DefaultPageSettings.PaperSize But neither approach returns the correct values. If you've done the above successf...more >>

Hi all, I'm using the ToolStrip in .NET 2.0, and I can't seem to find a way to change the size of it. What I want is a toolbar the size of the IE toolbar, preferably with text below images if possible. Can anyone shed any light on how to do this? Thanks, Alex Clark ...more >>

Hi all! Aspiring VB programmer losing hair <And Sleep> over this problem. I have spent several days researching through the various usenets and resources to no avail, and so now I am taking the next step. Situation: I have a form (Form 1) with a datagrid that has a context menu for adding...more >>

Anybody have any code for selecting an appropriate printer and printing an envelope? Greatly appreciated....more >>

I am designing a table to contain a field to stores a value that must indicate none, one, or many choices. The form will have a group box with checkboxes (multi-choice) You see the records in this table contain partially pre-configured records. The records serve as "master" data that will late...more >>

Hi I have a DataGrid which has combos in the first field. These combos are populated via a DataView from another table. When I click the header of the field i.e. to sort it, the rows are sorted via the foriegn key in the combo, rather than the value that is actually displayed. How can I get...more >>

assuming I have 2GB memory. And 1.5GB available. dim c1(,) as byte redim c1(1000, 1024*1024) throws system.outofmemoryexception. I'm like... huh? Initially I thought a lot of space is taken up by GC. So, I up my memory to 4GB. Same thing.... So, I read microsoft documents on this type of...more >>

I am trying to create a form using databinding to a dataset and one of the fields requires the user to select from a list of optons. Any hints on how to do this other than bind the field to a label or text box to display the current field value then add a combo box with the list of items to c...more >>

This should be simple. I have a VB 2003 project that needs one VB 2005 component (I cannot just port the project as a key component is currently 2003 only). I created a class in VB 2005, tested it and compiled to a dll. VB 2003 will not let me reference this dll and says it is not a valid ...more >>

When I select textbox1 I want all text in it to be selected. I used the textbox1_enter event to run textbox1.selectall() This works if I tab to the box but not if it is selected by clicking on it. I hat to have to put textbox1.selectall() in the click event too. GotFocus event doesn't wor...more >>

I get an error when I try to execute the following code using ADO.Net in VB.Net: conn.open sqlString="CREATE LOGIN test WITH PASSWORD = '1qaz2wsx'" command=new SqlCommand(sqlString) command.connection = conn command.ExecuteNonQuery() The error occurs when executing the ExecuteNonQuery lin...more >>

I am using VB 2005/.net building a web site i have created a login screen using a Login control. I need to validate the user no/password entered by the user against an SQL Server database table. I can not figure out how to do this? do I need to write some VB to read the SQL table or is ...more >>

I want to return the proper Null to the SQL Database if my property is nothing Also I thought about creating a function so I don't have to put so many if statement for each property for each classes etc. However if I call ReturnValue(myClass.CompanyName) and CompanyName is Nothing then it crash...more >>

In VB.Net (1.1 framework), I have a datagrid that displays records from a SQL table. Only some of the columns are editable. When the user changes data in 2 and only 2 of the columns, I want to perform some calculations. There are about a dozen fields, only 3 of them are editable and I only wa...more >>

I'm using the System.Data.OleDb for SQL Server access, and it works perfectly. However, I see a lot of code examples that use System.Data.SqlClient. So I try it and it and can't get it to work. Here are my samples. Why does Oledb work and SqlClient not? ' At the top of the module: Imports S...more >>

Hi all, I want to use DictionaryBase as base class. The search performace matters lot. I have used a hashtable in a similar situation. This class DictionaryBase has a innerhash table so i guess the performace should be the same. Question. Would there be any perforamce difference f...more >>

Don't know if this can be done, but if I have a DataTable/DataView that has an integer column. Is there a way to do a "LIKE '123%'" kind of a filter on the column, which obviously works for text a text column. Thanks. ...more >>

What's the difference between these two methods? 1 - Parameterrized SQL queries: Dim CommandObject As New Data.SqlClient.SqlCommand With CommandObject .Connection = myConnection .Parameters.Clear() .Parameters.Add("@TextField", SqlDbType....more >>

Here's a good one for the gurus out there. I'm building a custom application that will query a web-service to get data. The users are broken into two groups. Group 1 is the in-office staff that are connected to the network. Group 2 is the remote staff that must connect via dial-up connectio...more >>

how to set default printer using vb.net? tia, mcnewsxp ...more >>

Hi there, I have a application to run OpenOffice version 2.0 as background process and I have windows service is running to check if OpenOffice is running or not. If it's not running I will call process class in vb.net to run OpenOffice as command line. The problem is my program is hanging ...more >>

Our company wants to standardize all our new programs. We are using .NET 2.0 and VB.NET against an Oracle Database and SQL Server Database. One suggestion was to have a single sign on and based on the sign on, list the programs available to the user. The user would select the program they w...more >>

Hi EveryBody: In Vb.Net 2003 : How can I add HTML Code to windows application project ? for example: <HTML> <HEAD> <title>WebForm1</title> </HEAD> <body MS_POSITIONING="GridLayout"> <form id="Form1" method="post" runat="server"> </form> </body> </HTML> Any help or redirection will...more >>

Hi, I am new to multitier app development. I am working on a windows app that will have business layer and data access layer components. When users log into the client app, it connects to the business layer to get a list of records that it then uses to populate a datagrid. The business layer...more >>

I have a collection of images that I need to give the user the option to print. I've googled the web and can't find anything that appropriately helps me with this. Basically, I want to loop through the collection of images and print them. If the images is larger than an standard size paper I...more >>

I have a class that accepts String and Long datatypes. Class Menu Private FirstTier as String Private SecondTier as Long Sub New(ByVal FirstTier As String, _ ByVal SecondTier As Long) .... Ok...great. this works fine but the problem arises as a result o...more >>

Group, i hope someone is able to help with this issue. I'd like the form to exit after certain logic calculation... i tried the me.dispose with in the Sub New() procedure, but it does not exit. i passed the boolean true parameter to the Protected Overloads Overrides Sub Dispose(ByVal di...more >>

Hi, I've been trying to create a multithreaded dll to be used for simple error logging to a file. The DLL will need to be imported into a .NET framework based application (Wonderware). I am having a problem importing into wonderware, getting the error message "...Denotes a field where a class...more >>

I converted a VB.NET 2003 app to 2005. I got error "SUB MAIN" not found. Why 05 requires a Sub Main to run? I never used Sub Main in my apps. Thanks Bill ...more >>

I am creating my own library (.DLL), I need to know the code to put a comments or Tooltip to my library. I want a Tooltip when I choose any function of my library when I working with, like the original library of VB when I press Ctrl & SpaceBar and I put the mouse point over the function name ...more >>

Hi, I have a VB.NET class library and I have to access a xml file that will always be in the same directory as the class library. So I use the followign code to open the file: Dim doc as XmlDocument doc.Load("C:\folderA\folderB\a.xml") Thing is though this path is subject to change....more >>

I have a vbscript which returns the folder size of any folder instantly by referring to Folder.Size. I don't need any iteration or recursion through the subfolders, adding together individual file sizes etc. But I can't find anything comparable in VB.NET or am I missing something? All the...more >>

I've posted my interview with Microsoft on the subject of WPF/E, which includes a cross-platform CLR able to render XAML and execute .NET IL, *probably* with JIT compilation. Microsoft will produce the Windows and Mac implementations, perhaps others, and will also license 3rd parties for other...more >>