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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|