public void XmlDB2DataGridView(ref System.Windows.Forms.DataGridView dgv) { dgv.Rows.Clear(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(mXmlDBPath); XmlNodeList root = xmlDoc.ChildNodes; foreach (XmlNode usernode in root[xmlDoc.ChildNodes.Count - 1].ChildNodes) { UserInfo curUser = new UserInfo(); curUser.XmlNode2UserInfo(usernode); System.Windows.Forms.DataGridViewRow row = new System.Windows.Forms.DataGridViewRow(); object[] objects = new string[16]; objects.Initialize(); //objects.SetValue(usernode.Attributes.GetNamedItem("id").InnerText.ToString(), 0); objects.SetValue(curUser.mId.ToString(), 0); objects.SetValue(curUser.mFirstName, 1); objects.SetValue(curUser.mLastName, 2); objects.SetValue(curUser.mFatherName, 3); objects.SetValue(curUser.mMotherName, 4); objects.SetValue(curUser.mB_Date.ToShortDateString(), 5); objects.SetValue(curUser.mCity, 6); objects.SetValue(curUser.mStreet, 7); objects.SetValue(curUser.mBuildingNum.ToString(), 8); objects.SetValue(curUser.mAppNum.ToString(), 9); objects.SetValue(curUser.mEMail, 10); objects.SetValue(curUser.mPhones, 11); objects.SetValue(curUser.mApplication, 12); // application objects.SetValue(curUser.mSex.ToString(), 13); // sex objects.SetValue(curUser.mPassedRect.ToString(), 14); // passed rectify objects.SetValue(curUser.mReachMaster.ToString(), 15); // reach master //objects.SetValue(Enums.EnumProvider.Instance.GetSexEnumFromDescription(curUser.mSex.ToString()), 12); //objects.SetValue(curUser.mApplication, 13); //objects.SetValue(Enums.EnumProvider.Instance.GetPassedRectificationEnumFromDescription(curUser.mPassedRect.ToString()), 14); dgv.Rows.Insert(dgv.Rows.Count, objects); dgv.Update(); } }
public void SetGrid(DateTime from, DateTime to, System.Windows.Forms.DataGridView grid) { var files = Global.BaseFiles(from, to); if (null == files || 0 == files.Count()) { return; } Base b = new Base(); table = new DataTable(); ds.Tables.Add(table); table.Columns.Add().DataType = typeof(string); table.Columns.Add().DataType = typeof(string); table.Columns.Add().DataType = typeof(string); table.Columns[0].ColumnName = "Время"; table.Columns[1].ColumnName = "Типоразмер"; table.Columns[2].ColumnName = "Группа прочности"; foreach (var path in files) { if (b.Open(path)) { System.Data.OleDb.OleDbCommand com = b.conn.CreateCommand(); System.Data.OleDb.OleDbParameter from_ = new System.Data.OleDb.OleDbParameter("", System.Data.OleDb.OleDbType.Date); from_.Value = from; com.Parameters.Add(from_); System.Data.OleDb.OleDbParameter to_ = new System.Data.OleDb.OleDbParameter("", System.Data.OleDb.OleDbType.Date); to_.Value = to; com.Parameters.Add(to_); com.CommandText = "SELECT t.CurrentTime, t.Diameters, t.GroupStrength" + " FROM TubesTable as t" + " WHERE t.CurrentTime>=? and t.CurrentTime<?" ; System.Data.OleDb.OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { table.Rows.Add( ((DateTime)reader[0]).ToString("dd.MM.yyyy HH:mm:ss") , (string)reader[1] , (string)reader[2] ); } } } if (0 != table.Rows.Count) { grid.DataSource = table; grid.Columns[0].Width = 120; grid.Columns[1].Width = 100; grid.Columns[2].Width = 70; for (int i = 0; i < grid.ColumnCount; ++i) { grid.Columns[i].ReadOnly = true; } foreach (DataTable dt in ds.Tables) { foreach (DataColumn dc in dt.Columns) { if (dc.DataType == typeof(DateTime)) { dc.DateTimeMode = DataSetDateTime.Unspecified; } } } } grid.Update(); }