Configuring the Select link in gridview.

Hi There,

I am having a problem configuring the select link in the gridview, I have build a search engine, that works. When I click the select link in results gridview to pass the selected results to the next page I am having a problem getting the select link to work and pass my selection to a results page. My code is as follows below:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public partial class Members_SearchGen : System.Web.UI.Page
{
    private String strConnString = ConfigurationManager.ConnectionStrings["GenealogyConnectionString1"].ConnectionString;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            BindData();

        }

    }

    private void BindData()
    {

        string strQuery = "select FamilyName, FirstName, MiddleName1, MiddleName2, MiddleName3, Gender, DOB, COOB, SOB, COB, GenType, GenRank, GenTitles, GenTitles1, GenTitles2, DOD, COOD, SOD, COD" +

                           " from aspnet_Genealogy";

        SqlCommand cmd = new SqlCommand(strQuery);

       // GridView1.DataSource = GetData(cmd);

        GridView1.DataBind();

    }

    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string FamilyName = ((TextBox)GridView1.FooterRow.FindControl("FamilyName")).Text;

        string FirstName = ((TextBox)GridView1.FooterRow.FindControl("FirstName")).Text;

        string MiddleName1 = ((TextBox)GridView1.FooterRow.FindControl("MiddleName1")).Text;

        string MiddleName2 = ((TextBox)GridView1.FooterRow.FindControl("MiddleName2")).Text;

        string MiddleName3 = ((TextBox)GridView1.FooterRow.FindControl("MiddleName3")).Text;

        string Gender = ((TextBox)GridView1.FooterRow.FindControl("Gender")).Text;

        string DOB = ((TextBox)GridView1.FooterRow.FindControl("DOB")).Text;

        string COOB = ((TextBox)GridView1.FooterRow.FindControl("COOB")).Text;

        string SOB = ((TextBox)GridView1.FooterRow.FindControl("SOB")).Text;

        string COB = ((TextBox)GridView1.FooterRow.FindControl("COB")).Text;

        string GenType = ((TextBox)GridView1.FooterRow.FindControl("GenType")).Text;

        string GenRank = ((TextBox)GridView1.FooterRow.FindControl("GenRank")).Text;

        string GenTitles = ((TextBox)GridView1.FooterRow.FindControl("GenTitles")).Text;

        string GenTitles1 = ((TextBox)GridView1.FooterRow.FindControl("GenTitles1")).Text;

        string GenTitles2 = ((TextBox)GridView1.FooterRow.FindControl("GenTitles2")).Text;

        string DOD = ((TextBox)GridView1.FooterRow.FindControl("DOD")).Text;

        string COOD = ((TextBox)GridView1.FooterRow.FindControl("COOD")).Text;

        string SOD = ((TextBox)GridView1.FooterRow.FindControl("SOD")).Text;

        string COD = ((TextBox)GridView1.FooterRow.FindControl("COD")).Text;

        SqlConnection con = new SqlConnection(strConnString);

        SqlCommand cmd = new SqlCommand();

        cmd.CommandType = CommandType.Text;

        cmd.CommandText = "insert into aspnet_Genealogy(FamilyName, FirstName, MiddleName1, MiddleName2, MiddleName3, Gender, DOB, COOB, SOB, COB, GenType, GenRank, GenTitles, GenTitles1, GenTitles2, DOD, COOD, SOD, COD) " +

        "values(@FamilyName, @FirstName, @MiddleName1, @MiddleName2, @MiddleName3, @Gender, @DOB, @COOB, @SOB, @COB, @GenType, @GenRank, @GenTitles, @GenTitles1, @GenTitles2, @DOD, @COOD, @SOD, @COD);" +

        "select FamilyName, FirstName, MiddleName1, MiddleName2, MiddleName3, Gender, DOB, COOB, SOB, COB, GenType, GenRank, GenTitles, GenTitles1, GenTitles2, DOD, COOD, SOD, COD from aspnet_Genealogy";

        cmd.Parameters.Add("@FamilyName", SqlDbType.Char).Value = FamilyName;

        cmd.Parameters.Add("@FirstName", SqlDbType.Char).Value = FirstName;

        cmd.Parameters.Add("@MiddleName1", SqlDbType.Char).Value = MiddleName1;

        cmd.Parameters.Add("@MiddleName2", SqlDbType.Char).Value = MiddleName2;

        cmd.Parameters.Add("@MiddleName3", SqlDbType.Char).Value = MiddleName3;

        cmd.Parameters.Add("@Gender", SqlDbType.Char).Value = Gender;

        cmd.Parameters.Add("@DOB", SqlDbType.VarChar).Value = DOB;

        cmd.Parameters.Add("@COOB", SqlDbType.NVarChar).Value = COOB;

        cmd.Parameters.Add("@SOB", SqlDbType.NVarChar).Value = SOB;

        cmd.Parameters.Add("@COB", SqlDbType.NVarChar).Value = COB;

        cmd.Parameters.Add("@GenType", SqlDbType.NVarChar).Value = GenType;

        cmd.Parameters.Add("@GenRank", SqlDbType.NVarChar).Value = GenRank;

        cmd.Parameters.Add("@GenTitles", SqlDbType.NVarChar).Value = GenTitles;

        cmd.Parameters.Add("@GenTitles1", SqlDbType.NVarChar).Value = GenTitles1;

        cmd.Parameters.Add("@GenTitles2", SqlDbType.NVarChar).Value = GenTitles2;

        cmd.Parameters.Add("@DOD", SqlDbType.VarChar).Value = DOD;

        cmd.Parameters.Add("@COOD", SqlDbType.NVarChar).Value = COOD;

        cmd.Parameters.Add("@SOD", SqlDbType.NVarChar).Value = SOD;

        cmd.Parameters.Add("@COD", SqlDbType.NVarChar).Value = COD;

        //GridView1.DataSource = GetData(cmd);

        GridView1.DataBind(); 
    }
}

Can anyone help.....

I look forward to hearing from you soon..

Thanks

ASW