Line 83: // int CatId1 = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString()); Line 84: // Label catid1 = ((Label)(gvDetails.Rows[e.RowIndex].FindControl("lb_id"))); Line 85: int catid1 = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString()); Line 86: string catname = gvDetails.DataKeys[e.RowIndex].Values["catname"].ToString(); Line 87: TextBox txtname = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtname"); Source File: e:\project b2bchennai\Admin\CategoryDetail.aspx.cs Line: 85
protected void BindDetails() { //int catid=Convert.ToInt32(gvDetails.DataKeys.ToString()); con.Open(); SqlCommand cmd = new SqlCommand("select top 1 catname,catdesc from categorydetail order by catid desc", con); // SqlCommand cmd = new SqlCommand("select * from categorydetail order by catname,catdesc desc limit 1", con); // SqlCommand cmd = new SqlCommand("SELECT TOP 1 catname,catdesc FROM categorydetail", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); if (ds.Tables[0].Rows.Count > 0) { gvDetails.DataSource = ds; gvDetails.DataBind(); } else { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); gvDetails.DataSource = ds; gvDetails.DataBind(); int columncount = gvDetails.Rows[0].Cells.Count; gvDetails.Rows[0].Cells.Clear(); gvDetails.Rows[0].Cells.Add(new TableCell()); gvDetails.Rows[0].Cells[0].ColumnSpan = columncount; gvDetails.Rows[0].Cells[0].Text = "No Records Found"; } } protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e) { int catid1 = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString()); string catname = gvDetails.DataKeys[e.RowIndex].Values["catname"].ToString(); TextBox txtname = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtname"); TextBox txtdesc = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtdesc"); con.Open(); SqlCommand cmd = new SqlCommand("update categorydetail set catname='" + txtname.Text + "',catdesc='" + txtdesc.Text + "' where catid="+catid1,con); cmd.ExecuteNonQuery(); con.Close(); lblresult.ForeColor = Color.Green; lblresult.Text = catname + " Details Updated successfully"; gvDetails.EditIndex = -1; BindDetails(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)