using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { SqlConnection con; SqlCommand cmd, cmd1; SqlDataAdapter da; SqlDataReader reader; string str; protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); con.Open(); cmd = new SqlCommand("select ID, Name, Gender, Relationship from Registration", con); reader = cmd.ExecuteReader(); gvUsers.DataSource = reader; gvUsers.DataBind(); reader.Dispose(); reader.Close(); //bindresult(); con.Close(); } protected void gvUsers_SelectedIndexChanged(object sender, EventArgs e) { str = gvUsers.SelectedDataKey.Value.ToString(); gvUsers.SelectedRow.BackColor = System.Drawing.Color.SkyBlue; cmd1 = new SqlCommand("select * from Registration where ID = '" + str + "'", con); DataTable dt = new DataTable(); da = new SqlDataAdapter(cmd1); da.Fill(dt); gvDetails.DataSource = dt; gvDetails.DataBind(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)