Hi EveryBody,
The Book MCTS asks me to add sql data adapter control from toolbox in VC# 2005 enviroment but i still can not find it in toolbox what should i do to add it to my toolbox

thanx

1. Right click any place in Toolbox and click "Choose Items..." in the popup menu.
2. Find "SqlDataAdapter" in the popup dialog and check it.
3. Click "OK"

You'll find it in your toolbox.

1. Right click any place in Toolbox and click "Choose Items..." in the popup menu.
2. Find "SqlDataAdapter" in the popup dialog and check it.
3. Click "OK"

You'll find it in your toolbox.

Did my respone resolved your problem?

thank you very much every thing is ok now.

i want to ask you another question : what is the best way to connect C# app client to SQl Server on the server.

Actually it depends, huh? ^_^

If you want to build an app as soon as possible, SqlDataAdapter is a great choice. And if you want to apply the N-Tier architecture or something object oriented, LINQ to SQL or some other O-R mapping framework are good choices.

For more information about LINQ to SQL, you could visit http://msdn.microsoft.com/en-us/library/bb386976.aspx

I'm using vs2008.

When I tried to add the sqldataadapter to my tool list, I followed the instructions you provided, and checked the box... however, it does NOT appear in the toolbox, even if I save VS and reopen. If I try again to add the control, it shows as checked, but still doesn't appear in the toolbox.

I'm using vs2008.

When I tried to add the sqldataadapter to my tool list, I followed the instructions you provided, and checked the box... however, it does NOT appear in the toolbox, even if I save VS and reopen. If I try again to add the control, it shows as checked, but still doesn't appear in the toolbox.

Hi,