Advantage Database record in FormView

ASP code:

<%@ Page Title="" Language="C#" MasterPageFile="~/Master.master" AutoEventWireup="true" CodeFile="AdsTest.aspx.cs" Inherits="AdsTest" %>

<%@ Register assembly="System.Web.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" namespace="System.Web.UI.WebControls" tagprefix="asp" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="content" Runat="Server">
    <asp:LoginView ID="LoginView1" runat="server">
    <Rolegroups>
     <asp:RoleGroup Roles="Managers">
        <ContentTemplate>
        </ContentTemplate>
     </asp:RoleGroup>
     <asp:RoleGroup Roles="Users>
        <ContentTemplate>
            <asp:TextBox ID="tbNumber" runat="server"></asp:TextBox>
            <br /><br />
            <asp:GridView ID="GridView1" runat="server"
            OnLoad="GridView1_Load" DataKeyNames="Number" 
            OnSelectedIndexChanged="GridView1_SelectedIndexChanged" 
            AutoGenerateSelectButton="true">
            </asp:GridView>
            <br /><br />
            <asp:GridView ID="GridView2" runat="server"
            OnLoad="GridView2_Load" DataKeyNames="Clinician" 
            onselectedindexchanged="GridView2_SelectedIndexChanged" 
            AutoGenerateSelectButton="True">
            </asp:GridView>
            <br />
            <asp:FormView ID="FormView1" runat="server" CellPadding="4" 
                ForeColor="#333333" DefaultMode="ReadOnly" >
                <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                <RowStyle BackColor="#EFF3FB" />
                <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                <EditRowStyle BackColor="#2461BF" />
            </asp:FormView>
            <asp:SqlDataSource ID="sqlAdsDetails" runat="server" 
                ConnectionString="<%$ ConnectionStrings:AdsConnection %>" 
                onselecting="sqlAdsDetails_Selecting" 
                ProviderName="<%$ ConnectionStrings:AdsConnection.ProviderName %>" 
                SelectCommand="">
                <SelectParameters>
                </SelectParameters>
            </asp:SqlDataSource>
        </ContentTemplate>
     </asp:RoleGroup>
     </Rolegroups>
     <AnonymousTemplate>
     </AnonymousTemplate>
     </asp:LoginView>
</asp:Content>

C# code:

using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Advantage.Data.Provider;
using System.Data;
using System.Data.Objects;
using System.Data.Objects.DataClasses;

public partial class AdsTest : System.Web.UI.Page
{
    private Model.EmpModel empModel;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (User.Identity.IsAuthenticated)
        {
            empModel = new Model.EmpModel();
        }
        else
        {
            FormsAuthentication.RedirectToLoginPage();
        }
        
    }

    protected void GridView1_Load(object sender, EventArgs e)
    {
        GridView gv1 = (GridView)LoginView1.FindControl("GridView1");
        TextBox tbNumber = (TextBox)LoginView1.FindControl("tbNumber");

        AdsConnection conn = new AdsConnection();
        conn.ConnectionString = "Data Source=c:\\******\\dd1.add;User ID=******;Password=******;ServerType=LOCAL;TrimTrailingSpaces=True";
        DataSet ds1 = new DataSet();
        AdsDataAdapter ada1 = new AdsDataAdapter();

        //ObjectQuery<Model.EMPLOYEE> EmployeeQuery = empModel.EMPLOYEE;
        try
        {
            conn.Open();
            AdsCommand com = new AdsCommand("Select * From EMPLOYEE Where Number = 2", conn);
            ada1.SelectCommand = com;
            ada1.Fill(ds1, "EMPLOYEE");
            gv1.DataSource = ds1;
            //gv1.DataSource = EmployeeQuery;
            gv1.DataBind();
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
        finally
        {
            conn.Close();
        }
    }

    protected void GridView2_Load(object sender, EventArgs e)
    {
        GridView gv2 = (GridView)LoginView1.FindControl("GridView2");
        TextBox tbNumber = (TextBox)LoginView1.FindControl("tbNumber");

        AdsConnection conn = new AdsConnection();
        conn.ConnectionString = "Data Source=c:\\ahh-live\\dd1.add;User ID=adssys;ServerType=LOCAL;TrimTrailingSpaces=True";
        DataSet ds1 = new DataSet();
        AdsDataAdapter ada1 = new AdsDataAdapter();

        try
        {
            conn.Open();
            AdsCommand com = new AdsCommand("Select * From EMPAVAIL Where Clinician = 2", conn);
            ada1.SelectCommand = com;
            ada1.Fill(ds1, "EMPAVAIL");
            gv2.DataSource = ds1;
            gv2.DataBind();
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
        finally
        {
            conn.Close();
        }
    }

    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridView gv1 = (GridView)LoginView1.FindControl("GridView1");
        SqlDataSource sqlAdsDetails = (SqlDataSource)LoginView1.FindControl("sqlAdsDetails");
        FormView fv1 = (FormView)LoginView1.FindControl("FormView1");

        sqlAdsDetails.SelectCommand = "Select * from Employee Where Number = " + gv1.SelectedValue;
        fv1.DataSourceID = "sqlAdsDetails";
        //sqlAdsDetails.Select(DataSourceSelectArguments.Empty);
        fv1.DataBind();
    }
    protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridView gv2 = (GridView)LoginView1.FindControl("GridView2");
        SqlDataSource sqlAdsDetails = (SqlDataSource)LoginView1.FindControl("sqlAdsDetails");
        FormView fv1 = (FormView)LoginView1.FindControl("FormView1");

        sqlAdsDetails.SelectCommand = "Select * from Employee Where Number = " +     gv2.SelectedValue;
        fv1.DataSourceID = "sqlAdsDetails";
        sqlAdsDetails.Select(DataSourceSelectArguments.Empty);
        fv1.DataBind();
    }
    protected void sqlAdsDetails_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {

    }

Select allOpen in new window