public GridDropDownColumn AddDropDownColumn(string dataField, string headerText, bool enableEmptyItem) { GridDropDownColumn c = new GridDropDownColumn(); _grid.MasterTableView.Columns.Add(c); c.DropDownControlType = GridDropDownColumnControlType.DropDownList; c.EnableEmptyListItem = enableEmptyItem; c.EmptyListItemText = BindingListItem.EmptyText; c.EmptyListItemValue = BindingListItem.EmptyValue; c.ListValueField = BindingListItem.ValueProperty; c.ListTextField = BindingListItem.TextProperty; c.HeaderText = headerText; c.DataField = dataField; return(c); }
private void CreateGridColumns() { if (TableInfo == null) { return; } TableInfo ti = TableInfo; int i = 0; uxGrid.MasterTableView.Columns.Clear(); foreach (ColumnInfo c in ti.Columns) { if (c.IsPrimaryKey) { uxGrid.MasterTableView.DataKeyNames = new string[] { c.ColumnName }; if (c.IsIdentity) { continue; } } GridEditableColumn col; var fk = c.ForeignKeyRelation; if (fk == null) { if (c.DataType == DbType.Boolean) { col = new GridCheckBoxColumn(); uxGrid.MasterTableView.Columns.Insert(i, col); ((GridCheckBoxColumn)col).DataField = c.ColumnName; } else { col = new GridBoundColumn(); uxGrid.MasterTableView.Columns.Insert(i, col); ((GridBoundColumn)col).DataField = c.ColumnName; } col.DataType = DbTypeUtility.GetType(c.DataType); } else { GridDropDownColumn dc = new GridDropDownColumn(); col = dc; if (c.ColumnName.ToLower() != "unionid") { uxGrid.MasterTableView.Columns.Insert(i, col); dc.DataField = c.ColumnName; dc.DataType = DbTypeUtility.GetType(c.DataType); dc.DataSourceID = "gidDS_" + c.ColumnName; dc.ListTextField = "_col_"; dc.ListValueField = fk.PKField; } } col.HeaderText = c.Title; col.SortExpression = c.ColumnName; col.ShowFilterIcon = false; col.CurrentFilterFunction = GridKnownFunction.Contains; col.AutoPostBackOnFilter = true; //col.UniqueName = c.ColumnName; i++; } }
protected void UsersEvents() { SqlDataSource gridsource = new SqlDataSource(); string connStr = ConfigurationManager.ConnectionStrings["HelpDeskConnString"].ToString(); gridsource.ConnectionString = connStr; gridsource.SelectCommand = "SELECT * FROM [tblUser]"; gridsource.UpdateCommand = "Update [tblUser] Set [FirstName] = @FirstName , [Lastname]= @LastName , [EmailAddress] = @EmailAddress , [RoleId] = @RoleId WHERE [UserId] = @UserId"; gridsource.DeleteCommand = "DELETE FROM [tblUser] WHERE [UserId] = @UserId"; //delete parameters Parameter Deletepm = new Parameter(); Deletepm.Name = "UserId"; Deletepm.DbType = DbType.Int32; gridsource.DeleteParameters.Add(Deletepm); // update parameters Parameter Updatepm = new Parameter(); Updatepm.Name = "UserId"; Updatepm.DbType = DbType.Int32; Updatepm.Name = "FirstName"; Updatepm.DbType = DbType.String; Updatepm.Name = "Lastname"; Updatepm.DbType = DbType.String; Updatepm.Name = "EmailAddress"; Updatepm.DbType = DbType.String; //Updatepm.Name = "Password"; //Updatepm.DbType = DbType.String; //Updatepm.Name = "ProjectId"; //Updatepm.DbType = DbType.Int32; Updatepm.Name = "RoleId"; Updatepm.DbType = DbType.Int32; gridsource.UpdateParameters.Add(Updatepm); rg_Users.DataSource = gridsource; bool isRoleAdded = false; // bool isProjectAdded = false; foreach (GridColumn col in rg_Users.MasterTableView.Columns) { //if(col.UniqueName == "ProjectId") // isProjectAdded = true; if (col.UniqueName == "RoleId") isRoleAdded = true; } //Projects //sourceproj.ConnectionString = connStr; //sourceproj.SelectCommand = "SELECT * FROM [tblGroupProjectName]"; //GridDropDownColumn ddlProject = new GridDropDownColumn(); //if (!isProjectAdded) // rg_Users.MasterTableView.Columns.Add(ddlProject); //ddlProject.UniqueName = "ProjectId"; //ddlProject.HeaderText = "Project Name"; //ddlProject.DataSourceID = "sourceproj"; //ddlProject.DataField = "ProjectId"; //ddlProject.ListTextField = "ProjectName"; //ddlProject.ListValueField = "ProjectId"; // roles GridDropDownColumn ddlRole = new GridDropDownColumn(); sourceRole.ConnectionString = connStr; sourceRole.SelectCommand = "SELECT * FROM [tblUserRole]"; if (!isRoleAdded) rg_Users.MasterTableView.Columns.Add(ddlRole); ddlRole.UniqueName = "RoleId"; ddlRole.HeaderText = "Role"; ddlRole.DataSourceID = "sourceRole"; ddlRole.DataField = "RoleId"; ddlRole.ListTextField = "UserRole"; ddlRole.ListValueField = "RoleId"; }