questions on databinding?

1. can it handle multi-user environment?
2. can be developed forcommercial application?
3. on parent/child binding, all records of parent are being retrieved, how about the child records?does it mean when you navigate, the child databindingsource will retrieve anew from the database and displayrecords thatmeets the parent/child relationship?
4.Is the connection open on databinding while form is running?(I sensed when you runthe form, the connection is open/closeprocess.)

enlighten me pls.
Grecko

Hi,

1. Do you mean different operations for different users? Yes, it can. When user runs the application, you can check the user role and give user corresponding action authorization.

2. You can use windows forms application for commercial application. If you are afraid of Windows forms security, please refer to the following page. It gives detail information about windows forms security.

http://msdn.microsoft.com/en-us/library/fk15fz9w.aspx

3. If you don’t handle any relationship of two tables or other data collection, the child will not show the corresponding to the data of the parent.

You can add the datarelathion to the parent/child datasource. FAQ 31 32 tells how to show master –details.

4. This depends on what you defined: when to get the data. If you get the data in form.load event, it opens the connection when user opens this form. If you use connection.open method and forget the close the connection, it may keep opening. When you use DataAdapter, if the connection is closed before Fill is called, it is opened to retrieve data, then closed; if the connection is open before Fill is called, it remains open.

If I misunderstood you, or you have further questions, please feel free to tell me.

Best regards,

Ling Wang

Hi,

1. Do you mean different operations for different users? Yes, it can. When user runs the application, you can check the user role and give user corresponding action authorization.

2. You can use windows forms application for commercial application. If you are afraid of Windows forms security, please refer to the following page. It gives detail information about windows forms security.

http://msdn.microsoft.com/en-us/library/fk15fz9w.aspx

3. If you don’t handle any relationship of two tables or other data collection, the child will not show the corresponding to the data of the parent.

You can add the datarelathion to the parent/child datasource. FAQ 31 32 tells how to show master –details.

4. This depends on what you defined: when to get the data. If you get the data in form.load event, it opens the connection when user opens this form. If you use connection.open method and forget the close the connection, it may keep opening. When you use DataAdapter, if the connection is closed before Fill is called, it is opened to retrieve data, then closed; if the connection is open before Fill is called, it remains open.

If I misunderstood you, or you have further questions, please feel free to tell me.

Best regards,

Ling Wang