Data access advise

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
RegardsYou may have better results posting to the *.windowsforms.databinding group.
"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
>
>

DAAB ( sqlhelper ) Problem

Hi,

i am using sql 2000 and VS2005 ASP.NET 2.0

i have a problem using sqlhelper although i didn't notice it before (i've use it a lot)

the problem summarize as increasing of the connection (mayb 50+ for one user) which results in an pool size "Overflow"

i navigated the net i found many people speaking of an alternative from microsoft.

- i would like to know more information about the problem and

- is it the best alternative or not?

- and what is the best alternative?

thanx in advance

i would be pleased if you provide me with information

When using the DAAB to create datareaders, the default behavior is that the DAAB will create the connection from a connectionsting and when you have fully iterated over the datareader, the connection will automatically close. this occurs because the daab uses the commandbehavior of: CloseConnection

http://msdn2.microsoft.com/en-us/library/system.data.commandbehavior.aspx

Since you're leaking connections, you must be doing something to open these connections yourself and you will need to make sure that you close the connections when you are done with them.

TheEnterprise Library supercedes the DAAB, but switching to it will likely not solve your problem as you have a connection leak somewhere that you will really need to find in your code.

Customizing Toolbar in Reporting Service

Hi

I use SSRS 2005; i have a report with Drill down feature, connecting to another report. when i preview the report in the VS2005; i get a backup button in the RS toolbar to move from the second report to the main report after the drill down.

but once i deploy it on the server and when the user views the report on the web i dont get to see the BACK button.

Is it possible to do so?

anybody have tried and seen before....

/chandresh soni

There is no back button on the web-based toolbar. We thought that people would get confused with having a back button in the browser along with one on the toolbar. The back button on the browser will generally work except it will include other actions like toggles and sorts.|||

thanks Brain, for replying.

i will try something alternative. or ask the user to use the browser back button.