473,320 Members | 2,083 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

VB.NET / Access 2000 App

I have a sweet application developed in MS Access 2000, but need to
re-develop it in VB.NET to completely hide Access and make it a wee bit more
user-friendly.

I've developed MS Access/VB 5 applications in the past, but this VB.NET is a
whole new beast. How does one gain simple access to the database - other
than that butt-ugly Data Grid? I've been using Wrox's Beginning VB.NET, but
could sure use some suggestions on better reference materials.

Thnaks in advance for advice and kindness!
Nov 21 '05 #1
11 2520
Over the long term, you're best bet is learning SQL (inserts, updates) and
the DataReader. I have yet to see a data-bound control that wasn't more
hassle than it was worth.

--
Jonathan Allen
"roy_ware" <ro*****@discussions.microsoft.com> wrote in message
news:2A**********************************@microsof t.com...
I have a sweet application developed in MS Access 2000, but need to
re-develop it in VB.NET to completely hide Access and make it a wee bit
more
user-friendly.

I've developed MS Access/VB 5 applications in the past, but this VB.NET is
a
whole new beast. How does one gain simple access to the database - other
than that butt-ugly Data Grid? I've been using Wrox's Beginning VB.NET,
but
could sure use some suggestions on better reference materials.

Thnaks in advance for advice and kindness!

Nov 21 '05 #2
I've had to stay with and struggle using the DataGrid on more than a few
dozen occasions, but there are third party controls which I'm told are
pretty good. the OP should do a search on this.

I think Cor has used one or two, so he may have some comments on this.

Cheers

--
Terry Burns
http://TrainingOn.net
"Jonathan Allen" <x@x.x> wrote in message
news:ee**************@tk2msftngp13.phx.gbl...
Over the long term, you're best bet is learning SQL (inserts, updates) and
the DataReader. I have yet to see a data-bound control that wasn't more
hassle than it was worth.

--
Jonathan Allen
"roy_ware" <ro*****@discussions.microsoft.com> wrote in message
news:2A**********************************@microsof t.com...
I have a sweet application developed in MS Access 2000, but need to
re-develop it in VB.NET to completely hide Access and make it a wee bit
more
user-friendly.

I've developed MS Access/VB 5 applications in the past, but this VB.NET
is a
whole new beast. How does one gain simple access to the database - other
than that butt-ugly Data Grid? I've been using Wrox's Beginning VB.NET,
but
could sure use some suggestions on better reference materials.

Thnaks in advance for advice and kindness!


Nov 21 '05 #3
ML
The Infragistics controls are great, the grid is excellent.

"Terry Burns" <he**@now.com> wrote in message
news:uI**************@TK2MSFTNGP14.phx.gbl...
I've had to stay with and struggle using the DataGrid on more than a few
dozen occasions, but there are third party controls which I'm told are
pretty good. the OP should do a search on this.

I think Cor has used one or two, so he may have some comments on this.

Cheers

--
Terry Burns
http://TrainingOn.net
"Jonathan Allen" <x@x.x> wrote in message
news:ee**************@tk2msftngp13.phx.gbl...
Over the long term, you're best bet is learning SQL (inserts, updates)
and the DataReader. I have yet to see a data-bound control that wasn't
more hassle than it was worth.

--
Jonathan Allen
"roy_ware" <ro*****@discussions.microsoft.com> wrote in message
news:2A**********************************@microsof t.com...
I have a sweet application developed in MS Access 2000, but need to
re-develop it in VB.NET to completely hide Access and make it a wee bit
more
user-friendly.

I've developed MS Access/VB 5 applications in the past, but this VB.NET
is a
whole new beast. How does one gain simple access to the database -
other
than that butt-ugly Data Grid? I've been using Wrox's Beginning VB.NET,
but
could sure use some suggestions on better reference materials.

Thnaks in advance for advice and kindness!



Nov 21 '05 #4
I can't find reference in VS.Net to the DataReader. Is it like Infragistics
- something extra you have to buy?

