VB or C# for SQL Server

B

Bob

I was woundering. Is one better than the other for building a windows app
that uses an SQL 2000 server behind it?

Bob
 
V

Val Mazur \(MVP\)

Bob,

It is a matter of your personal preference. For SQL Server it does not
matter at all, since it does not know what kind of language it is used to
build the application. In .NET languages are more a subject of the
preference
 
S

Scott M.

There is no difference in what .NET language you use, it is a matter of
preference. All the .NET languages perform the same and have the same
capabilities (more or less).
 
P

Paul Clement

¤ I was woundering. Is one better than the other for building a windows app
¤ that uses an SQL 2000 server behind it?
¤
¤ Bob
¤

VB is better. ;-)


Paul
~~~~
Microsoft MVP (Visual Basic)
 
C

Cor Ligthert [MVP]

Paul,
VB is better. ;-)

Sometimes it's better not to tell that.

By instance, if somebody is driving a Ferrari and somebody who cannot afford
that asks, "what is better? Than in my opinion a nice answer is. "It is a
matter of personal preference".

:)

Cor
 
W

W.G. Ryan MVP

Bob:

Since you do database access with ADO.NET and ADO.NET is a technology that's
not dependent on language, like everyone else said, it's pretty much the
same either way. There are language differences between the two that
necessitate using one over the other in some cases, but in respect to data
access, I don't know of even one. And even in those instances (i.e. needing
unsafe code blocks) you can use one language to build a dll and reference it
from another. And in the new 2.0 Framework, there are instances where you
can use both languages in the same project (as opposed to know where you can
use both in the same solution).
http://www.knowdotnet.com/articles/multilanguage.html
 
P

Paul Clement

¤ Paul,
¤
¤ >
¤ > VB is better. ;-)
¤ >
¤
¤ Sometimes it's better not to tell that.
¤
¤ By instance, if somebody is driving a Ferrari and somebody who cannot afford
¤ that asks, "what is better? Than in my opinion a nice answer is. "It is a
¤ matter of personal preference".
¤

Cor,

I didn't know VB.NET was a Ferrari. So what is C#, a Hyundai? ;-)


Paul
~~~~
Microsoft MVP (Visual Basic)
 
W

WJ

I didn't know VB.NET was a Ferrari. So what is C#, a Hyundai? ;-)

C#=Concorde. It crashed only once. Click here for more:
http://www.concorde-jet.com/

VB=Ford Pinto. It stalled too many times. Ford finally quit making it ! The
world is praying for BG to discontinue this product. Man should quit "dim"
this or dim that. So silly isn't it ! We are in th 21st Cent..

John W
 
E

Edwin E. Smith

I knew when I saw the subject line that this would quickly develop into a
religeous war. :)

I like C# better because it seems like there is more support for it and it
seems "cooler" to know C# than VB. AFAIK though there is nothing you can do
in one that you can't do in the other.

But then, what do I know? I'm just starting out.

Edwin
 
W

William \(Bill\) Vaughn

You're right. Mr. John Webbs (if that's what his name is) lost all
credibility with me because of his slam against VB.NET--something about
which he clearly knows very little. The reason you like C# is as valid as
anyone's--some people just like it better. It really makes no difference. If
you're used to Java you'll tend to like C# better. If you're one of the N
million VB developers, you'll tend to like VB.NET better. Judging VB.NET
based on what you know about VB6 or VBA is like judging a car's performance
by the color of its paint. Both languages compile to virtually identical IL.
Both have a zealot following and some that are multilingual. Both wait at
the same speed.

As far as which is best for SQL Server, the question does not make
sense--even if he's talking about CLR procedures for SQL Server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
W

WJ

William (Bill) Vaughn said:
You're right. Mr. John Webbs (if that's what his name is) lost all
credibility with me because of his slam against VB.NET

C'mon, Mr. William (Bill) Vaughn, wake up !!! This is a free forum, take
what you need, give what you can. One does not need your blessing just
because you write a few books !

JW
 
B

Bob

Hey All:

ok ok ok

The only reason I was asking was because I've been working in VB.NET for
awhile, purchased books on it, actualy liked it despite the bugs in VS 2003
but when I have trouble where no answer to be found in the book, I Google my
problem.

The thing is, I see the same type of questions asked relating to the problem
I might me having by a C# programer and answers given. However, in VB, I
see the question asked and very rarly is a solution given. Only vague
answers by Cor which amount to a whole lot of nothing.

I guess it can mean many things.

Four of which are as folows.

1) VB is so great that people don't need to join these groups
2) VB Sucks so people are switching to C#
3) C# sucks which is why so many people are joining those groups.
4) VB Sucks so people are switching to C# and finding that it also sucks but
C# is still new so there is still a lot of online support for it.

I guess the answer lies in a book store where I can find C# books so can
learn and decide which color Ford Pinto I want to drive.

Thanks for the amusing posts

Bob
 
C

Cor Ligthert [MVP]

Bob,

Why are you speaking about VB and C#? This is very vague,

It should be in my opinion C and VB or C# and VB.Net

You are replying here that my answers are very vague. Period.
What do you mean by that, maybe can you give concrete recent examples with
the questions and my answers on that?

How do you expect to get concrete answer if you are not able to define your
problem?

By the way, there are thousands of answers given on your question in these
dotNet newsgroups.

