private static void GetDataSetSpsSchema(TbConnection con, string command) { DbCommand com = con.CreateCommand(); com.CommandText = command; DataTable table = new DataTable("sps_schema"); DataColumn workCol = table.Columns.Add("schemaid", typeof(Int32)); workCol.AllowDBNull = false; workCol.Unique = true; table.Columns.Add("wmi", typeof(String)); table.Columns.Add("salesmakecode", typeof(Int32)); table.Columns.Add("protocol", typeof(Int32)); table.Columns.Add("systemtype", typeof(Int32)); table.Columns.Add("modelyearcode", typeof(Int32)); table.Columns.Add("vinpattern", typeof(String)); table.Columns.Add("snfrom", typeof(String)); table.Columns.Add("snto", typeof(String)); table.Columns.Add("hwid", typeof(Int32)); table.Columns.Add("identtype", typeof(Int32)); table.Load(com.ExecuteReader()); set.Tables.Add(table); workCol.Dispose(); com.Dispose(); }
private void MakeTPTable() { DataColumn myColumn = new DataColumn(); DataTable dtbl = new DataTable("history"); dtbl.Locale = CultureInfo.CurrentCulture; myColumn.DataType = System.Type.GetType("System.String"); myColumn.ColumnName = "time"; dtbl.Columns.Add(myColumn); myColumn = new DataColumn(); myColumn.DataType = System.Type.GetType("System.String"); myColumn.ColumnName = "name"; dtbl.Columns.Add(myColumn); myColumn = new DataColumn(); myColumn.DataType = System.Type.GetType("System.String"); myColumn.ColumnName = "slurl"; dtbl.Columns.Add(myColumn); dtbl.PrimaryKey = new DataColumn[] { dtbl.Columns["time"] }; tp = dtbl; myColumn.Dispose(); dtbl.Dispose(); }
private static void GetDataSetSpsHwdescription(TbConnection con, string command) { DbCommand com = con.CreateCommand(); com.CommandText = command; DataTable table = new DataTable("sps_hwdescription"); DataColumn workCol = table.Columns.Add("hwid", typeof(Int32)); workCol.AllowDBNull = false; workCol.Unique = true; table.Columns.Add("hwlocid", typeof(Int32)); table.Columns.Add("hwname", typeof(String)); table.Load(com.ExecuteReader()); set.Tables.Add(table); workCol.Dispose(); com.Dispose(); /* * TbDataAdapter adapter = new TbDataAdapter(); * * DataTable sampleTable = new DataTable("sps_hwdescription"); * TbCommand com = (TbCommand)con.CreateCommand(); * com.CommandText = command; * adapter.SelectCommand = com; * adapter.Fill(sampleTable); * //adapter.Fill(sampleTable,"sps_schema"); * * adapter.Dispose(); * com.Dispose(); */ }
private void makeHeader(DataTable lsTable, string[] lsColumns) { try { DataColumn lsCol; if (lsTable.Columns.Count == 0) { lsTable.Columns.Clear(); } foreach (string s in lsColumns) { lsCol = new DataColumn(); lsCol.DataType = System.Type.GetType("System.String"); lsCol.ColumnName = s; lsTable.Columns.Add(lsCol); lsCol.Dispose(); } return; } catch (Exception ex) { showErrorMessage(ex); } }
//Convert DataTbale All column in String Column public DataTable ConverDataTableToString(DataTable dataTable) { DataTable tempDataTable = new DataTable(); foreach (DataColumn columnName in dataTable.Columns) { DataColumn tempColumn = new DataColumn(); tempColumn.ColumnName = columnName.ColumnName; tempColumn.DataType = System.Type.GetType("System.String"); tempColumn.AutoIncrement = false; tempColumn.Caption = columnName.Caption; tempColumn.ReadOnly = false; tempColumn.Unique = false; tempDataTable.Columns.Add(tempColumn); tempColumn.Dispose(); } foreach (DataRow readRow in dataTable.Rows) { DataRow tempdataRow = tempDataTable.NewRow(); foreach (DataColumn readColumn in dataTable.Columns) { tempdataRow[readColumn.ColumnName] = readRow[readColumn.ColumnName].ToString(); } tempDataTable.Rows.Add(tempdataRow); } return(tempDataTable); }
private void replaceObjectDataColumn(DataTable dt, DataColumn dcOld) { int index = dcOld.Ordinal; dt.Columns.Remove(dcOld); DataColumn dcNew = new DataColumn(dcOld.ColumnName, typeof(System.Byte[]), dcOld.Expression, dcOld.ColumnMapping); dcNew.AutoIncrement = dcOld.AutoIncrement; dcNew.AutoIncrementSeed = dcOld.AutoIncrementSeed; dcNew.AutoIncrementStep = dcOld.AutoIncrementStep; dcNew.Caption = dcOld.Caption; dcNew.DefaultValue = dcOld.DefaultValue; foreach (object prop in dcOld.ExtendedProperties) { dcNew.ExtendedProperties.Add(prop.GetHashCode(), prop); } dcNew.MaxLength = dcOld.MaxLength; dcNew.Prefix = dcOld.Prefix; dcNew.ReadOnly = dcOld.ReadOnly; dcNew.Unique = dcOld.Unique; dt.Columns.Add(dcNew); dcNew.SetOrdinal(index); dcOld.Dispose(); dcOld = null; }
private void LimpaColunas() { col_ID.Dispose(); col_Time.Dispose(); col_Msg.Dispose(); col_ID = null; col_Time = null; col_Msg = null; }
public void Dispose() { sentence?.Dispose(); resultSentence?.Dispose(); dc1?.Dispose(); dc2?.Dispose(); dc3?.Dispose(); sentence = null; resultSentence = null; dc1 = null; dc2 = null; dc3 = null; }
//private DataTable MakeDataTable() //{ // DataColumn myColumn = new DataColumn(); // DataTable dtbl = new DataTable("list"); // myColumn.DataType = System.Type.GetType("System.String"); // myColumn.ColumnName = "mute_name"; // dtbl.Columns.Add(myColumn); // myColumn = new DataColumn(); // myColumn.DataType = System.Type.GetType("System.String"); // myColumn.ColumnName = "uuid"; // dtbl.Columns.Add(myColumn); // //mutelist.Columns.Add(myColumn); // //dtbl.PrimaryKey = new DataColumn[] { dtbl.Columns["uuid"] }; // myColumn.Dispose(); // return dtbl; //} private static DataTable MakeGiverDataTable() { DataTable dtbl = new DataTable("list"); dtbl.Locale = CultureInfo.CurrentCulture; DataColumn myColumn = new DataColumn(); myColumn.DataType = System.Type.GetType("System.String"); myColumn.ColumnName = "Command"; dtbl.Columns.Add(myColumn); //client.Inventory.GiveItem(iitem.UUID, iitem.Name, iitem.AssetType, avid, false); DataColumn myColumn1 = new DataColumn(); myColumn1.DataType = System.Type.GetType("System.String"); myColumn1.ColumnName = "UUID"; dtbl.Columns.Add(myColumn1); DataColumn myColumn2 = new DataColumn(); myColumn2 = new DataColumn(); myColumn2.DataType = System.Type.GetType("System.String"); myColumn2.ColumnName = "Name"; dtbl.Columns.Add(myColumn2); DataColumn myColumn3 = new DataColumn(); myColumn3.DataType = System.Type.GetType("System.String"); myColumn3.ColumnName = "AssetType"; dtbl.Columns.Add(myColumn3); DataColumn[] keys = new DataColumn[1]; keys[0] = myColumn; dtbl.PrimaryKey = keys; myColumn.Dispose(); myColumn1.Dispose(); myColumn2.Dispose(); myColumn3.Dispose(); return(dtbl); }
private static void GetDataSetSpsConfiguration(TbConnection con, string command) { DbCommand com = con.CreateCommand(); com.CommandText = command; DataTable table = new DataTable("sps_configuration"); DataColumn workCol = table.Columns.Add("vehicleid", typeof(Int32)); //workCol.AllowDBNull = false; //workCol.Unique = true; table.Columns.Add("ecuid", typeof(Int32)); table.Load(com.ExecuteReader()); set.Tables.Add(table); workCol.Dispose(); com.Dispose(); }
/// <summary> /// To create data column /// </summary> /// <param name="caption">Caption</param> /// <param name="columnName">Column Name</param> /// <param name="dataType">Data Type</param> /// <returns></returns> public static DataColumn CreateDataColumn(string caption, string columnName, string dataType) { DataColumn column = null; try { column = new DataColumn(); column.Caption = caption; column.ColumnName = columnName; column.DataType = System.Type.GetType(dataType); return(column); } finally { if (column != null) { column.Dispose(); column = null; } } }
public static DataTable CreateNewTable(string TableName, string[] Fields) { DataTable dataTable = new DataTable(TableName); DataColumn[] dataColumnArray = new DataColumn[1] { new DataColumn() }; dataColumnArray[0].DataType = System.Type.GetType("System.Int32"); dataColumnArray[0].ColumnName = "Count"; dataColumnArray[0].AutoIncrement = true; dataColumnArray[0].ReadOnly = true; dataTable.Columns.Add(dataColumnArray[0]); dataTable.PrimaryKey = dataColumnArray; for (int index = 0; index < Fields.Length; ++index) { DataColumn column = !Fields[index].StartsWith("dbl") ? (!Fields[index].StartsWith("int") ? new DataColumn(Fields[index], System.Type.GetType("System.String")) : new DataColumn(Fields[index], System.Type.GetType("System.Int32"))) : new DataColumn(Fields[index], System.Type.GetType("System.double")); dataTable.Columns.Add(column); column.Dispose(); } return(dataTable); }
/// <summary> /// Gets the data table from data reader. /// </summary> /// <returns>The data table from data reader.</returns> /// <param name="dataReader">Data reader.</param> private DataTable GetDataTableFromDataReader(IDataReader dataReader) { DataTable schemaTable = dataReader.GetSchemaTable(); schemaTable.Locale = CultureInfo.CurrentCulture; DataTable resultTable = new DataTable(); resultTable.Locale = CultureInfo.CurrentCulture; foreach (DataRow dataRow in schemaTable.Rows) { DataColumn dataColumn = new DataColumn(); dataColumn.ColumnName = dataRow["ColumnName"].ToString(); dataColumn.DataType = Type.GetType(dataRow["DataType"].ToString()); dataColumn.ReadOnly = (bool)dataRow["IsReadOnly"]; dataColumn.AutoIncrement = (bool)dataRow["IsAutoIncrement"]; dataColumn.Unique = (bool)dataRow["IsUnique"]; resultTable.Columns.Add(dataColumn); dataColumn.Dispose(); } schemaTable.Dispose(); while (dataReader.Read()) { DataRow dataRow = resultTable.NewRow(); for (int i = 0; i < resultTable.Columns.Count; i++) { dataRow[i] = dataReader[i]; } resultTable.Rows.Add(dataRow); } return(resultTable); }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrWhiteSpace(txtName1.Text) || String.IsNullOrWhiteSpace(txtName2.Text) || String.IsNullOrWhiteSpace(txtName3.Text) || String.IsNullOrWhiteSpace(txtScore1.Text) || String.IsNullOrWhiteSpace(txtScore2.Text) || String.IsNullOrWhiteSpace(txtScore3.Text)) { MessageBox.Show("All text boxes need a value to be saved."); } else { DataSet ds = new DataSet("BombSquad"); DataTable table = new DataTable("CurrentLevel"); DataColumn column = new DataColumn("Level"); column.DataType = Type.GetType("System.String"); table.Columns.Add(column); DataRow row = table.NewRow(); row["Level"] = "Easy"; table.Rows.Add(row); ds.Tables.Add(table); table = new DataTable("Scores"); column = new DataColumn("Level"); column.DataType = Type.GetType("System.String"); table.Columns.Add(column); column = new DataColumn("Name"); column.DataType = Type.GetType("System.String"); table.Columns.Add(column); column = new DataColumn("Score"); column.DataType = Type.GetType("System.String"); table.Columns.Add(column); row = table.NewRow(); row["Level"] = "Easy"; row["Name"] = txtName1.Text; row["Score"] = txtScore1.Text; table.Rows.Add(row); row = table.NewRow(); row["Level"] = "Medium"; row["Name"] = txtName2.Text; row["Score"] = txtScore2.Text; table.Rows.Add(row); row = table.NewRow(); row["Level"] = "Hard"; row["Name"] = txtName3.Text; row["Score"] = txtScore3.Text; table.Rows.Add(row); ds.Tables.Add(table); // write to file ds.WriteXml("BombSquad.xml"); ds.Dispose(); table.Dispose(); column.Dispose(); } }
/// <versions>08-10-2017(v0.0.4.8)</versions> private Boolean Set_Results_DataSource(GridControl objGridControl, AMFCMembers objListResults) { StackFrame objStackFrame = new StackFrame(); String sErrorMsg = String.Empty; try { #region Results Datasource if (objListResults == null || objListResults.Members == null || objListResults.Members.Count == 0) { sErrorMsg = "Não foi possível obter Sócios para esta procura!"; Program.HandleError(objStackFrame.GetMethod().Name, sErrorMsg, Program.ErroType.ERROR, true, false); return(false); } #endregion Results Datasource #region TreeDataSet DataTable objDataTableResults = new DataTable("Table_Find_Members_Resuls"); #region Data Columns Creation DataColumn objDataColumn_Member_NUMERO = new DataColumn(new AMFCMember().Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.NUMERO), typeof(Int64)); //Int64 DataColumn objDataColumn_Member_NOME = new DataColumn(new AMFCMember().Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.NOME), typeof(String)); DataColumn objDataColumn_Member_DATAADMI = new DataColumn(new AMFCMember().Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.DATAADMI), typeof(String)); #endregion Data Columns Creation #region Data Table Add Columns objDataTableResults.Columns.AddRange( new DataColumn[] { objDataColumn_Member_NUMERO, objDataColumn_Member_NOME, objDataColumn_Member_DATAADMI } ); #endregion Data Table Add Columns #region Data Columns Dispose objDataColumn_Member_NUMERO.Dispose(); objDataColumn_Member_NOME.Dispose(); objDataColumn_Member_DATAADMI.Dispose(); #endregion Data Columns Dispose #endregion TreeDataSet #region Binding Data foreach (AMFCMember objMember in objListResults.Members) { if (objMember == null || objMember.NUMERO < 1 || String.IsNullOrEmpty(objMember.NOME)) { continue; } #region Set Member Row Data DataRow objDataRow = objDataTableResults.NewRow(); objDataRow[objMember.Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.NUMERO)] = objMember.NUMERO.ToString(); objDataRow[objMember.Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.NOME)] = objMember.NOME; objDataRow[objMember.Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.DATAADMI)] = objMember.DATAADMI; #endregion Set Member Row Data objDataTableResults.Rows.Add(objDataRow); } objGridControl.DataSource = objDataTableResults; return(true); #endregion Binding Data } catch (Exception ex) { Program.HandleError(ex.TargetSite.Name, ex.Message, Program.ErroType.EXCEPTION, true, false); return(false); } finally { objStackFrame = null; } }