It seems quite odd that developers are forced to purchase third party
solutions to what VS.Net can't do by itself. (Or have I completely
misunderstood?)
"ML" wrote:
The Infragistics controls are great, the grid is excellent.

"Terry Burns" <he**@now.com> wrote in message
news:uI**************@TK2MSFTNGP14.phx.gbl...
I've had to stay with and struggle using the DataGrid on more than a few
dozen occasions, but there are third party controls which I'm told are
pretty good. the OP should do a search on this.

I think Cor has used one or two, so he may have some comments on this.

Cheers

--
Terry Burns
http://TrainingOn.net
"Jonathan Allen" <x@x.x> wrote in message
news:ee**************@tk2msftngp13.phx.gbl...
Over the long term, you're best bet is learning SQL (inserts, updates)
and the DataReader. I have yet to see a data-bound control that wasn't
more hassle than it was worth.

--
Jonathan Allen
"roy_ware" <ro*****@discussions.microsoft.com> wrote in message
news:2A**********************************@microsof t.com...
I have a sweet application developed in MS Access 2000, but need to
re-develop it in VB.NET to completely hide Access and make it a wee bit
more
user-friendly.

I've developed MS Access/VB 5 applications in the past, but this VB.NET
is a
whole new beast. How does one gain simple access to the database -
other
than that butt-ugly Data Grid? I've been using Wrox's Beginning VB.NET,
but
could sure use some suggestions on better reference materials.

Thnaks in advance for advice and kindness!



Nov 21 '05 #5
the DataReader is part of ADO.NET
"roy_ware" <ro*****@discussions.microsoft.com> wrote in message
news:90**********************************@microsof t.com...
I can't find reference in VS.Net to the DataReader. Is it like Infragistics - something extra you have to buy?

It seems quite odd that developers are forced to purchase third party
solutions to what VS.Net can't do by itself. (Or have I completely
misunderstood?)
"ML" wrote:
The Infragistics controls are great, the grid is excellent.

"Terry Burns" <he**@now.com> wrote in message
news:uI**************@TK2MSFTNGP14.phx.gbl...
I've had to stay with and struggle using the DataGrid on more than a few dozen occasions, but there are third party controls which I'm told are
pretty good. the OP should do a search on this.

I think Cor has used one or two, so he may have some comments on this.

Cheers

--
Terry Burns
http://TrainingOn.net
"Jonathan Allen" <x@x.x> wrote in message
news:ee**************@tk2msftngp13.phx.gbl...
> Over the long term, you're best bet is learning SQL (inserts, updates)> and the DataReader. I have yet to see a data-bound control that wasn't> more hassle than it was worth.
>
> --
> Jonathan Allen
>
>
> "roy_ware" <ro*****@discussions.microsoft.com> wrote in message
> news:2A**********************************@microsof t.com...
>>I have a sweet application developed in MS Access 2000, but need to
>> re-develop it in VB.NET to completely hide Access and make it a wee bit>> more
>> user-friendly.
>>
>> I've developed MS Access/VB 5 applications in the past, but this VB.NET>> is a
>> whole new beast. How does one gain simple access to the database -
>> other
>> than that butt-ugly Data Grid? I've been using Wrox's Beginning VB.NET,>> but
>> could sure use some suggestions on better reference materials.
>>
>> Thnaks in advance for advice and kindness!
>
>


Nov 21 '05 #6
well vb 2005 is slightly better.

"roy_ware" <ro*****@discussions.microsoft.com> wrote in message
news:90**********************************@microsof t.com...
I can't find reference in VS.Net to the DataReader. Is it like
Infragistics
- something extra you have to buy?

It seems quite odd that developers are forced to purchase third party
solutions to what VS.Net can't do by itself. (Or have I completely
misunderstood?)
"ML" wrote:
The Infragistics controls are great, the grid is excellent.