I tried to avoid to answer here because all the answers where already well
enough in relation to the way you asked the question and was only replying
to Paul, however, the best answer on a question as yours is in my opinion
this one.

http://groups-beta.google.com/group/microsoft.public.dotnet.general/msg/804482b9cce63bb7?hl=en

I hope that it gives you some help

Cor
 
B

Bob

Hello All:

Ok, sorry for the remark. I understand lang barriers as I'm American and my
wife is Indonesian.

My remark had nothing to do with that.

I spent days with Cor going round with a past issue I had and I did state
that did'nt want to use the bindingcontext(ds, "table").position to achieve
my goal. After a week of clarifying my question, he finaly responded with a
different way of using row positioning that would result with the same issue
as bindingcontext.

In any case, I found out on my own when I drove to NJ last weekend and
stayed at friends house who has a friend who has been programing VB since
mid 90's.

I admit that my experiance only goes back to VB 6 (and very limited at that)
which began right before VB.NET came out.

I don't believe this is a lang barrier thing as I have seen others in this
group.

Cor:

My 327 fields is working fine using panels that I set the visible property
to True as the user enters data.

When the user presses the down arrow on the last field in panel01,
panel01.visible = False Panel02.Visible = True etc ...

I also gave the user the choice of selecting the panel they wish to view
using Button_Click events

I do have a question. If you folkes don't want to answer me anymore, it's
fine.

When I'm done with this project, I will have many lines of code for the
visible property of these panels. I would like to move them to a Module.vb


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Label01.Visible = True
Panel01.Visible = True

Panel02.Visible = False
Label02.Visible = False

Panel03.Visible = False
Label03.Visible = False

Panel04.Visible = False
Label04.Visible = False

Panel05.Visible = False
Label05.Visible = False

Panel06.Visible = False
Label06.Visible = False
End Sub

I've tried a few different ways to move this to a Mod. Mostly nothing
happens. No error no nothing.

TIA

Bob
 
W

William \(Bill\) Vaughn

We agree. Cor has a lot to offer technically... it's just that he uses a
non-standard protocol to transmit it. I think anyone who's language skills
are good enough to just _participate_ in a technical forum should be
appauded. ;)

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
C

Cor Ligthert [MVP]

Bob,

To let not only Terry Burns (OHM) have fun, the thread you are talking about
was not done in a week and was not one, however where two different
questions which where almost both answered in the same day (although there
can have been a time lag situation and therefore two).

Therefore, I would not tell so loud that you are American; it can give a bad
impression about people from your nation, while I have until now only very
good experiences about that.

This where the threads where I tried to help you.
http://groups.google.com/group/micr...dingcontext+cor&rnum=2&hl=en#f41735e865ac9574

http://groups.google.com/group/micr...dingcontext+cor&rnum=3&hl=en#7d5d07dbbb3d042e

You understand probably not why, however based on your reflection about this
am I not able to answer the current question of you. I think that I
misunderstand you to much.

Cor
 
C

Cor Ligthert [MVP]

Bill,

Thanks.

However there is something that is in my eyes funny, I was answering that I
had read in another newsgroup from a major participant in this newsgroup the
difference between C# and VBNet people.

I deleted the message again because I was afraid that you would not read it
and than it was very vague.

Cor
 
B

Bob

Cor:

Don't judge Americans based on my frustrations. Also, Nationalism has
nothing to do with this issue.

People from all countries get frustrated at some point.

You can imagine my frustration when my friend asked me "Why are you using
untyped datasets Mr. MS Access Boy?" after I had done all that work.

Simply go with typed datasets in designer using the wizerds and create the
relations in the Schema and you will see your joined tables when you drill
down below the parent table. There you can select your fields for your
controles and you can have your MS Access scenario fun.

I had originaly tried this and it would work ok. Just sometimes the wizard
would not set the source column for the Original_CulumnName for any of the
fields.

No matter how many times I tried to regenerate the DataAdapter, it would not
work. The more I repeated the steps, the more it started making other
problems.

So again, after I spoke with my friend, I would run into the same problem.

That is what let me to the question VB.NET vs C#

So, I called him. He told me I was crazy until he was able to recreate the
problem. his response was that it's probably a bug. Simply create the
DataAdapters only 2 or 3 at a time, place my controles, bind my controles.
Save my project, test it and back it up often.

I was trying to create all 26 DataAdapters, Generate DataSet, Create
Relations, Save my project. Seems VB.NET can't handle that scenario.

Simply creating a few DataAdapters at a time, binding the controles, Saving,
Closing VS, Reopening, continuing seems to be working.

It's not my hardware (P4 3.0 Ghz, 80 GIG ATA 133, 1 GIG DDR 400)

Fortunatly, I was able to copy and paste all my controles from the first
project that has the untyped Dataset so I didn't have go through the boring
task of recreating all of them, lining them up etc ...

So, after all that, I decided to import the tables to SQL Server and use the
SQL DataAdapter wizards to generate Stored Procedures which seems nice so
far. Sometimes it still acts up and decides to automaticly create a second
sqlconnection and not create the proper field mapping which I find strange
but who kows what gets stuck in memory. So far, I have 16 backups of my
project. :)

Have a nice weekend

Bob
 
B

Bob

Cor:

By the way, you only posted 2 links to the group. I believe there were many
more than 2 post between you and me on that topic.

But you are right that it was only spread out over two maybe three days. And
yes, you were promt in responding.

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top