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 > march 2006

Problem with datatypes
Posted by Tom Rahav at 3/31/2006 12:00:00 AM
Hi, I use Visual Basic .net 2003 and MS Access as DB. I have a field called ID in a table called PersonalDetails in my database. For updating the data in this field, I do that by doing the following: Dim cnGeneral As New OleDbConnection(strConnectionString) Dim QueryStringPersonalDetails As S...more >>


Datagridview requery
Posted by Chris Strug at 3/27/2006 12:00:00 AM
Hi, As a learning exercise I have created a simple form which contains a DataGridView, a Textbox and a Command Button. The DGV is populated from a stored procedure which optionally takes a parameter to filter the data retrieved. When the form is first loaded, the DGV is populated from the p...more >>

exec sproc, return values to datagrid.
Posted by VB Newbie at 3/27/2006 12:00:00 AM
good day! im looking for a sample on how to load data to datagrid using sproc.. VB Newbie. ...more >>

haschanges not working?
Posted by George Hardy at 3/23/2006 2:02:45 PM
Hello all, I have a simple bound form for "vendors". This form opens from a list, and I use the fill method of the dataadapter to fill the dataset. However, when i change any data on the vendors form, and click the "save" button, I check to see if dsVendorDetail.HasChanges(). This alw...more >>

Rank newbie question
Posted by Chris Strug at 3/21/2006 12:36:31 PM
Hi, This is my first foray into vb.net and ado.net and was wondering if anyone could point me in the right direction. At the moment I'm attempting to create a simple form with half a dozen text boxes and button that when clicked executes a SQL Server stored procedure that inserts a recor...more >>

sql question
Posted by Nikolay Petrov at 3/21/2006 12:15:59 PM
I have three really small tables, which gave me a lot of headache. They reside in a MS Access database and a I am accessing them through ADO.NET(VB). Can't figure out how to make a "Select" query on them. These are the tables: 1St - "Transactions" TransactionID - primary key, autogen Transact...more >>

Help on data query
Posted by Nikolay Petrov at 3/20/2006 1:00:18 PM
I have three really small tables, which gave me a lot of headache. They reside in a MS Access database and a I am accessing them through ADO.NET(VB). Can't figure out how to make a "Select" query on them. These are the tables: 1St - "Transactions" TransactionID - primary key, autogen Transact...more >>

[VB2003] Deleting row doesn't set HasChanges?
Posted by marshallarts at 3/17/2006 10:25:43 PM
I have a datagrid on a form. The data source for the datagrid is a DataView onto a Dataset. I have a button which allows the user to delete the currently-selected row. When I do this, the row does disappear from the grid, so I must be deleting it from the Dataset OK. But when I close the form...more >>



Vbnet 2005 and databases + database bug ??
Posted by Marc at 3/17/2006 12:00:00 AM
Hi, I hope to find some information on this way, I used to develop databases in Access and want to try visual basic VB.net 2005 Could someone help me how to link 2 datagrid like in the first grid I want to show Customers and the second grid Customers Contacts from Customers. I also hav...more >>

Problem with ComboBoxes data bound to lookup tables
Posted by mjsterz NO[at]SPAM gmail.com at 3/16/2006 11:24:50 AM
I've been working with VB .NET for less than a year and this is the first time I've posted on one of these groups, so let me apologize beforehand if I'm being unclear, not posting my issue correctly, posting to the wrong forum, or committing some other sort of faux pas. My team is developing a...more >>

Bound Data Form not Datatable
Posted by Dominic A at 3/14/2006 8:37:20 PM
How can I tell if the current record on a from is new or one being edited ? EG I have created a form that is bound to a datasource, and the BindingNavigator. What I want to do is once a user has added a record and clicks movenext, check if the record is new or just a edited record. T...more >>

multi column combobox action
Posted by Dominic Anthony at 3/13/2006 2:48:22 PM
Hi All, I have some data that I would like to look up EG: ID Name 1 PersonName 2 PersonName1 3 PersonName Once the user selects the combo box I need to select that record. Now since two names could be the same, how ...more >>

Please help! Database won't update
Posted by Morten Dahl at 3/13/2006 2:50:22 AM
My database won't update?? I'm using VB.NET 2005 and SQL Server 2005 Express. I Create a Form and a database. Using the wizard draging the DatabaseDataSet Table on the form. Everything works fine. I can edit, delete, and add new records (save), but my changes are not visible when I close a...more >>

Learning VB 2005. Creating Your First Databbase
Posted by Dave Mills at 3/12/2006 12:00:00 AM
I hope this is the right group. There are so many to choose from. I am trying to work my way through the VS 2005/VB Express Guided Tour. I have not done any Database work with VB before. All is going more or less OK until now. I have completed the "MSDN Lib.../VB Express/Managing you records...more >>

Can you 'Query' a Dataset??
Posted by Don at 3/4/2006 10:05:36 PM
I haven't seen anything that suggests this is possible but I thought it wouldn't hurt to ask. (at least not too much) After a Dataset has been filled, is there a way to run a SQL query against that dataset to select a subset of rows to work with. What I mean is to initially fill the datase...more >>

Writing dates to Access
Posted by Doug Bell at 3/4/2006 12:00:00 AM
Hi, Can anyone help me with this? I am writing records to an Access MDB file from my VB.Net Application. Later retrieving the data from the last 10 (say) days. All works fine on my PC but on the Clients system it is writing the dates in US format up to 12th of the month and then correctly writi...more >>


DevelopmentNow Blog