"Terry Burns" <he**@now.com> wrote in message
news:uI**************@TK2MSFTNGP14.phx.gbl...
> I've had to stay with and struggle using the DataGrid on more than a
> few
> dozen occasions, but there are third party controls which I'm told are
> pretty good. the OP should do a search on this.
>
> I think Cor has used one or two, so he may have some comments on this.
>
> Cheers
>
> --
> Terry Burns
> http://TrainingOn.net
>
>
> "Jonathan Allen" <x@x.x> wrote in message
> news:ee**************@tk2msftngp13.phx.gbl...
>> Over the long term, you're best bet is learning SQL (inserts, updates)
>> and the DataReader. I have yet to see a data-bound control that wasn't
>> more hassle than it was worth.
>>
>> --
>> Jonathan Allen
>>
>>
>> "roy_ware" <ro*****@discussions.microsoft.com> wrote in message
>> news:2A**********************************@microsof t.com...
>>>I have a sweet application developed in MS Access 2000, but need to
>>> re-develop it in VB.NET to completely hide Access and make it a wee
>>> bit
>>> more
>>> user-friendly.
>>>
>>> I've developed MS Access/VB 5 applications in the past, but this
>>> VB.NET
>>> is a
>>> whole new beast. How does one gain simple access to the database -
>>> other
>>> than that butt-ugly Data Grid? I've been using Wrox's Beginning
>>> VB.NET,
>>> but
>>> could sure use some suggestions on better reference materials.
>>>
>>> Thnaks in advance for advice and kindness!
>>
>>
>
>


Nov 21 '05 #7
Roy,

Why use a datagrid when you can use nice controls which you can bind to a
datatable as you want to do it real nice?

You can use for that the labels, textbox, combobox, datetimepicker etc etc.
(Not all).

Here a little sample what has in fact everything in it beside the getting it
from and updating it to the database

\\\needs a combobox and a textbox on a form
Private Sub Form1_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
'This beneath you normally will get using a dataadapter
Dim ds As New DataSet
Dim dt As New DataTable
ds.Tables.Add(dt)
dt.Columns.Add("Id")
dt.Columns.Add("City")
dt.LoadDataRow(New Object() {"1", "Amsterdam"}, True)
dt.LoadDataRow(New Object() {"2", "London"}, True)
dt.LoadDataRow(New Object() {"3", "Paris"}, True)

'Here start the sample
ComboBox1.DataSource = ds.Tables(0)
'This above tells what table is used from the dataset
ComboBox1.DisplayMember = "Id"
'This tells what is displayed in the combobox
Dim cma As CurrencyManager _
= DirectCast(BindingContext(ds.Tables(0)), CurrencyManager)
'this keeps track of the current rows in the table
TextBox1.DataBindings.Add(New Binding("Text", ds.Tables(0), "City"))
'this tells what field of the dataset is used in the textbox.Text
End Sub
///

I hope this helps,

Cor
Nov 21 '05 #8
Hi Roy

This is from experience of a similar situation. vb 2003 is not that easy
specially due to a steep learning curve and even when you know it there is a
lot of coding. It just eats into man-hours. What I would strongly suggest is
to wait till vs2005 (expected around sept at the moment). If you can't wait
then start playing with vs2005 beta 2 to learn which you would have to do
anyway with vs2003. Then may be there is another ctp in a couple of months
which is stable enough to be used for actual development.

Regards

"roy_ware" <ro*****@discussions.microsoft.com> wrote in message
news:2A**********************************@microsof t.com...
I have a sweet application developed in MS Access 2000, but need to
re-develop it in VB.NET to completely hide Access and make it a wee bit
more
user-friendly.

I've developed MS Access/VB 5 applications in the past, but this VB.NET is
a
whole new beast. How does one gain simple access to the database - other
than that butt-ugly Data Grid? I've been using Wrox's Beginning VB.NET,
but
could sure use some suggestions on better reference materials.

Thnaks in advance for advice and kindness!

Nov 21 '05 #9
Precisely what I needed to know!!!

Can you recommend a book to help me learn this in more detail? I found a
book published by Wrox - Beginning VB.Net Databases - that seems to be a
fairly good primer, but my application is fairly advanced.

"Cor Ligthert" wrote:
Roy,

Why use a datagrid when you can use nice controls which you can bind to a
datatable as you want to do it real nice?

You can use for that the labels, textbox, combobox, datetimepicker etc etc.
(Not all).

