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 > december 2004

Need example binding UI to BL to DL
Posted by Frank Romano at 12/29/2004 10:47:57 AM
Hey, everyone. I have an application that was written in VB6 that I have to rewrite in VB.NET 2003 and I am completely lost. I have tried finding answers to my questions in MSDN and the newsgroups, but I'm only finding bits and pieces that just don't add up for me because I must not be using...more >>


reading and setting location for horizontal srcoll bar
Posted by ZR at 12/28/2004 5:55:03 PM
is there a way to control (get and set) the position of a Datagrid's, horizontal scrollbar? I am linking the datagrid to a very large table (hundreds of thousands of records) i cannot connect it to all the data at once since it would require lots and lots of memory. so i break up the tabl...more >>

Data Adapter Configuration Wizard-Where is Connection List?
Posted by Larry Woods at 12/28/2004 5:29:25 AM
I have moved some databases off of my computer. Now, when I open the Data Adapter Configuration Wizard the first time I have to wait about 2 minutes for it to determine that some of the connections are no longer available. If I knew where they kept the list of connections I could go in and delet...more >>

I need to fill a combo box from one table, but bind to another
Posted by Larry Woods at 12/28/2004 4:52:43 AM
This form is a "typical" data entry form where we might be collecting Customer information. I am trying to fill a combo box with a dataview that has (state,stateabbrev) as 2-col. rows. The State name will be the DisplayMember and the State abbreviation as the Value Member. But I want the di...more >>

Equivalent of VB5 'Seek'
Posted by Stephen Bowyer at 12/27/2004 10:13:50 AM
I'm finding the change from VB5 to VB.Net hard going! What would be the equivalent of Seek in .Net? I simply want to know if a particular value exists in mytable in mydataset - I don't need to display the dataset at all. TIA, Steve. ...more >>

ComboBox problem??? (newby in sight)
Posted by Najm at 12/26/2004 10:51:48 PM
Hi, I have a table (in MSDE2000) called ENTITE ("entity" in english) :) the table design is the following: CODE_ENTITE Char(8), NOM_ENTITE Char (50), DIRECTION Char (50). I have a combobox bounded to the table and that displays the 'CODE_ENTITE'. I want to have a Label or text box at the r...more >>

How do I deploy the correct Provider for the OleDbConnection??
Posted by max at 12/24/2004 7:26:08 AM
How do I install or make sure I have the correct Provider for OleDbDataReader. On my development machine (XP Pro, SP2, VS.net 2k3) everything works and I have the 'VFPOLEDB.1' provider available. How do I a) make sure this provider is provided and installed in my setup package or b) get t...more >>

Connection Timeout
Posted by M at 12/22/2004 2:15:01 PM
there are CommandTimeout for Connection object and Command object for vb6. If there are similar properties I can set for VB.NET when I use Dataset or Datareader? Thanks Chen ...more >>



Dataset vs datatable
Posted by Microsoft at 12/21/2004 12:52:14 AM
I'm reading through MSDN vb.net and I can't quite get what a dataset is vs a datatable I've written a program that creates a datatable then displays it in a datagrid control, but I also need to export it to a csv and am wondering if I should have used a dataset. ...more >>

VB express
Posted by Gonzo at 12/19/2004 12:15:50 PM
I am having trouble getting a data connection set up. I have no problem with the server explorer - it shows the database, tables and allows queries without a problem. However when I use the Data Source Configuration Wizard and navigate to the MDF file: C:\Program Files\Microsoft SQL Server\MSSQ...more >>

Simple Question - Access DB and VB updating Rows....
Posted by CXJ at 12/17/2004 10:11:50 AM
Hi, Does anybody know where I can find some information on Database access/update/delete through VB.NET I'm creating a program with multiple forms, which needs to select,add,delete record from an ACCESS DB. It is my first DB project and I'm totally lost... Any help I would greatly apprec...more >>

ADO Insert problem.
Posted by vinu at 12/17/2004 2:15:03 AM
We are having a strage problem wwhen we use recordset object for insert , it insert 3 more extra rows.. SQL : SET NOCOUNT ON;INSERT INTO F_BANK_STATEMENTS (STATEMENTDATE, STARTINGBALANCE, ENDINGBALANCE) VALUES ( '16 December 2004',3.00, 3.00);SELECT @@IDENTITY AS BANKID;SET NOCOUNT OF...more >>

