Hi

I am new to sql server and need to build a one-many winform app with visual
studio 2008 and sql server backend and need some pointers.

I have the following questions;

1. If I create the app by creating a relationship between master and child
tables in dataset and then dragging the master table and relation onto a
form to auto generate everything, would that be a good enough way to cerate
the app? If so, what more can I do to turn it into a robust enough app such
as error handling etc? If this is not a good way to cerate app what should I
instead do?

2. Is there a good book on the subject of vs2008/vb2008 and sql server 2005
specifically, that will me sufficient advise on how to develop the app?

Many Thanks

Regards

I'd recommend creating your business logic layer comprising of the data
access layers as well. This book is a great reference for that
http://as.wiley.com/WileyCDA/WileyTi...470396865.html

If you are just starting out, check out these videos
http://msdn.microsoft.com/en-us/vbasic/bb466226.aspx

"John" <info@nospam.infovis.co.uk> wrote in message
news:uHBSHxe5IHA.2336@TK2MSFTNGP03.phx.gbl...
> Hi
>
> I am new to sql server and need to build a one-many winform app with
> visual studio 2008 and sql server backend and need some pointers.
>
> I have the following questions;
>
> 1. If I create the app by creating a relationship between master and
> child tables in dataset and then dragging the master table and relation
> onto a form to auto generate everything, would that be a good enough way
> to cerate the app? If so, what more can I do to turn it into a robust
> enough app such as error handling etc? If this is not a good way to cerate
> app what should I instead do?
>
> 2. Is there a good book on the subject of vs2008/vb2008 and sql server
> 2005 specifically, that will me sufficient advise on how to develop the
> app?
>
> Many Thanks
>
> Regards
>
>
>

John,

> If I create the app by creating a relationship between master and child tables in dataset and then dragging the master table and relation onto a form to auto generate everything, would that be a good enough way to ceratethe app? <

Yet, I can just speak for my experiences with VS 2005 and I could not
find a real use for the auto-generated code. It is a nice idea to
automate this time-consuming task, but a database and its relations
are usually too complex to have good results with auto-created code.

>If so, what more can I do to turn it into a robust enough app such as error handling etc? <

Most important is to have the proper constraints such as foreign key
and check constraints in the database itself to avoid bad data. Then a
lot of work on the forms waits if you issue the things manually:
create data bindings, load data, activate/deactivate controls, do a
pre-validation of input, save the user input back to the database....
For .NET 2.0 Brian Noyes had a book with some intersting hints on data
binding, but I have not seen this to be updated for 3.0 resp. 3.5.

Brgds

Philipp Post

I agree with Phillip. I don't recommend auto-generated code except for
learners. My book should be ideal for you--it's designed for those just
getting started with SQL Server 2005 and will you understand how
everything works and how to best leverage the power of SQL Server.

"bass_player" <bass_player@mvps.org> wrote in message
news:OEv0s7j5IHA.3528@TK2MSFTNGP06.phx.gbl...
> I'd recommend creating your business logic layer comprising of the data
> access layers as well. This book is a great reference for that
> http://as.wiley.com/WileyCDA/WileyTi...470396865.html
>
> If you are just starting out, check out these videos
> http://msdn.microsoft.com/en-us/vbasic/bb466226.aspx
>
> "John" <info@nospam.infovis.co.uk> wrote in message
> news:uHBSHxe5IHA.2336@TK2MSFTNGP03.phx.gbl...
>> Hi
>>
>> I am new to sql server and need to build a one-many winform app with
>> visual studio 2008 and sql server backend and need some pointers.
>>
>> I have the following questions;
>>
>> 1. If I create the app by creating a relationship between master and
>> child tables in dataset and then dragging the master table and relation
>> onto a form to auto generate everything, would that be a good enough way
>> to cerate the app? If so, what more can I do to turn it into a robust
>> enough app such as error handling etc? If this is not a good way to
>> cerate app what should I instead do?
>>
>> 2. Is there a good book on the subject of vs2008/vb2008 and sql server
>> 2005 specifically, that will me sufficient advise on how to develop the
>> app?
>>
>> Many Thanks
>>
>> Regards
>>
>>
>>

--
__________________________________________________ ________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
__________________________________________________ __________________________________________

Hi Bill

What portion of auto generated code is not good. MS videos do the drag and
drop auto generation http://msdn.microsoft.com/en-us/vbasic/bb643827.aspx
and that's confusing.

I am reading through your book the feeling I get till page 39 is that is
more to do with sql server and not too much about winform front end but I
may be wrong.

I need to develop a simple one-two many vb winform app with sql server back
end. The two confusing issues are data access and update strategies and
error handling.

Thanks

Regards

"William Vaughn (MVP)" <billva@NoSpamBetav.com> wrote in message
news:EF7F3295-EC3E-49EB-8102-9D3112CF4670@microsoft.com...
>I agree with Phillip. I don't recommend auto-generated code except for
>learners. My book should be ideal for you--it's designed for those just
>getting started with SQL Server 2005 and will you understand how
>everything works and how to best leverage the power of SQL Server.
>
> "bass_player" <bass_player@mvps.org> wrote in message
> news:OEv0s7j5IHA.3528@TK2MSFTNGP06.phx.gbl...
>> I'd recommend creating your business logic layer comprising of the data
>> access layers as well. This book is a great reference for that
>> http://as.wiley.com/WileyCDA/WileyTi...470396865.html
>>
>> If you are just starting out, check out these videos
>> http://msdn.microsoft.com/en-us/vbasic/bb466226.aspx
>>
>> "John" <info@nospam.infovis.co.uk> wrote in message
>> news:uHBSHxe5IHA.2336@TK2MSFTNGP03.phx.gbl...
>>> Hi
>>>
>>> I am new to sql server and need to build a one-many winform app with
>>> visual studio 2008 and sql server backend and need some pointers.
>>>
>>> I have the following questions;
>>>
>>> 1. If I create the app by creating a relationship between master and
>>> child tables in dataset and then dragging the master table and relation
>>> onto a form to auto generate everything, would that be a good enough way
>>> to cerate the app? If so, what more can I do to turn it into a robust
>>> enough app such as error handling etc? If this is not a good way to
>>> cerate app what should I instead do?
>>>
>>> 2. Is there a good book on the subject of vs2008/vb2008 and sql server
>>> 2005 specifically, that will me sufficient advise on how to develop the
>>> app?
>>>
>>> Many Thanks
>>>
>>> Regards
>>>
>>>
>>>
>
> --
> __________________________________________________ ________________________
> William R. Vaughn
> President and Founder Beta V Corporation
> Author, Mentor, Dad, Grandpa
> Microsoft MVP
> (425) 556-9205 (Pacific time)
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> __________________________________________________ __________________________________________
>
>
>

Hi

> access layers as well. This book is a great reference for that
> http://as.wiley.com/WileyCDA/WileyTi...470396865.html

Page not found. Could you provide book name so I can look elsewhere?

Thanks

Regards