Here a little sample what has in fact everything in it beside the getting it
from and updating it to the database

\\\needs a combobox and a textbox on a form
Private Sub Form1_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
'This beneath you normally will get using a dataadapter
Dim ds As New DataSet
Dim dt As New DataTable
ds.Tables.Add(dt)
dt.Columns.Add("Id")
dt.Columns.Add("City")
dt.LoadDataRow(New Object() {"1", "Amsterdam"}, True)
dt.LoadDataRow(New Object() {"2", "London"}, True)
dt.LoadDataRow(New Object() {"3", "Paris"}, True)

'Here start the sample
ComboBox1.DataSource = ds.Tables(0)
'This above tells what table is used from the dataset
ComboBox1.DisplayMember = "Id"
'This tells what is displayed in the combobox
Dim cma As CurrencyManager _
= DirectCast(BindingContext(ds.Tables(0)), CurrencyManager)
'this keeps track of the current rows in the table
TextBox1.DataBindings.Add(New Binding("Text", ds.Tables(0), "City"))
'this tells what field of the dataset is used in the textbox.Text
End Sub
///

I hope this helps,

Cor

Nov 21 '05 #10
That's a good idea, but unfortunately, I can't afford to upgrade any further
at this time!

I maintain my software levels myself, doing some programming to keep my
hands busy so that one day I can get a job programming again!

"John" wrote:
Hi Roy

This is from experience of a similar situation. vb 2003 is not that easy
specially due to a steep learning curve and even when you know it there is a
lot of coding. It just eats into man-hours. What I would strongly suggest is
to wait till vs2005 (expected around sept at the moment). If you can't wait
then start playing with vs2005 beta 2 to learn which you would have to do
anyway with vs2003. Then may be there is another ctp in a couple of months
which is stable enough to be used for actual development.

Regards

"roy_ware" <ro*****@discussions.microsoft.com> wrote in message
news:2A**********************************@microsof t.com...
I have a sweet application developed in MS Access 2000, but need to
re-develop it in VB.NET to completely hide Access and make it a wee bit
more
user-friendly.

I've developed MS Access/VB 5 applications in the past, but this VB.NET is
a
whole new beast. How does one gain simple access to the database - other
than that butt-ugly Data Grid? I've been using Wrox's Beginning VB.NET,
but
could sure use some suggestions on better reference materials.

Thnaks in advance for advice and kindness!


Nov 21 '05 #11
Roy

It seems that for AdoNet the book from David Sceppa is the Bible.

Cor
Nov 21 '05 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: chicha | last post by:
Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I...
2
by: Scott | last post by:
Any help would be grateful :-) Problem: When I test my installation of Access 2000 MDE, I get the following error: "Unrecognised Format".. This means that Access 97 cannot read Access 2000. ...
3
by: Pat | last post by:
We have a database with Access 97 as the front-end and SQL7 as the back end. It is on a network server and accessed by joining a MS Access Workgroup. We are trying to add a new user and have...
3
by: Scott | last post by:
Hi, If we want to compile an Access 2002 database and distribute it to others, will the compiled software run on any PC, like Windows 98, Windows 2000, etc. Also, you don't have to have...
6
by: Serious_Practitioner | last post by:
....or lack thereof... I use Access 2000 which I own as part of Office 2000 Professional. I've had enough trouble with glitches to ask if these are common occurrences - 1. Sometimes the "Help"...
2
by: Jeff | last post by:
Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
0
by: com | last post by:
MS Access 2000 Password Recoverer 4.2 Screenshot - Soft30.com MS Access 2000 Password Recoverer will display the password to a MS Access database (*.mdb). This program works for MS Access files...
5
by: Mo | last post by:
Hello all, I'm trying to set up an access 2000 .adp project connecting to a SQL server 2005 database. I can set up the connection ok, but once I have completed the setup process, I get the...
3
by: NEWSGROUPS | last post by:
I am in the midst of trying to convert about 25 Access 2000 to Access 2003. The new environment consists of Office/Access 2003 and Outlook 2003. When converting the back ends I have no problems....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.