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