bind A Record from database to a form By Clicking hyper link

Question

how to bind A Record from database to a form By Clicking hyper link in gridview row?

Azaad Abbas · Answer

Design Side asp:GridView ID="gridCustomer" runat="server" AutoGenerateColumns="False" onrowcommand="gridCustomer_RowCommand"> ' CommandArgument=' ' CommandName="VIEW"> Columns > Code Behind Side protected void gridCustomer_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "VIEW") { int row = Convert.ToInt32(e.CommandArgument); Session["UserId"] = row; Response.Redirect("~/Update Pages/RegCustUpdateAndDelete.aspx"); } } New Form's CodeBehind Side protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { //open the db connection if it is closed... if (connection.State == ConnectionState.Closed) connection.Open(); int uid = Convert.ToInt32(Session["UserId"]); command = new SqlCommand(); command.CommandText = "sp_Get_CustFields"; command.CommandType = CommandType.StoredProcedure; command.Connection = connection; command.Parameters.AddWithValue("@uid", uid); SqlDataAdapter daPack = new SqlDataAdapter(command); DataSet dsPack = new DataSet(); daPack.Fill(dsPack); txtName.Text = dsPack.Tables[0].Rows[0]["Name"].ToString(); txtSo.Text = dsPack.Tables[0].Rows[0]["SoDoWo"].ToString(); txtAdd.Text = dsPack.Tables[0].Rows[0]["Address"].ToString(); txtMobNo.Text = dsPack.Tables[0].Rows[0]["MobNo"].ToString(); catch (Exception ex) { lblMessage.Text =ex.Message; lblMessage.Visible = true; } finally //Close db Connection if it is open.... { if (connection.State == ConnectionState.Open) connection.Close(); } }

Manish Kumar Choudhary · Answer

Go through following links it will help you http://www.aspsnippets.com/Articles/Convert-GridView-Column-into-HyperLink-Fields-in-ASPNet.aspx http://stackoverflow.com/questions/21930183/create-hyperlink-button-cells-in-gridview-using-c-sharp-asp-net

bind A Record from database to a form By Clicking hyper link

Answers (2)