By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,417 Members | 835 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,417 IT Pros & Developers. It's quick & easy.

SQL Server basics

P: n/a
I have a Dataset containing a DataTable (say, 'dt1') that has all the fields that are contained in a SQL Server database's table. In addition, it contains a field (let's call it 'HasItems') of type boolean. I want to populate 'dt1' with all the records in the SQL Server table, and populate the 'HasItems' field with True if matching records exist in another SQL Server table (actually a view), and False if no matching records exist. I could do this easily in Access, but I'm new to SQL Server, and need to know the best way to go about it. (The way I'm doing it now has me thinking, "First the earth cooled, then the dinosaurs came...")

Specific help would be appreciated, but also a reference I could use to ramp up my SQL Server skills would be nice too

Thanks.
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
* "=?Utf-8?B?cG1jZ3VpcmU=?=" <an*******@discussions.microsoft.com> scripsit:
I have a Dataset containing a DataTable (say, 'dt1') that has all the

fields that are contained in a SQL Server database's table. In
addition, it contains a field (let's call it 'HasItems') of type
boolean. I want to populate 'dt1' with all the records in the SQL
Server table, and populate the 'HasItems' field with True if matching
records exist in another SQL Server table (actually a view), and False
if no matching records exist. I could do this easily in Access, but I'm
new to SQL Server, and need to know the best way to go about it. (The
way I'm doing it now has me thinking, "First the earth cooled, then the
dinosaurs came...").

ADO.NET group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.