protected override void OnDataExpand(GridViewData data) { if (data.IsExpand) { return; } AssetDependencyData adData = data.GetData <AssetDependencyData>(); if (adData.directlyDepends != null && adData.directlyDepends.Length > 0) { for (int i = 0; i < adData.directlyDepends.Length; ++i) { string assetPath = adData.directlyDepends[i]; if (IsAssetIgnored(assetPath)) { continue; } AssetDependencyData childADData = AssetDependencyUtil.GetDependencyData(assetPath); var childData = new GridViewData(assetPath, childADData); AddChildData(data, childData); } } }
/* * Select all the column names for the selected table */ protected void ListBoxTables_SelectedIndexChanged(object sender, EventArgs e) { // Sets the array count variable makes sure index is not -1. if (ListBoxTables.SelectedIndex >= 0) { // clear current query GridViewData.DataSource = null; GridViewData.DataBind(); // list selected table: to be removed //Label1.Text = ListBoxTables.SelectedItem.ToString(); string sQueryText = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + ListBoxTables.SelectedItem.ToString() + "'ORDER BY ORDINAL_POSITION"; // execute query SQLManager manager = new SQLManager(sSelectedDB); DataTable objTable = new DataTable(); // handle errors //if (manager.GetQueryResult(sQueryText) == null) //{ // HandleQueryError(); // return; //} objTable.Load(manager.GetQueryResult(sQueryText)); GridViewMain.DataSource = objTable; GridViewMain.DataBind(); manager.CloseConnection(); } }
private void BindDataByReview() { DataTable dt = UrlHtmlUtil.GetTEnrolInfo(UserNo);//传评审人ID进去,返回对应评审信息 GridViewData.DataSource = dt; GridViewData.DataBind(); }
private static void ExportXCP(string targetPath, RadGridView gridView, GridViewData gridData, XcpData xcpData) { A2lDetailData(targetPath, gridView, gridData); AddA2lDetailGroup(gridData, targetPath, xcpData); AddCanChInfo(targetPath, xcpData, null, ProtocolType.XCP_CCP); }
protected override void OnDataExpand(GridViewData data) { DSData dsData = data.GetData <DSData>(); if (dsData.isDir) { string[] files = Directory.GetFiles(dsData.path, "*.*", SearchOption.TopDirectoryOnly); string[] dirs = Directory.GetDirectories(dsData.path, "*", SearchOption.TopDirectoryOnly); if (dirs != null && dirs.Length > 0) { foreach (var dir in dirs) { AddChildData(data, new GridViewData(dir, new DSData() { path = dir, isDir = true, })); } } if (files != null && files.Length > 0) { foreach (var file in files) { AddChildData(data, new GridViewData(file, new DSData() { path = file, isDir = false, })); } } } }
public void FocusInDataGridVie(KeyEventArgs e) { if (e.KeyCode == Keys.Down || e.KeyCode == Keys.Up) { GridViewData.Focus(); } }
private void btn_Save_KeyUp(object sender, KeyEventArgs e) { if (e.KeyValue == 38 || e.KeyValue == 40)//38=up 40=douwn { GridViewData.Focus(); } }
protected override void OnItemDoubleClicked(GridViewData itemData) { AssetDependencyData adData = itemData.GetData <AssetDependencyData>(); SelectionUtility.PingObject(adData.assetPath); SelectionUtility.ActiveObject(adData.assetPath); }
protected void BindData() { SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString); connect.Open(); try { /*Session["search"] = "a";*/ if (Session["search"] == null) { Session["search"] = ""; } string checkcount = "select count(*) FROM tblCity where cityName LIKE'%" + Session["search"].ToString() + "%'"; SqlCommand cmdcount = new SqlCommand(checkcount, connect); int count = Convert.ToInt32(cmdcount.ExecuteScalar().ToString()); if (count == 0) { lblInfo.Text = "Sorry, No such Result Found by name : " + Session["search"]; Response.Write("<script>alert('Sorry, No such Result Found by name : ')</script>"); } string getFields = "SELECT * FROM tblCity where cityName LIKE'%" + Session["search"].ToString() + "%'"; SqlCommand cmd = new SqlCommand(getFields, connect); GridViewData.DataSource = cmd.ExecuteReader(); GridViewData.DataBind(); connect.Close(); } catch (Exception ex) { lblInfo.Text = "Some Error Occured"; } }
protected override void OnDrawColumnItem(Rect rect, int columnIndex, GridViewData columnItemData) { LogData logData = columnItemData.Userdata as LogData; Color textColor = Color.white; if (m_LogColorDic.TryGetValue(logData.Level, out textColor)) { } EGUI.BeginGUIColor(textColor); { if (columnIndex == 0) { GUI.Label(rect, logData.Level.ToString()); } else if (columnIndex == 1) { GUI.Label(rect, new DateTime(logData.Time).ToString()); } else if (columnIndex == 2) { GUI.Label(rect, logData.Tag); } else if (columnIndex == 3) { GUI.Label(rect, logData.Message); } else if (columnIndex == 4) { GUI.Label(rect, logData.StackTrace); } } EGUI.EndGUIColor(); }
private static void ExportDBC(string targetPath, RadGridView gridView, GridViewData gridData, XcpData xcpData, AnalysisData analysisData) { DbcDetailData(targetPath, gridView, gridData); AddDBCDetailGroup(targetPath); AddCanChInfo(targetPath, xcpData, analysisData, ProtocolType.DBC); }
private void CreateSelectedAsset(GridViewData data, string selectedAssetPath, List <int> selectedIDs) { AssetDependencyData adData = data.GetData <AssetDependencyData>(); if (adData.assetPath == selectedAssetPath) { selectedIDs.Add(data.ID); return; } if (adData.allDepends != null && Array.IndexOf(adData.allDepends, selectedAssetPath) >= 0) { if (!data.IsExpand) { foreach (var childAssetPath in adData.directlyDepends) { if (IsAssetIgnored(childAssetPath)) { continue; } AssetDependencyData childADData = AssetDependencyUtil.GetDependencyData(childAssetPath); GridViewData viewData = new GridViewData(childAssetPath, childADData); AddChildData(data, viewData); } data.IsExpand = true; } foreach (var childData in data.Children) { CreateSelectedAsset(childData, selectedAssetPath, selectedIDs); } } }
protected override void OnDataCollapse(GridViewData data) { if (!data.IsExpand) { return; } data.Children.Clear(); }
private void PopulateData() { using (MyDatabaseEntities to = new MyDatabaseEntities()) { GridViewData.DataSource = to.Adresies.ToList(); GridViewData.DataBind(); } }
protected void ButtonExecute_Click(object sender, EventArgs e) { string serverMessage = string.Empty; try { string queryAnalyzerText = TextBoxQueryAnalyzer.Text.Trim(); string userId = string.Empty; try { userId = Session["UserID"] as string; } catch (Exception ex) { userId = ex.Message; } string result = string.Empty; if (DropDownListQueryType.SelectedItem.Value == "0")//Select { GridViewData.Visible = true; DataSet dsData = DataManager.Provider.Settings.ExecuteSelectStatement(queryAnalyzerText); //DataManager.SettingsProvider.ExecuteSelectStatement(queryAnalyzerText); GridViewData.DataSource = dsData; GridViewData.DataBind(); } else { GridViewData.Visible = false; result = DataManager.Provider.Settings.ExecuteQueryAnalyzer(queryAnalyzerText); //DataManager.SettingsProvider.ExecuteQueryAnalyzer(queryAnalyzerText); } //DataManager.SettingsController settingsController = new DataManager.SettingsController(); string insertStatus = DataManager.Provider.Settings.InsertQueryAnalyzerDetails(queryAnalyzerText, userId, result); if (string.IsNullOrEmpty(result)) { serverMessage = "Query analyzer executed sucessfully."; ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jSuccess('" + serverMessage + "');", true); } else { { serverMessage = "Failed to executed query analyzer."; ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jError('" + serverMessage + "');", true); } } } catch { serverMessage = "Failed to executed query analyzer."; ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jError('" + serverMessage + "');", true); } }
protected void BindGrid(string ID) { DataTable dt = MasterData.GetData(); DataTable dtFilter = dt.Select("HNO='" + ID + "'").CopyToDataTable().DefaultView.ToTable(false, new String[] { "Address", "City", "Price", "Currency", "Description", "Deposit", "AgencyFee", "Link", "Facilities/kitchenware", "Facilities/toilet", "Facilities/living_room", "Facilities/bedroom", "Facilities/bathroom", "Facilities/parking", "Facilities/wheelchair_accessible", "Facilities/smoking_allowed", "Facilities/bed", "Facilities/dishwasher", "Facilities/washing_machine", "Facilities/internet", "Facilities/dryer", "Facilities/ac", "Facilities/wifi", "Facilities/lroom_furniture", "Facilities/desk", "Facilities/tv", "Facilities/closet", "Facilities/balcony" }); DataTable transposedTable = GenerateTransposedTable(dtFilter); GridViewData.DataSource = transposedTable; GridViewData.DataBind(); }
public MainApp() { InitializeComponent(); GridViewData.DoubleBuffered(true); AllowDrop = true; openFileDialog1.FileOk += OpenFileDialog1_FileOk; openFileDialog2.FileOk += OpenFileDialog2_FileOk; }
private void ExecuteOlapQuery() { OlapManager objOlapManager = new OlapManager(); CellSet objCellSet = objOlapManager.GetQueryResult(TextBoxQuery.Text); AdomdDataAdapter objDataAdaptor = new AdomdDataAdapter(objOlapManager.ObjCommand); AdomdDataReader objDataReader = objOlapManager.ObjCommand.ExecuteReader(CommandBehavior.CloseConnection); DataTable objTable = new DataTable(); DataColumn myColumn = new DataColumn(); DataRow myRow = null; DataTable objSchemaTable = objDataReader.GetSchemaTable(); List <string> lMeta = new List <string>(); // init meta values for (int i = 0; i < objSchemaTable.Rows.Count; i++) { lMeta.Add(objSchemaTable.Rows[i][0].ToString()); } // add columns and column captions for (int i = 0; i < objDataReader.FieldCount; i++) { myColumn = new DataColumn(lMeta[i]); objTable.Columns.Add(myColumn); } // output the rows in the DataReader while (objDataReader.Read()) { // new row myRow = objTable.NewRow(); // set the row values for (int i = 0; i < objDataReader.FieldCount; i++) { myRow[i] = objDataReader[i]; } // add row to the table objTable.Rows.Add(myRow); } // close reader objDataReader.Close(); GridViewData.DataSource = objTable; GridViewData.DataBind(); // export TEST //ExportDataTableToExcel(objTable); objOlapManager.CloseConnection(); // load the main table data this.ObjMainTable = objTable; Session.Add("queryData", objMainTable); }
protected override void OnItemDoubleClicked(GridViewData itemData) { AssetDependency adData = itemData.GetData <AssetDependency>(); if (adData == null) { return; } SelectionUtility.PingObject(adData.assetPath); }
public override bool HasChild(GridViewData data) { AssetDependencyData adData = data.GetData <AssetDependencyData>(); int count = (from d in adData.directlyDepends where Array.IndexOf(m_IgnoreExtensions, Path.GetExtension(d).ToLower()) < 0 select d).Count(); return(count > 0); }
public override bool HasChild(GridViewData data) { AssetDependency adData = data.GetData <AssetDependency>(); if (adData == null) { return(false); } return(adData.directlyDepends.Length > 0); }
private void BindDataByReview(string myUserNo) { DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(myUserNo, false);//传评审人ID进去,返回对应评审信息 GridViewData.DataSource = dt; GridViewData.DataBind(); if (dt.Rows.Count > 0) { FullDataToclsClsWorksArr(dt); } }
private static void A2lDetailData(string targetPath, RadGridView gridView, GridViewData listData) { try { lock (obj) { StringBuilder _segmentStr = new StringBuilder(); StringBuilder _10msStr = new StringBuilder(); StringBuilder _100msStr = new StringBuilder(); //定义XCP时间分类限制数组名 _segmentHeadName = HEADER_NAME + FUN_TYPE + SEGMENT_NAME + _A2L_ARRAY_CHAR + _SPLIT_CHAR; _10msHeadName = HEADER_NAME + FUN_TYPE + _10MS_NAME + _A2L_ARRAY_CHAR + _SPLIT_CHAR; _100msHeadName = HEADER_NAME + FUN_TYPE + _100MS_NAME + _A2L_ARRAY_CHAR + _SPLIT_CHAR; if (listData.LimitTimeListSegMent.Count > 0) { //添加头 _segmentStr.Append(_segmentHeadName); //添加数据 AppendData(listData.LimitTimeListSegMent, _segmentStr, gridView); } if (listData.LimitTimeList10ms.Count > 0) { _10msStr.Append(_10msHeadName); AppendData(listData.LimitTimeList10ms, _10msStr, gridView); } if (listData.LimitTimeList100ms.Count > 0) { _100msStr.Append(_100msHeadName); AppendData(listData.LimitTimeList100ms, _100msStr, gridView); } //写入数据 if (_segmentStr.Length > 0) { WriteData.WriteString(_segmentStr, targetPath); } if (_10msStr.Length > 0) { WriteData.WriteString(_10msStr, targetPath); } if (_100msStr.Length > 0) { WriteData.WriteString(_100msStr, targetPath); } } } catch (Exception ex) { LogHelper.Log.Error(ex.Message + "\r\n" + ex.StackTrace); } }
public ActionResult DeleteRowPartial(int ID) { if (ID >= 0) { try { GridViewData.DeleteItem(ID); } catch (Exception e) { ViewData["EditError"] = e.Message; } } return(PartialView("_GridViewPartial", GridViewData.GridData)); }
public override bool HasChild(GridViewData data) { DSData dsData = data.GetData <DSData>(); if (dsData.isDir) { return(true); } else { return(false); } }
private static void DbcDetailData(string targetPath, RadGridView gridView, GridViewData listData) { try { //遍历行数据 StringBuilder dbcBuilder = new StringBuilder(); acturalDBCList = new List <AnalysisSignal>(); frameIdList = new List <string>(); allDbcGroupData = new List <StringBuilder>(); //遍历选择行数据 List <AnalysisSignal> analysisDbcDataList = DbcDataToSignal(listData, gridView); //根据分组ID查询该ID对应所有数据行 for (int i = 0; i < frameIdList.Count; i++) { var resdbcList = acturalDBCList.FindAll(dbc => dbc.DataAddress == frameIdList[i]); StringBuilder dbcGroupData = new StringBuilder(); dbcGroupData.Append(DBC_DETAIL_HEAD); string metholdName = DBC_DEATIL_METHOLD_NAME + "_" + frameIdList[i]; dbcGroupData.AppendLine(metholdName + "[] = \r\n{ "); //保存格式内容:名称+描述+单位+数据类型+数据长度+字节顺序+截取开始地址(dbc有用)+截取长度+数据地址(a2l-ecu地址,monitor-canid)+系数+偏移量 for (int j = 0; j < resdbcList.Count; j++) { dbcGroupData.Append("\t\t" + '"' + resdbcList[j].Name + '"' + ","); var dbcMsg = analysisDbcDataList.Find(dbc => dbc.DataAddress == resdbcList[j].DataAddress); dbcGroupData.Append('"' + dbcMsg.Describle + '"' + ","); dbcGroupData.Append('"' + resdbcList[j].Unit + '"' + ","); dbcGroupData.Append(resdbcList[j].SaveDataType + ","); dbcGroupData.Append(resdbcList[j].SaveDataLen + ","); dbcGroupData.Append(resdbcList[j].IsMotorola + ","); dbcGroupData.Append(resdbcList[j].StartIndex + ","); dbcGroupData.Append(resdbcList[j].DataBitLen + ","); dbcGroupData.Append(resdbcList[j].DataAddress + ","); dbcGroupData.Append(resdbcList[j].Factor + ","); dbcGroupData.AppendLine(resdbcList[j].OffSet + ","); } dbcGroupData.AppendLine("};"); LogHelper.Log.Info("DBC开始写入数据!"); allDbcGroupData.Add(dbcGroupData); LogHelper.Log.Info("DBC写数据完成!"); } //写数据 WriteData.WriteString(allDbcGroupData, targetPath); } catch (Exception ex) { LogHelper.Log.Info(ex.Message + ex.StackTrace); } }
private void BindDataByReview() { DataTable dt = UrlHtmlUtil.GetTEnrolInfo2(UserNo);//传申报人ID进去,返回对应的填写参赛信息 GridViewData.DataSource = dt; GridViewData.DataBind(); if (dt.Rows.Count > 0) { if (Convert.ToInt16(dt.Rows[0]["IsFirst"]) == 1) { this.showMyInfo.Style.Add("display", "block"); } } }
protected void btnUpload_Click(object sender, EventArgs e) { try { if (UploadRHFile.UploadedFiles.Count > 0) { string filename = "~/File/" + UploadRHFile.UploadedFiles[0].GetName(); if (UploadRHFile.UploadedFiles[0].GetExtension() == ".xls" || UploadRHFile.UploadedFiles[0].GetExtension() == ".xlsx") { if (UploadRHFile.UploadedFiles[0].GetName() != "") { string filePath = Server.MapPath(filename); string ConnectionString = ""; ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties='Excel 8.0;HDR=NO;IMEX=1'"; using (OleDbConnection cn = new OleDbConnection(ConnectionString)) { cn.Close(); cn.Open(); DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); if (dbSchema == null || dbSchema.Rows.Count < 1) { throw new Exception("Error: Could not determine the name of the first worksheet."); } string WorkSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString(); OleDbDataAdapter da = new OleDbDataAdapter("SELECT F1,F2,F3 FROM [" + WorkSheetName + "]", cn); DataTable dtFromExcel = new DataTable(WorkSheetName); da.Fill(dtFromExcel); cn.Close(); GridViewData.DataSource = dtFromExcel; GridViewData.DataBind(); } } else { lblMessage.Text = "Please select a file to upload."; } } } } catch (Exception ex) { lblMessage.Text = "Error occured while uploading: " + ex.Message; } }
protected void fetchData() { DataTable dt = new DataTable(); var relativeRoute = HttpContext.Current.Server.MapPath(@"\BDcoches.db"); var connstring = "data source=" + relativeRoute; using (var db = new SQLiteConnection(connstring)) { db.Open(); SQLiteCommand cmd = new SQLiteCommand("SELECT[ID], [Cuenta], [Clave], [NombreCompleto], [DNI], [Tel], [Email], [Rol] FROM[Usuarios] ", db); cmd.CommandType = CommandType.Text; SQLiteDataAdapter da = new SQLiteDataAdapter(cmd); da.Fill(dt); GridViewData.DataSource = dt; GridViewData.DataBind(); } }
protected void BindData() { SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString); try { string getFields = "SELECT * FROM tblRegistration"; SqlCommand cmd = new SqlCommand(getFields, connect); connect.Open(); GridViewData.DataSource = cmd.ExecuteReader(); GridViewData.DataBind(); connect.Close(); } catch (Exception ex) { //Response.Write("ERROR = " + ex.ToString()); } }
private void BindTeams() { List<TeamsController.TeamViewObject> data = null; using (TeamsController tc = new TeamsController()) { data = tc.GetScopedTeamViewObject(CurrentUser.UserID, Permissions.TeamManagement.ViewTeams).ToList(); } GridViewData<TeamsController.TeamViewObject> gvd = new GridViewData<TeamsController.TeamViewObject>(typeof(TeamsController.TeamViewObject)); gvd.AddData(data); gvAllTeams.GridViewItems = gvd; gvAllTeams.DataSource = data; gvAllTeams.DataBind(); // bind widgets rptWidgets.DataSource = data.Where(i => DateTime.Today <= i.End) .OrderBy(i => i.ProgramName).ThenByDescending(i => i.AgeCutoff) .Select(i => i.TeamID); rptWidgets.DataBind(); }