public void loaddata() { try { strConnection.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = strConnection; cmd.CommandText = "SELECT * FROM dbo.CategoryMaster "; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); GridCategory.DataSource = ds; GridCategory.DataBind(); cmd.Dispose(); strConnection.Close(); } catch { } finally { strConnection.Close(); } }
public MultiGridData(MultiGridData other, bool withValues = true) : base(other) { if (other.categories != null) { int count = other.categories.Length; categories = new GridCategory[other.categories.Length]; for (int i = 0; i < count; i++) { var c = other.categories[i]; var category = new GridCategory(c.name, new GridData(c.grid, withValues), c.color); category.grid.patch = patch; categories[i] = category; } } gridFilter = other.gridFilter; coloring = other.coloring; }
private void BindData() { var conString = ConfigurationManager.ConnectionStrings["ProductsCatalogConn"]; SqlConnection con = new SqlConnection(conString.ConnectionString); //SqlCommand cmd = new SqlCommand("SELECT CategoryId, CatName FROM tblCategories", con); SqlCommand cmd = new SqlCommand("dbo.getOrderedCategoryList", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); GridCategory.DataSource = ds; GridCategory.DataBind(); }
public MultiGridData(GridData other) : base(other) { coloring = other.coloring; if (other.categories != null && other.categories.Length > 0) { int count = other.categories.Length; categories = new GridCategory[count]; for (int i = 0; i < count; i++) { var c = other.categories[i]; var category = new GridCategory(c.name, new GridData(other, false), c.color); category.grid.categories = null; category.grid.patch = patch; categories[i] = category; } } }