Edit button code

Debasis Mohapatra

7y2.2kLearn iOS Programming

Please check the code if it is correct please say ok

protected void btnEdit_Click(object sender, EventArgs e)

{

Button btn = (Button)sender;

string id = ddlarticleno.SelectedValue;

string sql = "select * from production_stock where id=" + id + "";

connection.Open();

SqlDataAdapter dap = new SqlDataAdapter(sql, connection);

DataTable dt = new DataTable();

dap.Fill(dt);

if (dt.Rows.Count > 0)

{

txtproductionorder.Text = dt.Rows[0]["production_order_no"].ToString();

ddlarticleno.SelectedValue = dt.Rows[0]["article_no"].ToString();

txtarticedescription.Text = dt.Rows[0]["article_desc"].ToString();

txtorderedqty.Text = dt.Rows[0]["order_qty"].ToString();

txtfinishedqty.Text = dt.Rows[0]["rec_Quantity"].ToString();

}

5 Replies

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

Debasis Mohapatra7y ago
my code in html
<div class="form-group">
<div class="col-md-9 col-sm-9 col-xs-12 col-md-offset-3">
<%-- <input type="submit" class="btn btn-success" id="btnSaveProduct" value="Save" />--%>
<asp:Button ID="btnsaveproduct" runat="server" class="fa-save" BackColor="#00ffcc" Text="Save" OnClick="btnsaveproduct_Click" />
<asp:Button ID="btnEdit" runat="server" class="btn-info" Text="Edit" OnClick="btnEdit_Click" />
protected void btnEdit_Click(object sender, EventArgs e)
{
string id = ddlarticleno.SelectedValue;
string sql = "select * from production_stock where id=" + id + "";
connection.Open();
SqlDataAdapter dap = new SqlDataAdapter(sql, connection);
DataTable dt = new DataTable();
dap.Fill(dt);
if (dt.Rows.Count > 0)
{
txtproductionorder.Text = dt.Rows[0]["production_order_no"].ToString();
ddlarticleno.SelectedValue = dt.Rows[0]["article_no"].ToString();
txtarticedescription.Text = dt.Rows[0]["article_desc"].ToString();
txtorderedqty.Text = dt.Rows[0]["order_qty"].ToString();
txtfinishedqty.Text = dt.Rows[0]["rec_Quantity"].ToString();
}
}
Sreekanth Reddy7y ago
Hi Debasis,
You can catc the ID by using "e.CommandArgument"

Thank you.
Sreekanth Reddy7y ago
Hi Debasis,

Actually you needs to use the Rowcommand event for your scenario as follows :

//Add rowcommand event
ID="GridView1"
AllowPaging="true"
OnRowCommand="RowCommand"
Runat="server">
............................
..............................
OnClick = "Row_Selected" CommandName = 'EditRow' CommandArgument = '<%# Eval("Id") %>' />
............................
............................
............................

//Use rowcommand Event
protected void RowCommand(object sender, GridViewCommandEventArgs e)
{
//To get the ID :
int idIs = Convert.ToInt32(e.CommandArgument);
//Now IdIs contains the ID of the selected row. Pass this IdIs in your command.
string id = ddlarticleno.SelectedValue;
string sql = "select * from production_stock where id=" + idIs + "";
connection.Open();
SqlDataAdapter dap = new SqlDataAdapter(sql, connection);
DataTable dt = new DataTable();
dap.Fill(dt);
if (dt.Rows.Count > 0)
{
txtproductionorder.Text = dt.Rows[0]["production_order_no"].ToString();
ddlarticleno.SelectedValue = dt.Rows[0]["article_no"].ToString();
txtarticedescription.Text = dt.Rows[0]["article_desc"].ToString();
txtorderedqty.Text = dt.Rows[0]["order_qty"].ToString();
txtfinishedqty.Text = dt.Rows[0]["rec_Quantity"].ToString();
}

If it helps, mark as answer.
Thank you.
Debasis Mohapatra7y ago
so how can i catch the id in the table to edit the textbox value.
Debasis Mohapatra7y ago
Thank You Mr Ready

But srikanth i have one question that i am not doint from gridview edit. it's a simple edit but from there after click on edit button the even will genrate. do you have any simple way to catch the id and edit the textvalue data.