Too many Oracle Connections
Posted by Bob at 12/14/2004 1:33:05 PM
Hi, I have a dataclass that opens a connection to an Oracle 8.1.7 database, causes a write by executing a stored procedure then closes and disposes its connection and command objects. Yet when I call this procedure repeatedly eventually I get a too many connections message. Using an Oracle mon...more >>

VB6 Question
Posted by sam at 12/11/2004 3:27:16 AM
Where does one post a VB6 Question? What i am tring to do is? Get the file date from a *.txt or *.dot file Reason is I want to compare the the date of the master file and if the master is newer than the current local file over write the older file Sorry for posting here if this is the wr...more >>

oledb, Insert and retrieve record
Posted by Paul Smith at 12/9/2004 5:38:55 PM
I want to insert records into a 'company' and a 'locations' table. They are linked. So I need to insert into company table first, then retrieve this record to get it's index, so that I can insert into Locations. What is the best method to retrieve the record I have just inserted when I don't k...more >>

DataTable and DataColumn event
Posted by jcvoon_99 NO[at]SPAM yahoo.com at 12/9/2004 10:47:10 AM
Hi: I'm from Delphi world, In Delphi TDataSet (similler to DataTable) I can use the following event BeforeInsert, AfterInsert : Trigger before and after add a new record into data table, in the BeforeInsert event i can raise an exception to stop the Add action BeforeDelete, AfterDelete...more >>

I need to run a vb.net or aspx.net file every 10 seconds.
Posted by Steve Jacobs at 12/8/2004 5:19:14 AM
Hi, I need to run a vb.net or aspx.net file every 10 seconds. The Task Scheduler in Windows 2003 Server can only do it every 1 minute at the minimum, but I need it every 10 seconds. Is it possible to write a small program in VB.NET that would run in the background without using much resources,...more >>

newbie problems
Posted by Tym at 12/7/2004 2:53:13 PM
Hi! Moved over from VB6 to VB.Net ADO.Net.... trying to get used a a new way of working. (No lectures on DAO please! I knew what I was doing with that!) Anyway. Trying to add a record to a "table" in my database. I've had to use SQL INSERT instead of the "proper" way as I'm damned if ...more >>

looking for a SQLSERVER class code generator
Posted by Andrew Baker at 12/7/2004 1:50:42 AM
I am loking for a class generator that will give me a vb.net class for accessing a sqlserver table. Something that gives an attribute for each column in the database, and insert and update ability. Does anyone have one they could recomend? TIA Andrew ...more >>

Find the size of a DataSet
Posted by Matt at 12/6/2004 8:55:59 AM
Hello, Is it possible to find the size of a populated DataSet? I have an application (VB.Net) that that populates a DataSet and then sends that DataSet to a PDA. The application on the PDA then uses that DataSet. The size of the DataSet makes quite a bit of difference to the transfer time ...more >>

Combo Box Listing Category
Posted by Jeremy Dillinger at 12/3/2004 12:29:25 AM
I have a program setup to pull data from a database. My database table has things such as (category, Item, price, etc.) In my program I want to have multiple list boxes that will have a pull down list of different categories. The category is stored as a number and the item is stored as a string...more >>

Is JET Support installed on Basic Windows Installation?
Posted by Daren Hawes at 12/2/2004 8:22:57 PM
This is a multi-part message in MIME format. ------=_NextPart_000_0058_01C4D8AC.D8DA0D80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi I am making a small App that will use a Access DB to store about 30 records. My question is what percentage of Clean...more >>

"Syntax Error or Access Violation" ???
Posted by scott.shelbourne NO[at]SPAM gmail.com at 12/1/2004 2:55:06 PM
I'm getting a "Syntax error or access violation" error when I try to run a SQLServer stored procedure from my ASP.NET application. I can run the same exact procedure from Query Analyzer with no problems. I have checked the security permissions on SQLServer and have ensured this user has db_owner...more >>


DevelopmentNow Blog