Change GridView DataSource

[litton1]

Hi all, I am trying to follow a tutorial on template fields but it uses Access and i am using sql sever 2000.
how do i change the data source from this to sql server 2000?

<asp:AccessDataSource id="TypeSource" Runat="Server"
  DataFile="../Databases/eCommerce.mdb"
  SelectCommand="SELECT DISTINCT ItemType FROM Products ORDER BY ItemType"/>

...
<asp:TemplateField HeaderText="Type" ItemStyle-VerticalAlign="Top">
  <ItemTemplate>
    <asp:Label Text='<%# Eval("ItemType") %>' Runat="Server"/>
  </ItemTemplate>
  <EditItemTemplate>
    <asp:DropDownList id="EditType" DataSourceID="TypeSource" Runat="Server"
      DataTextField="ItemType" DataValueField="ItemType" SelectedValue='<%# Bind("ItemType") %>'/>
  </EditItemTemplate>
</asp:TemplateField>

I cannot find a tag same as this <asp:AccessDataSource for sql sever (could be me ... )?
Thx T.

Age is a consequence of experience

 

[jmeckley]

<asp:SqlDataSource ... />

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[litton1]

Thx Jason, cannot see wood for trees

Age is a consequence of experience