DataGrids - Everything you ever wanted to Know

(fyi - most of this in your local QuickStarts website)

<asp:SqlDataSource  CacheDuration="5" EnableCaching="True"...

============================================================================
w/TextBox
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.objectdatasource.filterexpression.aspx
============================================================================

SIMPLEST WAY
============================================================================================================================
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/DataBind4.src
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/DataBind7.src
============================================================================================================================

***pretty cool*** could rearange code to print out comment below the paged GRIDVIEW
============================================================================
http://quickstarts.asp.net/quickstartv20/aspnet/samples/data/DataKeys_vb.aspx
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/DataKeys.src
============================================================================

GridViewStoredProc
=========================================================================================
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewStoredProc.src
=========================================================================================


w/DAL objects
============================================================================
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/objects.aspx#dal
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewDAL.src



GridViewPagingSettings - First, Next , Previous, Last  (w/NO TEMPLATE)
=========================================================================================
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewPagingSettings.src
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewPagingSettings.src


Advanced Paging & Sorting
============================================================================
http://quickstarts.asp.net/quickstartv20/aspnet/doc/data/advanced.aspx#pagesort
http://quickstarts.asp.net/quickstartv20/aspnet/doc/data/advanced.aspx#pagesort
http://quickstarts.asp.net/quickstartv20/aspnet/doc/data/advanced.aspx#pagesort
============================================================================
http://quickstarts.asp.net/quickstartv20/aspnet/doc/ctrlref/data/objectdatasource.aspx
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewDAL.src&file=GridViewObject_cs\App_Code\AuthorsDB.cs&lang=C%23+Source
============================================================================


w/BLL objects
============================================================================
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewObject.src
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewObject.src
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewObject.src&file=GridViewObject_cs\App_Code\AuthorsComponent.cs&lang=C%23+Source


OptimisticConcurrencyDataObject
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/OptimisticConcurrencyDataObject.src
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/OptimisticConcurrencyDataObject.src&file=GridViewObject_vb\OptimisticConcurrencyDataObject.aspx&lang=VB+Source
============================================================================



**would be good for coments as detail - for long comments
Gridview w/ related Details view   (PAGER TEMPLATE)
============================================================================
(run-it) http://quickstarts.asp.net/quickstartv20/aspnet/samples/data/PagerTemplate_vb.aspx
(src) http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/PagerTemplate.src
AND
(run-it) http://quickstarts.asp.net/QuickStartv20/aspnet/samples/data/GridViewMasterDetails_vb.aspx
(src) http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewMasterDetails.src





VERY COOL --Page.DataBind()   <asp:label ID="Label1" text='<%# StateList.SelectedItem.Text %>' runat="server"/>
============================================================================
http://quickstarts.asp.net/quickstartv20/aspnet/samples/data/DataBind2_vb.aspx
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/DataBind2.src
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/DataBind2.src


*Databind directly to Grid*
============================================================================
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/DataBind4.src
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/DataBind7.src


**ASP.NET Quickstart Tutorials - TRee menu **(below)
Databinding in TEmplates
============================================================================
http://quickstarts.asp.net/quickstartv20/aspnet/doc/data/templates.aspx



**Drop down in a GridView** (but uses table adapters)
============================================================================
http://quickstarts.asp.net/quickstartv20/aspnet/doc/data/templates.aspx
http://quickstarts.asp.net/quickstartv20/aspnet/samples/data/PhotoAlbum_vb/AlbumsDataSetDropDown.aspx
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/PhotosAlbumDropDown.src







VALIDATION
============================================================================
http://quickstarts.asp.net/quickstartv20/aspnet/doc/validation/default.aspx
==================================================================
Server-Side RequiredFieldValidator Sample

<html>
<head>
    <script language="C#" runat=server>

        void ValidateBtn_Click(Object Sender, EventArgs E) {

           if (Page.IsValid == true) {
              lblOutput.Text = "Page is Valid!";
           }
           else {
              lblOutput.Text = "Some of the required fields are empty";
           }
        }

   </script>

</head>

=========================================================================================
        <asp:RequiredFieldValidator id="RequiredFieldValidator2"
            ControlToValidate="TextBox1"
            Display="Static"
            Width="100%" runat=server>
            *
        </asp:RequiredFieldValidator>

...

<ASP:Button id=Button1 text="Validate" OnClick="ValidateBtn_Click" runat=server />



==================================================================
Client-Side RequiredFieldValidator Sample
============================================================================
http://quickstarts.asp.net/quickstartv20/aspnet/samples/validation/ClientSideValidation_vb.aspx

<head>

    <script language="C#" runat=server>

        void Page_Load() {
            if (!IsPostBack) {
                // Validate intially to force *s to appear before the first round-trip
                Validate();
            }
        }

        void ValidateBtn_Click(Object Sender, EventArgs E) {

           if (Page.IsValid == true) {
              lblOutput.Text = "Page is Valid!";
           }
           else {
              lblOutput.Text = "Some of the required fields are empty";
           }
        }

   </script>

</head>
<body>

<form runat="server">

....
      <td>
        <ASP:TextBox id=TextBox1 onchange="ClientOnChange();" runat=server />
      </td>
      <td>
        <asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server"
            ControlToValidate="TextBox1"
            ErrorMessage="*"
            Display="Static"
            Width="100%">
        </asp:RequiredFieldValidator>


</form>

<script language=javascript>
<!--
    function ClientOnChange() {
       if (typeof(Page_Validators) == "undefined")
          return;
       document.all["lblOutput"].innerText = Page_IsValid ? "Page is Valid!" : "Some of the required fields are empty";
    }
// -->
</script>


</body>
</html>

============================================================================
SetFocusOnError="true"
============================================================================
http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/tipstricks/FocusAPI.src
============================================================================

 <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
      <asp:RequiredFieldValidator SetFocusOnError="true" ErrorMessage="TextBox1 is empty"
        ID="RequiredFieldValidator1" ControlToValidate="TextBox1" Display="Dynamic" runat="server">*</asp:RequiredFieldValidator>