SQL Server basics

[pmcguire]

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.

[Herfried K. Wagner [MVP]]

* "=?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>