protected void SetUserGridData() { //logFiles.ErrorLog("INTO SET USER GRID: curr group " + CurrentGroupName); try { string groupname = CurrentGroupName; curgrpname.Text = " Current Group: " + groupname; if (CurrentGroupName == "None") return; setLeadeermsg(username, groupname); int groupid = groupManagement.find_group_id(groupname); if (groupid < 1) { ShowErrorMessage(" did not find group " + groupname); return; } string selectQuery = " SELECT distinctrow webmpx.group_members.* FROM webmpx.group_members WHERE (((Group_members.Groupname)='" + groupname + "')) order by webmpx.group_members.Username asc;"; using (OdbcConnection connection = new OdbcConnection(ConfigurationManager.ConnectionStrings["MySQLConnStr"].ConnectionString)) { connection.Open(); using (OdbcCommand command = new OdbcCommand(selectQuery, connection)) using (OdbcDataAdapter adapter = new OdbcDataAdapter(command)) { DataTable dt = new DataTable(); try { adapter.Fill(dt); dt.DefaultView.Sort = SortExpression; groupmembers.DataSource = dt.DefaultView; groupmembers.DataBind(); } catch (Exception ex) { throw new Exception("Error in getting data using sql query: " + selectQuery + ". " + ex.Message, ex); } } connection.Close(); } } catch (Exception exp) { logFiles.ErrorLog(exp); ShowErrorMessage("An error has occured when reading user data."); } }
protected void gridGroupModels_RowCommand(object sender, GridViewCommandEventArgs e) { Button btn = e.CommandSource as Button; if (btn == null) { return; } int groupid = Convert.ToInt32(DropDownList2.SelectedValue); GridViewRow row = btn.NamingContainer as GridViewRow; if (e.CommandName.Equals("Update")) { UpdateRow(row); gridGroupModels.EditIndex = -1; } else if (e.CommandName.Equals("Delete")) { doDeleteFile(row); // no confirm !! lucie gwwd } else if (e.CommandName.Equals("Edit")) { gridGroupModels.EditIndex = row.RowIndex; // get fileid info CurrentFileid = Convert.ToString(get_modelid_row(row)); } else if (e.CommandName.Equals("CancelUpdate")) { gridGroupModels.EditIndex = -1; } else if (e.CommandName.Equals("Copy")) { btnLeft_Click(row); } SetGroupModelsData(groupManagement.find_group_id(CurrentGroupName)); }