Answer Questions

• John5150 Memory usage

  When creating global variable there seems to be 2 options. Option 1 Global myVariable as String Then as needed in the code put in lines such as myVariable = "LeftHanded" or myVariable = "RightHanded" Then when you retrieve these variable they have some meaning. Option 2 Global myVariable as Integer Then as needed in the code put in lines such as myVariable = 1 or myVariable = 2 Unfortunately, if there are a lot of choices besides 1 and 2 it ...Show All

• Dave_W HELP with SQL Server

  This is probably something obvious that I overlooked, but it is a problem I have been having for some time, and I can't seem to fix it. The application is called Firstapp, and the database is called Database1.mdf. When I try to add a database (I have only tried this with a table) to my project, everything goes along well, but an error message pops up saying "An error occured while creating the new data source: Could not get type information for ...Show All

• Schneider Modifying the OpenFileDialog

  I'm trying to add a file preview and other functionality to this form but it has been mission impossible. There is a section here (msdn) were something similar is performed but it is done in VB.NET 2003 & I am in 2005, I get allot of errors. If anyone here could directed me in the right direction or provide me with an easy to follow example it will be greatly appreciated. Thanks in advance. William Hi, ...Show All

• Christian Liensberger - MSP Converting Julian Time Values

  I am a VB6 newbie trying to convert a Julian (1970) value to a standard date and time format.  The value I am trying to convert is the number of seconds since Jan 1, 1970.  Any help would be greatly appriciated. This example is in C#, but it should easily be convertable into a VB function returning a DateTime object: http://blogs.gotdotnet.com/brada/PermaLink.aspx/627ff4ee-d2d3-4e77-9a5a-7ade21910af9 ...Show All

• TimBailey99 getting files from FTP

  Hey, I got a Windows application that processes Excel files and transfers all data to a DB. These Excel files at the moment are being sent to Malta from Germany via FTP........ the user copies the files to another location (as the FTP directory is not accessible) and then browses for them using an Open File Dialog.... the application then does the processing needed! I would like to automate this a bit more. 1. How can I access the FTP server (NO ...Show All

• redflux MsFlexGrid

  I use MsFlexGrid in VB6 , My purpose is to let user to input several row then update to database such as invoice, I used to write a for loop of Recordser.Addnew. How should I replace this action in VS 2005 VB.NET uses a disconnected database model called ADO.Net. The datagridview is the control which you probably want to be using and this can be databound to a dataset. All your changes are made on this disconnected datas ...Show All

• Satyendra Gupta Getting primary key of record just INSERTed

  Hi. What is the best way of inserting a row of data to an SQL Server database and getting the primary key (identity) of the record you just inserted - preferably in as few statements as possible I've not managed to find any examples of this on MSDN. Is there a method that does this without requiring another SELECT statement following the INSERT Thanks, Mark Ups... Sorry - it's an old asp-thing... Conn is as sqlconnection a ...Show All

• Dick Roose quicksort not that quick

  hi, i am trying to sort a long list of strings (100,000+) in order to identify unique values in the list. So, i've basically tried Array.Sort, which is nice (but i'm not sure which sorting algorithm it uses) but seems to be rather slow, so i tried implementing my own Quicksort (from the msdn library) but that also seems to take 10mins+ (i gave up at this point) for a list of 131,000 strings. I've tried sorting the list in Textpad - which takes s ...Show All

• Siggi Bjarnason Printing Question?

  I have an A4 paper with already printed table as following:- -----|-----|------|------|--------|-----|-------|-------|------|     (line 1) ---1--|--1---|--1----|--1----|------------------------------ ----2-|--2---|--2----|---2--|------------------------------- ----3-|--3---|--3----|---3--|------------------------------ ------------------------------------------------------------- the above is approx shape on ...Show All

• Barb O RC1: "Compiler has encountered a problem..... NEED HELP from MICROSOFT

  I do have a rather big VB Windows Project and I get all the time interrupted by a compiler error &Hc0000005&. Have to restart. It happens while I edit the code, two three keys pressed and I get the compiler error. Don't think there is any error in the code itself. It is close to impossible to work with VS anymore. Thanks very much for your help - Thomas Thanks for your answer. I was considering hardwar ...Show All

• Andreas Schweizer Using TabPage and binding data

  I had a tab wherein there are two tabpages(tabList,tabEditList)...On the tabList there is a datagridview(dgvPatients) which displays all data of a certain coulumn(Name)..The table("PATIENT") where Name is a member had other columns(ID,LastName,FirstName...etc) I make this other columns hidden in the dgvPatients as what i only like to show here are the names...What i really trying to do is, all of other details of such certain name would be ...Show All

• cmh Creating, Adding and Viewing Data in a table

  I need to create a temp table in VB2005 and then add data so I can create forms and labels after I have gotten all the required infor from other SAP tables. I have enclosed my code and could really use some help. I thought everything was working but when I try and view the data in the temp table there is nothing or it just isn't showing up. Try Me.WBDataTableTableAdapter.WBFill(Me.WBDataSet.WBDataTable, New System.Nullable(Of Decimal ...Show All

• Lucianamaría Strange ListBox.Items IndexOutOfRangeException

  OK.. I'm building a plumbing company's job tracker. On each Job there can be multiple plumbers and each of those plumbers might have one more more invoices attached to a job. I've included the image URLs incase they don't show up correctly First I add a few plumbers and invoices... (http://hillcrestplumbing.com/VBIssues/Step1.JPG) Then I remove one plumber and his attached invoices... (http://hillcrestplumbing.com/VBIssues/Step2.JPG) Then when I ...Show All

• Chris_hruska ASPNet gridview

  I want to 'Add' row in database using Gridview. on Add button click event I add empty row in Datatble at the top and set EditIndex of gridview to 0. When I click on Update button and Row_Updating event fires. I tried to access new value using GridView1.Rows(e.RowIndex).Cells(1).Text . But it returns zero length string. All the examples I saw so far uses objectdatasource and template colom but non of them explains how to access new value ...Show All

• niv_7 What are square brackets used for?

  Hello all, just curious on this. What's the difference between something like Dim strName as String, and Dim strName as [String] And where/why would you use [ ] if there is a difference Thank you in advance. There is no difference.  I have found that some of the C# to VB converters will put brackets in where they don't really belong.  I recently converted a project and it changed all reference ...Show All