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

Design Side
asp:GridView ID="gridCustomer" runat="server" AutoGenerateColumns="False" onrowcommand="gridCustomer_RowCommand">

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();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Azaad Abbas11y ago
Accepted answer
Design Side
asp:GridView ID="gridCustomer" runat="server" AutoGenerateColumns="False" onrowcommand="gridCustomer_RowCommand">



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();


}
}

0
Manish Kumar Choudhary11y ago

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
0