ADO Code 66 Seconds Set dcndb = New ADODB.Connection dcndb.Provider = "Microsoft.Jet.OLEDB.4.0" dcndb.ConnectionString = "Data Source=" + dtbs$ dcndb.Open Set rsUsers = New ADODB.Recordset rsUsers.Open Sql$, dcndb, adOpenForwardOnly, adLockReadOnly DAO Code 20 Seconds Set rDb = DBEngin...more >>

I have a DataList control that I want users to be able to sort the data in by clicking 1 of 3 buttons. The function I have created to do this is as follows: Private Sub SortPoems(ByVal sortby As String) Dim ratedpoems As New DataTable Dim sqltext As String = "SELECT * FROM poemrat...more >>

Hi everybody! I am working with a controltab that shows several listviews in its respective tabs. The problem is that in this listviews some elements are checked in and some not (I mean rows) and I would like to show only those that are checked in. My idea was to remove the row from ...more >>

In VB6, when you do Format(Date$, "medium date"), you get something like "25-Aug-06". How can I do that in VB.NET ? Thanks. ...more >>

As we probably know, the MaxLength property of the TextBox control only works when the TextMode property is SingleLine or Password. I want to limit the number of characters a user can enter into a MultiLine TextBox to 250. I figured the best way to do this would be with a RegularExpressionVali...more >>

Hi all-- Two years ago I bought a copy of vbdotnet2003 and the book "Learn MS VBDotNet 2003 in 21 Days", published by Sams. I started working through the book, but lost interest. This Christmas, I decided I would continue trying to learn this language. I am not a programmer, and am tryin...more >>

I have a Dll I created in VS 2000. The namespace is MyFunctions and the Class is CryptoUtil. I have a program that is using the Class but it can't access it directly. I have a class (below) called CryptoUtil. The functions are Shared functions. I have this Dll in the bin folder of my ...more >>

My VS2005 is crazy. From time to time I get some unlogical errors. I need ServicePack! Where I can find it? ...more >>

As I begin to do more and more with programs built from scratch in 2005 instead of those converted from 2003, I'm finding differences that are confusing. Why can't I set the size of a label in 2005? I put it on the form and try to set it's size to 72,16. It jumps right back to 39,13. In ...more >>

Hi, I have a row in a dataset table which is nullable ( and also on the sql backend ), but how can I set it to a null. if I try Myrow.myDate = nothing when I test the row, I get "#12:00AM" wh ?? IDEAS ?? -- Goofy ...more >>

Hello I would like to use the 'using' keyword (available in c#) in visual basic. I have looked at the MSDN library but it does nat have this in vb. Does anybody know of a similar keyword/function in vb? Thanks Shahil ...more >>

I don't see the mainmenu item in the toolbox of 2005. I guess I haven't created a project in 2005 using it yet. I know I upgraded some from 2003 to 2005 and they show the control mainmenu on the form1.vb design page. What do I use? Menustrip?...more >>

I have a simple question regarding inheritance in a web form. I have a DropDownList in an aspx form. It is called DropDownList1 I have a class that will be overriding the render event so I have a snippet of this class: Public Class CustomDDL Inherits DropDownList Protected Overrides ...more >>

Hi All, I've been out of the loop for a while and now I see SP1 available VS2005. I'm running VS2005 Team Edition for Software Developers. When I attempt to install VS80sp1-KB926601-X86-ENU.exe on my VS2005 Version 8.0.50727.363 (SP.050727-3600) the installer says: "The upgrade patch c...more >>

Can I create control array (like TextBox array) in design mode. In vb6 I drow some control at the form and then I copy/paste controls. After that every control have the same name, but they have propetry index which is position of this control in the array. Can I do this in asp.net or I must ...more >>

In vb2005 Express: In My Project > Application > Splash Screen I have selected my splash screen form. The form opens on project startup but closes immediately before anyone would have time to read it. I presume it only stays visible while the main form initialises. This is not long eno...more >>

Is it possible to convert PDF data report to excel thru VB.NET? Currently I am generating PDF report in my application using crystal. The requirement is to also generate the same report in Excel. I know we can do this by creating Excel template and filling the template with required data. But ...more >>

I have a windows form (FORM1) and in that I have a Richtextbox control. I am loading another form (FORM2) from form 1. From FORM2 I would like to access the richtexbox control on FORM1. So I tried doing the following code in form 2. Dim m_Form1 As New Form1 MessageBox.Show(m_Form1.RichTextBox...more >>

Hi everyone... can anyone tell me how to fire textchange event of textbox that is in datagrid...as on the basis of that i wana fetch data from the database.if you can provide code snippet or any link than i'll be thankful to you... Thanks & Regards, Nil "Problem is just the distance between...more >>

In my code below at the line 'response' a blip sound is heard and the program exits the sub -- No MsgBox is displayed. What am I doing wrong? If nonNumberEntered = True Then msg = "Enter numbers only" style = MsgBoxStyle.OkOnly title = "ERROR in cast" MsgBox(msg, sty...more >>

Dear, I'm trying to save some settings in my.settings in VB.NET 2003, in 2005 this is no problem and I do it on the following way: Public Shared Property KleurKoud() As Color Get Return My.Settings.KleurKoud() End Get Set(ByVal value As Color) ...more >>

How to select all ListView items and then copy that to clipboard (VB 7)? Please help. ...more >>