if (e.CommandName == "EditRow") { int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex; gvMainCategory.EditIndex = rowIndex; bindMC(); } //DataBinding method private void bindMC() { int counter = 1; counter = counter + 1; BL_MainCategory objBL_getMC = new BL_MainCategory(); gvMainCategory.DataSource = objBL_getMC.LoadCategory(); gvMainCategory.DataBind(); } private DataSet ExecuteSelectSQL(string sqlcmd) { string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter(sqlcmd, con); DataSet ds = new DataSet(); da.Fill(ds); return ds; } } public DataSet LoadMainCategory() { DataSet ds = new DataSet(); string sql = "select * from MainCategory"; ds = ExecuteSelectSQL(sql); return ds; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)