Data access advise

2 Sep 2005 7:40 AM

John S

Hi

vs2005/sql server2005. I have created a simple winform app by dragging a
table on a winform. I have used stored procedures for data access. I have
the following questions;

1. Using the default code generated by vs2005 for data access, how can I
trap record insertion to set some field values before the record is
inserted?

2. The default data access works nicely for insert in the main table. I need
to insert a detailed record for every record inserted in the main table. How
and where do I implement this second insert?

3. If I type a value in 'Company' field on the winform, when record is saved
the underlying table contains that same value in every field that has word
"company" in the fieldname such as CompanyType, CompanyAddress etc. Why is
that?

Thanks

Regards

2 Sep 2005 12:36 PM

JT

You may have better results posting to the *.windowsforms.databinding group.

Show quote

"John S" <John@nospam.infovis.co.uk> wrote in message
news:ujjYWH5rFHA.508@TK2MSFTNGSA03.privatenews.microsoft.com...
> Hi
>
> vs2005/sql server2005. I have created a simple winform app by dragging a
> table on a winform. I have used stored procedures for data access. I have
> the following questions;
>
> 1. Using the default code generated by vs2005 for data access, how can I
> trap record insertion to set some field values before the record is
> inserted?
>
> 2. The default data access works nicely for insert in the main table. I
> need
> to insert a detailed record for every record inserted in the main table.
> How
> and where do I implement this second insert?
>
> 3. If I type a value in 'Company' field on the winform, when record is
> saved
> the underlying table contains that same value in every field that has word
> "company" in the fieldname such as CompanyType, CompanyAddress etc. Why is
> that?
>
> Thanks
>
> Regards
>
>
>