Archived Months
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
all groups > vb.net data > may 2006

install Access 2003 mdb to network
Posted by Beth at 5/31/2006 12:02:01 PM
Hello. I'm writing an application that, for now, uses an Access 2003 database. If I install my application and the .mdb to c:\program files\vendor\app, it works fine. However, the data in the .mdb needs to be shared by multiple users, so I want the .exe and .mdb on a network drive. When ...more >>


check if row exists in table
Posted by Beth at 5/25/2006 3:39:01 PM
Hello. I need to import files from our network to an image server, but only if they haven't been imported already. I have a table storing records for each file that's imported, and I want to check that table to see if there's a row that matches the file's name and size. If it's there, I don...more >>

SSPI Issues
Posted by Aussie Rules at 5/25/2006 2:09:18 PM
Hi, About 8 times a day, all of a sudden I get the message 'cannot generate SSPI context' when trying to connect to SQL Server in my vb.net app. (also SQL Management fails at the same time, with same error) I have read up on this, and understand its a security issue, but why does it happ...more >>

Inline SQL vs stored procs on SQL Server 7 and 2000
Posted by kentk at 5/24/2006 9:37:01 AM
Is there a difference in how SQL Server 7 and SQL 2000 processes SQL passed from a program by an ADO command object. Reason I ask is I rewrote a couple applications a couple years ago were the SQL statements were inline. I basically took the SQL statements and put them into stored procs, wer...more >>

getting data from DBF into SQL Express
Posted by Burtamus at 5/19/2006 3:34:08 PM
I'm using VB.NET 2005 and SQL Express. I have WinApp set up and shows my clients with no problem. I receive a DBF file from a supplier and would like to suck that into SQL Express. Since SQL Express can't import the data directly, I'm working a coding it. I can connect to the DBF file using...more >>

how to add a reference in asp.net/vb.net?
Posted by Ben at 5/17/2006 8:27:39 PM
Hi, I need to add a reference in my project to a file (e.g. mysqldata.dll) in order to access Mysql. Using Visual Web Developer, i know how to do (menu website/add reference), but suppose i have no VWD or any tools, and that i create only one test.aspx file and another test.aspx.vb file with ...more >>

Create DB Example - It works, but is it right?
Posted by Miro at 5/17/2006 10:14:19 AM
Sorry forgot to post this on is forum, so this is also posted on microsoft.public.dotnet.langauges.vb I am teaching myself vb.net 2003, and I was wondering if someone can check my code. -It works, but i was wondering if i was on the right track or if I should have done it differently. ...more >>

DataGridView and ComboBox
Posted by Art at 5/12/2006 7:06:01 AM
Hi -- I hope someone can point me in the right direction I have a DataTable that I want to fill using a DataGridView. I've set the DataSource of the DataGridView to my DataTable. My problem is that I want some of the columns to be drop downs. For example, the user will need to enter a "p...more >>



Export DataTable to CSV file
Posted by Tom Rahav at 5/9/2006 5:36:36 PM
Hi, I have a DataTable that I need to convert to a CSV file, in the fastest and less resources demanding way. I did it by creating a MS Excel object, Worksheet object, etc. and running over each row and column in the DataTable and writing it to the Excel sheet. It's working, but v-e-r-y slo...more >>

Basic Database Questions
Posted by Miro at 5/9/2006 12:01:13 AM
Ok im a newbie to VB, and am having some trouble reading msdn help / or how it all links together. My books are either missing a step / or assume everything is set up correctly. I know about tables and keys but i just cant seem to find a "starting point" in VB.net. 1. Where do I go crea...more >>

SQL Aggregation Query
Posted by Liddle Feesh at 5/7/2006 6:06:25 PM
Dear Group, I appreciate that you are all busy; however I have a SQL programming task that I can't seem to get my head around at the moment. Any assistance will be very warmly appreciated. I have the following SQL view, which returns a Data Table, STOCK_TRADE, with the following data.. ...more >>

Aggregating groups of rows using SQL
Posted by Liddle Feesh at 5/7/2006 5:58:36 PM
Dear Group, I have a SQL coding problem, which I hope that you can help me with! I have the following SQL view, which returns a Data Table, STOCK_TRADE, with the following data.. CUSTOMER STOCK_CODE QUANTITY PRICE DATE J. BLOGGS MSFT 1000 535.50 10/05/2006 J. BLOGGS MSFT 2000 536....more >>

List SQL Servers in ComboBox
Posted by MATT at 5/5/2006 11:04:01 PM
I would like to be able to list all the SQL Servers on a local network in a comboBox. Much like the ODBC Wizard does it. Could someone point me in the right direction. I've Tried the SQLDMO, but that dosen't seem to exist in the VB.NET. Thanks MATT...more >>

Cannot create a new record?
Posted by TofuTheGreat NO[at]SPAM gmail.com at 5/4/2006 9:34:33 AM
Ugh. I'm starting to dislike ADO.Net. ADO seemed so much simpler. I'm creating a small database application for logging phone calls. The program is supposed to load a data entry screen where the user can enter the details of a phone call and then save the record. The functionality desired ...more >>

Design question
Posted by Lefteris Kororos at 5/4/2006 9:02:36 AM
I am developing an application in VB.NET to produce some reports. The back-end DB is an MS Access db. I have a table with the details of employees, a table with several projects, and a table with details for a specific month for each project. Due to the nature of the paying scheme of the emplo...more >>

Create SQL Statement with Form with many textboxes
Posted by MATT at 5/3/2006 3:25:02 PM
I have a form with about 50 textboxes that the user inputs information. When you click "Submit", it inserts the record into a SQL Database. Could someone recomend a better way of generating the sql statment. Right now i have: "Insert into Table (field1, field2, field3.... field50) values ...more >>

NULL Value - Specified cast is not valid
Posted by fniles at 5/3/2006 1:56:06 PM
I am accessing MS Access db with tblA whose column UNABLE can have NULL value. When I access UNABLE whose value is null, I got an error " Run-time exception thrown : System.InvalidCastException - Specified cast is not valid." either when I do IsDBNull(dr.GetString(0)) or dr.GetString(0) How...more >>

Cannot create data connection via drag-drop from server explorer in vb .net 2005 project
Posted by Chris Johnsen at 5/2/2006 3:59:24 PM
Hi, Posted this in the ADO non-.net newsgroup. Oops. Anyway, have a connection to a SQL Server 2005 database in my server explorer/data connections. I want to drop this onto my form to create a data connection. It won't let me do it. Get the circle-slash "can't do that here" cursor wh...more >>

Appending two data tables
Posted by Mark at 5/1/2006 1:06:01 PM
Hi - I'm looking for a code sample that will let me append a data table to a second master data table. You can assume that the tables' structures are identical. Seems like there should be a method to do this, but I can't find one. Thanks, Mark ...more >>


DevelopmentNow Blog