473,321 Members | 1,667 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,321 software developers and data experts.

data access with .net - visually or programatically?

BK
I am gently moving my database applications from vb6 to c# . I would really
appreciate if experienced c# database programmers among you could advice
whether I should connect to sql databases visually using server explore
controls or do it programatically as I have always done.

Kaz


Nov 13 '05 #1
1 1157
BK
Thanks Mariano. Your advice is much appreciated.

Kaz
"Mariano Birnios" <ma*****@tectimes.com> wrote in message
news:0a****************************@phx.gbl...
Hi!

I'm not a db programming guru, but maybe I can point you
some things...

If you use the visual designer (server explorer, etc.) to
connect to a database, you are actually "creating code" in
your project, in a visual way. That code, has a relation
with the visual elements you have created, so if you
change some property in the property window, that change
is reflected in your code...

So, as the desinger will just type code, I always prefer
to write my own.

But, also, there are other importan things. You must know
the code that the designer generates. For example,
probably you are creating a "typed dataset" with the
designer, but maybe is just enough with a simple dataset
created by you at the code window... without all the
overhead of typed datasets...

In a big project, I prefer not to use the visual designer
at all. If I have to write some small PIM, maybe I just
drag & drop a little...

Cheers...
Mariano

-----Original Message---->I am gently moving my database

applications from vb6 to c# . I would really
appreciate if experienced c# database programmers among

you could advice
whether I should connect to sql databases visually using

server explore
controls or do it programatically as I have always done.

Kaz


.

Nov 13 '05 #2

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

Similar topics

16
by: D Witherspoon | last post by:
I am developing a Windows Forms application in VB.NET that will use .NET remoting to access the data tier classes. A very simple way I have come up with is by creating typed (.xsd) datasets. For...
1
by: Susan | last post by:
I have a bound form and subform and am trying to enter the data in both forms programatically. The Linkmaster and Linkchild properties are set. My intent is to be able to look at the data before it...
2
by: Ashish | last post by:
hi all, i am just curious as to how to access the SessionState section in web.config file programatically and then to possibly change it , are there any .net standard classes to do this ? TIA...
5
by: jqpdev | last post by:
Hello all... I'm coming from a Borland Delphi background. Delphi has a specific component called a Data Module. In the designer the Data Module behaves like a windows form. A developer can...
12
by: Chris Springer | last post by:
I'd like to get some feedback on the issue of storing data out to disk and where to store it. I've never been in a production environment in programming so you'll have to bear with me... My...
2
by: JohnR | last post by:
When creating an msAccess db within the Access UI itself the fields that are text are NOT padded with blanks. For example, if I have a 10 char field and put in "HI" and then when I come back to...
3
by: Wired Hosting News | last post by:
Lets say I have 10 products in 10 different stores and every week I get a report from each store telling me how many items they have left for each of the 10 products. So each week I enter in 100...
3
by: RAR in WA | last post by:
I'm moving to .Net framework 2.0 from Visual Studio 2002/3 with more time on desktop apps than ASP.Net, although I have done a small amount in ASP.Net. Is best practice for ASP.Net now to use the...
1
by: ArunDhaJ | last post by:
Hi, I'm in need of help for solving the following problem: I've a page with two div tag as follows: <div id="divNormalView" runat="server"> <asp:listbox id="listSelectedMembers"...
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
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...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.